Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

You wrap up the first part of your Stage 2: Discounted Cash Flow Analysis on a Mixed-Use Retail and Office Building assuming a three-year holding period below: The asking price is $3

Finance Apr 20, 2021

You wrap up the first part of your Stage 2: Discounted Cash Flow Analysis on a Mixed-Use Retail and Office Building assuming a three-year holding period below:

The asking price is $3.7 million.

You should feel free to use any Excel Spreadsheets 

(a). What Project Capitalization Rate is implied by the asking price state above? 

(b). Market experts predict the capitalization rate for this type of property at the end of three years will be 9.0%. Brokers report that they typically charge 6% on a property.

What will the net sale price be if you sold the property at the end of year three?

Expert Solution

Answer:

Part (a)

Ask Price = NOI of year 1 / Capitalization Rate

Hence, Capitalization Rate = NOI of year 1 / Ask Price = 326,000 / (3.7 x 106) = 8.81%

Part (b)

Sale Price at the end of year 3 = NOI of year 4 / Capitalization rate = 384,000 / 9% = $ 4,266,667

Net Sale price = Sale price x (1 - Brokerage) = 4,266,667 x (1 - 6%) = $ 4,010,667

PFA

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment