Difference between revisions of "Documentation/How Tos/Calc: COUPNUM function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| (12 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | __NOTOC__ | + | {{DISPLAYTITLE: COUPNUM function}} |
| + | {{Documentation/CalcFunc FinancialTOC | ||
| + | |ShowPrevNext=block | ||
| + | |PrevPage=Documentation/How_Tos/Calc:_COUPNCD_function | ||
| + | |NextPage=Documentation/How_Tos/Calc:_COUPPCD_function | ||
| + | }}__NOTOC__ | ||
== COUPNUM == | == COUPNUM == | ||
| Line 20: | Line 25: | ||
=== Example: === | === Example: === | ||
| − | <tt>'''COUPNUM(" | + | <tt>'''COUPNUM("2017-01-25"; "2019-11-15"; 2; 1)'''</tt> |
| − | : returns <tt>'''6'''</tt>. A bond is originally issued on 15 November | + | : returns <tt>'''6'''</tt>. A bond is originally issued on 15 November 2009, with a ten-year term; the date of maturity is 15 November 2019. You subsequently purchase it on the secondary market, with a settlement date of 25 January 2017. Interest is paid half-yearly (<tt>'''frequency'''</tt> is 2); thus interest is due on the 15 May and the 15 November each year, during the bond's term. Interest is paid 6 times: on 15 May 2017, 15 November 2017, 15 May 2018, 15 November 2018, 15 May 2019 and 15 November 2019. |
| − | + | {{SeeAlso|EN| | |
| − | [[Documentation/How_Tos/Calc: COUPDAYBS function| | + | * [[Documentation/How_Tos/Calc: COUPDAYBS function|COUPDAYBS]] |
| − | [[Documentation/How_Tos/Calc: COUPDAYS function| | + | * [[Documentation/How_Tos/Calc: COUPDAYS function|COUPDAYS]] |
| − | [[Documentation/How_Tos/Calc: COUPDAYSNC function| | + | * [[Documentation/How_Tos/Calc: COUPDAYSNC function|COUPDAYSNC]] |
| − | [[Documentation/How_Tos/Calc: COUPNCD function| | + | * [[Documentation/How_Tos/Calc: COUPNCD function|COUPNCD]] |
| − | [[Documentation/How_Tos/Calc: COUPPCD function| | + | * [[Documentation/How_Tos/Calc: COUPPCD function|COUPPCD]] |
| − | [[Documentation/How_Tos/Calc: Financial functions| | + | * [[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 12:26, 31 January 2024
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
COUPNUM
Returns the number of coupons (interest payments) between the settlement date and maturity.
This function is only available if the Analysis AddIn is installed.
Syntax:
COUPNUM(settlement; maturity; frequency; basis)
- settlement: the date of purchase of the security.
- maturity: the date on which the security matures (expires).
- 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
Example:
COUPNUM("2017-01-25"; "2019-11-15"; 2; 1)
- returns 6. A bond is originally issued on 15 November 2009, with a ten-year term; the date of maturity is 15 November 2019. You subsequently purchase it on the secondary market, with a settlement date of 25 January 2017. Interest is paid half-yearly (frequency is 2); thus interest is due on the 15 May and the 15 November each year, during the bond's term. Interest is paid 6 times: on 15 May 2017, 15 November 2017, 15 May 2018, 15 November 2018, 15 May 2019 and 15 November 2019.
See Also
