1

Solve on Excel please and show steps

Discount rate Tax rate 8% 21% The Two Equipments (10 points) Price Annual costs Machine A Machine B 15,000 50,000 5,000 1,000 3 7 A company needs to buy a new lab equipment. There are two alternatives as given on the left. Both machines produce the same product, and thus, the same annual sales. Life span Which should the company choose? Assume straight-line depreciation to zero salvage value over the life of each machine. 12,000 Annual CF in Yr 1 Sales 12,000 1 Minus COGS 2 Minus depreciation 3 Profit before taxes 4 Subtract taxes 5 Profit after taxes 6 Add back depreciation 7 Cash flow 3 9 Year Machine A 0 1 2 3 4 Machine B