Difference between revisions of "Documentation/How Tos/Calc: RATE function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Syntax:)
(11 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
 +
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Financial_functions|<div style="font-size: 140%;">Financial Functions]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_RRI_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_PV_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Date_%26_Time_functions
 +
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Information_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Depreciation</div>
 +
* [[Documentation/How_Tos/Calc:_AMORDEGRC_function|<div style="font-size: 120%;">Amordegrc]]
 +
* [[Documentation/How_Tos/Calc:_AMORLINC_function|<div style="font-size: 120%;">Amorlinc]]
 +
* [[Documentation/How_Tos/Calc:_DB_function|<div style="font-size: 120%;">Db]]
 +
* [[Documentation/How_Tos/Calc:_DDB_function|<div style="font-size: 120%;">Ddb]]
 +
* [[Documentation/How_Tos/Calc:_SLN_function|<div style="font-size: 120%;">Sln]]
 +
* [[Documentation/How_Tos/Calc:_SYD_function|<div style="font-size: 120%;">Syd]]
 +
* [[Documentation/How_Tos/Calc:_VDB_function|<div style="font-size: 120%;">Vdb]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Payment Streams, Annuities, Loans</div>
 +
* [[Documentation/How_Tos/Calc:_CUMIPMT_function|<div style="font-size: 120%;">Cumipmt]]
 +
* [[Documentation/How_Tos/Calc:_CUMIPMT_ADD_function|<div style="font-size: 120%;">Cumipmt Add]]
 +
* [[Documentation/How_Tos/Calc:_CUMPRINC_function|<div style="font-size: 120%;">Cumprinc]]
 +
* [[Documentation/How_Tos/Calc:_CUMPRINC_ADD_function|<div style="font-size: 120%;">Cumpinc Add]]
 +
* [[Documentation/How_Tos/Calc:_FV_function|<div style="font-size: 120%;">Fv]]
 +
* [[Documentation/How_Tos/Calc:_FVSCHEDULE_function|<div style="font-size: 120%;">Fvschedule]]
 +
* [[Documentation/How_Tos/Calc:_IPMT_function|<div style="font-size: 120%;">Ipmt]]
 +
* [[Documentation/How_Tos/Calc:_IRR_function|<div style="font-size: 120%;">Irr]]
 +
* [[Documentation/How_Tos/Calc:_ISPMT_function|<div style="font-size: 120%;">Ispmt]]
 +
* [[Documentation/How_Tos/Calc:_MIRR_function|<div style="font-size: 120%;">Mirr]]
 +
* [[Documentation/How_Tos/Calc:_NPER_function|<div style="font-size: 120%;">Nper]]
 +
* [[Documentation/How_Tos/Calc:_NPV_function|<div style="font-size: 120%;">Npv]]
 +
* [[Documentation/How_Tos/Calc:_PMT_function|<div style="font-size: 120%;">Pmt]]
 +
* [[Documentation/How_Tos/Calc:_PPMT_function|<div style="font-size: 120%;">Ppmt]]
 +
* [[Documentation/How_Tos/Calc:_PV_function|<div style="font-size: 120%;">Pv]]
 +
* [[Documentation/How_Tos/Calc:_RATE_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Rate]]
 +
* [[Documentation/How_Tos/Calc:_RRI_function|<div style="font-size: 120%;">Rri]]
 +
* [[Documentation/How_Tos/Calc:_XIRR_function|<div style="font-size: 120%;">Xirr]]
 +
* [[Documentation/How_Tos/Calc:_XNPV_function|<div style="font-size: 120%;">Xnpv]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Securities</div>
 +
* [[Documentation/How_Tos/Calc:_ACCRINT_function|<div style="font-size: 120%;">Accrint]]
 +
* [[Documentation/How_Tos/Calc:_ACCRINTM_function|<div style="font-size: 120%;">Accrintm]]
 +
* [[Documentation/How_Tos/Calc:_DISC_function|<div style="font-size: 120%;">Disc]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_function|<div style="font-size: 120%;">Duration]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
 +
* [[Documentation/How_Tos/Calc:_EFFECTIVE_function|<div style="font-size: 120%;">Effective]]
 +
* [[Documentation/How_Tos/Calc:_EFFECT_ADD_function|<div style="font-size: 120%;">Effect Add]]
 +
* [[Documentation/How_Tos/Calc:_INTRATE_function|<div style="font-size: 120%;">Intrate]]
 +
* [[Documentation/How_Tos/Calc:_MDURATION_function|<div style="font-size: 120%;">Mduration]]
 +
* [[Documentation/How_Tos/Calc:_DURATION_ADD_function|<div style="font-size: 120%;">Duration Add]]
 +
* [[Documentation/How_Tos/Calc:_NOMINAL_function|<div style="font-size: 120%;">Nominal]]
 +
* [[Documentation/How_Tos/Calc:_NOMINAL_ADD_function|<div style="font-size: 120%;">Nominal Add]]
 +
* [[Documentation/How_Tos/Calc:_ODDFPRICE_function|<div style="font-size: 120%;">Oddfprice]]
 +
* [[Documentation/How_Tos/Calc:_ODDFYIELD_function|<div style="font-size: 120%;">Oddfyield]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Coupons</div>
 +
* [[Documentation/How_Tos/Calc:_COUPDAYBS_function|<div style="font-size: 120%;">Coupdaybs]]
 +
* [[Documentation/How_Tos/Calc:_COUPDAYS_function|<div style="font-size: 120%;">Coupdays]]
 +
* [[Documentation/How_Tos/Calc:_COUPDAYSNC_function|<div style="font-size: 120%;">Coupdaysnc]]
 +
* [[Documentation/How_Tos/Calc:_COUPNCD_function|<div style="font-size: 120%;">Coupncd]]
 +
* [[Documentation/How_Tos/Calc:_COUPNUM_function|<div style="font-size: 120%;">Coupnum]]
 +
* [[Documentation/How_Tos/Calc:_COUPPCD_function|<div style="font-size: 120%;">Couppcd]]
 +
 
 +
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Miscellaneous</div>
 +
 
 +
* [[Documentation/How_Tos/Calc:_DOLLARDE_function|<div style="font-size: 120%;">Coupdaybs]]
 +
* [[Documentation/How_Tos/Calc:_DOLLARFR_function|<div style="font-size: 120%;">Coupdays]]
 +
}}__TOC__
  
 
== RATE ==
 
== RATE ==
Line 20: Line 88:
 
: If this function returns error <tt>'''Err:523'''</tt>, the iteration has failed to converge - try a different guess, or recheck the parameters.
 
: If this function returns error <tt>'''Err:523'''</tt>, the iteration has failed to converge - try a different guess, or recheck the parameters.
  
−
: See '''[[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]''' for the underlying formula.
+
: See [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]] for the underlying formula.
  
 
=== Example: ===
 
=== Example: ===
Line 26: Line 94:
 
:  returns approximately <tt>'''4.98%'''</tt>. 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%.
 
:  returns approximately <tt>'''4.98%'''</tt>. 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%.
  
−
=== See also: ===
+
=== Issues: ===
−
[[Documentation/How_Tos/Calc: PV function|'''PV''']],
+
* 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.
−
[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']],
+
−
[[Documentation/How_Tos/Calc: PMT function|'''PMT''']],
+
−
[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']],
+
−
[[Documentation/How_Tos/Calc: NPV function|'''NPV''']],
+
−
[[Documentation/How_Tos/Calc: IRR function|'''IRR''']],
+
−
[[Documentation/How_Tos/Calc: FV function|'''FV''']],
+
−
[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
+
  
−
'''[[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]'''
+
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: PV function|PV]]
 +
* [[Documentation/How_Tos/Calc: IPMT function|IPMT]]
 +
* [[Documentation/How_Tos/Calc: PMT function|PMT]]
 +
* [[Documentation/How_Tos/Calc: PPMT function|PPMT]]
 +
* [[Documentation/How_Tos/Calc: NPV function|NPV]]
 +
* [[Documentation/How_Tos/Calc: FV function|FV]]
 +
* [[Documentation/How_Tos/Calc: NPER function|NPER]]
 +
* [[Documentation/How_Tos/Calc: RRI function|RRI]]
  
−
[[Documentation/How_Tos/Calc: Financial functions|'''Financial functions''']]
+
* [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]
  
−
=== Issues: ===
+
* [[Documentation/How_Tos/Calc: Financial functions|Financial functions]]
−
* 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.
+
 
 +
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Financial functions]]

Revision as of 09:28, 17 July 2018


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 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.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_RATE_function&oldid=243583"
Views
Personal tools
Navigation
Tools