Question

Sales (all credit): $6,000,000; Cost of Goods Sold: 80% of Sales; Accounts receivable: $350,000; Inventory: $600,000;...

Sales (all credit): $6,000,000; Cost of Goods Sold: 80% of Sales; Accounts receivable: $350,000; Inventory: $600,000; Accounts payable: $150,000 What is the expected working capital financing requirement based on the working capital cycle? Use 1 year = 365 days

$736,438

$756,164

$604,932

$920,548
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

The correct answer is last option $ 920,548

Credit Sales, S = $ 6,000,000

Cost of goods sold, COGS = 80% x S = 80% x 6,000,000 = $ 4,800,000

Accounts receivable, AR = $ 350,000; Inventory, I = $ 600,000; Accounts payable, AP = $ 150,000; Use 1 year = 365 days

Days in receivables = AR / S x 365 = 350,000 / 6,000,000 x 365 =  21 days

Inventory days = I / COGS x 365 = 600,000 / 4,800,000 x 365 =  46 days

Days to payment = AP / COGS x 365 = 150,000 / 4,800,000 x 365 = 11 days

Hence, working capital cycle in days = Days in receivables + Inventory days - Days to payment = 21 + 46 - 11 = 56 days

Hence, the expected working capital financing requirement based on the working capital cycle = 56 days of sales = 56 / 365 x S = 56 / 365 x 6,000,000 = $ 920,548

Hence, the correct answer is last option $ 920,548.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A company has inventory balance of $26,169, accounts receivable of $10,432, and accounts payable of $15,226....
A company has inventory balance of $26,169, accounts receivable of $10,432, and accounts payable of $15,226. If the credit sales are $194,874 and cost of goods sold are $139,527, what is the company's cash (conversion) cycle in number of days? (Use ending balances and assume 365 days in a year.) Options: 36.84 37.84 38.84 39.83 40.83
A company has inventory balance of $22,467, accounts receivable of $8,842, and accounts payable of $13,504....
A company has inventory balance of $22,467, accounts receivable of $8,842, and accounts payable of $13,504. If the credit sales are $171,186 and cost of goods sold are $118,377, what is the company's cash (conversion) cycle in number of days? (Use ending balances and assume 365 days in a year.) a) 41.64 b)40.60 c) 44.76 d) 42.68 e)43.72
Suppose that LilyMac Photography has annual sales of $323,000, cost of goods sold of $163,000, average...
Suppose that LilyMac Photography has annual sales of $323,000, cost of goods sold of $163,000, average inventories of $4,300, and average accounts receivable of $24,800. Assume that all of LilyMac’s sales are on credit. What will be the firm’s operating cycle? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places.)   Operating cycle days  
Zipper Corporation reported the following condensed income statement for 2015: Sales $5,900,000 Cost of goods sold...
Zipper Corporation reported the following condensed income statement for 2015: Sales $5,900,000 Cost of goods sold 4,130,000 Gross profit $1,770,000 Less expenses -1,520,000 Net income before taxes $250,000 Less income taxes 100,000 Net income after taxes $150,000 Assume the following: Average inventory $690,000 Average accounts receivable $1,220,000 Average accounts payable $390,000 (Use 365 days a year) Compute the following: (Round answers to 2 decimal places, e.g. 52.75.) Inventory turnover times Accounts receivable turnover times Average number of days to sell...
The firm has the information: inventory ($10,000),accounts receivable ($5,000), annual credit sales ($12,000), inventory ($14,000), cost...
The firm has the information: inventory ($10,000),accounts receivable ($5,000), annual credit sales ($12,000), inventory ($14,000), cost of goods sold ($15,000), calculate: a. the days in receivable b. Account receivable turn over …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………… c. Day’s in inventory ………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………
Timothy Johnson. has annual sales of $200,000, cost of goods sold of $150,000, average inventories of...
Timothy Johnson. has annual sales of $200,000, cost of goods sold of $150,000, average inventories of $2,500, average accounts receivable of $20,000, and an average accounts payable balance of $5,000. Assuming that all sales are on credit, what will be the firm’s cash cycle?
Blackberry, Inc. had sales for the past year of $38,250 and cost of goods sold of...
Blackberry, Inc. had sales for the past year of $38,250 and cost of goods sold of $21,038. In addition, the statement of financial position accounts was as shown in the table below. Blackberry uses average account values and a 365-day year where applicable in all of its computations. Account Beginning Ending Accounts receivable $1,800 $1,650 Inventory $2,450 $2,500 Accounts payable $1,950 $1,850 What is the cash cycle for Blackberry, Inc.? Multiple Choice 48.33 days 37.55 days 42.87 days 26.43 days...
Sempurna Manufacturing Company (SMC) has an average accounts receivable balance of RM1,250,000, an average inventory balance...
Sempurna Manufacturing Company (SMC) has an average accounts receivable balance of RM1,250,000, an average inventory balance of RM1,750,000, and an average accounts payable balance of RM800,000. Its annual sales are RM12,000,000 and its cost of goods sold represents 80 percent of annual sales. Assume there are 365 days in a year. What is SMC’s cash conversion cycle? "hopefully the answer without using excel"
Segwick Corp is estimating sales in Year 1 of $250,000 and cost of goods sold of...
Segwick Corp is estimating sales in Year 1 of $250,000 and cost of goods sold of $100,000. Given the following assumptions for Year 1, what is the projected change in working capital for that year? (Round to nearest $) Initial (Year 0) Working Capital $10,000 Cash 2% of sales Accounts Receivable 10 days outstanding (360-day year) Inventory Three months x cost of goods sold Accounts Payable 50% of inventory a. ($14,444) b. ($24,444) c. ($34,444) d. ($44,444)
Year Average Inventory $29,000 Accounts Receivable 23,000 Accounts Payable 11,000 Credit Sales = $180,000 COGS =...
Year Average Inventory $29,000 Accounts Receivable 23,000 Accounts Payable 11,000 Credit Sales = $180,000 COGS = $135,000 How many days are in the operating cycle?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT