Question

. The new equipment will have a cost of $9,000,000, and it will be depreciated on a straight-line basis over a period of six years (years 1-6) The old machine is also being depreciated on a straight-line basis. It has a book value or 200,000 (at year 0) and four more years of depreciation left ($50,000 per year). . The new equipment will have a salvage value of $0 at the end of the project's life (year 6). The old machine has a current salvage value (at year 0) of $300,000. . Replacing the old machine will require an investment in net operating working capital (NOWC) of $20,000 that will be recovered at the end of the project's life (year 6). . The new machine is more efficient, so the firm's incremental earnings before interest and taxes (EBIT) will increase by a total of $700,000 in each of the next six years (years 1-6). Hint: This value represents the difference between the revenues and operating costs (including depreciation expense) generated using the new equipment and that earned using the old equipment. The project's cost of capital is 13%. The company's annual tax rate is 40%. Complete the following table and compute the incremental cash flows associated with the replacement of the old equipment with the new equipment. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Initial EBIT - Taxes +New - Old +Salvage value - Tax on salvage - NOWC of NOWC Total free cash flow $1,920,000 The net present value (NPV) of this replacement project is: O -$1,407,395 O -$1,040,249 O-$1,223,822 O -$917,866

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home ert Page Layout Formulas Data Review V Add-Ins Cut Σ AutoSum , ta copy." paste В า 프. m. a-Δ. Ξミ 迣锂函Merge & Center. $, % , 弼皛Conditional Format. Cell. Insert Delete Format Sort &Find & Filter Select Format Painter 袖 Formatting ▼ as Table-styles ▼ 2 Clear , ▼ ▼ ▼ Clipboard Font Alignment dting BY107 BO BT BU BW BX BY BZ CA 90 0 4 6 92 93 LESS 94 ADD 95 LESS 96 ADD 97 LESS 98 LESS 99 ADD 100 A 101 B 102 A B 103 104 105 106 107 108 INITIAL INVESTMENT EBIT TAXES NEW DEPRECIATION (9000000/6) OLD DEPRECIATION SALVAGE VALUE TAX ON SALVAGE NWC RECAPTURE OF NWC TOTAL NET CASH FLOW PV FACTOR @ 13% PV OF CFAT 700000 80000 1500000 700000 280000 1500000 50000 700000 280000 1500000 1500000 700000 700000 280000 1500000 700000 280000 00000 80000 -2 15 40000 20000 1920000 0.5428 20000 1940000 0.4803 -8760000 1870000 1870000 1870000 1870000 0.8850 0.7831 0.6931 0.6133 -8760000 1654867.26 1464484.0 1296003.80 1146906.02 1042099.08 931817.94 -1223822 NPV NPV = 1223822 NOTE TAX ON SALVAGE VALUE SALVAGE VALUE BOOK VALUE PROFIT ON SALE TAX IS ON 100000 X 4096-40000 300000-200000 100000 トト IRRnpv RATION PBP ARR extem al ate MIRR NPV IRR REPLACEMENTS HpR GMAM EAC MACRS LEASE RATIOCASHBUDGET wacc BOND indiffEPS EBIT REPLACEMENT . - 30-03-2019