Syntax
=CUMIPMT(rate, nper, pv, start_period, end_period, type)Arguments
| Argument | Required | Description |
|---|---|---|
rate | Required | The interest rate per period |
nper | Required | The number of payment periods |
pv | Required | The present value |
start_period | Required | The first period to include |
end_period | Required | The last period to include |
type | Required | 0 for payments at the end of each period, 1 at the start |
How to use CUMIPMT
CUMIPMT takes 6 required arguments. Type =CUMIPMT( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=CUMIPMT(0.09/12, 30*12, 125000, 13, 24, 0)Result =CUMIPMT(0.09/12, 30*12, 125000, 1, 1, 0)Result Related financial functions
- COUPDAYSNCReturns the days from the settlement date to the next coupon date.
- COUPNCDReturns the next coupon date after the settlement date.
- COUPNUMReturns the number of coupons payable between the settlement date and maturity.
- COUPPCDReturns the coupon date on or before the settlement date.
- CUMPRINCReturns the total principal paid on a loan between two periods.
- DBReturns the depreciation of an asset for a period with the fixed declining balance method.
- DDBReturns the depreciation of an asset for a period with the double declining balance method or another factor.
- DISCReturns the discount rate of a security.
- DOLLARDEConverts a price written as a whole number and a fraction (like 1.02 meaning 1 and 2/16) to a decimal number.