### 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.**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__

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])

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