Description: \begin{tabular}{c|c|c|c|c|} \hline \multicolumn{1}{c}{ Scenario 1 } & Scenario 2 & \multicolumn{2}{c|}{ Scenario 3 } & Scenario 4 \\ \hline 10%,5 term, pay & 20%,5 term, pay & & 35% Down- \\ monthly, 25 & monthly, 25 & 20%,5 term, pay & Payment, 5 term, 25 \\ Amortization & Amortization & weekly, 25 & Amortiztion, 6% \\ period & period & Amortization period & interest \\ \hline \end{tabular} Downpayment at beginning Monthy mortgage payment Interest paid for the term Show your calculations and formula for each scenario Interest over the amortization period Total cost of your home at the end of the amortization period Savings noted from the previous Scenario After recording your findings in an Excel spreadsheet and comparing all four scenarios discuss what you are seeing and your conclusions Description: \begin{tabular}{c|c|c|c|c|} \hline \multicolumn{1}{c}{ Scenario 1 } & Scenario 2 & \multicolumn{2}{c|}{ Scenario 3 } & Scenario 4 \\ \hline 10%,5 term, pay & 20%,5 term, pay & & 35% Down- \\ monthly, 25 & monthly, 25 & 20%,5 term, pay & Payment, 5 term, 25 \\ Amortization & Amortization & weekly, 25 & Amortiztion, 6% \\ period & period & Amortization period & interest \\ \hline \end{tabular} Downpayment at beginning Monthy mortgage payment Interest paid for the term Show your calculations and formula for each scenario Interest over the amortization period Total cost of your home at the end of the amortization period Savings noted from the previous Scenario After recording your findings in an Excel spreadsheet and comparing all four scenarios discuss what you are seeing and your conclusions