Personal Finance Assignment Guide
Personal Finance Assignment Guide
In Semester Examina
25 marks
eving your goal. Here you think about where to put your money to
decide the investment avenues or instruments to put your money
propriate insurance to safeguard your savings and check whether
investment strategy you have chosen to achieve goals.
es and friends for help, but don't copy their work. This assignment
the future. If your assignment is too similar to someone else's, you
nt, your income and goal costs should match what's happening in
olicies that are available in the market right now. Make sure the
e market, and all the information about that fund is real and
Budget Worksheet
How much can I save? Where do I want to put my savings?
Income
₹ 91,000 Earnings 50% ₹ 91,000
Expenses Savings
description
Water
Rent
Utilities ( Electricity & Gas)
Mobile
Credit Cards
Groceries
Entairtainment
Clothes
Eating Out
Insurance
Gym membership
Petrol for Bike
Total Expenses
t
my savings?
36%
₹ 91,000
64%
Expenses Savings
amount
₹ 5,000
₹ 6,000
₹ 3,000
₹ 500
₹ 5,000
₹ 2,000
₹ 2,000
₹ 2,000
₹ 2,000
₹ 3,000
₹ 700
₹ 1,500
₹ 32,700
Step 1 Step 2
List down all your Major Life
Tag goals as 'Need' or 'Desire'
Goals.
Need /
Financial Goals Desire Priority
Need /
Financial Goals Desire Priority Cost Today
Need / Cost
Financial Goals Desire Priority Today
Rs 25 lac ( 5
Buy Car Need 5 Lakh Initial
Payment)
Medium Term (5-10 years)
Sibling Education Need 4 2 lacs
House renewation Desire
Trip to Paris Desire
Investment in gold Need
Find how much you need to save and invest, where to invest to achieve your inflation adju
Total
Step 7
25,44,000 358194
₹ 401,467.67 ₹ 33,455
₹ 2,696,640.00 ₹ 224,720
NA ₹ 10,000
₹ 13,463,864 ₹ 12,000
₹ 16,561,972 ₹ 638,369
Investments
Mutual Fund
Fund Name Category of Fund Monthly Amount Period
Axis Bluechip Fund Large Cap 10000 5 Years
HDFC Balanced
Hybrid Fund 12000 16 Years
Advatntage fund
HDFC Balanced Advantage Fund - IDCW Large Cap 60000 5 years
NJ Balanced Advantage Fund - Regular Plan - Growth Large Cap 12000 1 Year
Bank Recurring
Bank name Monthly Amount Period Expected Returns
SBI 70000 2 Years 7%
HDFC 1,000 1 years 6.60%
Future Value
1797672.21
347819.06
Life Insurance
Insurance
Company Plan Premium
Health Insurance
Insurance
Company Plan Sum Assured
General Insurance
Insurance Plan Sun Assured
Company
1)Bajaj Allianz Jewelry insurance 2000000
2)New India Assurance Home Insurance 5000000
rance
Add ons
Critical Illness
Cash Value Accumulation
Health Insurance
Premium Add ons
eneral Insurance
Premium Addons
20,000,000
Assumptions
0 • Additional Payments are applied at the end of the period (for FV formulas, type=0)
9 5 1 7 3 9 5 1 7 3 9 5 1 7 3 9 5 1 7 3 9 5 1 7 3 9 5
89 90 91 91 92 92 93 94 94 95 95 96 97 97 98 98 99 00 00 01 01 02 03 03 04 04 05 • Interest is added to the Balance and is calculated as rate_per_period * previous_balance
/1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /2 /2 /2 /2 /2 /2 /2 /2 /2 /2
/1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1 /1
12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 • For Daily compounding, the interest is calculated using rate=r/365 and the days between dates
• Some combinations of compound and deposit frequency don't make much sense (such as monthly and biweekly)
• Principal (P) and Payment (A) values are positive for deposits to savings
• For loans, enter a negative value for the Principal (P)
Principal + Cumulative
No. Date Payment Interest Balance
Payments Interest
0 1/1/2024 0.00 0.00
1 2/1/2024 10,000.00 10,000.00 0.00 0.00 10,000.00
2 3/1/2024 10,000.00 20,000.00 100.00 100.00 20,100.00
3 4/1/2024 10,000.00 30,000.00 201.00 301.00 30,301.00
4 5/1/2024 10,000.00 40,000.00 303.01 604.01 40,604.01
5 6/1/2024 10,000.00 50,000.00 406.04 1,010.05 51,010.05
6 7/1/2024 10,000.00 60,000.00 510.10 1,520.15 61,520.15
7 8/1/2024 10,000.00 70,000.00 615.20 2,135.35 72,135.35
8 9/1/2024 10,000.00 80,000.00 721.35 2,856.71 82,856.71
9 10/1/2024 10,000.00 90,000.00 828.57 3,685.27 93,685.27
10 11/1/2024 10,000.00 100,000.00 936.85 4,622.13 104,622.13
11 12/1/2024 10,000.00 110,000.00 1,046.22 5,668.35 115,668.35
12 1/1/2025 10,000.00 120,000.00 1,156.68 6,825.03 126,825.03
13 2/1/2025 10,000.00 130,000.00 1,268.25 8,093.28 138,093.28
14 3/1/2025 10,000.00 140,000.00 1,380.93 9,474.21 149,474.21
15 4/1/2025 10,000.00 150,000.00 1,494.74 10,968.96 160,968.96
16 5/1/2025 10,000.00 160,000.00 1,609.69 12,578.64 172,578.64
17 6/1/2025 10,000.00 170,000.00 1,725.79 14,304.43 184,304.43
18 7/1/2025 10,000.00 180,000.00 1,843.04 16,147.48 196,147.48
19 8/1/2025 10,000.00 190,000.00 1,961.47 18,108.95 208,108.95
20 9/1/2025 10,000.00 200,000.00 2,081.09 20,190.04 220,190.04
21 10/1/2025 10,000.00 210,000.00 2,201.90 22,391.94 232,391.94
22 11/1/2025 10,000.00 220,000.00 2,323.92 24,715.86 244,715.86
23 12/1/2025 10,000.00 230,000.00 2,447.16 27,163.02 257,163.02
24 1/1/2026 10,000.00 240,000.00 2,571.63 29,734.65 269,734.65
25 2/1/2026 10,000.00 250,000.00 2,697.35 32,432.00 282,432.00
26 3/1/2026 10,000.00 260,000.00 2,824.32 35,256.31 295,256.31
27 4/1/2026 10,000.00 270,000.00 2,952.56 38,208.88 308,208.88
28 5/1/2026 10,000.00 280,000.00 3,082.09 41,290.97 321,290.97
29 6/1/2026 10,000.00 290,000.00 3,212.91 44,503.88 334,503.88
30 7/1/2026 10,000.00 300,000.00 3,345.04 47,848.92 347,848.92
31 8/1/2026 10,000.00 310,000.00 3,478.49 51,327.40 361,327.40
32 9/1/2026 10,000.00 320,000.00 3,613.27 54,940.68 374,940.68
33 10/1/2026 10,000.00 330,000.00 3,749.41 58,690.09 388,690.09
34 11/1/2026 10,000.00 340,000.00 3,886.90 62,576.99 402,576.99
35 12/1/2026 10,000.00 350,000.00 4,025.77 66,602.76 416,602.76
36 1/1/2027 10,000.00 360,000.00 4,166.03 70,768.78 430,768.78
37 2/1/2027 10,000.00 370,000.00 4,307.69 75,076.47 445,076.47
38 3/1/2027 10,000.00 380,000.00 4,450.76 79,527.24 459,527.24
39 4/1/2027 10,000.00 390,000.00 4,595.27 84,122.51 474,122.51
40 5/1/2027 10,000.00 400,000.00 4,741.23 88,863.73 488,863.73
41 6/1/2027 10,000.00 410,000.00 4,888.64 93,752.37 503,752.37
42 7/1/2027 10,000.00 420,000.00 5,037.52 98,789.89 518,789.89
43 8/1/2027 10,000.00 430,000.00 5,187.90 103,977.79 533,977.79
44 9/1/2027 10,000.00 440,000.00 5,339.78 109,317.57 549,317.57
45 10/1/2027 10,000.00 450,000.00 5,493.18 114,810.75 564,810.75
46 11/1/2027 10,000.00 460,000.00 5,648.11 120,458.85 580,458.85
47 12/1/2027 10,000.00 470,000.00 5,804.59 126,263.44 596,263.44
48 1/1/2028 10,000.00 480,000.00 5,962.63 132,226.08 612,226.08
49 2/1/2028 10,000.00 490,000.00 6,122.26 138,348.34 628,348.34
50 3/1/2028 10,000.00 500,000.00 6,283.48 144,631.82 644,631.82
51 4/1/2028 10,000.00 510,000.00 6,446.32 151,078.14 661,078.14
52 5/1/2028 10,000.00 520,000.00 6,610.78 157,688.92 677,688.92
53 6/1/2028 10,000.00 530,000.00 6,776.89 164,465.81 694,465.81
54 7/1/2028 10,000.00 540,000.00 6,944.66 171,410.47 711,410.47
55 8/1/2028 10,000.00 550,000.00 7,114.10 178,524.57 728,524.57
56 9/1/2028 10,000.00 560,000.00 7,285.25 185,809.82 745,809.82
57 10/1/2028 10,000.00 570,000.00 7,458.10 193,267.92 763,267.92
58 11/1/2028 10,000.00 580,000.00 7,632.68 200,900.60 780,900.60
59 12/1/2028 10,000.00 590,000.00 7,809.01 208,709.60 798,709.60
60 1/1/2029 10,000.00 600,000.00 7,987.10 216,696.70 816,696.70
61 2/1/2029 10,000.00 610,000.00 8,166.97 224,863.67 834,863.67
62 3/1/2029 10,000.00 620,000.00 8,348.64 233,212.30 853,212.30
63 4/1/2029 10,000.00 630,000.00 8,532.12 241,744.43 871,744.43
64 5/1/2029 10,000.00 640,000.00 8,717.44 250,461.87 890,461.87
65 6/1/2029 10,000.00 650,000.00 8,904.62 259,366.49 909,366.49
66 7/1/2029 10,000.00 660,000.00 9,093.66 268,460.15 928,460.15
67 8/1/2029 10,000.00 670,000.00 9,284.60 277,744.75 947,744.75
68 9/1/2029 10,000.00 680,000.00 9,477.45 287,222.20 967,222.20
69 10/1/2029 10,000.00 690,000.00 9,672.22 296,894.42 986,894.42
70 11/1/2029 10,000.00 700,000.00 9,868.94 306,763.37 1,006,763.37
71 12/1/2029 10,000.00 710,000.00 10,067.63 316,831.00 1,026,831.00
72 1/1/2030 10,000.00 720,000.00 10,268.31 327,099.31 1,047,099.31
73 2/1/2030 10,000.00 730,000.00 10,470.99 337,570.31 1,067,570.31
74 3/1/2030 10,000.00 740,000.00 10,675.70 348,246.01 1,088,246.01
75 4/1/2030 10,000.00 750,000.00 10,882.46 359,128.47 1,109,128.47
76 5/1/2030 10,000.00 760,000.00 11,091.28 370,219.75 1,130,219.75
77 6/1/2030 10,000.00 770,000.00 11,302.20 381,521.95 1,151,521.95
78 7/1/2030 10,000.00 780,000.00 11,515.22 393,037.17 1,173,037.17
79 8/1/2030 10,000.00 790,000.00 11,730.37 404,767.54 1,194,767.54
80 9/1/2030 10,000.00 800,000.00 11,947.68 416,715.22 1,216,715.22
81 10/1/2030 10,000.00 810,000.00 12,167.15 428,882.37 1,238,882.37
82 11/1/2030 10,000.00 820,000.00 12,388.82 441,271.19 1,261,271.19
83 12/1/2030 10,000.00 830,000.00 12,612.71 453,883.90 1,283,883.90
84 1/1/2031 10,000.00 840,000.00 12,838.84 466,722.74 1,306,722.74
85 2/1/2031 10,000.00 850,000.00 13,067.23 479,789.97 1,329,789.97
86 3/1/2031 10,000.00 860,000.00 13,297.90 493,087.87 1,353,087.87
87 4/1/2031 10,000.00 870,000.00 13,530.88 506,618.75 1,376,618.75
88 5/1/2031 10,000.00 880,000.00 13,766.19 520,384.94 1,400,384.94
89 6/1/2031 10,000.00 890,000.00 14,003.85 534,388.79 1,424,388.79
90 7/1/2031 10,000.00 900,000.00 14,243.89 548,632.67 1,448,632.67
91 8/1/2031 10,000.00 910,000.00 14,486.33 563,119.00 1,473,119.00
92 9/1/2031 10,000.00 920,000.00 14,731.19 577,850.19 1,497,850.19
93 10/1/2031 10,000.00 930,000.00 14,978.50 592,828.69 1,522,828.69
94 11/1/2031 10,000.00 940,000.00 15,228.29 608,056.98 1,548,056.98
95 12/1/2031 10,000.00 950,000.00 15,480.57 623,537.55 1,573,537.55
96 1/1/2032 10,000.00 960,000.00 15,735.38 639,272.93 1,599,272.93
97 2/1/2032 10,000.00 970,000.00 15,992.73 655,265.65 1,625,265.65
98 3/1/2032 10,000.00 980,000.00 16,252.66 671,518.31 1,651,518.31
99 4/1/2032 10,000.00 990,000.00 16,515.18 688,033.49 1,678,033.49
100 5/1/2032 10,000.00 1,000,000.00 16,780.33 704,813.83 1,704,813.83
101 6/1/2032 10,000.00 1,010,000.00 17,048.14 721,861.97 1,731,861.97
102 7/1/2032 10,000.00 1,020,000.00 17,318.62 739,180.59 1,759,180.59
103 8/1/2032 10,000.00 1,030,000.00 17,591.81 756,772.39 1,786,772.39
104 9/1/2032 10,000.00 1,040,000.00 17,867.72 774,640.12 1,814,640.12
105 10/1/2032 10,000.00 1,050,000.00 18,146.40 792,786.52 1,842,786.52
106 11/1/2032 10,000.00 1,060,000.00 18,427.87 811,214.38 1,871,214.38
107 12/1/2032 10,000.00 1,070,000.00 18,712.14 829,926.53 1,899,926.53
108 1/1/2033 10,000.00 1,080,000.00 18,999.27 848,925.79 1,928,925.79
109 2/1/2033 10,000.00 1,090,000.00 19,289.26 868,215.05 1,958,215.05
110 3/1/2033 10,000.00 1,100,000.00 19,582.15 887,797.20 1,987,797.20
111 4/1/2033 10,000.00 1,110,000.00 19,877.97 907,675.17 2,017,675.17
112 5/1/2033 10,000.00 1,120,000.00 20,176.75 927,851.92 2,047,851.92
113 6/1/2033 10,000.00 1,130,000.00 20,478.52 948,330.44 2,078,330.44
114 7/1/2033 10,000.00 1,140,000.00 20,783.30 969,113.75 2,109,113.75
115 8/1/2033 10,000.00 1,150,000.00 21,091.14 990,204.89 2,140,204.89
116 9/1/2033 10,000.00 1,160,000.00 21,402.05 1,011,606.93 2,171,606.93
117 10/1/2033 10,000.00 1,170,000.00 21,716.07 1,033,323.00 2,203,323.00
118 11/1/2033 10,000.00 1,180,000.00 22,033.23 1,055,356.23 2,235,356.23
119 12/1/2033 10,000.00 1,190,000.00 22,353.56 1,077,709.80 2,267,709.80
120 1/1/2034 10,000.00 1,200,000.00 22,677.10 1,100,386.89 2,300,386.89
121 2/1/2034 10,000.00 1,210,000.00 23,003.87 1,123,390.76 2,333,390.76
122 3/1/2034 10,000.00 1,220,000.00 23,333.91 1,146,724.67 2,366,724.67
123 4/1/2034 10,000.00 1,230,000.00 23,667.25 1,170,391.92 2,400,391.92
124 5/1/2034 10,000.00 1,240,000.00 24,003.92 1,194,395.84 2,434,395.84
125 6/1/2034 10,000.00 1,250,000.00 24,343.96 1,218,739.80 2,468,739.80
126 7/1/2034 10,000.00 1,260,000.00 24,687.40 1,243,427.19 2,503,427.19
127 8/1/2034 10,000.00 1,270,000.00 25,034.27 1,268,461.47 2,538,461.47
128 9/1/2034 10,000.00 1,280,000.00 25,384.61 1,293,846.08 2,573,846.08
129 10/1/2034 10,000.00 1,290,000.00 25,738.46 1,319,584.54 2,609,584.54
130 11/1/2034 10,000.00 1,300,000.00 26,095.85 1,345,680.39 2,645,680.39
131 12/1/2034 10,000.00 1,310,000.00 26,456.80 1,372,137.19 2,682,137.19
132 1/1/2035 10,000.00 1,320,000.00 26,821.37 1,398,958.56 2,718,958.56
133 2/1/2035 10,000.00 1,330,000.00 27,189.59 1,426,148.15 2,756,148.15
134 3/1/2035 10,000.00 1,340,000.00 27,561.48 1,453,709.63 2,793,709.63
135 4/1/2035 10,000.00 1,350,000.00 27,937.10 1,481,646.73 2,831,646.73
136 5/1/2035 10,000.00 1,360,000.00 28,316.47 1,509,963.19 2,869,963.19
137 6/1/2035 10,000.00 1,370,000.00 28,699.63 1,538,662.82 2,908,662.82
138 7/1/2035 10,000.00 1,380,000.00 29,086.63 1,567,749.45 2,947,749.45
139 8/1/2035 10,000.00 1,390,000.00 29,477.49 1,597,226.95 2,987,226.95
140 9/1/2035 10,000.00 1,400,000.00 29,872.27 1,627,099.22 3,027,099.22
141 10/1/2035 10,000.00 1,410,000.00 30,270.99 1,657,370.21 3,067,370.21
142 11/1/2035 10,000.00 1,420,000.00 30,673.70 1,688,043.91 3,108,043.91
143 12/1/2035 10,000.00 1,430,000.00 31,080.44 1,719,124.35 3,149,124.35
144 1/1/2036 10,000.00 1,440,000.00 31,491.24 1,750,615.59 3,190,615.59
145 2/1/2036 10,000.00 1,450,000.00 31,906.16 1,782,521.75 3,232,521.75
146 3/1/2036 10,000.00 1,460,000.00 32,325.22 1,814,846.97 3,274,846.97
147 4/1/2036 10,000.00 1,470,000.00 32,748.47 1,847,595.44 3,317,595.44
148 5/1/2036 10,000.00 1,480,000.00 33,175.95 1,880,771.39 3,360,771.39
149 6/1/2036 10,000.00 1,490,000.00 33,607.71 1,914,379.10 3,404,379.10
150 7/1/2036 10,000.00 1,500,000.00 34,043.79 1,948,422.90 3,448,422.90
151 8/1/2036 10,000.00 1,510,000.00 34,484.23 1,982,907.12 3,492,907.12
152 9/1/2036 10,000.00 1,520,000.00 34,929.07 2,017,836.20 3,537,836.20
153 10/1/2036 10,000.00 1,530,000.00 35,378.36 2,053,214.56 3,583,214.56
154 11/1/2036 10,000.00 1,540,000.00 35,832.15 2,089,046.70 3,629,046.70
155 12/1/2036 10,000.00 1,550,000.00 36,290.47 2,125,337.17 3,675,337.17
156 1/1/2037 10,000.00 1,560,000.00 36,753.37 2,162,090.54 3,722,090.54
157 2/1/2037 10,000.00 1,570,000.00 37,220.91 2,199,311.45 3,769,311.45
158 3/1/2037 10,000.00 1,580,000.00 37,693.11 2,237,004.56 3,817,004.56
159 4/1/2037 10,000.00 1,590,000.00 38,170.05 2,275,174.61 3,865,174.61
160 5/1/2037 10,000.00 1,600,000.00 38,651.75 2,313,826.35 3,913,826.35
161 6/1/2037 10,000.00 1,610,000.00 39,138.26 2,352,964.62 3,962,964.62
162 7/1/2037 10,000.00 1,620,000.00 39,629.65 2,392,594.26 4,012,594.26
163 8/1/2037 10,000.00 1,630,000.00 40,125.94 2,432,720.21 4,062,720.21
164 9/1/2037 10,000.00 1,640,000.00 40,627.20 2,473,347.41 4,113,347.41
165 10/1/2037 10,000.00 1,650,000.00 41,133.47 2,514,480.88 4,164,480.88
166 11/1/2037 10,000.00 1,660,000.00 41,644.81 2,556,125.69 4,216,125.69
167 12/1/2037 10,000.00 1,670,000.00 42,161.26 2,598,286.95 4,268,286.95
168 1/1/2038 10,000.00 1,680,000.00 42,682.87 2,640,969.82 4,320,969.82
169 2/1/2038 10,000.00 1,690,000.00 43,209.70 2,684,179.52 4,374,179.52
170 3/1/2038 10,000.00 1,700,000.00 43,741.80 2,727,921.31 4,427,921.31
171 4/1/2038 10,000.00 1,710,000.00 44,279.21 2,772,200.52 4,482,200.52
172 5/1/2038 10,000.00 1,720,000.00 44,822.01 2,817,022.53 4,537,022.53
173 6/1/2038 10,000.00 1,730,000.00 45,370.23 2,862,392.75 4,592,392.75
174 7/1/2038 10,000.00 1,740,000.00 45,923.93 2,908,316.68 4,648,316.68
175 8/1/2038 10,000.00 1,750,000.00 46,483.17 2,954,799.85 4,704,799.85
176 9/1/2038 10,000.00 1,760,000.00 47,048.00 3,001,847.85 4,761,847.85
177 10/1/2038 10,000.00 1,770,000.00 47,618.48 3,049,466.33 4,819,466.33
178 11/1/2038 10,000.00 1,780,000.00 48,194.66 3,097,660.99 4,877,660.99
179 12/1/2038 10,000.00 1,790,000.00 48,776.61 3,146,437.60 4,936,437.60
180 1/1/2039 10,000.00 1,800,000.00 49,364.38 3,195,801.98 4,995,801.98
181 2/1/2039 10,000.00 1,810,000.00 49,958.02 3,245,760.00 5,055,760.00
182 3/1/2039 10,000.00 1,820,000.00 50,557.60 3,296,317.60 5,116,317.60
183 4/1/2039 10,000.00 1,830,000.00 51,163.18 3,347,480.77 5,177,480.77
184 5/1/2039 10,000.00 1,840,000.00 51,774.81 3,399,255.58 5,239,255.58
185 6/1/2039 10,000.00 1,850,000.00 52,392.56 3,451,648.13 5,301,648.13
186 7/1/2039 10,000.00 1,860,000.00 53,016.48 3,504,664.62 5,364,664.62
187 8/1/2039 10,000.00 1,870,000.00 53,646.65 3,558,311.26 5,428,311.26
188 9/1/2039 10,000.00 1,880,000.00 54,283.11 3,612,594.37 5,492,594.37
189 10/1/2039 10,000.00 1,890,000.00 54,925.94 3,667,520.32 5,557,520.32
190 11/1/2039 10,000.00 1,900,000.00 55,575.20 3,723,095.52 5,623,095.52
191 12/1/2039 10,000.00 1,910,000.00 56,230.96 3,779,326.48 5,689,326.48
192 1/1/2040 10,000.00 1,920,000.00 56,893.26 3,836,219.74 5,756,219.74
193 2/1/2040 10,000.00 1,930,000.00 57,562.20 3,893,781.94 5,823,781.94
194 3/1/2040 10,000.00 1,940,000.00 58,237.82 3,952,019.76 5,892,019.76
195 4/1/2040 10,000.00 1,950,000.00 58,920.20 4,010,939.96 5,960,939.96
196 5/1/2040 10,000.00 1,960,000.00 59,609.40 4,070,549.36 6,030,549.36
197 6/1/2040 10,000.00 1,970,000.00 60,305.49 4,130,854.85 6,100,854.85
198 7/1/2040 10,000.00 1,980,000.00 61,008.55 4,191,863.40 6,171,863.40
199 8/1/2040 10,000.00 1,990,000.00 61,718.63 4,253,582.03 6,243,582.03
200 9/1/2040 10,000.00 2,000,000.00 62,435.82 4,316,017.85 6,316,017.85
201 10/1/2040 10,000.00 2,010,000.00 63,160.18 4,379,178.03 6,389,178.03
202 11/1/2040 10,000.00 2,020,000.00 63,891.78 4,443,069.81 6,463,069.81
203 12/1/2040 10,000.00 2,030,000.00 64,630.70 4,507,700.51 6,537,700.51
204 1/1/2041 10,000.00 2,040,000.00 65,377.01 4,573,077.51 6,613,077.51
205 2/1/2041 10,000.00 2,050,000.00 66,130.78 4,639,208.29 6,689,208.29
206 3/1/2041 10,000.00 2,060,000.00 66,892.08 4,706,100.37 6,766,100.37
207 4/1/2041 10,000.00 2,070,000.00 67,661.00 4,773,761.38 6,843,761.38
208 5/1/2041 10,000.00 2,080,000.00 68,437.61 4,842,198.99 6,922,198.99
209 6/1/2041 10,000.00 2,090,000.00 69,221.99 4,911,420.98 7,001,420.98
210 7/1/2041 10,000.00 2,100,000.00 70,014.21 4,981,435.19 7,081,435.19
211 8/1/2041 10,000.00 2,110,000.00 70,814.35 5,052,249.54 7,162,249.54
212 9/1/2041 10,000.00 2,120,000.00 71,622.50 5,123,872.04 7,243,872.04
213 10/1/2041 10,000.00 2,130,000.00 72,438.72 5,196,310.76 7,326,310.76
214 11/1/2041 10,000.00 2,140,000.00 73,263.11 5,269,573.86 7,409,573.86
215 12/1/2041 10,000.00 2,150,000.00 74,095.74 5,343,669.60 7,493,669.60
216 1/1/2042 10,000.00 2,160,000.00 74,936.70 5,418,606.30 7,578,606.30
217 2/1/2042 10,000.00 2,170,000.00 75,786.06 5,494,392.36 7,664,392.36
218 3/1/2042 10,000.00 2,180,000.00 76,643.92 5,571,036.29 7,751,036.29
219 4/1/2042 10,000.00 2,190,000.00 77,510.36 5,648,546.65 7,838,546.65
220 5/1/2042 10,000.00 2,200,000.00 78,385.47 5,726,932.11 7,926,932.11
221 6/1/2042 10,000.00 2,210,000.00 79,269.32 5,806,201.44 8,016,201.44
222 7/1/2042 10,000.00 2,220,000.00 80,162.01 5,886,363.45 8,106,363.45
223 8/1/2042 10,000.00 2,230,000.00 81,063.63 5,967,427.08 8,197,427.08
224 9/1/2042 10,000.00 2,240,000.00 81,974.27 6,049,401.36 8,289,401.36
225 10/1/2042 10,000.00 2,250,000.00 82,894.01 6,132,295.37 8,382,295.37
226 11/1/2042 10,000.00 2,260,000.00 83,822.95 6,216,118.32 8,476,118.32
227 12/1/2042 10,000.00 2,270,000.00 84,761.18 6,300,879.51 8,570,879.51
228 1/1/2043 10,000.00 2,280,000.00 85,708.80 6,386,588.30 8,666,588.30
229 2/1/2043 10,000.00 2,290,000.00 86,665.88 6,473,254.18 8,763,254.18
230 3/1/2043 10,000.00 2,300,000.00 87,632.54 6,560,886.73 8,860,886.73
231 4/1/2043 10,000.00 2,310,000.00 88,608.87 6,649,495.59 8,959,495.59
232 5/1/2043 10,000.00 2,320,000.00 89,594.96 6,739,090.55 9,059,090.55
233 6/1/2043 10,000.00 2,330,000.00 90,590.91 6,829,681.45 9,159,681.45
234 7/1/2043 10,000.00 2,340,000.00 91,596.81 6,921,278.27 9,261,278.27
235 8/1/2043 10,000.00 2,350,000.00 92,612.78 7,013,891.05 9,363,891.05
236 9/1/2043 10,000.00 2,360,000.00 93,638.91 7,107,529.96 9,467,529.96
237 10/1/2043 10,000.00 2,370,000.00 94,675.30 7,202,205.26 9,572,205.26
238 11/1/2043 10,000.00 2,380,000.00 95,722.05 7,297,927.31 9,677,927.31
239 12/1/2043 10,000.00 2,390,000.00 96,779.27 7,394,706.59 9,784,706.59
240 1/1/2044 10,000.00 2,400,000.00 97,847.07 7,492,553.65 9,892,553.65
241 2/1/2044 10,000.00 2,410,000.00 98,925.54 7,591,479.19 10,001,479.19
242 3/1/2044 10,000.00 2,420,000.00 100,014.79 7,691,493.98 10,111,493.98
243 4/1/2044 10,000.00 2,430,000.00 101,114.94 7,792,608.92 10,222,608.92
244 5/1/2044 10,000.00 2,440,000.00 102,226.09 7,894,835.01 10,334,835.01
245 6/1/2044 10,000.00 2,450,000.00 103,348.35 7,998,183.36 10,448,183.36
246 7/1/2044 10,000.00 2,460,000.00 104,481.83 8,102,665.20 10,562,665.20
247 8/1/2044 10,000.00 2,470,000.00 105,626.65 8,208,291.85 10,678,291.85
248 9/1/2044 10,000.00 2,480,000.00 106,782.92 8,315,074.77 10,795,074.77
249 10/1/2044 10,000.00 2,490,000.00 107,950.75 8,423,025.51 10,913,025.51
250 11/1/2044 10,000.00 2,500,000.00 109,130.26 8,532,155.77 11,032,155.77
251 12/1/2044 10,000.00 2,510,000.00 110,321.56 8,642,477.33 11,152,477.33
252 1/1/2045 10,000.00 2,520,000.00 111,524.77 8,754,002.10 11,274,002.10
253 2/1/2045 10,000.00 2,530,000.00 112,740.02 8,866,742.12 11,396,742.12
254 3/1/2045 10,000.00 2,540,000.00 113,967.42 8,980,709.54 11,520,709.54
255 4/1/2045 10,000.00 2,550,000.00 115,207.10 9,095,916.64 11,645,916.64
256 5/1/2045 10,000.00 2,560,000.00 116,459.17 9,212,375.80 11,772,375.80
257 6/1/2045 10,000.00 2,570,000.00 117,723.76 9,330,099.56 11,900,099.56
258 7/1/2045 10,000.00 2,580,000.00 119,001.00 9,449,100.56 12,029,100.56
259 8/1/2045 10,000.00 2,590,000.00 120,291.01 9,569,391.56 12,159,391.56
260 9/1/2045 10,000.00 2,600,000.00 121,593.92 9,690,985.48 12,290,985.48
261 10/1/2045 10,000.00 2,610,000.00 122,909.85 9,813,895.33 12,423,895.33
262 11/1/2045 10,000.00 2,620,000.00 124,238.95 9,938,134.29 12,558,134.29
263 12/1/2045 10,000.00 2,630,000.00 125,581.34 10,063,715.63 12,693,715.63
264 1/1/2046 10,000.00 2,640,000.00 126,937.16 10,190,652.79 12,830,652.79
265 2/1/2046 10,000.00 2,650,000.00 128,306.53 10,318,959.31 12,968,959.31
266 3/1/2046 10,000.00 2,660,000.00 129,689.59 10,448,648.91 13,108,648.91
267 4/1/2046 10,000.00 2,670,000.00 131,086.49 10,579,735.40 13,249,735.40
268 5/1/2046 10,000.00 2,680,000.00 132,497.35 10,712,232.75 13,392,232.75
269 6/1/2046 10,000.00 2,690,000.00 133,922.33 10,846,155.08 13,536,155.08
270 7/1/2046 10,000.00 2,700,000.00 135,361.55 10,981,516.63 13,681,516.63
271 8/1/2046 10,000.00 2,710,000.00 136,815.17 11,118,331.79 13,828,331.79
272 9/1/2046 10,000.00 2,720,000.00 138,283.32 11,256,615.11 13,976,615.11
273 10/1/2046 10,000.00 2,730,000.00 139,766.15 11,396,381.26 14,126,381.26
274 11/1/2046 10,000.00 2,740,000.00 141,263.81 11,537,645.08 14,277,645.08
275 12/1/2046 10,000.00 2,750,000.00 142,776.45 11,680,421.53 14,430,421.53
276 1/1/2047 10,000.00 2,760,000.00 144,304.22 11,824,725.74 14,584,725.74
277 2/1/2047 10,000.00 2,770,000.00 145,847.26 11,970,573.00 14,740,573.00
278 3/1/2047 10,000.00 2,780,000.00 147,405.73 12,117,978.73 14,897,978.73
279 4/1/2047 10,000.00 2,790,000.00 148,979.79 12,266,958.52 15,056,958.52
280 5/1/2047 10,000.00 2,800,000.00 150,569.59 12,417,528.10 15,217,528.10
281 6/1/2047 10,000.00 2,810,000.00 152,175.28 12,569,703.38 15,379,703.38
282 7/1/2047 10,000.00 2,820,000.00 153,797.03 12,723,500.42 15,543,500.42
283 8/1/2047 10,000.00 2,830,000.00 155,435.00 12,878,935.42 15,708,935.42
284 9/1/2047 10,000.00 2,840,000.00 157,089.35 13,036,024.77 15,876,024.77
285 10/1/2047 10,000.00 2,850,000.00 158,760.25 13,194,785.02 16,044,785.02
286 11/1/2047 10,000.00 2,860,000.00 160,447.85 13,355,232.87 16,215,232.87
287 12/1/2047 10,000.00 2,870,000.00 162,152.33 13,517,385.20 16,387,385.20
288 1/1/2048 10,000.00 2,880,000.00 163,873.85 13,681,259.05 16,561,259.05
289 2/1/2048 10,000.00 2,890,000.00 165,612.59 13,846,871.64 16,736,871.64
290 3/1/2048 10,000.00 2,900,000.00 167,368.72 14,014,240.36 16,914,240.36
291 4/1/2048 10,000.00 2,910,000.00 169,142.40 14,183,382.76 17,093,382.76
292 5/1/2048 10,000.00 2,920,000.00 170,933.83 14,354,316.59 17,274,316.59
293 6/1/2048 10,000.00 2,930,000.00 172,743.17 14,527,059.76 17,457,059.76
294 7/1/2048 10,000.00 2,940,000.00 174,570.60 14,701,630.36 17,641,630.36
295 8/1/2048 10,000.00 2,950,000.00 176,416.30 14,878,046.66 17,828,046.66
296 9/1/2048 10,000.00 2,960,000.00 178,280.47 15,056,327.13 18,016,327.13
297 10/1/2048 10,000.00 2,970,000.00 180,163.27 15,236,490.40 18,206,490.40
298 11/1/2048 10,000.00 2,980,000.00 182,064.90 15,418,555.30 18,398,555.30
299 12/1/2048 10,000.00 2,990,000.00 183,985.55 15,602,540.85 18,592,540.85
300 1/1/2049 10,000.00 3,000,000.00 185,925.41 15,788,466.26 18,788,466.26
301 2/1/2049 10,000.00 3,010,000.00 187,884.66 15,976,350.92 18,986,350.92
302 3/1/2049 10,000.00 3,020,000.00 189,863.51 16,166,214.43 19,186,214.43
303 4/1/2049 10,000.00 3,030,000.00 191,862.14 16,358,076.58 19,388,076.58
304 5/1/2049 10,000.00 3,040,000.00 193,880.77 16,551,957.34 19,591,957.34
305 6/1/2049 10,000.00 3,050,000.00 195,919.57 16,747,876.92 19,797,876.92
306 7/1/2049 10,000.00 3,060,000.00 197,978.77 16,945,855.69 20,005,855.69
307 8/1/2049 10,000.00 3,070,000.00 200,058.56 17,145,914.24 20,215,914.24
308 9/1/2049 10,000.00 3,080,000.00 202,159.14 17,348,073.39 20,428,073.39
309 10/1/2049 10,000.00 3,090,000.00 204,280.73 17,552,354.12 20,642,354.12
310 11/1/2049 10,000.00 3,100,000.00 206,423.54 17,758,777.66 20,858,777.66
311 12/1/2049 10,000.00 3,110,000.00 208,587.78 17,967,365.44 21,077,365.44
312 1/1/2050 10,000.00 3,120,000.00 210,773.65 18,178,139.09 21,298,139.09
313 2/1/2050 10,000.00 3,130,000.00 212,981.39 18,391,120.48 21,521,120.48
314 3/1/2050 10,000.00 3,140,000.00 215,211.20 18,606,331.69 21,746,331.69
315 4/1/2050 10,000.00 3,150,000.00 217,463.32 18,823,795.00 21,973,795.00
316 5/1/2050 10,000.00 3,160,000.00 219,737.95 19,043,532.95 22,203,532.95
317 6/1/2050 10,000.00 3,170,000.00 222,035.33 19,265,568.28 22,435,568.28
318 7/1/2050 10,000.00 3,180,000.00 224,355.68 19,489,923.97 22,669,923.97
319 8/1/2050 10,000.00 3,190,000.00 226,699.24 19,716,623.21 22,906,623.21
320 9/1/2050 10,000.00 3,200,000.00 229,066.23 19,945,689.44 23,145,689.44
321 10/1/2050 10,000.00 3,210,000.00 231,456.89 20,177,146.33 23,387,146.33
322 11/1/2050 10,000.00 3,220,000.00 233,871.46 20,411,017.80 23,631,017.80
323 12/1/2050 10,000.00 3,230,000.00 236,310.18 20,647,327.97 23,877,327.97
324 1/1/2051 10,000.00 3,240,000.00 238,773.28 20,886,101.25 24,126,101.25
325 2/1/2051 10,000.00 3,250,000.00 241,261.01 21,127,362.27 24,377,362.27
326 3/1/2051 10,000.00 3,260,000.00 243,773.62 21,371,135.89 24,631,135.89
327 4/1/2051 10,000.00 3,270,000.00 246,311.36 21,617,447.25 24,887,447.25
328 5/1/2051 10,000.00 3,280,000.00 248,874.47 21,866,321.72 25,146,321.72
329 6/1/2051 10,000.00 3,290,000.00 251,463.22 22,117,784.94 25,407,784.94
330 7/1/2051 10,000.00 3,300,000.00 254,077.85 22,371,862.79 25,671,862.79
331 8/1/2051 10,000.00 3,310,000.00 256,718.63 22,628,581.42 25,938,581.42
332 9/1/2051 10,000.00 3,320,000.00 259,385.81 22,887,967.23 26,207,967.23
333 10/1/2051 10,000.00 3,330,000.00 262,079.67 23,150,046.90 26,480,046.90
334 11/1/2051 10,000.00 3,340,000.00 264,800.47 23,414,847.37 26,754,847.37
335 12/1/2051 10,000.00 3,350,000.00 267,548.47 23,682,395.84 27,032,395.84
336 1/1/2052 10,000.00 3,360,000.00 270,323.96 23,952,719.80 27,312,719.80
337 2/1/2052 10,000.00 3,370,000.00 273,127.20 24,225,847.00 27,595,847.00
338 3/1/2052 10,000.00 3,380,000.00 275,958.47 24,501,805.47 27,881,805.47
339 4/1/2052 10,000.00 3,390,000.00 278,818.05 24,780,623.53 28,170,623.53
340 5/1/2052 10,000.00 3,400,000.00 281,706.24 25,062,329.76 28,462,329.76
341 6/1/2052 10,000.00 3,410,000.00 284,623.30 25,346,953.06 28,756,953.06
342 7/1/2052 10,000.00 3,420,000.00 287,569.53 25,634,522.59 29,054,522.59
343 8/1/2052 10,000.00 3,430,000.00 290,545.23 25,925,067.81 29,355,067.81
344 9/1/2052 10,000.00 3,440,000.00 293,550.68 26,218,618.49 29,658,618.49
345 10/1/2052 10,000.00 3,450,000.00 296,586.18 26,515,204.68 29,965,204.68
346 11/1/2052 10,000.00 3,460,000.00 299,652.05 26,814,856.72 30,274,856.72
347 12/1/2052 10,000.00 3,470,000.00 302,748.57 27,117,605.29 30,587,605.29
348 1/1/2053 10,000.00 3,480,000.00 305,876.05 27,423,481.34 30,903,481.34
349 2/1/2053 10,000.00 3,490,000.00 309,034.81 27,732,516.16 31,222,516.16
350 3/1/2053 10,000.00 3,500,000.00 312,225.16 28,044,741.32 31,544,741.32
351 4/1/2053 10,000.00 3,510,000.00 315,447.41 28,360,188.73 31,870,188.73
352 5/1/2053 10,000.00 3,520,000.00 318,701.89 28,678,890.62 32,198,890.62
353 6/1/2053 10,000.00 3,530,000.00 321,988.91 29,000,879.53 32,530,879.53
354 7/1/2053 10,000.00 3,540,000.00 325,308.80 29,326,188.32 32,866,188.32
355 8/1/2053 10,000.00 3,550,000.00 328,661.88 29,654,850.21 33,204,850.21
356 9/1/2053 10,000.00 3,560,000.00 332,048.50 29,986,898.71 33,546,898.71
357 10/1/2053 10,000.00 3,570,000.00 335,468.99 30,322,367.69 33,892,367.69
358 11/1/2053 10,000.00 3,580,000.00 338,923.68 30,661,291.37 34,241,291.37
359 12/1/2053 10,000.00 3,590,000.00 342,412.91 31,003,704.28 34,593,704.28
360 1/1/2054 10,000.00 3,600,000.00 345,937.04 31,349,641.33 34,949,641.33
361 2/1/2054 10,000.00 3,610,000.00 349,496.41 31,699,137.74 35,309,137.74
362 3/1/2054 10,000.00 3,620,000.00 353,091.38 32,052,229.12 35,672,229.12
363 4/1/2054 10,000.00 3,630,000.00 356,722.29 32,408,951.41 36,038,951.41
364 5/1/2054 10,000.00 3,640,000.00 360,389.51 32,769,340.92 36,409,340.92
365 6/1/2054 10,000.00 3,650,000.00 364,093.41 33,133,434.33 36,783,434.33
366 7/1/2054 10,000.00 3,660,000.00 367,834.34 33,501,268.68 37,161,268.68
367 8/1/2054 10,000.00 3,670,000.00 371,612.69 33,872,881.36 37,542,881.36
368 9/1/2054 10,000.00 3,680,000.00 375,428.81 34,248,310.18 37,928,310.18
369 10/1/2054 10,000.00 3,690,000.00 379,283.10 34,627,593.28 38,317,593.28
370 11/1/2054 10,000.00 3,700,000.00 383,175.93 35,010,769.21 38,710,769.21
371 12/1/2054 10,000.00 3,710,000.00 387,107.69 35,397,876.90 39,107,876.90
372 1/1/2055 10,000.00 3,720,000.00 391,078.77 35,788,955.67 39,508,955.67
373 2/1/2055 10,000.00 3,730,000.00 395,089.56 36,184,045.23 39,914,045.23
374 3/1/2055 10,000.00 3,740,000.00 399,140.45 36,583,185.68 40,323,185.68
375 4/1/2055 10,000.00 3,750,000.00 403,231.86 36,986,417.54 40,736,417.54
376 5/1/2055 10,000.00 3,760,000.00 407,364.18 37,393,781.71 41,153,781.71
377 6/1/2055 10,000.00 3,770,000.00 411,537.82 37,805,319.53 41,575,319.53
378 7/1/2055 10,000.00 3,780,000.00 415,753.20 38,221,072.73 42,001,072.73
379 8/1/2055 10,000.00 3,790,000.00 420,010.73 38,641,083.45 42,431,083.45
380 9/1/2055 10,000.00 3,800,000.00 424,310.83 39,065,394.29 42,865,394.29
381 10/1/2055 10,000.00 3,810,000.00 428,653.94 39,494,048.23 43,304,048.23
382 11/1/2055 10,000.00 3,820,000.00 433,040.48 39,927,088.71 43,747,088.71
383 12/1/2055 10,000.00 3,830,000.00 437,470.89 40,364,559.60 44,194,559.60
384 1/1/2056 10,000.00 3,840,000.00 441,945.60 40,806,505.20 44,646,505.20
385 2/1/2056 10,000.00 3,850,000.00 446,465.05 41,252,970.25 45,102,970.25
386 3/1/2056 10,000.00 3,860,000.00 451,029.70 41,703,999.95 45,563,999.95
387 4/1/2056 10,000.00 3,870,000.00 455,640.00 42,159,639.95 46,029,639.95
388 5/1/2056 10,000.00 3,880,000.00 460,296.40 42,619,936.35 46,499,936.35
389 6/1/2056 10,000.00 3,890,000.00 464,999.36 43,084,935.71 46,974,935.71
390 7/1/2056 10,000.00 3,900,000.00 469,749.36 43,554,685.07 47,454,685.07
391 8/1/2056 10,000.00 3,910,000.00 474,546.85 44,029,231.92 47,939,231.92
392 9/1/2056 10,000.00 3,920,000.00 479,392.32 44,508,624.24 48,428,624.24
393 10/1/2056 10,000.00 3,930,000.00 484,286.24 44,992,910.48 48,922,910.48
394 11/1/2056 10,000.00 3,940,000.00 489,229.10 45,482,139.59 49,422,139.59
395 12/1/2056 10,000.00 3,950,000.00 494,221.40 45,976,360.98 49,926,360.98
396 1/1/2057 10,000.00 3,960,000.00 499,263.61 46,475,624.59 50,435,624.59
397 2/1/2057 10,000.00 3,970,000.00 504,356.25 46,979,980.84 50,949,980.84
398 3/1/2057 10,000.00 3,980,000.00 509,499.81 47,489,480.65 51,469,480.65
399 4/1/2057 10,000.00 3,990,000.00 514,694.81 48,004,175.45 51,994,175.45
400 5/1/2057 10,000.00 4,000,000.00 519,941.75 48,524,117.21 52,524,117.21
401 6/1/2057 10,000.00 4,010,000.00 525,241.17 49,049,358.38 53,059,358.38
402 7/1/2057 10,000.00 4,020,000.00 530,593.58 49,579,951.96 53,599,951.96
403 8/1/2057 10,000.00 4,030,000.00 535,999.52 50,115,951.48 54,145,951.48
404 9/1/2057 10,000.00 4,040,000.00 541,459.51 50,657,411.00 54,697,411.00
405 10/1/2057 10,000.00 4,050,000.00 546,974.11 51,204,385.11 55,254,385.11
406 11/1/2057 10,000.00 4,060,000.00 552,543.85 51,756,928.96 55,816,928.96
407 12/1/2057 10,000.00 4,070,000.00 558,169.29 52,315,098.25 56,385,098.25
408 1/1/2058 10,000.00 4,080,000.00 563,850.98 52,878,949.23 56,958,949.23
409 2/1/2058 10,000.00 4,090,000.00 569,589.49 53,448,538.72 57,538,538.72
410 3/1/2058 10,000.00 4,100,000.00 575,385.39 54,023,924.11 58,123,924.11
411 4/1/2058 10,000.00 4,110,000.00 581,239.24 54,605,163.35 58,715,163.35
412 5/1/2058 10,000.00 4,120,000.00 587,151.63 55,192,314.99 59,312,314.99
413 6/1/2058 10,000.00 4,130,000.00 593,123.15 55,785,438.14 59,915,438.14
414 7/1/2058 10,000.00 4,140,000.00 599,154.38 56,384,592.52 60,524,592.52
415 8/1/2058 10,000.00 4,150,000.00 605,245.93 56,989,838.44 61,139,838.44
416 9/1/2058 10,000.00 4,160,000.00 611,398.38 57,601,236.83 61,761,236.83
417 10/1/2058 10,000.00 4,170,000.00 617,612.37 58,218,849.20 62,388,849.20
418 11/1/2058 10,000.00 4,180,000.00 623,888.49 58,842,737.69 63,022,737.69
419 12/1/2058 10,000.00 4,190,000.00 630,227.38 59,472,965.06 63,662,965.06
420 1/1/2059 10,000.00 4,200,000.00 636,629.65 60,109,594.71 64,309,594.71