(7' points, 3+2+2) Using the headers in tab A4 of the Excel spreadsheet and the input values included in the green "box": a. Create a monthly amortization schedule for a xed rate 15-year mortgage. Make sure that any value that the user (me in this case) changes in the green "box" will be reected in your amortization schedule. Yoru' monthly payment calculation should be included in cell J5 and should also automatically change with any changes to the values in the green "box". b. Next to the amortization schedule, create an Excel graph that shows the remaining mortgage balance overtime. Make sure that your graph is labeled appropriately. c. Include a vloolnrp mction in cell L? that will reect the remaining mortgage balance associated with the end of the month entered by the user into cell J 7. For example. if the user enters 34 into cell J 7', cell L7 will automatically show the remaining mortgage balance after 34 months. (8 points, (15* 16) Calculate the nominal and real annual rate of housing price appreciation rate for Miami and for Houston for the requested different time periods using the housing price index data and the ination index data provided to you in tab A5 of the Excel spreadsheet. In total, you need to calculate 16 values that will appear in the 16 yellow cells of that Excel tab. (6 points, 3+3) Given your results from the previous problem: a. What can you say about the magnitude and the volatility of housing price appreciation in the short, mediunr and long run? b. Are the results from question 5 consistent with the theory of price appreciation we discussed in the beginning of this course? Briey explain