ACCRINT()
Syntax. ACCRINT(Issue,First_Interest_Date,Settlement,Nominal_Interest,Par_Value, Frequency,Basis,Calculation_Method)
Definition. The function ACCRINT() calculates the accrued interest of a debt due in full intra-annually or the accrued interest of a fixed-interest security with periodic interest payments.
Arguments
Issue (required) Specifies the date of the loan agreement or the issue of the security.
First_Interest_Date (required) Identical to the due date if it is intra-annual; otherwise, results from the number of periods, which is defined by the frequency.
Settlement (required) The date when the ownership of the security changes.
Nominal_Interest (required) The agreed-upon yearly interest rate (coupon interest rate) of the debt instrument/loan/bond. ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
