I need to fill in an excel sheet for question 4 (above), in the exact same format of this example sheet provided (below). Thanks!

tie best strategy for Chis 3. Interpreting the rent ratio. Art Patton has equally attractive job offers in Miami and Los Angeles The rent ratios in the cities are 8 and 20, respectively. Art would really like to buy rather than rent a home after he moves. Explai attractiveness of moving to Miami rather than Los Angeles, given his stated goal n how to interpret the rent ratio and what it tells Art about the relative 4. Rent vs. buy home. Use Worksheet 5.2. Denise Green is currently renting an apartment to per month and paying $275 annually for rent er's insurance. She just found a small townhouse that she can buy for $185,000. She has enough cash for a $10,000 down payment and $4,000 irn closing costs. Her bank is offering 30-year mortgages at 6 percent per y following costs as a percentage ear. Denise estimated the of the home's price: property taxes, 2.5 percent; homeowner's insurance, 0.5 percent; and maintenance, 0.7 percent. She is in the 25 percent tax bracket and has an after-tax rate of return on invested funds of 4 percent. Using Worksheet 5.2, calculate the cost of each alternative and recommend the less costly option-rent or buy-for Denise Calculating required down payment on home purchase. How much would you have to put down on a house costing $100,000 if the house had an appraised value of $105,000 and the lender required an 80 percent loan-to-value ratio? Determining maximum affordable mortgage. Using the maximum ratios for a conventional mortgage, how big a monthly payment could the Danforth family afford if their gross (before-tax) monthly income amounted to $4,000? Would it make any difference if they were already making