Question: 4. (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


4. (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. $5,000,000 5.25% 7.50% 3.00% 3.00% 5.25% Total CF Asking price CAP Required Rate Expected NOI growth Vacancy rate Terminal CAP Year NOI $5,000,000 1 $262,500 262,500 2$ 270,375 270,375 3 278,486 S 278,486 0 4 $286,841 286,84 5 295,446 $ 295,446 6 $304,309 S 6,100,680 IRR: 7.81% IRR: / Total
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
