You are analyzing a 50,000 RSF office property. The purchase price is $5.7 million and a 75% loan is available for a term of 30 years (monthly payments) at an interest rate of 7%. The current market rental rate is $19.00 RSF and the current vacancy is 11%. Operating expenses are $275,000 per year. Set up the first year operating statement for the proposed investment from PGI to BTCF and answer the following:

Mortgage constant (Rm) for ADS
Operating expense ratio (OER)
Debt coverage ratio (DCR)
Equity dividend rate (Re)
The overall rate of return (Ro)
Break-even occupancy ratio (BEOR)