You are looking to purchase a commercial property that is projected to generate $$950,000$ in annual NOI. The prevailing market cap rate for this asset is $8\mathrm{.}0\%$

You approach your banker with the deal and ask at what terms they would be willing to lend on the acquisition.

She responds that they are currently issuing loans for this asset type at $7\mathrm{.}5\%$ annual interest $($paid monthly$)$ with a $25-$year amortization. She adds that the bank will finance the deal based on the lesser of a minimum $1\mathrm{.}25$ debt service coverage ratio or a $75\%$ loan$-$to$-$cost ratio.

What size loan would they be willing to issue based on these terms? $($round to the nearest dollar$)$

Please provide excel sheet with calculations and formulas