find the affordable mortgage. Assuming a 20% down payment, the maximum price of a house would be the affordable mortgage divided by 0.8. Use the following data to test your model Total monthly gross income =$6,100 Nonmortgage housing expenses =$350 Monthly installment debt =$400 Monthly payment per $1,000 mortgage =$7.15 Enter the formulas for the spreadsheet that implements this model. find the affordable mortgage. Assuming a 20% down payment, the maximum price of a house would be the affordable mortgage divided by 0.8. Use the following data to test your model Total monthly gross income =$6,100 Nonmortgage housing expenses =$350 Monthly installment debt =$400 Monthly payment per $1,000 mortgage =$7.15 Enter the formulas for the spreadsheet that implements this model