FV |
FV(rate, nper, pmt [,pv] [,type]) |
Returns the future value of a series of equal cash flows at regular intervals. |
rate | The fixed interest rate per period. |
nper | The total number of payments. |
pmt | The fixed payment made each period. |
pv | (Optional) The present value (0). |
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 [[Compounding Interest]] page. * 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 NPER function to return the number of periods for an investment. * You can use the PMT function to return the full amount (principal + interest) paid every period on a loan with fixed interest. * 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 VBA.FV * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top