Difference between revisions of "Manuals/calci/CUMPRINC"
Jump to navigation
Jump to search
(Created page with "= CUMPRINC(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type) = *Where <math>Rate</math> is the interest rate, per peroid, *<math>NoPaymentPeriods</math> is the n...") |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | = CUMPRINC(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type) | + | <div style="font-size:30px">'''CUMPRINC(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type)'''</div><br/> |
| − | |||
*Where <math>Rate</math> is the interest rate, per peroid, | *Where <math>Rate</math> is the interest rate, per peroid, | ||
*<math>NoPaymentPeriods</math> is the number of periods over which the loan or investment is to be paid, | *<math>NoPaymentPeriods</math> is the number of periods over which the loan or investment is to be paid, | ||
| Line 7: | Line 6: | ||
*<math>EndPeriod</math> is the number of the last period over which the interest is to be calculated, | *<math>EndPeriod</math> is the number of the last period over which the interest is to be calculated, | ||
*<math>Type</math> specifies whether the payment is made at the start or end of the period. | *<math>Type</math> specifies whether the payment is made at the start or end of the period. | ||
| − | + | **CUMPRINC(), returns the cumulative principal paid on a loan between two periods. | |
| − | CUMPRINC() | ||
== Description == | == Description == | ||
| Line 85: | Line 83: | ||
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | Year 1 | | class="sshl_f" | Year 1 | ||
| − | | class=" " | $- | + | | class=" " | $-7,056.90 |
| class=" " | | | class=" " | | ||
|- class="even" | |- class="even" | ||
| class=" " | Year 2 | | class=" " | Year 2 | ||
| − | | class=" " | $- | + | | class=" " | $-7,344.41 |
| class=" " | | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| class=" " | Year 3 | | class=" " | Year 3 | ||
| − | | class=" " | $- | + | | class=" " | $-7,643.64 |
| class=" " | | | class=" " | | ||
|- class="even" | |- class="even" | ||
| class=" " | Year 4 | | class=" " | Year 4 | ||
| − | | class=" " | $- | + | | class=" " | $-7,955.05 |
| class=" " | | | class=" " | | ||
|} | |} | ||
| Line 108: | Line 106: | ||
==Related Videos== | ==Related Videos== | ||
| − | {{#ev:youtube| | + | {{#ev:youtube|v=2zMIdrdW80k|280|center|CUMPRINC }} |
== See Also == | == See Also == | ||
Latest revision as of 03:03, 19 November 2020
CUMPRINC(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type)
- Where is the interest rate, per peroid,
- is the number of periods over which the loan or investment is to be paid,
- is the present value of loan or investment,
- is the number of the first period over which the interest is to be calculated,
- is the number of the last period over which the interest is to be calculated,
- specifies whether the payment is made at the start or end of the period.
- CUMPRINC(), returns the cumulative principal paid on a loan between two periods.
is the interest rate, per peroid,
is the number of periods over which the loan or investment is to be paid,
is the present value of loan or investment,
is the number of the first period over which the interest is to be calculated,
is the number of the last period over which the interest is to be calculated,
specifies whether the payment is made at the start or end of the period.
Description
CUMPRINC(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type)
- must be an integer between 1 and .
- must be an integer between 1 and .
- should be smaller than . Else Calci displays #NUM !error message.
- If or is <=0, then Calci displays #NUM !error message.
- If or is > , then Calci displays #NUM !error message.
- value is an integer value (either 0 or 1).
0 indicates the payment is made at the end of the period;
1 indicates the payment is made at the start of the period.
- If value is other than 0 or 1, Calci displays #N/A error message.
Examples
Consider the following example that shows the use of CUMPRINC function:
Cumulative payment on the principal, during each year of a loan of $30,000 that is to be paid off over 4 years, with an interest rate of 4% per year. Payment is to be made at the end of each month.
- The payments are made monthly, so we have converted the annual interest rate of 4% into a monthly rate (=4%/12).
- The number of years into months (=4*12).
Formulas:
| A | B | |
| Year 1 | =CUMPRINC(4%/12,48,30000,1,12,0) | |
| Year 2 | =CUMPRINC(4%/12,48,30000,13,24,0) | |
| Year 3 | =CUMPRINC(4%/12,48,30000,25,36,0) | |
| Year 4 | =CUMPRINC(4%/12,48,30000,37,48,0) |
Results:
| A | B | |
| Year 1 | $-7,056.90 | |
| Year 2 | $-7,344.41 | |
| Year 3 | $-7,643.64 | |
| Year 4 | $-7,955.05 |
- The calculated interest payments are negative values, as they represents outgoing payments (for the individual taking out the loan).
Related Videos
See Also
References