Assume you want to buy a home worth X dollars. You would be paying a down payment equal to 20% of the value of the home. You will take out a mortgage loan on the remaining. Show your calculations for this in the excel sheet. Assume a reasonable annual rate of interest that you would be paying on this loan. You will make monthly interest payments on this loan for the next 180 months (15 years) when the loan will be fully repaid. Construct an amortization table in Excel. Your excel spreadsheet should show the formula for your calculations. Answer the following questions in the same excel file: a What is the monthly payment amount? b. How much did you end up paying for this home (including all principal repayments and interest)? C. What is the total interest payment over 15 years? d. Comment on your observation of amount of interest payment versus amount of principal repayment over time. Calculate the present value, future value and payments for both an ordinary annuity. Construct loan amortization table. a. Assume you want to buy a home worth X dollars. You would be paying a down payment equal to 20% of the value of the home. You will take out a mortgage loan on the remaining. Show your calculations for this in the excel sheet. Assume a reasonable annual rate of interest that you would be paying on this loan. You will make monthly interest payments on this loan for the next 180 months (15 years) when the loan will be fully repaid. Construct an amortization table in Excel. Your excel spreadsheet should show the formula for your calculations. Answer the following questions in the same excel file: a What is the monthly payment amount? b. How much did you end up paying for this home (including all principal repayments and interest)? C. What is the total interest payment over 15 years? d. Comment on your observation of amount of interest payment versus amount of principal repayment over time. Calculate the present value, future value and payments for both an ordinary annuity. Construct loan amortization table. a