Problem 1 (10 point) You are looking to purchase a house valued at $325.000 in the suburbs of Kansas City. You decide to pay 20% of the value of the house as down payment and borrow the rest at an APR of 3.206 for 20 years. A) Design an excel sheet that calculates the total payment, principle payment, and interest payment for each month for the entire duration of the loan 20 years). You should have 240 rows in that table to show the payments for each month b) Assuming that you itomise decoctions when you file taxes and are paying 255 marginal tax rate, determine the real cost of owning that house over 20 yeats HINT. Determine the present value of the real cost for each month and then sumit over the 240 months c) Would you be financially better of renting an apartment of similar size in the same neighborhood at a cost of S1000/month and investing your down payment and the difference between mortgage and rent payment in the market! Assume that the rent increases by 2% every year over the 20 years. Make justifiable assumptions for the following Rate of Return on Market Investment Home Maintenance Couts Property Taxes Increase in home value Parte is an open-ended problem and the answers will depend on your assumptions I expect you to make jastifiable assumptions