Difference between revisions of "Manuals/calci/RATE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | =RATE( | + | <div style="font-size:30px">'''RATE (NumberOfPayments,Payment,PV,FutureValue,Type,Guess)'''</div><br/> |
| − | *where, <math> | + | *where, <math>NumberOfPayments</math> represents total number of payment periods |
*<math>Payment</math> represents the payment made for each period | *<math>Payment</math> represents the payment made for each period | ||
| − | *<math> | + | *<math>PV</math> represents the remaining value of payment to be done |
*<math>FutureValue</math> represents the balance value to attain after last payment is made | *<math>FutureValue</math> represents the balance value to attain after last payment is made | ||
*<math>Type</math> represents the payments due | *<math>Type</math> represents the payments due | ||
*<math>Guess</math> is the guess value for what rate will be | *<math>Guess</math> is the guess value for what rate will be | ||
| − | RATE() | + | RATE() returns the interest rate per period of an annuity. |
== Description == | == Description == | ||
| − | RATE( | + | RATE (NumberOfPayments,Payment,PV,FutureValue,Type,Guess) |
*RATE is calculated by iteration and can have zero or more solutions. | *RATE is calculated by iteration and can have zero or more solutions. | ||
Revision as of 15:31, 27 July 2018
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
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 beRATE() 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.33263515005213806 as a result.
Related Videos
See Also
References