You have been asked by the president of the Farr Construction Company to

Problem 2

evaluate the proposed acquisition of a new earth mover. The mover?s basic price is $200,000, and it would cost another $30,000 to modify itfor special use. Assume that the mover falls into the MACRS 5 year class, it would be sold after 4years for $60,000, and it would require an increase in net operating workingcapital (spare parts inventory) of $10,000. The earth mover would have no effecton revenues, but it is expected to save the firm $50,000 per year in befor-taxoperating costs, mainly labor. The firm?s marginal federal-plus-state tax rate is 40percent and the project?s cost of capital is 10 percent. Evaluate the project using the NPV rule and the IRR rule

Problem 1 - Evaluating a New Project Year 0 Project- 5 Year Life Building Purchase Equipment Purchase Total Initial Investment $ Year 1 Year 2 Year 3 Year 4 Year 5 (20,000,000) (10,000,000) (30,000,000) Unit Sales Price per Unit Total Sales $ Variable Cost per Unit Total Variable Costs $ Total Fixed Costs 30,000 30,000 30,000 30,000 30,000 6,000 $ 6,120 $ 6,242 $ 6,367 $ 6,495 180,000,000 183,600,000 187,272,000 191,017,440 194,837,789 (4,000) $ (4,080) $ (4,162) $ (4,245) $ (4,245) (120,000,000) (122,400,000) (124,848,000) (127,344,960) (127,344,960) (20,000,000) Depreciation Rate (39 Year) Building Depreciation Depreciation Rate (5 Year) Equipment Depreciation Total Depreciation Costs $ Earnings Before Income Tax (EBIT) $ Tax Rate Total Taxes (20,402,000) (20,606,020) (20,812,080) 1.30% (260,000) 20.00% (2,000,000) $ (2,260,000) 2.60% (520,000) 32.00% (3,200,000) $ (3,720,000) 2.60% (520,000) 19.00% (1,900,000) $ (2,420,000) 2.60% (520,000) 12.00% (1,200,000) $ (1,720,000) 2.60% (520,000) 11.00% (1,100,000) (1,620,000) 37,740,000 $ 37,280,000 $ 39,602,000 $ 41,346,460 $ 45,060,749 40% (15,096,000) Net Operating Profits (NOPAT) (20,200,000) 40% (14,912,000) 40% (15,840,800) 40% (16,538,584) 40% (18,024,299) $ 22,644,000 $ 22,368,000 $ 23,761,200 $ 24,807,876 $ 27,036,449 $ 2,260,000 $ 24,904,000 $ 3,720,000 $ 26,088,000 $ 2,420,000 $ 26,181,200 $ 1,720,000 $ 26,527,876 $ 1,620,000 28,656,449 NOWC Percentage Required 10% 10% 10% 10% 10% Net Operating Working Capital $ 18,000,000.00 $18,360,000.00 $18,727,200.00 $19,101,744.00 $19,483,778.88 $ Increase in NOWC ### $ (360,000) $ (367,200) $ (374,544) $ (382,035) $ 10% 19,483,779 Add Back Depreciation Operating Cash Flow Total Annual Project Cash Flow $ (18,000,000) $ 24,544,000 $ 25,720,800 $ 25,806,656 $ 26,145,841 $ 48,140,228 Terminal Year Cash Flow Building Sale (MV) Less: Book Value of Building Profit on Sale Tax on Loss (40%) Net Salvage Value on Building 10,000,000 (27,660,000) $ (17,660,000) 7,064,000 $ 2,936,000 Equipment Sale (MV) Less: Book Value of Equipment Profit on Sale Tax on Profit (40%) Net Salvage Value on Equipment $ $ 2,000,000 (600,000) 1,400,000 560,000 1,440,000 Total Net Salvage Value $ 4,376,000 521,841 $ 22,516,228 Free Cash Flow $ Required Rate of Return (WACC) NPV $ (43,624,000) $ 12.00% (31,273,154) (1,080,000) $ 96,800 $ 182,656 $ IRR -12.37% Problem 2 - Evaluating a Cost Saving Project Year 0 Acquisition - 5 Year Life Earth Mover Installation Costs Total Initial Investment $ Year 1 Year 2 Year 3 Year 4 (200,000) (30,000) (230,000) Savings in Costs $ 50,000 $ 50,000 $ 50,000 $ 50,000 Depreciation Rate (5 Year) Total Depreciation Costs $ 20.00% (46,000) $ 32.00% (73,600) $ 19.00% (43,700) $ 12.00% (27,600) Earnings Before Income Tax (EBIT) $ 96,000 $ (23,600) $ 93,700 $ 77,600 Tax Rate Total Taxes $ 40.00% 38,400 $ 40.00% (9,440) $ 40.00% 37,480 $ 40.00% 31,040 Net Operating Profits (NOPAT) $ 57,600 $ (14,160) $ 56,220 $ 46,560 Add Back Depreciation Operating Cash Flow $ $ 46,000 $ 103,600 $ 73,600 $ 59,440 $ 43,700 $ 99,920 $ 27,600 74,160 10,000 - 10,000 - 10,000 10,000 59,440 $ 99,920 $ 84,160 $ $ 60,000 (39,100) 20,900 8,360 51,640 (78,440) $ (94,200) Net Operating Working Capital Increase in NOWC 10,000 (100,000) Total Annual Project Cash Flow $ (10,000) $ ### 103,600 $ Terminal Year Cash Flow Machine Sale Less: Book Value of Machine Profit on Sale Tax on Profit (40%) Net Salvage Value on Equipment Free Cash Flow $ (188,360) $ Required Rate of Return (WACC) ?? NPV $ IRR (477,878) Err:523 (74,760) $ (118,920) $ Problem 3 - Evaluating a Replacement Project Year 0 Year 1 Year 2 Year 3 Year 4 Acquisition - 5 Year Life New Machinery ?? Sale - Old Machine ?? Total Initial Investment ?? New Sales Old Sales Change in Sales ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? New Costs Old Costs Change in Costs ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? New Depreciation Old Depreciation Change in Depreciation ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? Earnings Before Income Tax (EBIT) ?? ?? ?? ?? Tax Rate Total Taxes ?? ?? ?? ?? Net Operating Profits (NOPAT) ?? ?? ?? ?? Add Back Depreciation Operating Cash Flow ?? ?? ?? ?? ?? ?? ?? ?? Net Operating Working Capital ?? Increase in NOWC ?? ?? ?? ?? ?? ?? ?? ?? ?? Total Annual Project Cash Flow ?? ?? ?? ?? ?? ?? ?? ?? ?? Free Cash Flow 40.00% ?? Required Rate of Return (WACC) ?? NPV ?? IRR ?? 40.00% 40.00% 40.00% NOT NEEDED NOT NEEDED NOT NEEDED NOT NEEDED