Calculate 1-year cash flow with following metrics in Execl sheet:

LTV, DSCR, DY, Breakeven point, Going in Cap Rate and Cash on Cash return.

Total Acquisition Price is $1,056,000

Property consists of eight office suites, Three on the first floor and five on the second floor

Contract rents are: two suites at $1,800/mo, one at $3,600/mo and five at $1,560/mo

Vacancy and collection losses are 10% per year

Operating expenses are 40% of EGI

CapEx are 5% of EGI

First mortgage loan is $792,000

Annual mortgage rate is 6.5%

Loan amortization is 30 years

Total up-front financing cost are 3% of loan amount