Question

In: Finance

Elsee, Inc., has net sales of $16 million, and 75 percent of these are credit sales....

Elsee, Inc., has net sales of $16 million, and 75 percent of these are credit sales. Its cost of goods sold is 65 percent of annual net sales. The firm’s cash conversion cycle is 58.0 days. The inventory balance at the firm is $1,842,000, while its accounts payable balance is $2,387,000. What is the firm’s accounts receivable balance? (Round intermediate calculations to 1 decimal places, e.g. 15.1. and final answer to nearest whole dollar, e.g. 5,275.)

The firm’s accounts receivables are $ .

Solutions

Expert Solution

CCC = DIO + DSO - DPO

Cash Conversion Cycle = 58 days

DIO = Days Inventory Outstanding = (Inventory /Cost of goods sold) x Number of days in the period

                                                        = $ 1,842,000/ ($ 16,000,000 x 0.65) x 365

                                                        = ($ 1,842,000/ $10,400,000) x 365

                                                        = 0.177115384615385 x 365

  = 64.6471153846154 or 64.6 days

DSO = Days Sales Outstanding = (Account Receivable /Total Credit Sales) x Number of days in the period

= Account Receivable / ($ 16,000,000 x 0.75) x 365

= (Account Receivable / $ 12,000,000) x 365

DPO = Days Payable Outstanding = (Accounts Payable /Cost of goods sold) x Number of days in the period

= ($ 2,387,000/$10,400,000) x 365

    = 0.229519230769231 x 365

                                                      = 83.7745192307692 or 83.8 days

DSO = 58 - 64.6 + 83.8

        = 77.2 days

77.2 = (Account Receivable /$ 12,000,000) x 365

Account Receivable /$ 12,000,000 = 77.2/365

                                                        = 0.211287671232877

Account Receivable = 0.211506849315068 x $ 12,000,000

                                 = $ 2,538,082.19178082 or $ 2,538,082

The firm's account receivables are $ 2,538,082


Related Solutions

Elsee, Inc., has net sales of $15 million, and 75 percent of these are credit sales....
Elsee, Inc., has net sales of $15 million, and 75 percent of these are credit sales. Its cost of goods sold is 65 percent of annual net sales. The firm’s cash conversion cycle is 56.0 days. The inventory balance at the firm is $1,591,000, while its accounts payable balance is $2,068,000. What is the firm’s accounts receivable balance? (Round intermediate calculations to 1 decimal places, e.g. 15.1. and final answer to nearest whole dollar, e.g. 5,275.)
Sunland Handicrafts, Inc., has net sales of $3.20 million with 50 percent being credit sales. Its...
Sunland Handicrafts, Inc., has net sales of $3.20 million with 50 percent being credit sales. Its cost of goods sold is $1.92 million. The firm’s cash conversion cycle is 51.5 days, and its operating cycle is 86.5 days. What is the firm’s accounts payable?
HBM, Inc. had sales of $9 million and a net profit margin of 10 percent in...
HBM, Inc. had sales of $9 million and a net profit margin of 10 percent in 20X0. Management expects sales to grow to $10.8 million and $12.6 million in 20X1 and 20X2, respectively. Management wants to know if additional funds will be necessary to finance this anticipated growth. Currently, the firm is not operating at full capacity and should be able to sustain a 25 percent increase in sales. However, further increases in sales will require $3 million in plant...
Jupiter Ltd has annual credit sales of $80 million and 2 percent of the value of...
Jupiter Ltd has annual credit sales of $80 million and 2 percent of the value of these sales have to be written off as bad debt. Currently Jupiter’s credit terms are 4/15 net 30; and 50 percent of the non-defaulting credit customers take advantage of the discount. A further 40 percent of non-defaulters pay on time and the remaining 10 percent of non-defaulters pay 15 days late. Jupiter Ltd is considering changing its credit terms to 2/10, net 30. It...
Problem 3 Pro Build Inc. has had a net income of $16 million in its most...
Problem 3 Pro Build Inc. has had a net income of $16 million in its most recent year. Net income is expected to grow by 3% per year. The firm always pays out 80% of net income as dividends and has 7 million shares of common stock outstanding. The required return is 9%. Part 1 What is the current stock price?
ABC Corp has net income of $75 million, total liabilities of $100 million, 45% of which...
ABC Corp has net income of $75 million, total liabilities of $100 million, 45% of which is interest-bearing debt at 8% interest. The ROE for XYZ is 15% and the tax rate is 25%. Find ABC’s ROA and ROIC.
Parramore Corp has $16 million of sales, $3 million of inventories, $2 million of receivables, and...
Parramore Corp has $16 million of sales, $3 million of inventories, $2 million of receivables, and $3 million of payables. Its cost of goods sold is 65% of sales, and it finances working capital with bank loans at an 9% rate. Assume 365 days in year for your calculations. Do not round intermediate steps. What is Parramore's cash conversion cycle (CCC)? Do not round intermediate calculations. Round your answer to two decimal places.   days If Parramore could lower its inventories...
Parramore Corp has $16 million of sales, $1 million of inventories, $2 million of receivables, and...
Parramore Corp has $16 million of sales, $1 million of inventories, $2 million of receivables, and $1 million of payables. Its cost of goods sold is 75% of sales, and it finances working capital with bank loans at an 6% rate. Assume 365 days in year for your calculations. Do not round intermediate steps. A. What is Parramore's cash conversion cycle (CCC)? Do not round intermediate calculations. Round your answer to two decimal places.   days B. If Parramore could lower...
Lipto Biomedic has credit sales of $740,000 yearly with credit terms of net 60 days, with...
Lipto Biomedic has credit sales of $740,000 yearly with credit terms of net 60 days, with an average collection period of 75 days. Lipto is considering offering a 3 percent discount for payment in 10 days. They would use the cash generated from the reduced receivables to reduce their bank loans which cost 8%. Assume ALL of the customers take advantage of the 3/10 terms. Use the following table to calculate the costs and benefits for Lipto and make decision...
(Accounts receivable collection policy​) The Cowboy Bottling Company will generate ​$16 million in credit sales next...
(Accounts receivable collection policy​) The Cowboy Bottling Company will generate ​$16 million in credit sales next year. Collection of these credit sales will occur evenly over this period. The​ firm's employees work 300 days a year.​ Currently, the​ firm's processing system ties up 6 ​days' worth of remittance checks. A recent report from a financial consultant indicated procedures that will enable Cowboy Bottling to reduce processing float by 1 full days. If Cowboy invests the released funds to earn 11...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT