Only in excel. No hard coded formulas.

E F G K C D BUYING A NEW MACHINE 1 22,500 22,500 34 22,500 22,500 22,500 2 Year 3 Cost savings of workers 4 Depreciation 5 Earnings before taxes 6 Tax (30%) 7 Net operating profit after tax 8 Capital investment 9 Add back depreciation 10 11 Free cash flow -60,000 12 12% 13 Discount rate 14 NPV 15 10,000 5,000 16 Book value at year 5 17 Market value at year 5 18 Capital gains of selling at the fifth year 19 20 21 22 23 24 25 27 28 29 30 31 33 34 35 37 E F G K C D BUYING A NEW MACHINE 1 22,500 22,500 34 22,500 22,500 22,500 2 Year 3 Cost savings of workers 4 Depreciation 5 Earnings before taxes 6 Tax (30%) 7 Net operating profit after tax 8 Capital investment 9 Add back depreciation 10 11 Free cash flow -60,000 12 12% 13 Discount rate 14 NPV 15 10,000 5,000 16 Book value at year 5 17 Market value at year 5 18 Capital gains of selling at the fifth year 19 20 21 22 23 24 25 27 28 29 30 31 33 34 35 37