ПочатиПочніть безкоштовно

Adding cumulative functions to the schedule

In this example, instead of adding the CUMIPMT() and CUMPRINC() functions to calculate for a point in time, it will be added into the whole schedule!

To reduce the amount of cutting and pasting, the loan is now a 2 year amortizing loan instead of a 20 year amortizing loan.

Remember that in your cumulative functions, the first period will always be 1, and the only number that should change is the period.

Ця вправа є частиною курсу

Амортизація позик у Google Sheets

Переглянути курс

Інструкції до вправи

  • Use the CUMIPMT() function to calculate cumulative interest paid in all periods from period 1 through 24 in cells L4:L27.
  • Use the CUMPRINC() function to calculate cumulative principal paid in all periods from period 1 through 24 in cells M4:M27.
  • Use the periods in B7 when referring to the total number of periods.
  • The values in columns L and M should be positive numbers.

Практична інтерактивна вправа

Перетворіть теорію на практику за допомогою однієї з наших інтерактивних вправ

Почати вправу