CUMPRINC
Returns the cumulative principal paid on a loan between two periods.
FinancialFinance & Accounting
What it does
Calculates total principal paid on a loan between two periods.
Syntax
CUMPRINC(rate, nper, pv, start_period, end_period, type)
Arguments
rate(number) — Interest rate per period.nper(number) — Total periods.pv(number) — Loan amount.start_period(number) — Start period.end_period(number) — End period.type(number) — Timing.
Examples
Cumulative Principal
Principal paid in first year.
FORMULA
=CUMPRINC(0.05/12, 60, 10000, 1, 12, 0)
RESULT
-1800
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | -1800 |