- Picture and text skills
- Case
Returns the accrued interest on a security with a lump sum payment due.
strong>
Syntax
ACCRINTM (issue,maturity,rate,par,basis)
Note: You should use the DATE function to enter dates, or enter dates as the result of other formulas or functions.
For example, use the function DATE(2009,7,23) to enter July 23, 2009. The problem occurs if the date is entered as text.
Issue The date on which a security is issued.
Maturity The maturity date of the securities.
Rate The annual coupon rate of the securities .
Par The par value of the security, if Omitting par, function ACCRINTM treats par as $1000.
Basis day count basis type.
Description
■ WPS tables can store dates as serial numbers that can be used for calculations. By default, the serial number for December 31, 1899 is 1, and for January 2008
The serial number for the 1st is 39448 because it is 39448 days from December 31, 1899.
■ Issue, settlement and basis will be truncated.
■ If issue, first-interest, or settlement is not a legal date, function ACCRINTM returns the error value #VALUE!.
■ If the interest rate is 0 or the par value is 0, function ACCRINTM returns the error value #NUM!.
■ If basis < 0 or basis > 4, function ACCRINTM returns the error value #NUM!.
■ If issue ≥ settlement, function ACCRINTM returns the error value #NUM!.
■ The calculation formula of ACCRINTM is as follows:
ACCRINTM = par x rate x A/D
In the formula:
A = calculated on a monthly basis Accrual days. When calculating interest due on maturity, it refers to the number of days between the issuance date and the maturity date.
D = annual base number.
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-ACCRINTM-han-shu-dao-qi-yi-ci-xing-zheng-quan-li-xi.html
评论列表(196条)
测试