deepcalc
DocsISPMT

ISPMT

View as markdown/docs/functions/ispmt.md Ask Claude about this pageOpens Claude with this page's address

Returns interest for even-principal payment.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=ISPMT(0.05/12, 1, 360, 100000)
Result -415.5092592592593

Syntax

ISPMT(rate, per, nper, pv)
rate
number required
per
number required
nper
number required
pv
number required
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.