This exercise is an important part of the learning process. The exercise has three objectives: to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This exercise is an important part of the learning process. The exercise has three objectives: to ensure that you understand the analysis using simulation, to recognize the uncertainty in cash flow forecasts, and to get you well on your way to your final 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 financial returns, to modeling and managing uncertainty to make better ex ante investment and finance decisions. Task 1: Prepare a "base case" analysis of the Tower Office building using the following assumptions: Purchase Price Gross Floor Area Office Rent Rent Growth Rate Expense Growth Stabilized Vacancy Expenses Terminal Cap Rate Discount Rate Tower Office Assumptions $17,000,000 170,000 sf $30/sf 3% 3% 5% $17.5/sf 11.5% 12.5% 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. (a) Use the pro forma to determine the before-tax IRR (BTIRR) and after-tax IRR (ATIRR). (b) What is the NPV for this property using a 12.5 percent (after-tax) discount rate. Task 2: Incorporate uncertainty in the rent growth rate of Tower Office building To model the uncertainty of rent growth use a normal distribution with an average expected rent growth rate of 3 percent and a standard deviation of 2 percent. The latter implies that the rental growth rate should be within 2 percent of the mean (or between 1 percent and 5 percent) 68 percent of the time and should be within 4 percent of the mean (or between -1 percent and 7 percent) 95 percent of the time. Run 500 iterations for Tower Office building, not one more nor one less. (a) After running 500 iterations of the model calculate the mean of the 500 NPVs to yield an Expected Net Present Value (ENPV). (b) Create the cumulative distribution function for the NPV. Graph the table as a scatter plot and format as necessary. (c) Identify the value-at-risk (i.e., the loss at the worst 10 percent of the scenarios) and the value-at-gain (i.e., the gain at the best 10 percent of the scenarios). (d) Compute the probability that the NPV of the property will be zero or less. (e) Discuss how you could plot multiple cumulative distribution functions on the same graph to compare and analyze the probabilistic outcomes across multiple alternatives. This exercise is an important part of the learning process. The exercise has three objectives: to ensure that you understand the analysis using simulation, to recognize the uncertainty in cash flow forecasts, and to get you well on your way to your final 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 financial returns, to modeling and managing uncertainty to make better ex ante investment and finance decisions. Task 1: Prepare a "base case" analysis of the Tower Office building using the following assumptions: Purchase Price Gross Floor Area Office Rent Rent Growth Rate Expense Growth Stabilized Vacancy Expenses Terminal Cap Rate Discount Rate Tower Office Assumptions $17,000,000 170,000 sf $30/sf 3% 3% 5% $17.5/sf 11.5% 12.5% 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. (a) Use the pro forma to determine the before-tax IRR (BTIRR) and after-tax IRR (ATIRR). (b) What is the NPV for this property using a 12.5 percent (after-tax) discount rate. Task 2: Incorporate uncertainty in the rent growth rate of Tower Office building To model the uncertainty of rent growth use a normal distribution with an average expected rent growth rate of 3 percent and a standard deviation of 2 percent. The latter implies that the rental growth rate should be within 2 percent of the mean (or between 1 percent and 5 percent) 68 percent of the time and should be within 4 percent of the mean (or between -1 percent and 7 percent) 95 percent of the time. Run 500 iterations for Tower Office building, not one more nor one less. (a) After running 500 iterations of the model calculate the mean of the 500 NPVs to yield an Expected Net Present Value (ENPV). (b) Create the cumulative distribution function for the NPV. Graph the table as a scatter plot and format as necessary. (c) Identify the value-at-risk (i.e., the loss at the worst 10 percent of the scenarios) and the value-at-gain (i.e., the gain at the best 10 percent of the scenarios). (d) Compute the probability that the NPV of the property will be zero or less. (e) Discuss how you could plot multiple cumulative distribution functions on the same graph to compare and analyze the probabilistic outcomes across multiple alternatives.
Expert Answer:
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these accounting questions
-
A building is a sphere of 135 ft in diameter. What is the volume of the building? The volume of the building is 1288249.34 ft. (Type your answer using the appropriate number of significant digits.)
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The IQ and VIQ are tools insurance producers use to learn more about internal assumptions regarding factors that ultimately control policy performance. They have information in all of the following...
-
Consider again the conditions of Exercise 2. Suppose that the losses from errors of type I and type II are equal, and the prior probabilities that H0 and H1 are true are equal. Determine the Bayes...
-
Consider the perpendicular rectangles shown schematically. (a) Determine the shape factor F 12 . (b) For rectangle widths of X = 0.5, 1.5, and 5 m, plot F 12 as a function of Z b for 0.05 Z b 0.4m....
-
What are the different ways in which a defendant may be served with process?
-
Describe the layout of a typical fast-food franchise such as McDonalds. What type of layout is it? How does it support productivity? Do different franchises (e.g., Burger King or Wendys) have...
-
Explain how the rows and columns created excel database would help you further analyze the information
-
SECTION B: ANSWER ANY THREE (3) QUESTIONS QUESTION TWO The following summarized statements of comprehensive income have been prepared for the year ended 31 December 2014 for Gold Reef Holdings and...
-
Discussion Board: Thoughts on the Merits of the NPV Rule A Compose a post on your thoughts on The Merits of Net Present Value Rule. Why is this rule superior? Why is that so crucial in Finance? What...
-
Xenor Corporation introduced a bond in 2002 that offered a coupon rate of 8 1/2%, resulting in coupon payments of $8.50. The bond is scheduled to mature in 2032. If the current going interest rate in...
-
With many companies merging in different countries, are cultures merging too? Why is that important to IHR? Why is human resources in the health care industry just as important as any other industry?
-
An employer has scheduled candidates for interviews. When one person is told of her interview time, she says she is unavailable due to caregiving responsibilities, and asks for another time. The...
-
An investor purchased $100,000 in a 5-year index-linked guaranteed investment certificate (GIC) in a non-registered account. The GIC matured at $110,000. Assuming he is in a 26% marginal tax bracket,...
-
Jeffrey is a 5 month old infant weighing 15lbs. (Infants <6 months old need 108 kcal/kg/d.) How many kcal should Jeffrey receive per day?
-
You have been appointed as the new environmental manager for Microsoft. In a blog post to your key stakeholders, discuss using environmental management as a competitive advantage.
Study smarter with the SolutionInn App