PLEASE UES EXCEL TO ANSWER THE FOLLOWING QUESTION; PLEASE SHOW EQUATION IN EXCEL

Projects with different lives: You are trying to choose between purchasing one of two machines for a factory. Machine A costs $15,000 to purchase and has a three-year life. Machine B costs $17,700 to purchase but has a four-year life. Regardless of which machine you purchase, it will have to be replaced at the end of its operating life. Which machine would you choose? Assume a marginal tax rate of 35 percent and a discount rate of 15 percent.