Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Financial > Getting Started | Next > 

 

Terminology

 
 

Amortisation - This is the term given to the process of paying back loans.

 
 

Annuity - This is just a series of constant cash payments made over a continuous period. For example, a car loan or a mortgage is an annuity.

 
 

A series of equal payments if often called an ordinary annuity.

 
 

Rate - This refers to the interest rate and is usually expressed an an annual interest rate

 


 

Basic Financial Functions

 
 

There are 5 basic financial functions and these refer to circumstances when you have a fixed rate of interest throughout a period of time.

 
 
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 (or principle) of an investment.
RATEThe interest rate per period of an annuity.
NPERThe number of periods for an investment.
 

 

Positive or Negative

 
 

Money that is paid to you is positive

 
 

Money that is deposited or is spent by you in negative.

 

 

Cross Checking

 
 

You can easily check you have the correct answer in your calculations by cross checking

 
 

SS example

 



 
IPMTThe interest payment for a given period of an investment.
PPMTThe payment on principle for a given period for an investment.
 



 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top | Next >