:Tabular Financial Functions COUPPCD Function-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns a number representing the previous interest payment date before the settlement date.

Grammar

COUPPCD(settlement, maturity, frequency, [basis])

Important: Dates should be entered using the DATE function or as the result of another formula or function. For example, use the function DATE(2008,5,23) to enter May 23, 2008. The problem occurs if the date is entered as text.

COUPPCD function syntax has the following parameters:

▪Settlement Required. The settlement date of a security. The settlement date of the securities is the date after the issuance date when the securities are sold to the purchaser.

▪Maturity Required. The maturity date of a security. The expiry date is the date when a security expires.

▪Frequency Required. Number of annual interest payments. If you pay annually, frequency = 1; if you pay semiannually, frequency = 2; if you pay quarterly, frequency = 4.

▪Basis Optional. The type of day count basis to use.

Basis	Daily counting basis
0 or omitted	US (NASD) 30/360
1	Actual/Actual
2	Actual/360
3	Actual/365
4	Europe 30/360

Remarks

▪ Dates can be stored in tables as serial numbers that can be used for calculations. By default, the serial number for January 1, 1900 is 1, and the serial number for January 1, 2008 is 39448 because it is 39448 days from January 1, 1900.

▪The settlement date is the date when the buyer purchases the coupon (such as a bond). The maturity date is the date when the coupon expires. For example, a 30-year bond issued on January 1, 2008, was purchased by a buyer six months later. The issuance date is January 1, 2008, the settlement date is July 1, 2008, and the maturity date is 30 years after the issuance date of January 1, 2008, that is, January 1, 2038.

▪All parameters will be truncated.

▪ If the settlement or expiry date is not a valid date, COUPPCD returns the #VALUE! error value.

▪ If frequency is any number other than 1, 2, or 4, COUPPCD returns the #NUM! error value.

▪If basis < 0 or basis > 4, COUPPCD returns the #NUM! error value.

If settlement ≥ maturity, COUPPCD will return a #NUM! error value.

Example

Data	Description
2011-1-25	Settlement Day
2011-11-15	Expiration date
2	Pay semi-annually (see information above)
1	Based on actual days/actual days (see information above)
Formula	Description	Results
=COUPPCD(A2,A3,A4,A5)	For bonds with the above conditions, it is the last interest payment date before the settlement date.	2010-11-15

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-cai-wu-han-shu-COUPPCD-han-shu.html