Working Capital Math Problems with Computations
Complete math problems show work.
Working Capital Exercise (Show your work)
1. Houston Corporation has an inventory conversion period of 60 days (DII), a receivables collection period of 36 days (DSO), and a payable deferral period of 24 days (DPO)
a. What is the length of the company’s cash conversion cycle? (6 pts)
b. If Houston’s annual sales are $3,960,000 and all sales are on credit, what is the average balance in accounts receivable? (6 pts)
c. How many times per year does Houston turn over its inventory? (6 pts)
d. What would happen to Houston’s cash conversion cycle if, on average, inventories could be turned over eight times a year? (7 pts)
2. Webber Corporation carries an amount of receivables equal to $80,000, and its annual credit sales equal $2.4 million. What is the receivables collection period (DSO)? (25 pts)
3. Cleary Enterprises owes its suppliers $180,000. The company’s cost of goods sold averages $2.52 million per year. What is Cleary’s payables deferral period (DPO)? (25 pts)
4. Willowman Furniture Company has inventory that equals $48 million. If the inventory turnover for the company is 8, what is the inventory conversion period? (25 pts)
Name Course Instructor Date
Working Capital Exercise (Show your work)
1 Houston Corporation has an inventory conversion period of 60 days (DII), a receivables collection period of 36 days (DSO), and a payable deferral period of 24 days (DPO).
1 What is the length of the company’s cash conversion cycle? (6 pts)
Cash Conversion Cycle = Days Inventory Outstanding+ Days Sales Outstanding (receivables collection period)- Days Payable (payable deferral period)
Cash Conversion Cycle = DII + DSO – DPO 60+36-24= 72 days
2 If Houston’s annual sales are $3,960,000 and all sales are on credit, what is the average balance in accounts receivable? (6 pts)
DSO= Average accounts receivables/ Total credit sales * number of days
36 days= Average accounts receivables/ $3,960,000 * number of days
Average balance in accounts receivable ($3,960,000*36)/ 360 days = $396,000
3 How many times per year does Houston turn over its inventory? (6 pts)
Inventory turnover =Cost of goods sold (COGS) / average inventory OR sales/ average Inventory
Cost of goods sold (COGS)= beginning inventory+ purchases- ending inventory
Inventory conversion period= Average inventory/ COGS * 360
Inventory conversion period 60= (Average inventory/ $3,960,000)*360
Average inventory= ($3,960,000*60)/ 360 = $ 660,000
Inventory turnover =$3,960,000/ $ 660,000= 6 times
4 What would happen to Houston’s cash conversion cycle if, on average, inventories could be turned over eight times a year? (7 pts)
Inventory turnover =Cost of goods sold (C...
👀 Other Visitors are Viewing These APA Math Problem Samples:
- Confidence interval. Mathematics & Economics Math Problem6 pages/≈1650 words | APA | Mathematics & Economics | Math Problem |
- MAT101 SLP4 Answer Template10 pages/≈2750 words | No Sources | APA | Mathematics & Economics | Math Problem |
- Formulate Design of Experiments and ANOVA31 pages/≈8525 words | 4 Sources | APA | Mathematics & Economics | Math Problem |
- Hypothesis Testing and Type Errors Module 5 Case10 pages/≈2750 words | No Sources | APA | Mathematics & Economics | Math Problem |
- Economics Math: Correlations / Linear & Multiple Regression2 pages/≈550 words | 2 Sources | APA | Mathematics & Economics | Math Problem |
- Trident University Case10 pages/≈2750 words | No Sources | APA | Mathematics & Economics | Math Problem |
- Managerial Economics: MBA 540 Mid-term Exam3 pages/≈825 words | APA | Mathematics & Economics | Math Problem |