시작하기무료로 시작하기

Where did your money go?

When you create a loan amortization table, you will calculate how the initial payments are split between interest and principal payments. This information tells you how much it costs (interest) to pay on the loan each year and what you can expect your balance to be at the end of the year.

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

Google Sheets로 하는 Financial Modeling

강의 보기

연습 안내

  • In D10, create a formula of interest rate times the year beginning balance.
  • In E10, create a formula of the annual payment minus the interest payment.
  • In F10, show the final year end balance by subtracting the year beginning balance minus the principal.

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

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

연습 시작