Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

LOCKBOX ANALYSIS OF ACCOUNTS RECEIVABLE INSTRUCTIONS FOR EVALUATION OF A LOCKBOX SYSTEM: Global Manufacturing is considering using a lockbox system to speed up collections

image text in transcribed

LOCKBOX ANALYSIS OF ACCOUNTS RECEIVABLE INSTRUCTIONS FOR EVALUATION OF A LOCKBOX SYSTEM: Global Manufacturing is considering using a lockbox system to speed up collections of accounts receivable from its customers in the new year. They have two Lockbox proposals to consider: one from U.S. Bank, and one from Well Fargo Bank. The information you will need to evaluate each bank's proposal is presented on this worksheet. HELP: Also see the file named "09-SAMPLE COMPANY LOCKBOX ANALYSIS OF ACCOUNTS RECEIVABLES.pdf" provided to help you setup your spreadsheet for these LOCKBOX calculations. Annual interest rate (T-Bill rate) = Average value of each payment = Average # of payments per day = Annual fixed charge = Lockbox fee per payment =|| Reduction in collection time (# days) =|| DATA INPUTS U. S. Bank Wells Fargo 13.54% $4,215 52 13.54% ALWAYS USE CELL REFERENCES to the correct values on your worksheets to do your calculations. $4,215 52 $8,500 $0.41 $35,700 $0.22 NOTE: Cells shaded in YELLOW are the cells you must provide the calculations or analysis. 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 Practice Problem 27-11. Part b. U.S Bank= Wells Fargo = $314,312 $580,180 (b) What will be the annual net savings? Assume that the Annual interest rate (T-bill rate) is 13.54 percent annually. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.) Similar to Practice Problem 27-10. U.S Bank= Wells Fargo = $0 $0 (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 Practice Problem 27-12. U.S Bank = Wells Fargo = (d) Which is the Preferred Lockbox System for Global Manufacturing, Inc.? 0 0 U.S Bank or Wells Fargo (e) What is the reduction in accounts receivable balance as a result of implementing the Preferred Lockbox System in 2024? (Round to the nearest whole dollar) $0 = Reduction in collection time (Preferred System) X Average value of each payment x Average number of payments per day I Daily Interest Rate U.S. Bank 0.03480% Wells Fargo 0.03480% PV (Cash Inflow) PV (Transaction cost) $ 61,270.59 $ 32,876.90 NPV (without annual fixed charge ######## # PV(Annual fixed charge) $62,776.96 ###### # NPV (With annual fixed charg $ 314,312 $ 580,180

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Thomas Garman, Raymond Forgue

12th edition

9781305176409, 1133595839, 1305176405, 978-1133595830

More Books

Students also viewed these Finance questions

Question

Define rapport as it relates to a clinical interview.

Answered: 1 week ago

Question

Work individually with a faculty member

Answered: 1 week ago