CUMPRINC

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

Syntax

CUMPRINC(rate, nper, pv, start_period, end_period, type)

Argument	Description	Required
`rate`	The interest rate	Required
`nper`	The total number of payment periods	Required
`pv`	The present value	Required
`start_period`	The first period in the calculation	Required
`end_period`	The last period in the calculation	Required
`type`	The timing of the payment	Required

=CUMPRINC(0.09/12, 30*12, 125000, 1, 12, 0)

Result ⇒ -853.9964

=CUMPRINC(0.09/12, 30*12, 125000, 13, 24, 0)

Result ⇒ -934.1071

=CUMPRINC(0.05/12, 60, 10000, 1, 1, 0)

Result ⇒ -147.0457

Other Financial functions:

CUMIPMT - Returns the cumulative interest paid between start_period and end_period
DB - Returns the depreciation of an asset for a specified period using the fixed-declining balance method
DISC - Returns the discount rate for a security
EFFECT - Returns the effective annual interest rate
FV - Returns the future value of an investment.
FVSCHEDULE - Returns the future value of an initial principal after applying a series of compound interest rates
IPMT - Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
IRR - Returns the internal rate of return for a series of cash flows
NOMINAL - Returns the annual nominal interest rate
NPER - Returns the number of periods for an investment
NPV - Calculates the net present value of a series of cash flows at a given discount rate
PMT - Calculates the payment for a loan based on constant payments and a constant interest rate.
PPMT - Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
PV - Returns the present value of an investment.
RATE - Returns the interest rate per period of a loan or investment.
SLN - Returns the straight-line depreciation of an asset for one period
XIRR - Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPV - Returns the net present value for a schedule of cash flows that is not necessarily periodic