deepcalc
DocsCUMPRINC

CUMPRINC

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

Returns cumulative principal paid on loan.

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

Examples

=CUMPRINC(0.06/12, 60, 10000, 13, 24, 0)
Result -1877.07999731021

Syntax

CUMPRINC(rate, nper, pv, start_period, end_period, type)
rate
number required
nper
number required
pv
number required
start_period
number required
end_period
number required
type
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.