Syntax
ACCRINT( issue, first_interest, settlement, rate, [par], frequency, [basis], [calc_method] ).
Parameters
ssue: The date the security is issued.
first_interest: The date when the initial interest is paid.
settlement: The settlement date of the security.
rate: The annual interest rate or coupon when the security was issued.
par: The par value of the security.
frequency: The number of coupon payments per year:
1 = annual
2 = semi annual (default)
4 = quarterly
basis (Optional): The type of day counting to use:
0 = US 30/360 (default)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = European 30/360
calc_method (Optional): The start date for the accrued interest:
True = start accruing interest from the issue date.
False = start accruing interest from the last coupon payment date.”
Example
=ACCPRINT(“4/3/2017”, “4/3/2017”, “4/6/2017”, 0.06,1000,2,1
Result
0.494505495