X is buying a fixed interest mortgage for a home listed at USD $80000$

X is interested in comparing the effects of a $10\%$ versus a $20\%$

down payment option on monthly mortgage payments, the total interest paid over the life of the mortgage.

A$.$ Calculate the monthly mortgage payments for both the $10\%$ and $20\%$ down payment options using the mortgage formula.

B$.$ Determine the total interest paid over the life of the mortgage for each scenario

C$.$ Analyze the impact of making additional annual payments of USD $10,000$ towards the mortgage principal for each down payment option starting at the end of the $1$st year. How does this affect the total interest paid and the amortization period?

D$.$ Assume that funds not used for the down payment could be invested with an average annual return of $6\%.$ Calculate the potential value of these investments at the end of the mortgage period for each down payment option.

E$.$ Weigh the financial pros and cons of each down payment option.

F$.$ State and justify any assumptions made in your analysis, which may include economic factors, tax implications changes in the real estate market, or X$$s financial situation.

G$.$ Provide headers $($ column labels $)$for the excel work to compile the report.