6. Consider the list of factors mentioned in class that matters for deciding whether to rent a home vs. buying a home, we want to build a spreadsheet to simulate the housing decision. Here are the assumptions we make for the buying and renting scenarios (10 points): Notes: All rates are stated in annual term. If you pay taxes on your personal property or/and interest on your mortgage, you payments may be deductible from your income tax bill. Maintenance cost increases at the inflation rate. - If one decides to buy, what is the net cash if the home is sold in 10 years? - If one decides to rent, what is the saving after 10 years(consider cash that would be spent on home-purchase/expense as saving per period)? - What is the present value of buying or renting a house? 6. Consider the list of factors mentioned in class that matters for deciding whether to rent a home vs. buying a home, we want to build a spreadsheet to simulate the housing decision. Here are the assumptions we make for the buying and renting scenarios (10 points): Notes: All rates are stated in annual term. If you pay taxes on your personal property or/and interest on your mortgage, you payments may be deductible from your income tax bill. Maintenance cost increases at the inflation rate. - If one decides to buy, what is the net cash if the home is sold in 10 years? - If one decides to rent, what is the saving after 10 years(consider cash that would be spent on home-purchase/expense as saving per period)? - What is the present value of buying or renting a house