Downloads
DAXFinancialIntermediate

FV

Returns the future value of an investment that has equal periodic payments and a fixed rate.

Syntax
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

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

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals