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

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
−
{{Documentation/MasterTOC
+
{{DISPLAYTITLE: IRR function}}
−
|bookid=1234'''
+
{{Documentation/CalcFunc FinancialTOC
−
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
+
|ShowPrevNext=block
−
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Financial_functions|<div style="font-size: 140%;">Financial Functions]]
+
|PrevPage=Documentation/How_Tos/Calc:_IPMT_function
−
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_ISPMT_function
+
|NextPage=Documentation/How_Tos/Calc:_ISPMT_function
−
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_IPMT_function
+
}}__NOTOC__
−
|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%; border-style: double; border-color:#778899;">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%;">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__
+
  
 
== IRR ==
 
== IRR ==
Line 80: Line 17:
 
: <tt>'''IRR'''</tt> iterates to find the rate of return which gives a zero net present value for the cash flows. At least one of the cash flows must be negative and at least one positive - to allow the net present value to be zero. The rate of return is per period, and interest is compounded each period.
 
: <tt>'''IRR'''</tt> iterates to find the rate of return which gives a zero net present value for the cash flows. At least one of the cash flows must be negative and at least one positive - to allow the net present value to be zero. The rate of return is per period, and interest is compounded each period.
  
−
: The payments are assumed to arise at the start of each period; the order in which the payments are given is important.  
+
: The payments are assumed to arise at the start of each period; the order in which the payments are given is important.  
  
 
=== Example: ===
 
=== Example: ===
Line 89: Line 26:
 
* This function does not currently accept arrays.
 
* This function does not currently accept arrays.
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: NPV function|NPV]]
 
* [[Documentation/How_Tos/Calc: NPV function|NPV]]
 
* [[Documentation/How_Tos/Calc: MIRR function|MIRR]]
 
* [[Documentation/How_Tos/Calc: MIRR function|MIRR]]

Latest revision as of 15:54, 30 January 2024

IRR

Calculates the internal rate of return of a series of cash flows.

Syntax:

IRR(payments; guess)

payment is a range containing the payments made or received, at regular intervals.
guess (optional, defaults to 10%) is a first guess at the rate.


IRR iterates to find the rate of return which gives a zero net present value for the cash flows. At least one of the cash flows must be negative and at least one positive - to allow the net present value to be zero. The rate of return is per period, and interest is compounded each period.
The payments are assumed to arise at the start of each period; the order in which the payments are given is important.

Example:

IRR(A1:A4)

where A1:A4 contain -5000, 1000, 2000, 3000, returns approximately 8.21%.

Issues:

  • This function does not currently accept arrays.


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