refinancing.

Currently, rental rates average $\backslash (\backslash$$ $4\mathrm{.}95/$ S F $\backslash ).$ Market vacancies are $\backslash (8\mathrm{.}00\backslash \%\backslash ).$ The subject OER is stable around $\backslash (19\backslash \%\backslash ).$ Market cap rates are now $\backslash (7\mathrm{.}50\backslash \%\backslash ).$ Your lender has proposed refinancing based on a current valuation using these market terms.

Below are the original loan terms from $3$ years ago and the new proposed loan terms.$\backslash (1\mathrm{.}5\backslash \%\backslash )$ prepayment penalty $(\backslash (1\mathrm{.}5\backslash \%\backslash )$ of loan balance at time of prepayment$)$

Determine the following:

B$1.$ The current NOI.

B$2.$ The current market value.

B$3.$ The maximum amount you can borrow with the new loan based on the LTV$.$

B$4.$ The maximum amount you can borrow with the new loan based on the DCR$.$

B$5.$ The new annual debt service $($ADS$)$ for the new loan.

B$6.$ The balance of the original loan at the end of year $6.$

B$7.$ The prepayment penalty for the original loan, which is a loan fee for the new loan.

B$8.$ The effective borrowing cost for the new loan.

B$9.$ The debt yield for the new loan.

B$10.$ Does the property qualify for this new loan based on its current income? Why or why not?