# Manuals/calci/RATE

Jump to navigation
Jump to search

**RATE (NumberOfPayments,Payment,PV,FutureValue,Type,Guess)**

- where, represents total number of payment periods
- represents the payment made for each period
- represents the remaining value of payment to be done
- represents the balance value to attain after last payment is made
- represents the payments due
- is the guess value for what rate will be
- RATE() returns the interest rate per period of an annuity.

## Description

RATE (NumberOfPayments,Payment,PV,FutureValue,Type,Guess)

- RATE is calculated by iteration and can have zero or more solutions.
- includes principal value and the interest amount. If omitted, is required.
- , and are optional.
- If is omitted, Calci assumes it to be zero(0).
- can be represented as '1' or '0'.

Type | Payments Due |
---|---|

0 or omitted | At the end of the period |

1 | At the beginning of the period |

- If is omitted, Calci assumes it to be 10%.

## Examples

Consider the following example that shows the use of RATE function:

2 | 8 | |

-50 | -100 | |

2000 | 50000 | |

0 | 0 | |

1 | 0 | |

12% |

=RATE(A1*12,A2,A3,A4,A5,A6) displays monthly rate of loan-4.01%as a result. =RATE(B1*12,B2,B3,B4,B5) displays monthly rate of loan-2.77%as a result. =RATE(B1*12,B2,B3,B4,B5)*12 displays annual rate of loan-0.33263515005213806as a result.

## Related Videos

## See Also

## References