of University Pennsylvania The Wharton School
FNCE 100 PROBLEM SET #2 Fall Term 2005 A. Craig MacKinlay
Capital Budgeting Under Certainty 1. (a) Plot the NPV as a function of the interest rate for the following sequences of cash ows: Sequence A Sequence B 1 2 3 4 100 100 200 100 100 0 100 200
(b) What is the IRR for each sequence? Show this on your graphs. 2. BICCC is considering whether to replace an existing machine or to spend money on overhauling it. The replacement machine would cost $9000 now and would require maintenance of $1000 at the end of every year for 8 years. At the end of 8 years it would have a scrap value of $2000 and would be sold. The existing machine requires increasing amounts of maintenance each year, and its salvage value is falling as shown below: Year Maintenance Salvage Now 1 2 3 4 0 1000 2000 3000 2000 4000 2500 1500 1000 0
(The existing machine can be sold for $4000 now. If it is sold in 1 year, the price will be $2500, and $1000 will have to be spent on maintenance. The machine will last for 4 more years before it falls apart.) If BICCC faces an opportunity cost of capital of 15 percent, when should it replace the machine? 3. Five years ago, trucking magnate Leonard Rose purchased ten trucks for $15,000 each. He is now considering replacing those trucks with ve new models. One new model can 19
do the work of two of the present trucks. Each new truck will cost $25,000 and has an expected life of ten years with a $1,000 salvage value. It is expected that the current trucks have ten years of service left at the end of which they will have no salvage value. If the ve new trucks are purchased, Rose expects total operating expenses for the company to decrease by $10,000 per year. The old trucks could currently be sold for $3,000 each. Taxes are at a 40% rate. The Rose Company uses straight line depreciation. Roses costs of capital is 8%. Should he replace the trucks? 4. The H. O. Company is considering purchasing a machine in order to produce a new product. The new product will generate revenues of $50,000 per year for ve years. The cost of materials and labor needed to generate these revenues will total $30,000 per year and other cash expenses will be $10,000 per year. Net working capital of $5,000 will be required immediately and this amount will be freed-up at the end of the fth year. The machine will cost $25,000. It will be depreciated using MACRS for the three year asset class. The three year class depreciates the asset over 4 years as follows: 33.33%, 44.45%, 14.81%, and 7.81%. Finally, the rms tax rate is 35% and its required return is 10%. Using the net present value method, determine whether investment in the new machine is economically acceptable. 5. Mr. T. Thumb is the president of Microtechnology, Inc. a very small private company. He expects revenues in the forthcoming year of $20 million and costs (including taxes) of $15 million. During the subsequent 5 years (i.e., years 2 through 6) Mr. Thumb forecasts that revenues and costs will grow by 25 percent a year, but he anticipates that all prots will need to be plowed back into the business. Thereafter he forecasts that growth will drop to 5 percent a year and that the company will need to plow back only 40 percent of prots. Mr. Thumb has recently been oered $75 million in cash for his company. Is this a fair oer if the opportunity cost of capital is 12 percent? 6. Mr. Cyrus Clops, the president of Giant Enterprises, has to make a choice between two possible investments: Cash Flows, Thousands of Dollars Project A B C0 400 200 C1 +241 +131 C2 +293 +172 IRR Percent 21 31
The opportunity cost of capital is 9 percent. Mr. Clops is tempted to take B, which has the higher IRR. 20
(a) Explain to Mr. Clops why this is not the correct procedure. (b) Show him how to adapt the IRR rule to choose the best project. (c) Show him that this project also has the higher NPV. 7. Brylcream Oil Companys properties are expected to yield 1000 barrels a year forever. After all expenses except taxes, Brylcream can sell this years production for $20 per barrel (to be received at the end of the year). This pre-tax net-income is expected to increase at an 8 percent annual rate. Brylcream faces a constant 40 percent income tax rate and does not have access to depletion allowances or other tax shields. Brylcreams opportunity rate is (quite naturally) 10 percent. How much is Brylcream Oil Company worth today? (Show calculations.) 8. Calculate the NPV of the following project given a 0 (yes, zero) percent real discount rate. Show your cash ow calculations. Today (t = 0) Investment Output (# widgets) Labor input (hours) Cash ow NPV The rm faces a 40 percent tax rate and uses straight-line depreciation. The salvage value of the investment will be zero at t=2. Labor costs today are $12 per hour and will increase at 10 percent per year. In real terms, Widgets will sell for 300 each today. This price will remain constant in real terms. The expected annual ination rate equals 10%. 9. Conocococonut is considering the purchase of a new harvester. They are currently involved in deliberations with the manufacturer and as of yet the parties have not come to a settlement regarding the nal purchase price. The management of Conocococonut has hired you, a high-priced consultant, to arrive at the break-even purchase price such that the NPV of the project will be zero. This will be of obvious use to Conocococonut in their negotiation with the capital equipment manufacturer. FACTS: (1) The new harvester is not expected to aect revenues, but operating expenses will be reduced by $10,000 per year for 10 years. 21 $40,000 0 0 Year 1 (t = 1) 0 2,000 100 Year 2 (t = 2) 0 2,000 100
(2) The old harvester is now 5 years old with 10 years of its scheduled life remaining. It was purchased for $45,000 and depreciated on a straight-line basis to zero over 15 years. Its salvage value is expected to be $5,000 at the end of 15 years. (3) The old harvester has a current market value of $25,000. (4) The new harvester will be depreciated straight-line over its 10 year life to zero. Its salvage value is expected to be $10000. (5) The corporate tax rate is 35%. (6) The rms cost of capital is 15%. 10. The Pratt Piston Company is considering an investment in a new plant which will entail an immediate capital expenditure of 2000 ($1000s). The plant is to be depreciated on a straight-line basis over 10 years and there will be no salvage value. Annual operating revenues (before depreciation and taxes) are expected to be 550 for the rst 5 years of the plant and to be 400 for the following 5 years. Assuming that the company has a required return of 12 percent after taxes for such an investment and that its marginal tax rate is 40 percent, calculate (a) average return on book, (b) the payback period, (c) NPV, (d) IRR, (e) the protability index. 11. A machine costs $3500 and has an expected life of 7 years with no salvage value. Calculate the depreciation in each year, and the present value of the depreciation tax shield at an interest rate of 12 percent under (a) straight-line depreciation & (b) MACRS (7 year class). The corporate tax rate is 35 percent. What dierence does the choice of depreciation method make? What dierence does it make to your calculations if the asset is depreciated over 5 years instead of 7 years? [Note: Depreciation rates for MACRS 7 year asset class are 14.29%, 24.49%, 17.49%,12.49%, 8.93%, 8.93%, 8.93%, and 4.45% over eight years. Depreciation rates for MACRS 5 year asset class are 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76% over six years.] 12. The following example serves to illustrate the importance of taking anticipated ination into account explicitly when estimating future cash ows. Too often, there is a tendency not to consider its eect in these estimates. Because anticipated ination is embodied in the required rate of return, not to take account of it in the cash-ow estimates will result in a biased appraisal of the project and, in turn, the possibility of a less than optimal allocation of capital. To illustrate this bias, assume that a project which costs $100,000 at time 0 was under consideration and was expected to provide cash-ow benets over the next 5 years. Assume further straight-line depreciation and a corporate tax rate of 50%. Suppose that cash ows were estimated on the basis of price levels at time 0, with no
22
consideration of the eect of future ination, and that these estimates were: END OF YEAR: 1 Expected Cash Inow Cash Expected Outow Incremental Net Operating Income 1-tax rate Depreciation tax rate Net Cash Flow $30,000 10,000 20,000 .50 10,000 10,000 $20,000 2 $40,000 10,000 30,000 .50 15,000 10,000 $25,000 3 $50,000 10,000 40,000 .50 20,000 10,000 $30,000 4 $50,000 10,000 40,000 .50 20,000 10,000 $30,000 5 $30,000 10,000 20,000 .50 10,000 10,000 $20,000
(a) If the relevant cost of capital is 12%, what is the projects calculated net present value? Should the rm accept the project according to this analysis? (b) Now recalculate your answer to (a), assuming a 5% ination rate. 13. The Borstal Company has to choose between two machines which do the same job but have dierent lives. The two machines have the following costs: Year 0 1 2 3 4 Machine A $40,000 10,000 10,000 10,000 + replace ... Machine B $50,000 8,000 8,000 8,000 8,000 + replace
If the discount rate is 12 percent, which machine would Borstal buy?
23
University of Pennsylvania The Wharton School
FNCE 100 Solutions to PROBLEM SET #2 Fall Term 2005 A. Craig MacKinlay
Capital Budgeting Under Certainty 1. (a) PV 100 ......... PV 200 .........
0 (b) A: 0 = 100 + B: 0 = 100 +
0
.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... .... .... .... .... .... .... .... ...
r
100 (1+IRR)3 200 (1+IRR)3
100 1+IRR 0 1+IRR
80% 200 + (1+IRR)2 +
100 (1+IRR)2
0
.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... .... .... .... .... .... .... .... ...
52%
r 0
IRR = 80%. IRR = 52%.
+
2. Equivalent annual cost of replacement machine (EAC): PVcosts = $9000 + $1000 2000 = t (1.15)8 t=1 (1.15) $9000 + 4.487($1000) $2000(0.3269) = $12, 833 PV 8 year annuity factor @ 15 percent = $12, 833 = $2860 4.487
8
EAC of new machine =
Set up keeping machine for 1 year as an alternative and also consider keeping machine for 2, 3, and 4 years as separate alternatives. Cost of keeping existing machine 1 year: The opportunity cost of not selling it now is $4000. Maintenance is $1000. Salvage value is $2500. 24
Thus, for the present value of costs we have: P V = $4000 + $1000 $2500 = $2696 1.15 1.15
This gives an equivalent annual cost of keeping the machine for 1 year of $3100 since at r = 15% the one year annuity factor is 0.8696. One is better o selling it now, since the EAC of a new machine is $2860. Cost of keeping existing machine two years: The opportunity cost of not selling it now is $4000. Maintenance is $1000 year 1 and $2000 year 2. Salvage value is $1500. Thus, for the present value of costs we have: P V = $4000 + [ $1000 $2000 $1500 + ] = $5248 2 1.15 1.15 1.152
This gives an equivalent annual cost of keeping the machine for 2 years of $3228 since at r = 15% the two year annuity factor is 1.626. One is better o selling it now, since the EAC of a new machine is $2860. Similar calculations show the equivalent annual cost of keeping the existing machine for 3 and 4 years is also in excess of the EAC of buying a new machine. Thus, BICCC is best o buying a new machine immediately. 3. Since the old trucks have 10 years of service left from today, they had an original useful life of 15 years and zero salvage value. cash ow, t = 0: sale of old trucks: salvage = tax shelter = [(10, 000 3000).4]10 = 30,000 28,000 58,000 125,000 67,000
cost of new trucks
cash ows, t = 1, 10: after tax reduction in expenses (10, 000 .6) increase in depreciation tax shield (12500 .4) (10000 .4) = 6,000 1,000 7,000
25
cash ow, t = 10: salvage of new trucks (5 1000) taxes on capital gain ($5000 0.40) 5,000 2,000 3,000
3000 (1.08)10
NPV = 67, 000 + 7000(10 yr annuity discount factor @ 8%) + = 67, 000 + 46970 + 1390 = $18, 640 KEEP OLD TRUCKS 4. cash ow, t = 0: initial investment investment in working capital cash ows, t = 1, 5: after tax net operating cash ows all years (50, 000 30, 000 10, 000).65 Depreciation tax shield t = 1: 0.3333 25, 000 .35 = t = 2: 0.4445 25, 000 .35 = t = 3: 0.1481 25, 000 .35 = t = 4: 0.0741 25, 000 .35 = cash ow, t = 5: recovery of working capital investment = NPV = 30,000 + 6,500 (5 yr annuity discount factor @ 10%) +
2916 (1.10)
25,000 5,000 30,000
6,500 2,916 3,889 1,296 648
5,000
+
3889 (1.10)2
+
1296 (1.10)3
+
648 (1.10)4
+
5000 (1.10)5
= $5, 027
purchase the machine 5. PV of payments to shareholders 5m PV = + 1.12
(5m)(1.25)5 (1.05)(.6) .12.05 (1.12)6
= $74.04 million
$75m is higher than the fair value so the oer is more than fair. 26
6. (a) This procedure is incorrect because the IRR does not take into account the relative scale of mutually exclusive projects. Because of this, a large scale project that may contribute more to rm value will be rejected due to its high initial investment. The proper way to evaluate the projects, if IRR must be used, is to calculate the value of the incremental project (i.e., C = A B), to see if the additional investment necessary for A is worth undertaking. If C is worth undertaking (i.e. IRR > 9%) and B is worth undertaking, then, since A = C + B, A is the project which should be chosen. (b) IRR of the increment: A:
110 solve for IRR: 200 + (1+IRR) + IRR = 10% > 9%; accept A
C0 200
121 (1+IRR)2
C1 110 =0
C2 121
(c) NPVA = 400 + (241)(.9174) + (293)(.8417) = 67.71 NPVB = 200 + (131)(.9174) + (172)(.8417) = 64.9518 A>B 7. PV = C1 1000 $20(1 0.4) $12000 = = = $600, 000 rg 0.10 0.08 0.02
8. The cash ow to a company is the sum of after-tax cash ows from operations plus the cash resulting from depreciation tax shield, i.e., (S OC)(1 ) + DEP. From the data given in the problem the rst component is easily put in real terms. The second must be deated: year 1: year 2: ((2000)(300) (100)(12))(.6) + (.4)(20, 000) = 366, 553 1.10 .4(20, 000) ((2000)(300) (100)(12))(.6) + = 365, 892 (1.10)2
NPV = 40,000 + 366,553 + 365,892 = $692,445 9. Calculate incremental cash ows for new harvester: Time 0 cash ows: (a) Payment to manufacturer = X (b) Sale of old = 25,000 (c) Book value old: 45,000 - 5(3000) = 30,000 Cap. Gain = Market Value Book Value = 25,000 30,000 = 5,000 27
Tax savings = (5,000)(.35) = 1750
Cash Flow Increment years 1 to 10: (S OC)(1 ) + DEP X 3000 = .035X + 5450 = (10, 000)(.65) + .35 10 Salvage values at time 10 (Book values are 0) after tax ow from not selling old after tax ow from selling new incremental ow Set NPV Equal to Zero and Find X:
10
3,250 +6,500 +3,250
X + 25, 000 + 1, 750 +
10 t=1
.035X+5450 (1.15)t 10
+
3250 (1.15)10
=0
X + 26, 750 + 0.035X
t=1
1 (1.15)t
+
t=1
5450 (1.15)t
+ 803 = 0
0.824X + 54, 906 = 0 X = $66, 605 10. (a) Average Return on Book: NI 15 550,000 200,000 350,000 140,000 210,000 NI 610 400,000 200,000 200,000 80,000 120,000
A.R.B. = (b) 4.88 years (c) $132,501.23 (d) 13.71%
(5)(210,000)+5(120,000) 10 10 2,000,000200,000(t) t=0 11
= 16.5%
28
(e) 1.066 11. S.L.D. Year 1 2 3 4 5 6 7 8 7 yrs. 500 500 500 500 500 500 500 3500 PV at 12%: 799 12. (a) NPV = 100, 000 + = 10440 (b) 1 (Inc.NOI)(1 )(1 + )yr +(DEP)( ) 10,500 +10,000 20,500 1.12 2 16,538 +10,000 26,538 (1.12)2 3 23,153 +10,000 33,153 (1.12)3 4 24,310 +10,000 34,310 (1.12)4 5 12,763 +10,000 22,763 (1.12)5
20,000 (1.12)
MACRS T.S. 245 245 245 245 245 7 yrs. 500 857 612 437 313 313 313 155 3500 T.S. 175 300 214 153 110 110 110 54 5 yrs. 700 1120 672 403 403 202 T.S. 245 392 235 141 141 71
T.S. 175 175 175 175 175 175 175
5 yrs. 700 700 700 700 700
3500
3500
883 +
25,000 (1.12)2
834
30,000 (1.123 )
904
+
+
30,000 (1.12)4
+
20,000 (1.12)5
= 100000 + 17860 + 19930 + 21350 + 19070 + 11350 Reject.
NPV = 100, 000 + 18, 304 + 21, 156 + 23, 598 + 21, 805 + 12, 916 = 2, 221 Still reject, but project looks much better than under (a). 13. Use the method of equivalent annual cost (EAC). 29
Find the amount that, if paid in each year (starting in year 1), would have the same present value as the actual stream of costs. Machine A: 40, 000 + 10, 000 10, 000 10, 000 EACA EACA EACA + + = + + 2 3 2 1+r (1 + r) (1 + r) (1 + r) (1 + r) (1 + r)3 r = .12 64, 018 = EACA (2.4018) EACA = 26, 654 Machine B: 50, 000 +
8,000 1+r 8,000 (1+r)2 8,000 (1+r)3 8,000 (1+r)4 EACB 1+r EACB (1+r)2 EACB (1+r)3 EACB (1+r)4
+
+
+
=
+
+
+
r = .12
74, 299 = EACB (3.0373) EACB = 24, 462
Borstal should buy machine B because it has a lower EAC. Note: The PV of the innite stream of costs is: PVA = PVB =
EACA r EACB r 26,654 .12 24,462 .12
= =
= 222, 117 = 203, 850.
30