In: Finance
Use the cash flows and competitive spreads shown in the table below.
| ($ millions) | ||||
| Year 0 | Year 1 | Year 2 | Years 3–10 | |
| Investment | 180 | |||
| Production (millions of pounds per year) | 0 | 0 | 48 | 88 | 
| Spread ($ per pound) | 1.03 | 1.03 | 1.03 | 1.03 | 
| Net revenues | 0 | 0 | 49.44 | 90.64 | 
| Production costs | 0 | 0 | 38.00 | 38.00 | 
| Transport | 0 | 0 | 0 | 0 | 
| Other costs | 0 | 28 | 28 | 28 | 
| Cash flow | –180 | 28 | –16.56 | –24.64 | 
| NPV (at r = 7%) = 0 | ||||
Assume the dividend payout ratio each year is 100%.
a. Calculate the year-by-year book and economic profitability for investment in polyzone production. Assume straight-line depreciation over 10 years and a cost of capital of 7%. (Negative answers should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your income answers in millions rounded to 2 decimal places and enter the rate of return as a percent rounded to 2 decimal places.)
| Period: | 0 | 1 | 2 | 3 | 4 | 5 | 
| Book income ($) | ||||||
| Book rate of return (%) | ||||||
| Economic income ($) | ||||||
| 6 | 7 | 8 | 9 | 10 | |
| Book income ($) | |||||
| Book rate of return (%) | |||||
| Economic income ($) | |||||
b-1. What is the economic rate of return? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)
Economic rate of return %
b-2. Now compute the steady-state book rate of return (ROI) for a mature company producing polyzone. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)
ROI %
Part (a) The year-by-year book and economic profitability for investment in polyzone is calculated and shown in yellow highlighted rows. Yellow highlighted rows are your answers.
| 
 Parameter  | 
 Linkage  | 
 Year 0  | 
 Year 1  | 
 Year 2  | 
 Year 3  | 
 Year 4  | 
 Year 5  | 
 Year 6  | 
 Year 7  | 
 Year 8  | 
 Year 9  | 
 Year 10  | 
| 
 Investment  | 
 A  | 
 180.00  | 
||||||||||
| 
 Depreciation  | 
 B = A / 10  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
|
| 
 Year end book value  | 
 C = 180 - accumulated depreciation  | 
 180.00  | 
 162.00  | 
 144.00  | 
 126.00  | 
 108.00  | 
 90.00  | 
 72.00  | 
 54.00  | 
 36.00  | 
 18.00  | 
 -  | 
| 
 Calculation of Book Income & Book Rate of Return  | 
||||||||||||
| 
 Net revenues  | 
 D  | 
 -  | 
 -  | 
 49.44  | 
 90.64  | 
 90.64  | 
 90.64  | 
 90.64  | 
 90.64  | 
 90.64  | 
 90.64  | 
 90.64  | 
| 
 [-] Production costs  | 
 E  | 
 -  | 
 -  | 
 38.00  | 
 38.00  | 
 38.00  | 
 38.00  | 
 38.00  | 
 38.00  | 
 38.00  | 
 38.00  | 
 38.00  | 
| 
 [-] Transport  | 
 F  | 
 -  | 
 -  | 
 -  | 
 -  | 
 -  | 
 -  | 
 -  | 
 -  | 
 -  | 
 -  | 
 -  | 
| 
 [-] Other costs  | 
 G  | 
 -  | 
 28.00  | 
 28.00  | 
 28.00  | 
 28.00  | 
 28.00  | 
 28.00  | 
 28.00  | 
 28.00  | 
 28.00  | 
 28.00  | 
| 
 [-] Depreciation  | 
 B (from above)  | 
 -  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
 18.00  | 
| 
 Book Income  | 
 D - (E+F+G+B)  | 
 -  | 
 (46.00)  | 
 (34.56)  | 
 6.64  | 
 6.64  | 
 6.64  | 
 6.64  | 
 6.64  | 
 6.64  | 
 6.64  | 
 6.64  | 
| 
 Book Rate of Return  | 
 I = D / C from prior year  | 
 -25.56%  | 
 -21.33%  | 
 4.61%  | 
 5.27%  | 
 6.15%  | 
 7.38%  | 
 9.22%  | 
 12.30%  | 
 18.44%  | 
 36.89%  | 
|
| 
 Calculation of Economic Income  | 
||||||||||||
| 
 Cash flows  | 
 J  | 
 (180.00)  | 
 (28.00)  | 
 (16.56)  | 
 24.64  | 
 24.64  | 
 24.64  | 
 24.64  | 
 24.64  | 
 24.64  | 
 24.64  | 
 24.64  | 
| 
 Discount rate  | 
 K  | 
 7%  | 
||||||||||
| 
 PV of cash flows at the beginning of the year  | 
 L = NPV(7%, Future cash flows)  | 
 87.88  | 
 122.03  | 
 147.13  | 
 132.79  | 
 117.45  | 
 101.03  | 
 83.46  | 
 64.66  | 
 44.55  | 
 23.03  | 
|
| 
 PV of cash flows at the end of the year  | 
 M = NPV(7%, Future cash flows from next period)  | 
 122.03  | 
 147.13  | 
 132.79  | 
 117.45  | 
 101.03  | 
 83.46  | 
 64.66  | 
 44.55  | 
 23.03  | 
 -  | 
|
| 
 Economic Depreciation  | 
 N = L - M  | 
 (34.15)  | 
 (25.10)  | 
 14.34  | 
 15.34  | 
 16.42  | 
 17.57  | 
 18.80  | 
 20.11  | 
 21.52  | 
 23.03  | 
|
| 
 Economic Income  | 
 O = J - N  | 
 6.15  | 
 8.54  | 
 10.30  | 
 9.30  | 
 8.22  | 
 7.07  | 
 5.84  | 
 4.53  | 
 3.12  | 
 1.61  | 
(b) - 1 Economic rate of return will be same as the discount rate, as given in the question. At some point in the question, NPV is being calculated at 7%. Hence economic rate of return = 7%
(b) - 2 Steady state ROI = Sum of Book income over the life of 10 years = Add all the elements in the row titled Book Income = - 27.44
Investments = Sum of year end book value over the life = add the elements in the row titled Year end book value = 990
Hence, ROI = - 27.44 / 990 = - 2.77%