CUMIPMT

Function Type: Financial

Description:

Returns the cumulative interest paid between two periods.

Function Structure:

=CUMIPMT(rate, nper, pv, start_period, end_period, type)

Argumet Breakdown:

rate – The interest rate per period.

nper – The total number of payments for the loan.

pv – The present value, or total value of all payments now.

start_period – First payment in calculation.

end_period – Last payment in calculation.

type – When payments are due. 0 = end of period. 1 = beginning of period.

Example:

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉

---

Back to Learn Excel->