始める無料で始める

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.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する