Financial
ACCRINT function
Accrued interest of a periodic-interest bond. ACCRINT works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) | Argument | Use |
|---|---|
issue | required |
first_interest | required |
settlement | required |
rate | required |
par | required |
frequency | required |
basis | optional |
calc_method | optional |
On live data
In Sheets, ACCRINT sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
More financial functions
PMTPeriodic payment of a loan or annuityACCRINTMAccrued interest paid at maturityAMORDEGRCFrench degressive depreciation of a periodAMORLINCFrench linear depreciation of a periodCOUPDAYBSDays from coupon period start to settlementCOUPDAYSDays in the coupon period of settlementCOUPDAYSNCDays from settlement to the next couponCOUPNCDNext coupon date after settlementCOUPNUMCoupons payable up to maturityCOUPPCDPrevious coupon date before settlementCUMIPMTInterest paid between two periodsCUMPRINCPrincipal paid between two periods
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.