Difference between revisions of "Documentation/How Tos/Calc: XIRR function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
(6 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: XIRR function}} |
+ | {{Documentation/CalcFunc FinancialTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_RRI_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_XNPV_function | ||
+ | }}__NOTOC__ | ||
== XIRR == | == XIRR == | ||
Line 20: | Line 25: | ||
: where A1:A4 contain -2750, 1000, 2000, and B1:B4 contain dates "2008-02-05", "2008-07-05", "2009-01-05" returns approximately <tt>'''0.124'''</tt>, or 12.4%. The dates once entered into B1:B4 will display as set in the current locale. | : where A1:A4 contain -2750, 1000, 2000, and B1:B4 contain dates "2008-02-05", "2008-07-05", "2009-01-05" returns approximately <tt>'''0.124'''</tt>, or 12.4%. The dates once entered into B1:B4 will display as set in the current locale. | ||
− | {{ | + | === Issues: === |
+ | * This function does not currently accept arrays. | ||
+ | |||
+ | {{SeeAlso|EN| | ||
* [[Documentation/How_Tos/Calc: IRR function|IRR]] | * [[Documentation/How_Tos/Calc: IRR function|IRR]] | ||
* [[Documentation/How_Tos/Calc: MIRR function|MIRR]] | * [[Documentation/How_Tos/Calc: MIRR function|MIRR]] | ||
Line 28: | Line 36: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | + | [[Category: Documentation/Reference/Calc/Financial functions]] | |
− | |||
− |
Latest revision as of 16:04, 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 | }} > |
XIRR
Calculates the internal rate of return of a series of irregular cash flows.
Syntax:
XIRR(payments; dates; guess)
- payments is a range containing the payments made or received, at irregular intervals.
- dates is a range containing dates on which the payments were made or received.
- guess (optional, defaults to 10%) is a first guess at the rate.
- XIRR 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 annum, and interest is assumed compounded annually, with a year assumed to be 365 days long. Specifically, the equation solved is:
- The order in which the payments/dates are stated is not important, except that the first payment given must have the earliest date.
Example:
XIRR(A1:A4; B1:B4)
- where A1:A4 contain -2750, 1000, 2000, and B1:B4 contain dates "2008-02-05", "2008-07-05", "2009-01-05" returns approximately 0.124, or 12.4%. The dates once entered into B1:B4 will display as set in the current locale.
Issues:
- This function does not currently accept arrays.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}