Merge $\backslash$& Center $\backslash (\backslash$checkmark $\backslash )$ D$15\backslash ($ f$\_\{$x$\}\backslash )\backslash$begin$\{$tabular$\}\{|$r$|$r$|$r$|\}\backslash$hline $\backslash$multicolumn$\{3\}\{|$c$|\}\{$ DATA INPUTS $\}\backslash \backslash \backslash$hline Annual interest rate $\backslash (=\backslash )$ & U$.$ S$.$ Bank & Wells Fargo $\backslash \backslash \backslash$hline Average value of each payment $\backslash (=\backslash )$ & $\backslash (3\mathrm{.}48\backslash \%\backslash )$ & $\backslash (3\mathrm{.}48\backslash \%\backslash )\backslash \backslash \backslash$hline Average $\backslash$# of payments per day $\backslash (=\backslash )$ & $\backslash (\backslash$$ $5,470\backslash )$ & $\backslash (\backslash$$ $5,470\backslash )\backslash \backslash \backslash$hline Annual fixed charge $\backslash (=\backslash )$ & $78$ & $78\backslash \backslash \backslash$hline Lockbox fee per payment $\backslash (=\backslash )$ & $\backslash (\backslash$$ $28,500\backslash )$ & $\backslash (\backslash$$ $9,750\backslash )\backslash \backslash \backslash$hline & $\backslash (\backslash$$ $0\mathrm{.}39\backslash )$ & $\backslash (\backslash$$ $0\mathrm{.}58\backslash )\backslash \backslash \backslash$hline $\backslash$end$\{$tabular$\}$ ALWAYS USE CELL REFERENCE correct values on your worksheet your calculations. $($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$b$)$ U$.$S Bank $=\backslash (\backslash$square $\backslash )$ Wells Fargo $=\backslash (\backslash$square $\backslash )($b$)$ Which is the Preferred Lockbox System for Global Manufacturing, Inc.? $($U$.$S$.$ Bank or Wells Fargo$)???17($c$)$ How many customers are needed, on average each day, to make each of the lockbox systems break$-$even? $($Round to the nearest whole customer$)($Similar to Problem $27-12)$ U$.$S Bank $=\backslash (\backslash$square $\backslash )\backslash [\backslash$text $\{$ Wells Fargo $\}=\backslash ]\backslash (\backslash$square $\backslash )($d$)$ How much of a reduction in accounts receivable should Global expect from the Preferred Lockbox System if implemented in $2024?($Round to the nearest whole dollar$)\backslash (\backslash$square $\backslash )\backslash (=\backslash )$ Reduction in collection time $\backslash (\backslash$times $\backslash )$ Average value of each payment $\backslash ($ x $\backslash )$ Average number of paymer