You are trying to prepare financial statements for Bartlett Pickle Company, but seem to be missing its balance sheet. You have Bartlett's income statement, which shows sales last year were $320 million with a gross profit margin of 50 percent. You also know that credit sales equaled three-quarters of Bartlett's total revenues last year. In addition, Bartlett had a collection period of 50 days, a payables period of 30 days, and an inventory turnover of 5 times based on cost of goods sold. Calculate Bartlett's year-ending balance for accounts receivable, inventory, and accounts payable. Note: Round your answers to 1 decimal place. Bartlett's year-ending balance (million) Accounts receivable Inventory Accounts payable

You are trying to prepare financial statements for Bartlett Pickle Company, but seem to be missing its balance sheet. You have Bartlett's income statement, which shows sales last year were $320 million with a gross profit margin of 50 percent. You also know that credit sales equaled three-quarters of Bartlett's total revenues last year. In addition, Bartlett had a collection period of 50 days, a payables period of 30 days, and an inventory turnover of 5 times based on cost of goods sold. Calculate Bartlett's year-ending balance for accounts receivable, inventory, and accounts payable. Note: Round your answers to 1 decimal place. Bartlett's year-ending balance (million) Accounts receivable Inventory Accounts payable

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter3: Evaluation Of Financial Performance

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The Raattama Corporation had sales of $3.5 million last year, and it earned a 5% return (after taxes) on sales. Recently, the company has fallen behind in its accounts payable. Although its terms of purchase are net 30 days, its accounts payable represents 60 days’ purchases. The company’s treasurer is seeking to increase bank borrowing in order to become current in meeting its trade obligations (that is, to have 30 days’ payables outstanding). The company’s balance sheet is as follows (in thousands of dollars): How much bank financing is needed to eliminate the past-due accounts payable? Assume that the bank will lend the firm the amount calculated in part a. The terms of the loan offered are 8%, simple interest, and the bank uses a 360-day year for the interest calculation. What is the interest charge for 1 month? (Assume there are 30 days in a month.) Now ignore part b and assume that the bank will lend the firm the amount calculated in part a. The terms of the loan are 7.5%, add-on interest, to be repaid in 12 monthly installments. What is the total loan amount? What are the monthly installments? What is the APR of the loan? What is the effective rate of the loan? Would you, as a bank loan officer, make this loan? Why or why not?
The Eagle Machine Company averaged $2 million in inventory last year, and the cost of goods sold was $10 million. Figure shows the breakout of raw materials, work-in-process, and finished goods inventories. The best inventory turnover in the company’s industry is six turns per year. If the company has 52 business weeks per year, how many weeks of supply were held in inventory? What was the inventory turnover? What should the company do?
Last year Delightful Desserts had a quick ratio of 2.2, a current ratio of 5.0, an inventory turnover of 8, total current assets of $285,000, and cash and equivalents of $36,000. If the cost of goods sold equaled 80 percent of sales, what were Bailey's annual sales and days' sales outstanding (DSO)? Assume there are 360 days in a year. Round your answer for annual sales to the nearest dollar and answer for DSO to one decimal place. Annual sales: $ DSO:
Kareem & Sons last year reported sales of 12 million and an inventory turnover ratio of 4. The company is now adopting a new inventory system. If the new system is able to reduce the firm’s inventory level and increase the firm’s inventory turnover ratio to 8 while maintaining the same level of sales, how much cash will be freed up? Medwing Corporation has a DSO of 19 days. The company averages 5,500 in credit sales each day. What is the company’s average accounts receivable? McDowell Industries sells on terms of 4/10, net 40. Total sales for the year are $825,500. Thirty percent of customers pay on the 15th day and take discounts; the other 70% pay, on average, 60 days after their purchases. What is the days sales outstanding? What is the average amount of receivables? What would happen to average receivables if McDowell toughened its collection policy with the result that all non-discount customers paid on the 40th day? International Industries sells on terms of 3/10, net 50.…
Last year, Jumpin' Trampolines (JT) had a quick ratio of 1.0, a current ratio of 1.8, an inventory turnover of 3.5, total current assets of $67,500, and cash and equivalents of $15,000. If the cost of goods sold equaled 70 percent of sales, what were JT's annual sales and DSO?
Last year, Jumpin’ Trampolines (JT) had a quick ratio of 1.0, a current ratio of 1.8, an inventory turnover of 3.5, total current assets of $67,500, and cash and equivalents of $15,000. If the cost of goods sold equaled 70 percent of sales, what were JT’s annual sales and DSO? Please answer vertically
a) Kareem & Sons last year reported sales of 12 million and an inventory turnover ratio of 4. The company is now adopting a new inventory system. If the new system is able to reduce the firm’s inventory level and increase the firm’s inventory turnover ratio to 8 while maintaining the same level of sales, how much cash will be freed up?b) Medwing Corporation has a DSO of 19 days. The company averages 5,500 in credit sales each day. What is the company’s average accounts receivable?c) McDowell Industries sells on terms of 4/10, net 40. Total sales for the year are $825,500. Thirty percent of customers pay on the 15th day and take discounts; the other 70% pay, on average, 60 days after their purchases.a. What is the days sales outstanding?b. What is the average amount of receivables?c. What would happen to average receivables if McDowell toughened its collection policy with the result that all non-discount customers paid on the 40th day?d) International Industries sells on terms of…
a) Kareem & Sons last year reported sales of 12 million and an inventory turnover ratio of 4. The company is now adopting a new inventory system. If the new system is able to reduce the firm’s inventory level and increase the firm’s inventory turnover ratio to 8 while maintaining the same level of sales, how much cash will be freed up? b) Medwing Corporation has a DSO of 19 days. The company averages 5,500 in credit sales each day. What is the company’s average accounts receivable? c) McDowell Industries sells on terms of 4/10, net 40. Total sales for the year are $825,500. Thirty percent of customers pay on the 15th day and take discounts; the other 70% pay, on average, 60 days after their purchases.a. What is the days sales outstanding?b. What is the average amount of receivables?c. What would happen to average receivables if McDowell toughened its collection policy with the result that all non-discount customers paid on the 40th day? Solve only B and C sub parts.
Mareez Pharma is trying to determine the effect of its inventory and receivable turnover ratios on its cash flow cycle. Mareez Pharma sales last year (all on credit) were $ 5,000,000, and its net profit was 10%. Its inventory turnover was 6.0 times during the year, and its average collection period was 40 days. Its annual cost of goods sold was $3,800,000. The firm had fixed assets totaling $1,500,000. Mareez Pharma payables deferral period is 50 days. Required: Calculate Mareez Pharma cash conversion cycle. Assuming Mareez Pharma holds negligible amounts of cash and marketable securities, calculate its total assets turnover and ROA. Suppose you have been recently hired by Mareez Pharma as CFO. Your finance manager who was expecting to be promoted as CFO has recommended you that it is possible to change annual inventory turnover to 9.5 times without affecting the sales. You know that management is keenly watching: cash conversion cycle, total assets turnover and ROA as your KPI.…
Libscomb Technologies' annual sales are $6,974,991 and all sales are made on credit, it purchases $3,511,535 of materials each year (and this is its cost of goods sold). Libscomb also has $550,869 of inventory, $522,928 of accounts receivable, and $477,584 of accounts payable. Assume a 365 day year. What is Libscomb’s Inventory Turnover?
The FMT Corporation is trying to determine the effect of its inventory turnover ratio and days salesoutstanding (DSO) on its cash flow cycle. FMT sales last year (all on credit) were ₱150,000, and it earneda net profit of 6%, or ₱9,000. It turned over its inventory 5 times during the year, and its DSO was 36.5days. The firm had fixed assets totalling ₱35,000. FMT payables deferral period is 40 days.a. Calculate FMT’s cash conversion cycle.b. Assuming FMT holds negligible amounts of cash and marketable securities, calculate its totalassets turnover and ROA.c. Suppose FMT Corp managers believe that the inventory turnover can be raised to 7.3 times.What would FMT’s cash conversion cycle, total assets turnover, and ROA have been if theinventory turnover had been 7.3 for the year?
A company has total annual sales (all credit) of $400,000 and a gross profit margin of 20 percent. Its current assets are $80,000; current liabilities, $60,000; inventories, $30,000; and cash, $10,000. a. How much average inventory should be carried if management wants the inventory turnover to be 4? b. How rapidly (in how many days) must accounts receivable be collected if management wants to have an average of $50,000 invested in receivables? (Assume a 360-day year.)