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.