Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started