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
-
You are the Chief Risk Officer of a newly-established actively managed fund with a portfolio $10 million, currently all invested in equities with an investment horizon of one year only. Due to the...
-
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 4, and suppose that () is required to be a given value 0 (0 < 0 < 1). Determine the test procedure for which () will be a minimum, and calculate this...
-
Aaron's Agency sells an insurance policy offered by Capital Insurance Company for a commission of $100 on January 2, 2017. In addition, Aaron will receive an additional commission of $10 each year...
-
Wang Company has several processing departments. Costs charged to the Assembly Department for October 2002 totaled $1,347,200 as follows. Production records show that 25,000 units were in beginning...
-
Use the information from BE17-1, but assume the bonds are purchased as an available-for-sale security. Prepare Garfields journal entries for (a) The purchase of the investment, (b) The receipt of...
-
if a line slope of -4, then the value of y blank by blank is the value of (x)incre ases by 1
-
Grommet Limited manufactures its only product in its Salt Lake City factory. The general manager, Elizabeth Miller, has just received a special request from a customer for 10,000 units of this...
-
Which of the following is a gathering held by a firm seeking publicity for an event or happening for news reporters? Press conference External audit Lobbying Created publicity
-
How do transformational leaders orchestrate strategic alliances and collaborative partnerships to leverage complementary strengths and resources, thereby fostering synergistic growth and market...
-
List five with an explanation of the obligatory conditions of Zakat to be eligible as alms asset?
-
In a high school Principal name the five things that worry them about their business and organization and if they can share their plans to mitigate or eliminate their worries. Write a 4-5page summary...
-
What are the differences among ROI analysis,Break Even analysis,and NPV analysis?Which one is more suitable under what situation? Please would you provide an example of capacity decisions and how to...
-
What innovative methodologies can leaders employ to cultivate a diverse and inclusive workforce, thereby capitalizing on the manifold perspectives and experiences to foster creativity and drive...
-
Se-t, sm hit. sint dt 8 Evaluate: 0
-
Assume that a trial balance is prepared with an account balance of $21,360 listed as $21,630 and an account balance of $1,500 listed as $15,000. Identify the transposition and the slide.
-
A ___________ is the range of authoritative requests to which a subordinate is willing to respond without subjecting the directives to critical evaluation or judgment. (a) A zone of indifference (b)...
-
Define organizational politics and give an example of how it operates in both functional and dysfunctional ways.
-
Identify and explain at least three guidelines for the acquisition of (a) position power and (b) personal power by managers.
Study smarter with the SolutionInn App