$12.$ You are analyzing a $30,000$ RSF flex property located at $123$ Main St$.$ in Denver, CO$.$ The purchase price is $$1\mathrm{.}2$ million and a $70\%$ loan is available for a term of $25$ years $($monthly payments$)$ at an interest rate of $9\%.$ The current market rental rate is $$9\mathrm{.}00$ RSF and the current vacancy is $10\%.$ Operating expenses are $$123,000$ per year. Set up the first year operating statement for the proposed investment from PGI to BTCF and answer the following:

Initial equity required $($Cfo$)\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Loan amount $($Vm$)\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Monthly payment $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Annual debt service $($ADS$)\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Mortgage constant $($Rm$)$ for ADS $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Operating expense ratio $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Debt coverage ratio $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Equity dividend rate $($Re$)\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Overall rate of return $($Ro$)\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Break$-$even occupancy ratio $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$