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.
Este ejercicio forma parte del curso
Loan Amortization in Google Sheets
Instrucciones del ejercicio
- 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()andPPMT()) into cellsB8:D9. Use absolute referencing for all numbers except the period (use$A8). - Fill in the closing balance for period 1 in cell
F8and the correct opening and closing balances for period 2 in cellsE9:F9.
Ejercicio interactivo práctico
Pon en práctica la teoría con uno de nuestros ejercicios interactivos
Empieza el ejercicio