ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
visit pFinTools.com for more
2
Date
3
ASSETSLIABILITIES
4
AccountCurrent BalanceReturn(proj)Proj Growth/YrContibutions/MoAccountAmountInterestInterest/YrPayments/Mo
5
LiquidUltra Short Term
6
Savings Acc ₹ 10,000.00 3.50% ₹ 350.00 Credit Card Bill ₹ 1,000.00 0.00% ₹ -
7
8
9
10
11
12
Total Liquid ₹ 10,000.00 3.50% ₹ 350.00 ₹ - Total Ultra Short Term ₹ 1,000.00 0.00% ₹ - ₹ -
13
14
15
Short TermShort Term
16
Mutual Funds ₹ 500,000.00 10.00% ₹ 50,000.00 ₹ 2,000.00 Borrowed from Friend ₹ 28,000.00 0.00% ₹ -
17
Health Insurance ₹ 837.83
18
19
20
21
22
Total Short Term ₹ 500,000.00 10.00% ₹ 50,000.00 ₹ 2,000.00 Total Short Term ₹ 28,000.00 0.00% ₹ - ₹ 837.83
23
(Stable Short Term + Liquid) ₹ 510,000.00 10% ₹ 50,350.00 ₹ 2,000.00
24
25
Long TermLong Term
26
ELSS Mutual Funds ₹ 300,000.00 15.00% ₹ 45,000.00 ₹ 12,500.00 House Loan ₹ 4,000,000.00 8.50% ₹ 340,000.00 ₹ 50,000.00
27
Retirement Savings ₹ 750,000.00 12.00% ₹ 90,000.00 ₹ 2,500.00
28
29
30
31
32
Total Long Term ₹ 1,050,000.00 12.86% ₹ 135,000.00 ₹ 15,000.00 Total Long Term ₹ 4,000,000.00 8.50% ₹ 340,000.00 ₹ 50,000.00
33
34
Savings (Emergency Fund)
35
Secret Saving Account ₹ 180,000.00 2.00% ₹ 3,600.00
36
37
38
39
40
41
Total Savings ₹ 180,000.00 2.00% ₹ 3,600.00 ₹ -
42
43
TOTAL ASSETS ₹ 1,740,000.00 10.86% ₹ 188,950.00 ₹ 17,000.00 TOTAL LIABILITIES ₹ 4,029,000.00 8.44% ₹ 340,000.00 ₹ 50,837.83
44
45
NET WORTH ₹ (2,289,000.00)6.60% ₹ (151,050.00) ₹ 67,837.83
46
without LTF and savings ₹ (3,519,000.00)8.23% ₹ (289,650.00)
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100