I need to know the formulas and inputs required to solve this in Excel. Please show how to do it in Excel.

4. You have a factory that produces light bulbs. Your old machine is costing a lot of money lately in repairs and you are considering replacing it. You have two offers. You sell each light bulb for $0.40, the discount rate is 12%, and the corporate tax rate 40%. a. Which machine would you prefer to buy if your annual production is 1,000,000 light bulbs? (EAC for A: 39507.92; EAC for B: -846.89.) b. At what level of production will you change your answer? (482631) B 12% 40% 1,000,000 0.40 A 1 Discount rate 2 Corporate tax rate 3 4 Annual production 5 Price of light bulbs 6 7 8 Cost 9 Variable cost per light bulbs 10 Fixed costs 11 Life span Machine A 500,000 0.12 100,000 10 Machine B 200,000 0.25 75,000 4