Imagine that you borrowed M = $450,000 and together with an additional $50,000 of personal equity, you purchased a house worth

$500,000. To finance the purchase you took out a twenty-five-year mortgage with a term of three years, at an APR of i = 6%. Please create a mortgage schedule that illustrates the monthly payment, interest paid, principal paid, and outstanding balance for each month over the thirty-six-month term of the mortgage. How much do you owe at the end of thirty-six months? How much have you paid in total over the thirty-six months?What fraction was interest and what fraction was principal? For this question ignore mortgage insurance.