FV function in Excel

Use

FV function (Also known as future value function) calculates the future value of an investment.

Syntax

FV(rate,nper,pmt,[pv],[type])

rate – The interest rate per period. (per month or annum etc.)

nper – The number of payment periods in an annuity/ investment.

pmt –  The payment made during each period.

[pv] – [optional] The present value of future payments. If omitted, assumed to be zero. Must be entered as a negative number.

[type] – The optional argument that indicated when payments are due:

Set type equal to

If payments are due

0 At the end of the period
1 At the beginning of the period

Example

Formula:

Result:

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved