Achieving a Certain Future Value

Problem

You want to put away a sum of money annually at a given interest rate in order to achieve a specific future value to cover a known upcoming expense. You need to know how much to put away each year.

Solution

Use the PMT function.

Discussion

By way of example, let's assume you need $150,000 in 15 years' time and you want to invest a sum of money annually to raise this money. You're confident you can get an annual interest rate on your investment of 7.6%. How much do you invest each year?

You can use the PMT function (see Recipe 14.5) to compute the annual amount to invest. The formula =PMT(0.076, 15, 0, 150000, 0) returns a payment value for this example of $5,698.76 per year.

See Also

See Recipe 14.5 for more information on the syntax for PMT.

Категории