Simply expressed, I want to know how to access the Excel capability found on this page.

I attempted to use the FV function, but it does not appear to have support for annual payment increases.

The payment increase may be expressed in percentage points (as in the linked page) or even by a set sum each year (like "increase deposit by 10000 every year).

An illustration:
Year 1:

```Monthly Deposit: 5000
No. of deposits in a year: 12
Interest rate: 10%
Interest compounded quarterly
Total deposited during the year: **60000**
Interest earned in first year: **3323**
```

Year 2:

```Amount carried forward from first year: **603323** (principal + Interest)
Monthly Deposit: 5500 (increased by 10% or increased by a fixed value of 500 every year)
No. of deposits in a year: 12
Interest rate: 10%
Interest compounded quarterly
Total deposited during the year: 66000
Interest earned during year: 13552 (large, because we started the year with seed value from previous year)
```

and so on.

The FV function gives me the correct value for year 1, but I could not find a way to extrapolate it to increase investment every year.

Nov 26, 2022 in Others 2,082 views

## 1 answer to this question.

It's possible that I don't understand how to calculate quarterly interest because I'm using Excel 2003. You should be able to adjust the monthly compound solution I have. To add further years, enter the year number in column A and copy and paste the formula into column B. The formula is =FV(\$B\$2/12, \$B\$3, \$B\$4, +A9*\$B\$7, -\$B9,\$B\$6) in cells b10. It increases the value in B7 to the payment rate for every additional year, using the previous year's outcome as the baseline.

• 63,700 points

## Excel - compound interest with continuing contribution

The FV() formula would be what you're looking for. =FV(10%,35,-10000) There ...READ MORE

## Excel formula for Euclidean distance

Euclidean Norm of a vector of size ...READ MORE

## Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

## Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...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