• 460K Members
• 12.3K Online
• 557K Conversations

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!

# 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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies