I need help with the excel formulas to get the right answers for these.I have referred back to my notes and I am stuck.

Wells Fargo PNC Bank 3.02% 3.02% $4,578 $4,578 51 51 Rate on money market investments Average Customer payment Average number of payments per day Annual fee Cost per transaction Reduction in collection time $17,850 $8,500 $0.54) $0.35 NOTE: Cells shaded in YELLOW are the cells you must provide the calculations or analysis. Wells Fargo PNC Bank $0 $0 The questions that the CEO needs you to answer are as follows: (a) What is the Net Present Value (NPV) of each of the new lockbox system proposals (including the annual fixed charge) ? (Round to the nearest whole dollar) (Similar to Problem 27-11 Part (b)) (b) How many average payments per day are needed to make each of the lockbox systems break-even? (Round to the nearest whole customer) (Similar to Problem 27-12 using GOAL SEEK function) 0 01 (c) Which is the Preferred Lockbox System for Global Manufacturing, Inc.? (Wells Fargo or PNC Bank) Wells Fargo or PNC Bank? (d) How much of a reduction in accounts receivable should Global expect from the Preferred Lockbox System if implemented in 2021? (Round to the nearest whole dollar) This value will automatica $466,956 Accounts Receivable" valu CORRECTIONS workshee