Highlighted
New Contributor

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 with 8%.

Person B invests 0\$ every year from 18 to 28 but then starts to invest 1000\$ every year until age 65. It compounds every with with 8%.

I want 47 rows (65-18) for Person A & B and finally a "total". I want to see it grow in every cell.

Anyone that could help me set it up and perhaps link it to a an upload service? I want to learn...

Thanks!

Highlighted

Re: Excel formula for compound interest and "deposits" during 60 years?

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