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 進行財務建模
練習說明
- 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.
