Function:  

CURRENCY_SYMBOL  

Description:  

Returns the currency symbol for the given currency code  

Parameters:  

Currency code, for example USD  

Example:  

CURRENCY_SYMBOL(‘USD’)

   

Function:  

PV  

Description:  

Calculates present value of an investment. The present value is the total amount that a series of future payments is worth now  

Parameters:  

1) Rate – interest rate per period (in percents, 50% is 0.5).

2) Nper – total number of payment periods in an annuity  

3) Payment – payment made each period  

4) Future value (optional) – future value or the cash balance you want to attain after the last payment is made. If omitted assumed to be 0  

5) Type (optional) – indicates when payments are due. 0 or omitted – at the end of the period; 1 – at the start of the period  

Example:  

PV (0.08, 12 * 20, 500, 0, 0)

   

Function:  

FV  

Description:  

Calculates the future value of an investment based on periodic constant payments and a constant interest rate  

Parameters:  

1) Rate – interest rate per period (in percents, 50% is 0.5).

2) Nper – total number of payment periods in an annuity  

3) Payment – payment made each period  

4) Present value (optional) – present value or the lump-sum amount that a series of future payments is worth right now. If omitted assumed to be 0  

5) Type (optional) – indicates when payments are due. 0 or omitted – at the end of the period; 1 – at the start of the period  

Example:  

FV (0.08, 12 * 20, 500, 0, 0)

   

Function:  

NPER  

Description:  

Calculates total number of payment periods in an annuity  

Parameters:  

1) Rate – interest rate per period (in percents, 50% is 0.5).  

2) Payment – payment made each period  

3) Future value (optional) – future value or the cash balance that is attained after the last payment is made. If omitted assumed to be 0  

4) Present value (optional) – present value or the lump-sum amount that a series of future payments is worth right now. If omitted assumed to be 0  

5) Type (optional) – indicates when payments are due. 0 or omitted – at the end of the period; 1 – at the start of the period  

Example:  

NPER (0.08, 500, 0, 0, 0)

   

Function:  

PMT  

Description:  

Calculates payment to be made each period  

Parameters:  

1) Rate – interest rate per period (in percents, 50% is 0.5).  

2) Nper – total number of payment periods in an annuity  

3) Future value (optional) – future value or the cash balance that is attained after the last payment is made. If omitted assumed to be 0  

4) Present value (optional) – present value or the lump-sum amount that a series of future payments is worth right now. If omitted assumed to be 0  

5) Type (optional) – indicates when payments are due. 0 or omitted – at the end of the period; 1 – at the start of the period  

Example:  

PMT (0.08, 12 * 20, 500,  0, 0)