Difference between revisions of "Documentation/How Tos/Calc: YIELD function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
|||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 25: | Line 25: | ||
<tt>'''YIELD("2008-02-15"; "2010-11-15"; 5%; 95; 100; 2; 0)'''</tt> | <tt>'''YIELD("2008-02-15"; "2010-11-15"; 5%; 95; 100; 2; 0)'''</tt> | ||
: returns approximately <tt>'''0.070'''</tt> or 7%. | : returns approximately <tt>'''0.070'''</tt> or 7%. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
=== Issues: === | === Issues: === | ||
* This function is not exact, as it relies on iteration. It may thus give slightly different results to other spreadsheets. For practical purposes any differences are unlikely to be significant. | * This function is not exact, as it relies on iteration. It may thus give slightly different results to other spreadsheets. For practical purposes any differences are unlikely to be significant. | ||
| + | |||
| + | {{SeeAlso|EN| | ||
| + | * [[Documentation/How_Tos/Calc: PRICE function|PRICE]] | ||
| + | * [[Documentation/How_Tos/Calc: PRICEDISC function|PRICEDISC]] | ||
| + | * [[Documentation/How_Tos/Calc: PRICEMAT function|PRICEMAT]] | ||
| + | * [[Documentation/How_Tos/Calc: YIELDDISC function|YIELDDISC]] | ||
| + | * [[Documentation/How_Tos/Calc: YIELDMAT function|YIELDMAT]] | ||
| + | * [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]] | ||
| + | * [[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 09:30, 17 July 2018
YIELD
Calculates the yield for an interest paying security.
Syntax:
YIELD(settlementdate; maturitydate; rate; price; redemptionvalue; frequency; basis)
- settlementdate: the settlement (purchase) date of the security.
- maturitydate: the maturity (redemption) date of the security.
- rate: the (annual) coupon rate of the security.
- price: the price of the security, per 100 par value.
- redemptionvalue: the redemption value of the security, per 100 par value.
- frequency: 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 calculates the yield of a security. It uses the PRICE function, and iterates (up to 100 times) to find the yield that would give price.
Example:
YIELD("2008-02-15"; "2010-11-15"; 5%; 95; 100; 2; 0)
- returns approximately 0.070 or 7%.
Issues:
- This function is not exact, as it relies on iteration. It may thus give slightly different results to other spreadsheets. For practical purposes any differences are unlikely to be significant.
See Also
