Question $9$

U $/1$ pts

Use the information in the table below to come up with a projected value for the subject property using the GIM approach. Gross Income should be based on Gross Potential Rent. Use the average GIM for the $3$ comparables in your valuation.

Round your answer to the nearest $$1,000$ dollars.

$\backslash$table$[[$Property$,\backslash$table$[[$Size $($rentable$],[$sf$)]],$Sales Price,Avg Rents$/$SF$,$Occupancy$],[$Subject$,54,569,\backslash$table$[[?????-],[$Calculate this$]],$$$12\mathrm{.}45,90\mathrm{.}8],[\backslash$table$[[$Comparable$],[$#$1]],50,207,4,950,215,$$$13\mathrm{.}01,92\mathrm{.}1],[\backslash$table$[[$Comparable$],[$#$2]],53,018,5,348,416,$$$12\mathrm{.}76,93\mathrm{.}4],[\backslash$table$[[$Comparable$],[$#$3]],46,566,5,072,848,$$$13\mathrm{.}23,88\mathrm{.}5]]$

$5,371,350$ margin of error $\frac{+}{-}1,000$

$**$correct answer is listed below the problem, just want to see how to get this in excel$***$