Basic Financial Functions

PMTThe payment for a loan with constant payments and fixed interest.
FVThe future value of an investment over a period of time.
PVThe present value of an investment.
RATEThe interest rate per period of an annuity.
NPERThe number of periods for an investment.

Understanding Monthly Deposits

Any savings account consist of five important numbers. These are the following:
0) The final lump sum you will receive at the end (often called the future value).
1) The total amount you want to invest every month.
2) The interest rate which you will receive on your deposits.
3) The number of years the money will be in the bank for.
4) The number of years it will take for you to have saved a certain amount.

Lets assume you want to save £150 a month for 3 years in an account that offers 5.8% interest a year.

FV - How much would I have saved at the end ?

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

PMT - How much do I need to save a month ?

PMT(rate, nper, pv [,fv] [,type])

RATE - What interest rate am I getting ?

RATE(nper, pmt, pv [,fv] [,type] [,guess])

NPER - How many months have I been saving for ?

NPER(rate, pmt, pv [,fv] [,type])

NPER - How many years until I have £20,000

NPER(rate, pmt, pv [,fv] [,type])

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext