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

Returns the future value of a series of equal cash flows at regular intervals.

rateThe fixed interest rate per period.
nperThe total number of payments.
pmtThe fixed payment made each period.
pv(Optional) The present value.
type(Optional) The number indicating when the payments are due:
0 = the end of the period (default)
1 = the start of the period

Remarks

* For an illustrated example refer to the page called Future Value > Compounding Interest.
* A negative number represents any cash you pay out.
* A positive number represents any cash you receive (start with or end with).
* The "rate" and "nper" MUST be expressed in the same units of time: years, months or days.
* The "rate" can either be entered with the percentage sign or as a decimal.
* The "nper" is the number of compounding periods.
* If "pmt" is left blank, you must include "pv".
* If "pmt" is left blank, then 0 is used.
* The "pv" is the present value of any cash you have initially.
* If "pv" is left blank, then you must include "pmt".
* If "pv" is left blank, then 0 is used.
* If "type" = 0, then payments are made in arrears.
* If "type" is left blank, then 0 is used.
* You can use the PV function to return the present value of a series of equal cash flows at regular intervals.
* You can use the RATE function to return the interest rate for a series of equal cash flows at regular intervals.
* The equivalent VBA function is FV
* For the Microsoft documentation refer to support.office.com

 A
1=FV(5.8%,3,,-2000) = £2,368.57
2=FV(0.058,3,,-2000) = £2,368.57
3=PV(0.058,3,,-2368.574) = £2,000.00
4=FV(0.058/12,3*12,,-2000) = £2,379.11
5=FV(0.058/365,3*365,,-2000) = £2,380.08
6=FV(0.062,3,12*-150) = £5,741.72
7=FV(0.062/12,3*12,-150) = £5,918.10
8=PV(0.047/12,2*12,150,-3741.433) = -£23.19
9=FV(0.08,4,,-20000) = £27,209.78
10=FV(0.047/12,3*12,-150,-2000) = £8,089.31
11=A7+A4 = £8,297.21
12=RATE(3*12,-150,-2000,8261.913)*12 = 5.80%
13=FV(12.5%/12,5*12,-200,15000) = -£11,378.69
14=FV(0.125/12,5*12,0,-15000) = £27,933.24
15=FV(0.125/12,5*12,-200,0) = £16,554.55
16=A14-A15 = £11,378.69

1 & 2 - How much is £2,000 worth in 3 years time with an interest rate of 5.8% (compounded yearly).
3 - This is checking the answer in Examples 1 & 2.
4 - How much is £2,000 worth is 3 years time with an interest rate of 5.8% (compounded monthly). Notice this value is larger than the answer in 1.
5 - How much is £2,000 worth in 3 years time with an interest rate of 5.8% (compounded daily). Notice this value is larger than the answer in 4.
6 - How much will I have saved if I deposit £150 every month for 3 years assuming a fixed annual growth rate of 6.2% (compounded yearly).
7 - How much will I have saved if I deposit £150 every month for 3 years assuming a fixed annual growth rate of 6.2% (compounded monthly).
8 - This is checking the answer in 4.
9 - How much would I have to pay back if I borrowed £20,000 for 4 years at an annual interest rate of 8%.
10 - How much will I have saved if I have £2,000 in my account and I deposit a further £150 every month for 3 years with a fixed annual growth rate of 4.7%.
11 - This is checking the answer in 10.
12 - This is checking the above answers by returning the correct interest rate.
13 - How much would I still have to pay back if I borrowed £15,000 for 5 years at an annual interest rate of 12.5% and was capable of repaying back £200 a month.
14 - How much will I need to pay back if I borrow £15,000 for 5 years at an annual interest rate of 12.5%.
15 - How much will I have saved if I deposit £200 a month for 5 years at an annual interest rate of 12.5%.
16 - This is checking the answer in 13.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top