Difference between revisions of "Manuals/calci/RATE"
Jump to navigation
Jump to search
| (4 intermediate revisions by 3 users not shown) | |||
| 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() 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. | ||
*<math>Payment</math> includes principal value and the interest amount. If omitted, <math>FutureValue</math> is required. | *<math>Payment</math> includes principal value and the interest amount. If omitted, <math>FutureValue</math> is required. | ||
| − | + | *<math>FutureValue</math>, <math>Type</math> and <math>Guess</math> are optional. | |
*If <math>FutureValue</math> is omitted, Calci assumes it to be zero(0). | *If <math>FutureValue</math> is omitted, Calci assumes it to be zero(0). | ||
*<math>Type</math> can be represented as '1' or '0'. | *<math>Type</math> can be represented as '1' or '0'. | ||
| Line 70: | Line 69: | ||
=RATE(B1*12,B2,B3,B4,B5) displays monthly rate of loan ''-2.77%'' 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. | =RATE(B1*12,B2,B3,B4,B5)*12 displays annual rate of loan ''-0.33263515005213806'' as a result. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|GtaoP0skPWc|280|center|RATE}} | ||
== See Also == | == See Also == | ||
| Line 78: | Line 81: | ||
*[http://en.wikipedia.org/wiki/Interest_rate_derivative Interest Rate Derivative] | *[http://en.wikipedia.org/wiki/Interest_rate_derivative Interest Rate Derivative] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 16:23, 22 August 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
- RATE() returns the interest rate per period of an annuity.
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
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