Question
(Activity ratios) The following financial information is for Ambroise Industries Inc.: 2020 2019 Sales $5,221,000 $4,173,000 Cost of goods sold 2,558,290 2,044,770 Accounts receivable 611,000
(Activity ratios) The following financial information is for Ambroise Industries Inc.:
2020 | 2019 | |||
---|---|---|---|---|
Sales | $5,221,000 | $4,173,000 | ||
Cost of goods sold | 2,558,290 | 2,044,770 | ||
Accounts receivable | 611,000 | 554,000 | ||
Inventory | 712,380 | 762,140 | ||
Accounts payable | 195,930 | 209,430 | ||
Total assets | 1,837,660 | 1,657,920 |
Ambroise is a distributor of auto parts operating in eastern Ontario that offers 30-day terms and has all sales on credit. The company has a large inventory due to the number of parts it stocks for different makes and models of cars. Most of its suppliers offer terms of 30 days, and Ambroise tries to stay on good terms with its suppliers by paying on time.
a) What is the average time it takes Ambroise to collect its accounts receivable? (Round answer to 1 decimal place, e.g. 18.4. Round intermediate calculations to 2 decimal places.)
Average collection period | Enter a number of days rounded to 1 decimal place. days |
b) What is the average length of time that it takes Ambroise to sell through its inventory? (Round answer to 1 decimal place, e.g. 18.4. Round intermediate calculations to 2 decimal places.)
Days to sell inventory | Enter a number of days rounded to 1 decimal place. days |
c) What is the average length of time that it takes Ambroise to pay its payables? (Round answer to 1 decimal place, e.g. 18.4. Round intermediate calculations to 2 decimal places.)
Accounts payable payment period | Enter a number of days rounded to 1 decimal place. days |
d) The cash-to-cash cycle is the length of time from when a company purchases an item of inventory to when it collects cash from its sale, reduced by the days it takes to pay the related accounts payable. How long is Ambroises cash-to-cash cycle? (Round answer to 1 decimal place, e.g. 18.4.)
Ambroses cash-to-cash cycle | Enter a number of days rounded to 1 decimal place. days |
e) Assume that Ambroise finances its inventory with a working capital loan from the bank. If Ambroise could improve its inventory management system and reduce the days to sell inventory to an average of 50 days, how much lower would the companys bank loan be? (Round answer to 0 decimal places, e.g. 45,482.)
Companys bank loan would be | $Enter a dollar amount rounded to 0 decimal places. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started