Difference between revisions of "Documentation/How Tos/Calc: RATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (talk | contribs) |
m |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{ | + | {{DISPLAYTITLE: RATE function}} |
| − | + | {{Documentation/CalcFunc FinancialTOC | |
| − | + | |ShowPrevNext=block | |
| − | + | |PrevPage=Documentation/How_Tos/Calc:_PV_function | |
| − | | | + | |NextPage=Documentation/How_Tos/Calc:_RRI_function |
| − | + | }}__NOTOC__ | |
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | }} | ||
== RATE == | == RATE == | ||
| Line 76: | Line 13: | ||
: <tt>'''rate'''</tt>: the (fixed) interest rate per period. | : <tt>'''rate'''</tt>: the (fixed) interest rate per period. | ||
: <tt>'''numperiods'''</tt>: the total number of payment periods in the term. | : <tt>'''numperiods'''</tt>: the total number of payment periods in the term. | ||
| − | : <tt>'''payment'''</tt>: the payment made each period. If <tt>'''futurevalue'''</tt> is given, this may omitted (defaults to 0). | + | : <tt>'''payment'''</tt>: the payment made each period. If <tt>'''futurevalue'''</tt> is given, this may be omitted (defaults to 0). |
: <tt>'''presentvalue'''</tt>: the lump sum payment at the start of the term. | : <tt>'''presentvalue'''</tt>: the lump sum payment at the start of the term. | ||
: <tt>'''futurevalue'''</tt>: the cash balance you wish to attain at the end of the term (optional - defaults to 0). | : <tt>'''futurevalue'''</tt>: the cash balance you wish to attain at the end of the term (optional - defaults to 0). | ||
| Line 97: | Line 34: | ||
* Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not. | * Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not. | ||
| − | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: PV function|PV]] | * [[Documentation/How_Tos/Calc: PV function|PV]] | ||
* [[Documentation/How_Tos/Calc: IPMT function|IPMT]] | * [[Documentation/How_Tos/Calc: IPMT function|IPMT]] | ||
Latest revision as of 16:02, 30 January 2024
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
| < {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
RATE
Calculates the interest rate for an annuity.
Syntax:
RATE(numperiods; payment; presentvalue; futurevalue; type; guess)
- rate: the (fixed) interest rate per period.
- numperiods: the total number of payment periods in the term.
- payment: the payment made each period. If futurevalue is given, this may be omitted (defaults to 0).
- presentvalue: the lump sum payment at the start of the term.
- futurevalue: the cash balance you wish to attain at the end of the term (optional - defaults to 0).
- type: when payments are made (optional - defaults to 0):
- 0 - at the end of each period.
- 1 - at the start of each period (including a payment at the start of the term).
- guess: an optional guess of the interest rate (defaults to 10%).
- RATE calculates the fixed interest rate needed, so that presentvalue (the value today) followed by a payment each period for numperiods periods results in futurevalue, the value at the end of the term. Interest is assumed to be compounded each period. The calculation uses iteration to solve an equation, with guess as the starting value for the iteration.
- If this function returns error Err:523, the iteration has failed to converge - try a different guess, or recheck the parameters.
- See Derivation of Financial Formulas for the underlying formula.
Example:
RATE(3; -1000; 0; 3152; 0; 10%)
- returns approximately 4.98%. You pay 1,000 at the end of each year for 3 years, and receive 3,152.50 at the end of the term. The applicable interest rate was 4.98%.
Issues:
- Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}
