Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-842294%22%20slang%3D%22en-US%22%3EExcel%20formula%20for%20compound%20interest%20and%20%22deposits%22%20during%2060%20years%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842294%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20make%20an%20excel%20formula%20according%20to%20this%20situation%3A%3C%2FP%3E%3CP%3EPerson%20A%20%2F%20Person%20B%3CBR%20%2F%3EPerson%20A%20invests%201000%24%20every%20year%20from%2018%20to%2028%2C%20and%20then%20holds%20it%20until%20age%2065.%20It%20compounds%20every%20year%20with%208%25.%3C%2FP%3E%3CP%3EPerson%20B%20invests%200%24%20every%20year%20from%2018%20to%2028%20but%20then%20starts%20to%20invest%201000%24%20every%20year%20until%20age%2065.%20It%20compounds%20every%20with%20with%208%25.%3C%2FP%3E%3CP%3EI%20want%2047%20rows%20(65-18)%20for%20Person%20A%20%26amp%3B%20B%20and%20finally%20a%20%22total%22.%20I%20want%20to%20see%20it%20grow%20in%20every%20cell.%3C%2FP%3E%3CP%3EAnyone%20that%20could%20help%20me%20set%20it%20up%20and%20perhaps%20link%20it%20to%20a%20an%20upload%20service%3F%20I%20want%20to%20learn...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BThanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842294%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842324%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20for%20compound%20interest%20and%20%22deposits%22%20during%2060%20years%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842324%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387021%22%20target%3D%22_blank%22%3E%40aldrigoffice%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20set-up%20an%20attached%20sample%20file%20that%20hopefully%20will%20help%20you.%20Two%20separate%20schedules%20for%20Person%20A%20%26amp%3B%20B%20showing%20annual%20interest%20earned%20and%20progressive%20value%20of%20investment.%3C%2FP%3E%3CP%3EExcel's%20built-in%20financial%20functions%26nbsp%3B%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E%3DFV%3C%2FSTRONG%3E%3C%2FFONT%3E%3CSPAN%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3E%26nbsp%3B(rate%2C%20nper%2C%20pmt%2C%20%5Bpv%5D%2C%20%5Btype%5D)%3C%2FSTRONG%3E%3C%2FFONT%3Eis%20also%20used%20to%20cross%20check%20the%20calculated%20numbers.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENote%3A%20It%20is%20assumed%20that%20investment%20will%20be%20made%20at%20the%20begging%26nbsp%3Bof%20the%20period%20(%3CSTRONG%3Eannuity%20due)%3C%2FSTRONG%3E%2C%20calculation%20will%20have%20to%20be%20revised%20if%20investment%20is%20made%20at%20the%20end%20of%20the%20period.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20let%20me%20know%20if%20it%20works%20for%20you.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETauqeer%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
aldrigoffice
New Contributor

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! 

1 Reply

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

 

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies