Difference between revisions of "CumPrinc"
Line 2: | Line 2: | ||
[[Category:Doc Status D]] <!-- For Lumina use, do not change --> | [[Category:Doc Status D]] <!-- For Lumina use, do not change --> | ||
− | = CumPrinc(rate,nper,pv | + | == CumPrinc(rate, nper, pv, start_per, end_per, ''type'') == |
− | The cumulative principal received on an annuity (with periodic payments and constant interest rate) between | + | The cumulative principal received on an annuity (with periodic payments and constant interest rate) between «start_per» and «end_per» inclusive. A negative number represents cumulative principal paid. |
Parameters: | Parameters: | ||
− | + | ;«Rate»: The interest rate per period. | |
− | + | ;«NPer»: The total number of periods in the annuity's lifetime. | |
− | + | ;«Pv»: The present value. | |
− | + | :If you receive a loan, this is the loan amount as a positive number. | |
− | + | :If you give someone a loan, this is a negative number. | |
− | + | ;«Start_per»: First period included in the sum. | |
− | + | ;«End_per»: Last period included in the sum. | |
− | + | ;«Type»: (Optional) Indicates whether payments are at the beginning of the period. | |
− | + | :<code>True</code> = Payments due at beginning of period, with first payment due immediately. | |
− | + | :<code>False</code> = Payments due at end of period. (default) | |
− | |||
− | |||
Returns: | Returns: | ||
− | + | :<code>Index n := start_per..end_per Do Sum(PPmt(rate, n, nper, pv, 0, type), I)</code> | |
− | |||
− | |||
+ | == Library == | ||
Financial Functions | Financial Functions | ||
− | = Examples = | + | == Examples == |
− | |||
Five years ago, you took out a 30-year fixed rate mortgage at a rate of 6.5% for an initial loan of $350K. How much equity have you paid for during the first five years? | Five years ago, you took out a 30-year fixed rate mortgage at a rate of 6.5% for an initial loan of $350K. How much equity have you paid for during the first five years? | ||
− | :- | + | :<code>-CumPrinc(6.5%/12, 30*12, $350K,1, 5*12) → $22,361.58</code> |
− | |||
− | |||
− | * [[PPmt]] | + | == See Also == |
+ | * [[PPmt]] | ||
+ | * [[CumIPmt]] | ||
+ | * [[Financial functions]] |
Latest revision as of 01:17, 30 January 2016
CumPrinc(rate, nper, pv, start_per, end_per, type)
The cumulative principal received on an annuity (with periodic payments and constant interest rate) between «start_per» and «end_per» inclusive. A negative number represents cumulative principal paid.
Parameters:
- «Rate»
- The interest rate per period.
- «NPer»
- The total number of periods in the annuity's lifetime.
- «Pv»
- The present value.
- If you receive a loan, this is the loan amount as a positive number.
- If you give someone a loan, this is a negative number.
- «Start_per»
- First period included in the sum.
- «End_per»
- Last period included in the sum.
- «Type»
- (Optional) Indicates whether payments are at the beginning of the period.
True
= Payments due at beginning of period, with first payment due immediately.False
= Payments due at end of period. (default)
Returns:
Index n := start_per..end_per Do Sum(PPmt(rate, n, nper, pv, 0, type), I)
Library
Financial Functions
Examples
Five years ago, you took out a 30-year fixed rate mortgage at a rate of 6.5% for an initial loan of $350K. How much equity have you paid for during the first five years?
-CumPrinc(6.5%/12, 30*12, $350K,1, 5*12) → $22,361.58
See Also
Comments
Enable comment auto-refresher