In: Finance
When preparing capital budgeting analysis for a new project, Chris Johnson, a chief financial officer at BT Industries, faced a dilemma. The project involved a production of new type of shipping containers, which were significantly more durable and had a considerably longer useful life compared to conventional containers used in the industry. The year was 2009, and the equipment necessary for producing the containers was being sold for $750K. Each year, this cost is expected to increase by 30%. The useful life of the equipment and the project is 6 years. Mr. Johnson estimated that during a recovery year, the project will generate net cash flows of $500K per year, while during a recessionary year, the project will lose money, with an expected net cash flow of $-100K per year. Because the economy suffered a significant decline just a year prior, there was uncertainty about the economy in general, and, very much affected by the economy, the demand for shipping and containers. Market analysts predicted that 2010 provide certain information about the likelihood of recovery. At this point, in 2009, the likelihood of 2010 being a recovery year is estimated at 45% and the likelihood of 2010 being a recession year is estimated at 55%. If 2010 is a recovery year, the likelihood that recovery continues in 2011 and all subsequent years is 80%, and the likelihood of these subsequent years being recessionary years is 20%. If recession continues in 2010, the likelihood that 2011 and all subsequent years will be recovery years is 20%, and the likelihood of these subsequent years being recessionary is 80%. In 2011, the market gets resolved, and everyone will know the state of the economy for the foreseeable future with certainty. Since he has not dealt with uncertainty regarding the future state of the economy before, Mr. Johnson is bewildered and asks your help in determining the course of action regarding this opportunity. In particular, should the firm buy the equipment in 2009, 2010, or not buy at all? Mr. Johnson has estimated that the WACC for the company in certain times has been 10%. Assume that the project has no tax implications, i.e. the tax rate of 0%. Also assume that the firm can shut down the project any time at a one-time cost of $50K
. a) What is the NPV of investing into the machine in 2009? __________________ b) What is the NPV (in year 2009) of delaying the investment until 2010? __________________ c) What is the NPV (in year 2009) of delaying the investment until 2011? __________________ d) What strategy with respect to this investment should the firm follow? In other words, when should the firm invest? Explain your answer.
All financials below are in $ '000.
We are looking at four different options:
Option 1: 2010 is a recovery year and 2011 and all the subsequent years are also recovery years; probability = p1 = 45% x 80% = 36%
Initial investment, C0 = 750
Cash flow in all the six years 1 to 6 = C = 500
N = 6 years, Discount rate = R = 10%
Hence, NPV1 = - C0 + C / R x [1 - (1 + R)-N] = -750 + 500 / 10% x [1 - (1 + 10%)-6] = 1,427.63
Option 2: 2010 is a recovery year and 2011 and all the subsequent years are also recessionary years; probability = p1 = 45% x 20% = 9%
Cash flow in year 1 = C1 = 500
Cash flows in each of the year 2 to 6 = - 100; N = 5 years of annuity
Hence, NPV2 = - C0 + C1 / (1 + R) + C / [R x (1 + R)] x [1 - (1 + R)-N] = -750 + 500 / (1 + 10%) - 100 / [10% x (1 + 10%)] x [1 - (1 + 10%)-5] = - 640.07
Option 3: 2010 is a recessionary year and 2011 and all the subsequent years are also recovery years; probability = p1 = 55% x 20% = 11%
Cash flow in year 1 = C1 = -100
Cash flows in each of the year 2 to 6 = 500; N = 5 years of annuity
Hence, NPV2 = - C0 + C1 / (1 + R) + C / [R x (1 + R)] x [1 - (1 + R)-N] = - 750 - 100 / (1 + 10%) + 500 / [10% x (1 + 10%)] x [1 - (1 + 10%)-5] = 882.18
Option 4: 2010 is a recessionary year and 2011 and all the subsequent years are also recessionary years; probability = p1 = 55% x 80% = 44%
Cash flow in all the six years 1 to 6 = C = -100
N = 6 years, Discount rate = R = 10%
Hence, NPV1 = - C0 + C / R x [1 - (1 + R)-N] = -750 - 100 / 10% x [1 - (1 + 10%)-6] = - 1,185.53
a) What is the NPV of investing into the machine in 2009?
NPV2009 = p1 x NPV1 +
p2 x NPV2 + p3 x NPV3 +
p4 x NPV4 = 36.00% x 1,427.63 + 9.00%
x (640.07) + 11.00% x 882.18 + 44% x (1,185.53)
= 31.75
---------------------------------------
b) What is the NPV (in year 2009) of delaying the investment until 2010?
Four options are possible:
Option 1: 2010 was a recovery year and 2011 and all the subsequent years are also recovery years; probability = p1 = 45% x 80% = 36%
Initial investment, C0 = 750 x (1 + 30%) = 975 at the end of year 2010
Cash flow in all the six years 1 to 6 = C = 500
N = 6 years, Discount rate = R = 10%
Hence, NPV1 = - C0 + C / R x [1 - (1 + R)-N] = -975 + 500 / 10% x [1 - (1 + 10%)-6] = 1,202.63
Option 2: 2010 was a recovery year and 2011 and all the subsequent years are also recessionary years; probability = p1 = 45% x 20% = 9%
Cash flow in year 1 = C1 = 500
Cash flows in each of the year 2 to 6 = - 100; N = 5 years of annuity
Hence, NPV2 = - C0 + C1 / (1 + R) + C / [R x (1 + R)] x [1 - (1 + R)-N] = - 975 + 500 / (1 + 10%) - 100 / [10% x (1 + 10%)] x [1 - (1 + 10%)-5] = - 865.07
Option 3: 2010 was a recessionary year and 2011 and all the subsequent years are also recovery years; probability = p1 = 55% x 20% = 11%
Cash flow in year 1 = C1 = -100
Cash flows in each of the year 2 to 6 = 500; N = 5 years of annuity
Hence, NPV2 = - C0 + C1 / (1 + R) + C / [R x (1 + R)] x [1 - (1 + R)-N] = - 975 - 100 / (1 + 10%) + 500 / [10% x (1 + 10%)] x [1 - (1 + 10%)-5] = 657.18
Option 4: 2010 was a recessionary year and 2011 and all the subsequent years are also recessionary years; probability = p1 = 55% x 80% = 44%
Cash flow in all the six years 1 to 6 = C = -100
N = 6 years, Discount rate = R = 10%
Hence, NPV1 = - C0 + C / R x [1 - (1 + R)-N] = - 975 - 100 / 10% x [1 - (1 + 10%)-6] = - 1,410.53
NPV2010 = p1 x NPV1 + p2 x NPV2 + p3 x NPV3 + p4 x NPV4 = 36.00% x 1,202.63 + 9.00% x (865.07) + 11.00% x 657.18 + 44% x (1,410.53) = -193.25
Hence, NPV2009 = NPV2010 / (1 + R) = - 175.68
----------------------------------------------
c) What is the NPV (in year 2009) of delaying the investment until 2011?
We invest only if we come to know that all the future years are recovery.
Initial investment, C0 = 975 x (1 + 30%) = 1,267.50 at the end of year 2011
Cash flow in all the six years 1 to 6 = C = 500
N = 6 years, Discount rate = R = 10%
Hence, NPV2011 = - C0 + C / R x [1 - (1 + R)-N] = - 1,267.50 + 500 / 10% x [1 - (1 + 10%)-6] = 910.13
Hence, NPV2009 = NPV2011 / (1 + R)2 = 752.17
--------------------------------------------------
d) What strategy with respect to this investment should the firm follow? In other words, when should the firm invest? Explain your answer.