Upload a XLS model of this Chapter $5$ Concept

Build a Loan Amortization Schedule Using the following:

Prepare and amortization schedule and answer the following questions for a $30-$Year Mortgage for $$750,000$ at an interest rate of $6\mathrm{.}12\%.$ The loan should start March $2024.$

Scenario $1$ Questions:

$-$ What month and year will you pay off the loan?

$-$ What is the total Interest paid?

$-$ What is the principal payment in May $2040?$

Scenario $2$ Questions:

$-$ Using the same information above, how would your payment schedule change if you made $1$ extra monthly payment each year?