This exercise is an important part of the learning process. The exercise has three objectives: 0 to ensure that you understand the analysis using simulation, 0 to recognize the uncertainty in cash ow forecasts, and 0 to get you well on your way to your nal analysis. Incorporating uncertainty into real estate pro formas not only provides different results over deterministic models, it changes the angle of attack to real estate valuation problems. When uncertainty is taken into account, the focus shifts from simply maximizing nancial returns, to modeling and managing uncertainty to make better ex ante investment and nance decisions. Task 1: Prepare a "base case" analysis of the Tower Ofce building using the following assumptions: Tower Ofce Assumptions Purchase Price $17,000,000 Gross Floor Area I 170,000 sf Ofce Rent $30/sf Rent Growth Rate _ A fully amortizing 70 percent loan can be obtained at 7 percent interest for 30 years (total annual payments will be monthly payments times 12). The building represents 80 percent of value and is depreciable over 39 years (use 1/39 per year). Capital gains from price appreciation will be taxed at 20 percent and depreciation recapture will be taxed at 25 percent. The potential investor indicates that she is in the 36 percent bracket and has enough passive income from other activities so that any passive losses from this activity would not be subject to any passive activity loss limitation. Develop a 10-year pro forma. [3) Use the pro forma to determine the before-tax IRR {BTIRR} and after-tax IRR [ATIRRL {b} What is the NPV for this property using a 12.5 percent (after-tax) discount rate