Ideally, show how to answer this using excel functions. Thanks!

Problem 7. ABC Drinks purchases its 355 ml cans in large bulk from Wald-China Can Corporation. The finish on the anodized aluminum surface is produced by mechanical finishing technology called brushing or bead blasting. Engineers at Wald are switching to more efficient, faster, and cheaper machines to supply ABC. Use the estimates and MARR = 8% per year to select between two alternatives. Brush alternative: P= $-400,000; n= 10 years; S = $50,000; nonlabor AOC = $-60,000 in year 1, decreasing by $5000 annually starting in year 2. Bead blasting alternative: P= $-400,000; nis large, assume permanent; no salvage; nonlabor AOC = $-70,000 per year