CUMPRINC
The principal paid on a loan from one period to another, together.
Group: Financial. Compatible with DAX.
Syntax
CUMPRINC ( <rate>, <nper>, <pv>, <start_period>, <end_period>, <type> )| Parameter | Type | Description |
|---|---|---|
rate | Number | The interest rate per period. For monthly payments on a yearly rate, divide that rate by 12. |
nper | Number | How many payment periods there are, all told. |
pv | Number | The amount borrowed: it must be more than 0. |
start_period | Number | The first period of the stretch, counting from 1. |
end_period | Number | The last period of the stretch. |
type | Number | When the payments fall: 0 at the end of each period, 1 at its start. Required here. |
Returns
Number. The part of the payments that repaid the loan over those periods; negative, as it is paid out.
Remarks
- With
CUMIPMTover the same periods it makes up the payments in full: interest plus principal is the number of periods timesPMT. - Here pv must be positive (a loan received), and the answer is always negative.
- All of rate, nper and pv must be above 0, and type exactly 0 or 1. The start and end periods are rounded to whole numbers; a start below 1, an end before the start or an end after nper is an error.
Examples
Principal repaid in the first two years
The same loan: less goes to interest each month, so more is repaid in the second year.
EVALUATE
ROW (
"Year 1", CUMPRINC ( 0.045 / 12, 120, 2000000, 1, 12, 0 ),
"Year 2", CUMPRINC ( 0.045 / 12, 120, 2000000, 13, 24, 0 ),
"Year 1, all payments", CUMPRINC ( 0.045 / 12, 120, 2000000, 1, 12, 0 ) + CUMIPMT ( 0.045 / 12, 120, 2000000, 1, 12, 0 ),
"12 × PMT", 12 * PMT ( 0.045 / 12, 120, 2000000 )
)| Year 1 | Year 2 | Year 1, all payments | 12 × PMT |
|---|---|---|---|
| -162047.302760556 | -169491.727497675 | -248732.181016841 | -248732.181016841 |