You take a loan to buy a house priced at $200000.$ How much would need to pay in mortgage if you make the payment at the end of each $6$ month period. You take a mortgage for $15$ years. Suppose the interest rate is $6\%$ per year. What would be the loan amount at the end of $2$d year.

Do the calculation in cell c$7$ for the calculation.

What formula would you use?

What is the value of the PMT function?

What is the value at the end of year $3?$