시작하기무료로 시작하기

Finishing the amortization schedule

In this exercise, you will return to the amortization schedule that you completed at the end of Chapter 1.

In that schedule, you only filled in the first 2 periods of the schedule. In this exercise, you will fill in the rest of the schedule all the way down through 60 periods!

You will not have to change the interest rate or number of periods.

Remember - the schedule is complete when the closing balance is zero!

이 연습은 강의의 일부입니다

Google Sheets로 하는 대출 상환 일정표

강의 보기

연습 안내

  • Copy down the payment, interest, principal, opening balance, and closing balance in columns B:F.
  • Do not adjust any value in rows 1:6.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작