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.
이 연습은 강의의 일부입니다
Google Sheets로 하는 대출 상환 일정표
연습 안내
- 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.
