ACCPRINT

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