Start the loan amortization table
You want to know how much you will need to pay yearly on a $200,000 house loan to plan for your monthly expenses. You can use the pmt() function to calculate the yearly payment for this loan at 4% interest and a 15 year loan. Remember to expand the cells if you cannot see the table headers.
Creating these tables will help you understand how loans are repaid and allow you to check different interest rates and loan amounts for the best fit to your budget.
이 연습은 강의의 일부입니다
Google Sheets로 하는 Financial Modeling
연습 안내
- In
B7, use thepmt()function with the interest, number of years, and negative initial loan balance to calculate the yearly payment. - In
B10, enter a reference to the initial balance by using=B4. - In
C10, enter an absolute reference to the yearly payment calculated inB7.
