Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This residential development project consists of 2 0 one - bedroom units, 4 0 two - bedroom units, and 1 0 0 parking spaces. The

This residential development project consists of 20 one-bedroom units, 40 two-bedroom units, and 100 parking spaces. The table below shows market rents, vacancy rate, rent loss rate, operating expenses, capital expenditure allowance for the first year of operation, and expected annual growth rates for the next 7 years. The bottom part of the table lists the applicable income capitalization rates and development costs.
Questions [Answer all questions using Excel]
1. Develop 7-year before- and after-CAPEX operating cash flow projections.
2. Estimate the cash flow from the sale of the property at the end of year 7.
3. Estimate the value of the property once it becomes a fully stabilized asset.
4. Use the DCF method to find the before- and after-CAPEX discount rates that an investor who purchases the completed project at the price found in
question 3 will earn if she operates that property for 7 years. Explain the difference between the two discount rates and the difference between
the before-CAPEX discount and cap rates at the beginning of year 1.
5. If the developer decides to keep and operate the property for 7 years after completion, what will be his after-CAPEX return under the assumption that the entire investment takes place at the beginning of year 1? Why is his return higher than the corresponding return found in question 4?
6. What is the maximum after-CAPEX cap rate that will allow the developer to break once the property is completed? What will be the maximum vacancy rate on the apartments that will allow the developer to earn an after-CAPEX return of 10% if he keeps the property for 10 years?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Corporate Finance

Authors: Richard Brealey

10th Global Edition

0071314172, 9780071314176

More Books

Students also viewed these Finance questions

Question

25.0 m C B A 52.0 m 65.0 m

Answered: 1 week ago