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 306 views

## 1 answer to this question.

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.
• 63,180 points

## Excel: Highlighting duplicates with exact matches

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

## MS Excel - SumProduct formula with Loop

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

## Reading/parsing Excel (xls) files with Python

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

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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