Difference between revisions of "Documentation/How Tos/Calc: DURATION ADD function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
| (9 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | __NOTOC__ | + | {{DISPLAYTITLE: DURATION_ADD function}} |
| + | {{Documentation/CalcFunc FinancialTOC | ||
| + | |ShowPrevNext=block | ||
| + | |PrevPage=Documentation/How_Tos/Calc:_DURATION_function | ||
| + | |NextPage=Documentation/How_Tos/Calc:_EFFECTIVE_function | ||
| + | }}__NOTOC__ | ||
== DURATION_ADD == | == DURATION_ADD == | ||
| Line 27: | Line 32: | ||
<tt>'''DURATION_ADD("2008-2-28"; "2010-8-31"; 5%; 6%; 2; 0)'''</tt> | <tt>'''DURATION_ADD("2008-2-28"; "2010-8-31"; 5%; 6%; 2; 0)'''</tt> | ||
: returns approximately <tt>'''2.33'''</tt> years. | : returns approximately <tt>'''2.33'''</tt> years. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
=== Issues: === | === Issues: === | ||
| Line 40: | Line 37: | ||
* The <tt>'''DURATION'''</tt> function in Calc is entirely different. | * The <tt>'''DURATION'''</tt> function in Calc is entirely different. | ||
* This function uses <tt>'''YEARFRAC'''</tt> in the calculation. There are known slight inaccuracies (both in Calc and in Excel) in <tt>'''YEARFRAC'''</tt>. | * This function uses <tt>'''YEARFRAC'''</tt> in the calculation. There are known slight inaccuracies (both in Calc and in Excel) in <tt>'''YEARFRAC'''</tt>. | ||
| + | |||
| + | {{SeeAlso|EN| | ||
| + | * [[Documentation/How_Tos/Calc: DURATION function|DURATION]] | ||
| + | * [[Documentation/How_Tos/Calc: MDURATION function|MDURATION]] | ||
| + | |||
| + | * [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]] | ||
| + | |||
| + | * [[Documentation/How_Tos/Calc: Financial functions|Financial functions]] | ||
| + | |||
| + | * [[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]] | ||
Latest revision as of 10:51, 31 January 2024
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
DURATION_ADD
Returns the Macaulay duration of a security.
This function is only available if the Analysis AddIn is installed.
Syntax:
DURATION_ADD(settlementdate; maturitydate; rate; yield; frequency; basis)
- settlementdate: the settlement (purchase) date of the bond.
- maturitydate: the maturity (redemption) date of the bond.
- rate: the (annual) interest rate of the bond.
- yield: the (annual) yield of the bond.
- frequency: the number of interest payments per year (1, 2 or 4).
- basis: is the calendar system to use. Defaults to 0 if omitted.
- 0 - US method (NASD), 12 months of 30 days each
- 1 - Actual number of days in months, actual number of days in year
- 2 - Actual number of days in month, year has 360 days
- 3 - Actual number of days in month, year has 365 days
- 4 - European method, 12 months of 30 days each
- This function returns the Macaulay duration of a security, which is a measure of price volatility and interest rate sensitivity. It is the weighted average of the times to receipt of income from the security, where the weight for each time is the present value of that income divided by the present value of the security itself; the result is thus the sum of:
- time_until_receipti * present_value_of_incomei / present_value_of_security.
Example:
DURATION_ADD("2008-2-28"; "2010-8-31"; 5%; 6%; 2; 0)
- returns approximately 2.33 years.
Issues:
- This function is implemented as DURATION in Gnumeric and Excel.
- The DURATION function in Calc is entirely different.
- This function uses YEARFRAC in the calculation. There are known slight inaccuracies (both in Calc and in Excel) in YEARFRAC.
See Also
