Use the information below to calculate the Pro-Forma, Debt Service and PTCF. What is the Overall Cap Rate for this deal?

Purchase Price $1,800,000

Debt $1,200,000

Interest rate 8%

Loan Rate 30

Amoritizaton 30

Compounding Monthly

Equity $600,000

PGI $350,000

Vacancy 10.000%

OER 40.000%

Solove for:

PGI $350,000 (Given)

Vacancy ` 10.00% (Given)

EGI $315,000 (Given)

Operating Expenses ?????

NOI ????

DS $96,243 (Given)

PTCF (Equity CF) ???

Please explain and solve in excel as well. thnaks

Thank you.