Začněte nyníZačněte zdarma

Amortization table with two periods

This exercise adds new values to calculate for your schedule and adds the second period to your amortization schedule.

The new values required are:

  • Opening Balance (in column E)
  • Closing Balance (in column F)
  • Period 2 Amortization (row 9)

You'll also need to remember how to properly account for monthly payments given an annual rate.

Toto cvičení je součástí kurzu

Amortizace úvěru v Google Sheets

Zobrazit kurz

Pokyny k cvičení

  • Fill in the proper interest rate for a 6% annual rate, amortized monthly, into cell B4.
  • Fill in the proper number of periods for a 5-year loan, amortized monthly, into cell B5.
  • Fill in the correct financial formulas (PMT(), IPMT() and PPMT()) into cells B8:D9. Use absolute referencing for all numbers except the period (use $A8).
  • Fill in the closing balance for period 1 in cell F8 and the correct opening and closing balances for period 2 in cells E9:F9.

Interaktivní praktické cvičení

Proměňte teorii v praxi s jedním z našich interaktivních cvičení

Začít cvičení