# Basic Financial Functions

 PMT The payment for a loan with constant payments and fixed interest. FV The future value of an investment over a period of time. PV The present value of an investment. RATE The interest rate per period of an annuity. NPER The 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.
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
FV(rate, nper, pmt [,pv] [,type]) ### PMT - How much do I need to save a month ?

PMT
PMT(rate, nper, pv [,fv] [,type]) ### RATE - What interest rate am I getting ?

RATE
RATE(nper, pmt, pv [,fv] [,type] [,guess]) ### NPER - How many months have I been saving for ?

NPER
NPER(rate, pmt, pv [,fv] [,type]) ### NPER - How many years until I have £20,000

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