please read the scenario and answer question#4

Scenarios roc- You were recently telling your undle Travis how much you're enjoying this Business Math class. Uncle Travis, who has done very well as a finance director, decides to put your Business Math skills to the test with a little project. He is currently considering purchasing a new home and has found a place he likes. The house is located at 123 Elm St. has 3 bedrooms, 3 bathrooms, and 2,500 square feet of living space. As most nice houses in Southern California, it is expensively listed for $850,000. Uncle Travis has also identified a number of other houses in the area that are for sale or have recently sold (see below.) He has asked you to give him your opinion on whether $850,000 is a fair price for the house he wants to buy. Nearby houses for sale or recently sold: 4260 Seal Beach Blvd: 3 bedroom, 3 bathroom, 2,000 square feet of living space. Listed for $825,000 1601 Las Golondrinas St.: 3 bedroom, 3 bathroom, 2,700 square feet of living space. Listed for $975,000 4406 lI Farello Nero Ave.: 3 bedroom, 3 bathroom, 1,800 square feet of living space. Listed for $815,000 What You Will Do You are an avid student of the real estate market and know one of the best ways to determine whether 123 Elm St. is fairly priced is to estimate the price per square foot of each property and compare it to the average, maximum, and minimum price per square foot prices of the nearby houses. Input the provided information in a table format (either typed or by hand). The rows will capture the different houses (eg. input 123 Elm St. in the first row, then input 4260 Seal Beach Blvd. in the second row, etc.) The columns will capture the house characteristics (address, number of bedrooms, number of bathrooms, living space size, and price). See example below. 4. Based on the house Uncle Travis would like to purchase. What will be the value of the loan if the bank is willing to give your uncle a loan, with a loan-to-value (LTV) of 80%? What will be the monthly payment if your uncle will get a 30 year mortgage, at 80% LTV, with a rate of 4.0%