To determine: The cash conversion cycle, the new cash conversion cycle, the amount of cash that would be freed up and the effect on pretax profits.
Introduction:
Cash Conversion Cycle:
The cash conversion cycle refers to the time period which starts from the production of the products to selling of the products and lasts until the time the customer receives the cash.
Explanation of Solution
Given information:
The amount of sales is $12 million.
The amount of inventories is $3 million.
The amount of receivables is $3.25 million.
The amount of payables is $1.25 million.
Cost of goods sold is 75% of sales.
The rate of interest on bank loans is 8%.
Calculation of the cash conversion cycle:
The formula to calculate the cash conversion cycle is,
Substitute 60.83 days for inventory conversion period, 73 days for the average collection period and 30.41 days for the payables deferral period (refer working note) in the above formula.
The cash conversion cycle is 169.83 days or 170 days.
Now,
The inventories are reduced by 10%.
The receivables are reduced by 10%.
The payables are increased by 10%.
Calculation of the new cash conversion cycle:
The formula to calculate the cash conversion cycle is,
Substitute 109.5 days for inventory conversion period, 88.97 days for the average collection period and 55.76 days for the payables deferral period (refer working note) in the above formula.
The new cash conversion cycle is 143 days.
Calculation of the total amount of cash freed up:
The formula to calculate the total amount of cash freed up is,
Substitute $300,082.14 for cash freed up for inventory, $324,821.89 for cash freed up for accounts receivable and (-$125,013.68) for cash freed up for accounts payable (refer working note) in the above formula.
The total cash freed up is $499,890.35.
Calculation of the pre-tax profit:
The formula to calculate the pre-tax profit is,
Substitute $499,890.35 for the total cash freed up and 8% for the interest rate in the above formula.
The pre-tax profit is $39,991.228.
Working note:
Calculation of the cost of goods sold:
The cost of goods sold is $9,000,000.
Calculation of the inventory conversion period:
The inventory conversion period is 121.67 days.
Calculation of the average collection period:
The average collection period is 98.85 days.
Calculation of the payable deferral period:
The payment deferral period is 50.69 days.
Calculation of the new amount of inventories:
The new amount of inventories is $2,700,000.
Calculation of the new amount of receivables:
The new amount of receivables is $2,925,000.
Calculation of the new amount of payables:
The amount of new payables is $1,375,000.
Calculation of the new inventory conversion period:
The inventory conversion period is 109.5 days.
Calculation of the average collection period:
The average collection period is 88.97 days.
Calculation of the payable deferral period:
The payment deferral period is 55.76 days.
Calculation of the cash freed up for inventory:
The cash freed up for inventory is $300,082.14.
Calculation of the cash freed up for accounts receivable:
The cash freed up for accounts receivables is $324,821.89.
Calculation of the cash freed up for accounts payable is:
The cash freed up for accounts payable is ($125,013.68).
Thus, the cash conversion cycle is 170 days, the new cash conversion cycle is 143 days, the total cash freed up is $499,890.35 and the pre-tax profit is $39,991.228.
Want to see more full solutions like this?
Chapter 15 Solutions
Fundamentals Of Financial Management, Concise Edition (mindtap Course List)
- Calculate the Operating Cash for this Firm:A new firm, GASFORALL, Co expects to generate Sales of $117,700. GASFORALL has variable costs of $74,800, and fixed costs of $15,300. The per-year depreciation is $3,850 and the tax rate is 35 percent. Given this info: What is the annual operating cash flow?arrow_forwardProblem The Sandbox's Company has cash needs of P5 million per month. If Sandbox needs more cash, it can sell marketable securities, incurring a fee of P300 for each transaction. If Sandbox leaves its funds in marketable securities, it expects to earn approximately 0.50% per month on their investment. 1. Using the Baumol model, what level of cash infusion minimizes Sandbox’s costs associated with cash? Use a number, no decimal value no currency, no space, no commas. * 2. If Sandbox gets a cash infusion of P1 million each time it needs cash, what are the total costs per month associated its cash infusions? Use a number, no decimal value no currency, no space, no commas * please answer all questions. Thanks!arrow_forwardAztec Products wishes to evaluate its cash conversion cycle (CCC). Research by one of the firm’s financial analysts indicates that on average the firm holds items in inventory for 65 days, pays its suppliers 35 days after purchase, and collects its receivables after 55 days. The firm’s annual sales (all on credit) are about R2.1 billion, its cost of goods sold represent about 67 percent of sales, and purchases represent about 40 percent of cost of goods sold. Assume a 365-day year. What is Aztec Products’ cash conversion (CCC)? If Aztec could shorten its CCC by 5 days, would it be best to reduce the inventory holding period, reduce the receivable collection period, or extend the accounts payable period? Why? How should the firm manage its inventory, accounts receivable, and accounts payable in order to reduce the length of its cash conversion cycle?arrow_forward
- XYZ Stadium Inc. has annual sales of P80,000,000 and keeps average inventory of P20,000,000. On average, the firm has accounts receivable of P16 ,000,000. The firm buys all raw materials on credit, its trade credit terms are net 35 days, and it pays on time. The firm’s managers are searching for ways to shorten the cash conversion cycle. If sales can be maintained at existing levels but inventory can be lowered by P4,000,000 and accounts receivable lowered by P2,000,000, what will be the net change in the cash conversion cycle? Use a 365-day year. Round to the closest whole day. A firm has an average age of inventory of 60 days, an average collection period of 45 days, and an average payment period of 30 days. The firm’s cash conversion cycle is A firm has a cash conversion cycle of 120 days, an average collection period of 25 days, and an average payment period of 50 days. The firm’s average age of inventory is A firm purchased raw materials on account and paid for them within…arrow_forwardC. Exodus Corp. is analyzing the performance of its cash management. On the average, the firm holds inventory 65 days, pays its suppliers in 35 days, and collects its receivables in 15 days. The firm has a current annual outlay of P1,960,000 on operating cycle investments. Exodus currently pays 10 percent for its negotiated financing. (Assume a 360-day year.) Calculate the following: a. Cash conversion cycle b. Operating cycle. c. Daily expenditure and the firm's annual savings if the operating cycle is reduced by 15 days.arrow_forwardmekmek Corporation uses the Baumol Cash Model to determine its optimal cash balance. For the coming year, the expected cash disbursement total to P432,000. The interest rate on marketable securities is P8 per transaction. Using 5% carrying cost rate, what is the optimal cash balance of the company? A. 1,175.76 B. 5,878.78 C. 11,757.55 D. 142,000arrow_forward
- Your consulting firm was recently hired to improve the performance of RP Inc, which is highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis. you want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? Average inventory Annual sales Annual cost of goods seld Average accounts receivable Average accunts payable P5.000 P00.000 PH0,000 P0,000 F5000 140.6 days 120.6 days 133.6 days 148.0 days O 126.9 daysarrow_forwardWatkins Resources faces a smooth annual demand for cash of $1.66 million, incurs transaction costs of $69 every time the firm sells marketable securities, and can earn 3.1 percent on its marketable securities. What will be its optimal cash replenishment level? (Enter your answer in dollars not in millions. Round your answer to 2 decimal places.) Optimal casharrow_forwardPROBLEM Buccaneer, Inc., has determined that it needs $10 million in cash per week. If Buccaneer needs additional cash, it can sell marketable securities, incurring a fee of $100 for each transaction. If Buccaneer leaves funds in its marketable securities, it expects to earn approximately 0.2% per week on their investment. 1. How much is the weekly opportunity cost of cash? (Use a number, must be in decimal form. eg. 6.3%/100, encode 0.063 , no commas, no currency, no space) * 2. How much is the total demand for cash per week? (Use a number, no decimal value, no commas, no currency, no space) * 3. How much is the cost per transaction? (Use a number, no decimal value, no commas, no currency, no space) * 4. Using the Baumol Model, how much cash should Buccaneer raise from selling securities each week to minimize its costs of cash? (Use a number, no decimal value, no commas, no currency, no space) * PLEASE ANSWER ALL QUESTIONS. THANK YOUarrow_forward
- A corporation has $344 million in sales,$232 million in COGS, $53 million in inventory, $128 million in accounts receivables, and $93 million in accounts payable. The firm borrows at 8% compounded daily to finance its NOWC. How much will the firm have to pay in interest for the year due to the Cash Conversion Cycle? Hint: take the COGS and calculate how much it grows over one cash conversion cycle (in days) with a daily interest rate that you calculate from APR. Answer in millions of dollars. Make sure you have 3 or 4 significant digits (ie. if the the answer is $6789,012 million, your answer should be 6,789) You Answered 235.7 Correct Answer 3.735 margin of error +/- 2%arrow_forwardThe Sandbox's Company has cash needs of P5 million per month. If Sandbox needs more cash, it can sell marketable securities, incurring a fee of P300 for each transaction. If Sandbox leaves its funds in marketable securities, it expects to earn approximately 0.50% per month on their investment. 1. Using the Baumol model, how much would be the Sandbox’s minimum total costs associated with cash infusion? 2. If Sandbox gets a cash infusion of P1 million each time it needs cash, what are the holding costs associated with its cash investment? 3. Using the Baumol model, what level of cash infusion minimizes Sandbox’s costs associated with cash?arrow_forward1. Ashwell Corp has $1,700,000 of sales, $250,000 of inventories, $175,000 of receivables, and $125,000 of payables. Its cost of goods sold is 70% of sales. What is Ashwell’s cash conversion cycle? 2. If current assets are $133,000 and current liabilities are $107,500, what is working capital?arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education