FV
Returns the future value of an investment that has equal periodic payments and a fixed rate.
FV(<rate>, <nper>, <pmt> [, <pv>] [, <type>])Returns: A number. Cash you put in is negative, so the future value of money you have invested is shown as a positive amount.
What it does
FV answers the question "what will this investment be worth at the end?" It grows a starting amount and a series of payments at a fixed rate over a number of periods. Finance teams use it for savings and sinking fund projections, for the balance a deposit will reach, for the value of a reserve at a future date, and for the compound growth of an investment that the board is reviewing.
Syntax and arguments
- rate: the interest rate per period. Match it to the payment period. Required.
- nper: the number of periods. Required.
- pmt: the payment per period. Cash you put in is negative. Required.
- pv: a starting amount. Cash you put in is negative. Optional, and 0 is the default.
- type: 0 for end-of-period payments (the default), or 1 for start-of-period payments. Optional.
Example
A treasurer puts 500 a month into a reserve account that earns 0.5 percent a month, for five years. The payment is cash that leaves the operating account, so it is entered as -500.
Reserve Balance in 5 Years = FV(0.005, 60, -500)
The result is 34,885.02, the balance at the end of month 60 from the 60 deposits and the monthly interest. The total deposited is 30,000, so the difference is the interest earned.
Example: a second, different use
A single amount of 1,000 invested today at 4% a year for five years. The starting amount is entered as -1,000, because it is cash paid into the investment.
Investment Value in 5 Years = FV(0.04, 5, 0, -1000)
The result is 1,216.65, which is 1,000 grown at 4% a year for five years.
Things to watch
- Keep the rate and the number of periods on the same basis. A monthly deposit needs the monthly rate.
- Cash in and cash out must have opposite signs. If the deposits and the starting amount are both positive, the result has the wrong sign.
- FV assumes a fixed rate. Interest that changes over time needs a schedule, not FV.
- The result is a projection, not an actual balance. Label it as such in the report.
In business terms
FV supports savings and sinking fund plans, reserve projections, the growth of a deposit in a treasury policy, and the future value of a contribution plan. It is also used to check the balance at the end of a loan, where the remaining balance is the future value of the loan amount less the payments made.