Excel - compound interest with continuing contribution

0 votes
I'm looking for a formula in Excel that will use compound interest and let me contribute a continuous payment for "x" number of years.

i.e., a contribution of $10,000 with an annual interest rate of 10%. I make a $10,000 yearly contribution for the next 35 years. How much will the account be worth?
Oct 7, 2022 in Others by Kithuzzz
• 38,020 points
698 views

1 answer to this question.

0 votes

The FV() formula would be what you're looking for.

=FV(10%,35,-10000)

There are variations to this formula.

  • 10% assumes you only make one payment a year. If you pay 12 times a year, use 10%/12.
  • 35 is the total number of years. This doesn't change even if you change the above.
  • -10000 is your 10k / year payment.
answered Oct 8, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
0 answers

Download Excel sheet from .NET Core 3.1 Web API with jQuery Ajax client

I am trying to download an Excel ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,690 points
1,095 views
0 votes
0 answers

Excel: Highlighting duplicates with exact matches

1 I've got two columns of data, and ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
433 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18, 2022 in Others by Edureka
• 13,690 points
381 views
0 votes
1 answer

Reading/parsing Excel (xls) files with Python

I highly recommend xlrd for reading .xls files. But there are ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,720 points
692 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
3,517 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,870 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
926 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,444 views
0 votes
1 answer

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

answered Nov 26, 2022 in Others by narikkadan
• 63,720 points
2,591 views
0 votes
1 answer

How to convert an excel formula to SQL to calculate daily compound interest

Here is a solution that is effective. ...READ MORE

answered Nov 26, 2022 in Others by narikkadan
• 63,720 points
812 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP