using the Annual Equivalent Worth, what is the AEW for all 3 companies?

must use excel. show work/equations

Nike is looking to produce on of 3 different shoe options. It is your job to decide which shoe to manufacture. The shoe's information is listed below. Nike Zoom Nike Crossfits Nike Cartwrights 300,000 42,000 Initial Cost 250,000 30,000 100,000 14,000 Profit per year 12 15 18 10% 10% 10% Project life MARR Salvage Value What value will you use to compare each item? 10,000 0 5,000 ONPV AEW Project Life Initial Price