Forum Discussion
Excel formula for compound interest and "deposits" during 60 years?
Hi, I would like to make an excel formula according to this situation: Person A / Person B Person A invests 1000$ every year from 18 to 28, and then holds it until age 65. It compounds every year ...
Hi aldrigoffice
I have set-up an attached sample file that hopefully will help you. Two separate schedules for Person A & B showing annual interest earned and progressive value of investment.
Excel's built-in financial functions =FV (rate, nper, pmt, [pv], [type]) is also used to cross check the calculated numbers.
Note: It is assumed that investment will be made at the begging of the period (annuity due), calculation will have to be revised if investment is made at the end of the period.
Please let me know if it works for you.
Thanks
Tauqeer