Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I make assumptions for the exit cap and discount rate in the following question using the screenshot below? Estimate each propertys current value
How do I make assumptions for the exit cap and discount rate in the following question using the screenshot below?
"Estimate each property’s current value by calculating the present discounted value of expected future cash flows given to you in Exhibit 11 (Screenshot Below). To complete your valuation, you will need to make an exit cap and discount rate assumption."
Please include work, calculations, and reasoning.
Pro forma Brookline Road Shopping Center Expense growth assumption 2.00% Exit cap rate assumption CapEx reserve Discount rate assumption 17% 2016 2017 2018 2019 2020 2021 Gross rental revenue $1,590,772.76 $1,607,869.37 $1,625,375.14 $1,643,300.28 $1,766,655.25 $1,785,450.79 $68,118.23 $1,643,300.28 $1,698,537.03 $1,785,450.79 $737,250.72 Vacancy Net rental revenue $1,590,772.76 $1,607,869.37 $681,105.70 $909,667.06 $1,625,375.14 $708,622.37 $916,752.77 Total operating expenses Net operating income Capital costs Tenant improvements Leasing commissions Capital reserves Total capital costs Operating cash flow $694,727.82 $913,141.55 $722,794.82 $920,505.46 $751,995.73 $961,286.31 $1,033,455.06 $154,643.40 $154,643.40 $755,023.66 $155,234.06 $155,234.06 $757,907.49 $155,847.97 $155,847.97 $760,904.80 $156,485.93 $156,485.93 $764,019.53 $179,470.25 $9,500.00 $163,418.67 $352,388.92 $608,897.39 $175,687.36 $175,687.36 $857,767.70 Property sale Total property cash flow $755,023.66 $757,907.49 $760,904.80 $764,019.53 Current property valuation
Step by Step Solution
★★★★★
3.39 Rating (146 Votes )
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