Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5. (9 points) Consider the Excel/@Risk analysis on a hypothetical income producing property shown below. The only input risk distribution defined in this analysis

image text in transcribed

5. (9 points) Consider the Excel/@Risk analysis on a hypothetical income producing property shown below. The only input risk distribution defined in this analysis is the "Terminal CAP", which is assumed to have a normal distribution with a mean of 5.25% and a standard deviation of 1%. The distribution shown below is the IRR output distribution. Asking price $5,000,000 Year CAP 5.25% 0 Total CF -$5,000,000 Required Rate 7.50% 1 $ 262,500 $ 262,500 Expected NOI growth 3.00% 2 $ 270,375 $ 270,375 Vacancy rate 3.00% 3 $ 278,486 $ 278,486 Terminal CAP 5.25% 4 $ 286,841 $ 286,841 5 $ 295,446 $ 295,446 6 $ 304,309 $6,100,680 IRR: 7.81% 0.00% 7.50% 45.... 16 14 12 10 8 6 4 2 0 IRR: / Total... 54.... 35% IRR: Total CF Minimum 0.232% Maximum 35.4% Mean 8.17% Std Dev 3.08% Values 10000 a. According to this analysis, what is the probability that you will earn a positive nominal return on your investment? b. According to this analysis, what is the probability that you will earn a return that is equal or higher than your required return? c. Given today's real estate and interest rate market environments, what is the problem with defining a "Terminal CAP" with a normal distribution? Suggest a different kind of distribution that might be more suitable and explain how this distribution is likely to affect your IRR output compared with a normal distribution. Will it increase the chance that you will earn your required rate of return?

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

Intermediate Financial Management

Authors: Brigham, Daves

10th Edition

978-1439051764, 1111783659, 9780324594690, 1439051763, 9781111783655, 324594690, 978-1111021573

More Books

Students also viewed these Finance questions