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 incomeproducing property shown below. The only input risk distribution defined in this

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!