1. (25 points) You have the opportunity to purchase a triplex rental property. You expect this...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. (25 points) You have the opportunity to purchase a triplex rental property. You expect this property to generate $108,000 in rent one year from now and for rent to increase at 4% per year for the following four years. Five years from now, you believe you will be able to sell the property for $750,000. Assume the interest rate is 7% per year. a. How much should you be willing to pay today for this property? b. If you can buy the property for $1,000,000 what is the NPV of this opportunity? c. Acknowledging that the dollar values above are in the future (and therefore are estimates) explore what the NPV would be if your assumptions about growth are wrong. Using a Data Table ("Data tab -> What-if analysis -> Data Table"), calculate the NPV for values of g between 0% and 10% (NPV @g=0%, NPV @ g=1% etc.) Plot your results in a connected (the dots are connected) scatter plot. d. At what value of g is the NPV = 0? (Hint: use Goal Seek, found in "Data tab -> What-if analysis -> Goal Seek"). Logic check your value against the scatter plot you just created. Record your answer as a hard-coded value and reset g to 4% before moving on. e. Repeat your analysis from the last two questions, but now change the interest rate (discount rate). Evaluate the NPV for all values of r between 0% and 10%. Plot the results in a connected scatter plot. This is called an NPV profile. f. At what value of r is the NPV = 0? This is called the Internal Rate of Return (IRR). Logic check your value against the scatter plot you created. g. Now use a two-way Data Table to simultaneously evaluate NPV at all values of g between 0% and 10% AND all values of r between 0% and 10%. (you should have a 10x10 matrix). Highlight cells where NPV is negative (hint: try using conditional formatting on the Home tab). 223 1 4 5 Ans 1 A 6 Ans 1.B 7 8 Ans 1.C 10 11 12 13 14 15 16 17 18 19 A 20 21 Ans 1.0 22 23 Ans 1.E 24 25 26 27 28 29 30 31 32 33 34 B B 0 387074 11895 3% 11895 0% ($22,439.04) 1% -14100.51778 2% -5600.169411 Discount rate 0% 1% C 3% 3064.372947 4% 11895.49791 5% 20895.61257 6% 30067.14252 7% 39412.53181 8% 48934.24298 58634.75705 9% 10% 68516.57353 2% 3% 4% 5% 6% 1 108000 7% 8% 9% 10% 100935 D 2 112320 98105 $80,000.00 550,000.00 540,000.00 $20,000.00 5000 (520,000,00) (540,000,00) E F 95354 3 116812.8 121485.312 876344.724 92681 Chart Title 45 G 6% 5 624822 IN H 10% Interest rate 12% 4% 7% 1. (25 points) You have the opportunity to purchase a triplex rental property. You expect this property to generate $108,000 in rent one year from now and for rent to increase at 4% per year for the following four years. Five years from now, you believe you will be able to sell the property for $750,000. Assume the interest rate is 7% per year. a. How much should you be willing to pay today for this property? b. If you can buy the property for $1,000,000 what is the NPV of this opportunity? c. Acknowledging that the dollar values above are in the future (and therefore are estimates) explore what the NPV would be if your assumptions about growth are wrong. Using a Data Table ("Data tab -> What-if analysis -> Data Table"), calculate the NPV for values of g between 0% and 10% (NPV @g=0%, NPV @ g=1% etc.) Plot your results in a connected (the dots are connected) scatter plot. d. At what value of g is the NPV = 0? (Hint: use Goal Seek, found in "Data tab -> What-if analysis -> Goal Seek"). Logic check your value against the scatter plot you just created. Record your answer as a hard-coded value and reset g to 4% before moving on. e. Repeat your analysis from the last two questions, but now change the interest rate (discount rate). Evaluate the NPV for all values of r between 0% and 10%. Plot the results in a connected scatter plot. This is called an NPV profile. f. At what value of r is the NPV = 0? This is called the Internal Rate of Return (IRR). Logic check your value against the scatter plot you created. g. Now use a two-way Data Table to simultaneously evaluate NPV at all values of g between 0% and 10% AND all values of r between 0% and 10%. (you should have a 10x10 matrix). Highlight cells where NPV is negative (hint: try using conditional formatting on the Home tab). 223 1 4 5 Ans 1 A 6 Ans 1.B 7 8 Ans 1.C 10 11 12 13 14 15 16 17 18 19 A 20 21 Ans 1.0 22 23 Ans 1.E 24 25 26 27 28 29 30 31 32 33 34 B B 0 387074 11895 3% 11895 0% ($22,439.04) 1% -14100.51778 2% -5600.169411 Discount rate 0% 1% C 3% 3064.372947 4% 11895.49791 5% 20895.61257 6% 30067.14252 7% 39412.53181 8% 48934.24298 58634.75705 9% 10% 68516.57353 2% 3% 4% 5% 6% 1 108000 7% 8% 9% 10% 100935 D 2 112320 98105 $80,000.00 550,000.00 540,000.00 $20,000.00 5000 (520,000,00) (540,000,00) E F 95354 3 116812.8 121485.312 876344.724 92681 Chart Title 45 G 6% 5 624822 IN H 10% Interest rate 12% 4% 7%
Expert Answer:
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these accounting questions
-
You have the opportunity to purchase a 25-year, $1,000 par value bond that has an annual coupon rate of 9%. If you require a YTM of 7.6%, how much is the bond worth to you?
-
A mining firm has the opportunity to purchase a license on a plot of land to mine for gold. Consider the following financial information: The investment cost to mine is $40M. It costs $320 per...
-
You have an opportunity to purchase a private competitor called Fernand in Mexico. You will use only your funds if you decide to purchase the company. a. When you attempt to determine the value of...
-
Antonio Banderos & Scarves makes headwear that is very popular in the fall/winter season. Units sold are anticipated as: October .......... 1,250 November ......... 2,250 December ......... 4,500...
-
Your boss has told you to evaluate two ovens for Tink-the-Tinkers, a gourmet sandwich shop. After some questioning of vendors and receipt of specifications, you are assured that the ovens have the...
-
\(Y\) is a random variable with \(\mu_{Y}=0, \sigma_{Y}=1\), skewness \(=0\), and kurtosis \(=100\). Sketch a hypothetical probability distribution of \(Y\). Explain why \(n\) random variables drawn...
-
Imagine you are the CIO and have to select the three most relevant indicators for the quality of your information system at your hospital: Which would you select? You can look at the examples in...
-
Data for Norman Company are presented in E23-5. Prepare the operating activities section of the statement of cash flows using the indirect method.
-
Macy Inc. produces the following three items of stuffed toys using an automated technology: Bear, Puppy, and Bunny. The estimation for the number of units produced, machine hours used, and direct...
-
After retiring as a physician, Bob Guthrie became an avid downhill skier on the steep slopes of the Utah Rocky Mountains. As an amateur inventor, Bob was always looking for something new. With the...
-
If you buy a bond for $1,200.00, earn interest payments totaling $42.00 during the year, and then sell it for $1,251.00. This information is shown in the following table. B0 Interest B1 $1,200.00...
-
Brickman Corporation uses the allowance method to account for uncollectible receivables. At the beginning of the year, Allowance for Bad Debts had a credit balance of $1,000. During the year Brickman...
-
Relax Recliner Chairs completed the following selected transactions: Record the transactions in the journal of Relax Recliner Chairs. Explanations are not required. (Round to the nearest dollar.)...
-
The beginning balance sheet of Text Source Co. included a $700,000 investment in Taylor stock (20% ownership). During the year, Text Source completed the following investment transactions:...
-
Use the following abbreviations to indicate the journal in which you would record transactions a through n. J = General journal S = Sales journal CR = Cash receipts journal P = Purchases journal CP =...
-
Summer BBQ uses a perpetual inventory system to record inventory. All purchases and sales of merchandise inventory were on account. Company records indicate the following data for the month of June...
-
Cola Company reported the following on its 2020 income statement. Using the income statement and the balance sheet given below, prepare the statement of cash flows using the indirect method. For...
-
In the operation of an automated production line with storage buffers, what does it mean if a buffer is nearly always empty or nearly always full?
-
In several of the above exercises, we have indicated that an infinite series 1/(1+r )+1/(1+r )2 +1/(1+r )3 +... sums to 1/r . This can (and has, in some of the B-parts of exercises above) been used...
-
Public policy makers are often pressured to reduce class size in public schools in order to raise student achievement. A: One way to model the production process for student achievement is to view...
-
Most developed countries prohibit employers from paying wages below some minimum level w. This is an example of a price floor in the labor market and the policy has an impact in a labor market so...
-
Entropy of wet steam is given by (a) \(s_{f}+x s_{f g}\) (b) \(x s_{g}\) (c) \(s_{g}+s_{f g}\) (d) \(x s_{f}\)
-
Determine the change in internal energy when one \(\mathrm{kg}\) of steam expands from \(10 \mathrm{bar} 300^{\circ} \mathrm{C}\) to 0.5 bar and 0.9 dry. Take \(c_{p s}=2.1 \mathrm{~kJ} /...
-
What do you understand by the term priming ?
Study smarter with the SolutionInn App