Question

lets suppose, My initial investment is 5,00,000 Rs and I invest 1,00,000 rs per month .
My investment earns 10 percent P. A. and after 3 year I increased my investment to 2,00,000 per month. and the intrest rate or return is same 10 percent per annum.

After 6 years i startes to invest 3,00,000 rs per month and intrest rate or return is same.

after 10 year i startes to invest 10,00,000 rs per month and intrest remains same.

here , i never withdrawn my investment and i reinvest the 10 percent return every year as i received. Please re read the question, and answer correctly. there will be going to return on intrest as i will re invest them every year. consider i receive 10 percent intrest at end of year and as i receive i re invest the same.

So what will be my Net worth ( total money)
1) after 1 year
2) after 2 year
3) after 3 year
4) after 4 year
5) after 5 year
6) after 6 year
7) after 7 year
8) after 8 year
9) after 9 year
10) after 10 year
11) after 15 year
12) after 20 year
13) after 30 year
14) after 40 year
15) after 50 year
16) after 60 year

please also tell me how much time exactly you took to answer the questtion and is there any shortcut to answer the same. as its very leanth question

Answer 1

Net worth assuming the interest is accrued monthly after:

year 1: Rs. 17,08,913

Year 2: Rs. 31,54,887

Year 3: Rs. 47,52,273

Year 4: Rs. 90,50,982

It took around 5-10 mins in excel to calculate the above. the following is the method

Month	Opening	Investment	Interest	Net worth
1	-	500,000.00	4,166.67	504,166.67
2	504,166.67	100,000.00	5,034.72	609,201.39

The investment column is your investment amount for that month, the interest is the interest for 1 month for the opening amount plus the investment. New worth is the closing balance (Opening plus investment plus interest)