Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

WorksheetFunction.CumPrinc Method

Office 2007
Returns the cumulative principal paid on a loan between start_period and end_period.

Syntax

expression.CumPrinc(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6)

expression   A variable that represents a WorksheetFunction object.

Parameters

NameRequired/OptionalData TypeDescription
Arg1RequiredVariantThe interest rate.
Arg2RequiredVariant The total number of payment periods.
Arg3RequiredVariant The present value.
Arg4RequiredVariantThe first period in the calculation. Payment periods are numbered beginning with 1.
Arg5RequiredVariantThe last period in the calculation.
Arg6RequiredVariantThe timing of the payment.

Return Value
Double

Remarks

The following tables lists values used in

Arg6.
TypeTiming
0 (zero)Payment at the end of the period
1Payment at the beginning of the period
  • Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for Arg2. If you make annual payments on the same loan, use 12% for rate and 4 for Arg2.
  • Arg2, Arg4, Arg5, and type are truncated to integers.
  • If rate ≤ 0, Arg2 ≤ 0, or Arg3 ≤ 0, CumPrinc generates an error.
  • If Arg4 < 1, Arg5 < 1, or Arg4 > Arg5, CumPrinc generates an error.
  • If Arg6 is any number other than 0 or 1, CumPrinc generates an error.



Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.