Answer all questions in images below please and thanks

You are instructing your statistical consultant to create a model that will be used to predict the value of single family homes in the city of Hartford, Ct. Which would be a dummy variables in your model. (Select all that apply) _ Property is located in a fire district with fire hydrants _ quality of the schools lot size Basement area which has been improved A property on the historic registry Interior square footage Question 2 (1 point) Which of the following situations require an appraisal by an appraiser? (Mark all that apply) ) Listing a property for sale under the MLS ) Corporate valuation when one of the listed assets is real estate Underwriting of a mortgage _ Settling an estate upon death _ Expropriation of property by a state, federal or local government () Divorce settlementQuestion / ju.3 points, You have been asked to review three statistical models which will be used to calculate the appraised value for multi-family properties in Boston. Based on the statistics provided below which model would you select. Model 301: has an R Square of .154 and an adjusted R Square of .021 Model 710: has an R Square of .954 and an adjusted R Square of .921 Model 445: has an R Square of .025 and an adjusted R Square of . 121 Model 221: has an R Square of .954 and an adjusted R Square of .923 Model 555: has an R Square of .525 and an adjusted R Square of .501 O Model 555 Model 301 Model 221 Model 110 Model 445Question 10 (1 point) You are considering purchasing an office building in Boston for a pension fund. You plan to hold the property for 10 years. The properties under consideration are listed below. Based on this data which property would you purchase? Property 101: Current Cap rate 5.71%%, NOI is constant for 10 years O Property 103: Cap rate 5.48%, NOI is expected to be 15%% higher in years 3-10 Property 104: Cap rate 5.42%, NOI is expected to be 10%% higher in years 2- 10 Property 105: Cap rate 5.49%%, NOI is expected to be 10%% higher in years 4-10 Hide hint for Question 10 Hint what is the HPR for each case. Use Excel to solve this problem. Question 11 (1 point) Appraisers are LEAST LIKELY to be found working for O City government O Mortgage lending Insurance companies Architectural design firms O Accounting firms Clients of real estate agents BanksQuestion 15 (1 point) You are appraising a property using the Income approach (Investment method). The property under consideration for purchase has an NOI of $120,000 and sold three years ago $970,000. Your accountant has suggested you use a cap rate which is equal to 4.500% above the ten year T-bill rate. You checked the current auction for T-Bills, and the rate was 4:000%. What should you offer for the building based on the income approach? Your Answer: Answer Question 16 (1 point) Saved An investor is considering buying the River Creek Apt in Brighton. The apartment building can be purchased for $2,500,000. It has 6 apartments currently generating an NOI of $22,000 (for each unit). The plan is to demolish the current building and replaced it with an apartment building with 19 units. Each unit will cost $190,000 to build. The total demolition cost of the current building is $300,000. The NOI for the new building is projected at $24,000 (for each unit). Consider this an all-cash deal. No financing will be required for the improvements. What is the cap rate projected for the new development to the nearest tenth of percent. If your answer is 15.5%% enter 15.5 Bonus Question. Your Answer: 16 AnswerQuestion 17 (1 point) You have been given a tax assessment to review. They are using a statistical model which gives the coefficients for the model: parcel area (per sq. ft.) = 5 area above the basement floor = 120 bathrooms (each) = 15,000 double garage = 28,000 single garage = 18,000 decks per sq. ft. = 20 gas heat = 5000 Determine the assessed value of the property given the values below: Parcel area = 22,000 sq.ft. Area above the basement floor is 2,500 sq- ft. Property has 2 bathrooms Total deck area is 600 sq ft Property has 0 single car garages Property has 1 double car garages Note: A property can have a single plus a separate double garage. The house has gas heat. Give your answer to the nearest dollar. If your answer is $496,871 enter the value of 496871 Your Answer: Answer Question 18 (1 point) Saved You are using the cost approach (replacement) to value a property. A new home similar to the property your appraising sells for $400,000. You have been given a table to help in making the final adjustments to your valuation. Carpet replacement cost $10/sq. ft. Tile replacement cost $15/sq. ft. A single furnace has a replacement cost of $5000 ( 20 years - useful life). Roof replacement is $4/sq ft. (useful life 16 years). Based on the inspection data below, what should your property appraise at? There is 1,000 sq. ft. of carpet with no useful life. There is 500 sq. ft. of tile in the front hall and bathrooms that is cracked and will need to be replaced. The furnace is 8 years old. The roof is 2,200 sq.ft. and was replaced 12 years ago. Your Answer:Question 19 (1 point) Saved The River Creek Apt in Brighton can be purchased for $187,000 per unit. It has 8 apartments and is currently generating an NOI of $22,000 on each unit. What is the cap rate of the current building based on data provided? Give your answer in to the nearest tenth percent. If your answer is 13.5% enter 13.5 Your