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.
