Question

In: Finance

Saturn Ltd. Has sales of $ 800,000, a net income of $ 60,000 and the following...

Saturn Ltd. Has sales of $ 800,000, a net income of $ 60,000 and the following balance sheet:  

Assets

Amount ($)

Liabilities and Owners’ Equity

Amount ($)

Cash

$ 10,000

Accounts Payable

$ 30,000

Accounts Receivable

$ 50,000

Other Current Liabilities

$ 20,000

Inventories

$ 150,000

Long-term Debt

$50,000

Net Fixed Assets

$ 90,000

Common Equity

$ 200,000

Total Assets

$ 300,000

Total Liabilities and Owners’ Equity

$ 300,000

Additional Information:

·Cost of goods sold is $ 600,000. Of which 70% was purchased during the year.

  •   The company has no preferred stock.

Industry Information:

Ratios

Industry Average

Current Ratio

3.0

Quick Ratio

1.5

Inventory Turnover

9.2

Average Age of Inventory

75

Average Collection Period

20

Average Payment Period

30

Instructions:

a)      Calculate the Quick ratio of Saturn Ltd.

b)     Calculate the Average Collection Period of Saturn Ltd.

c) The company provides a credit term of 30 days to all its customers. On the basis of the company’s credit policy and the industry average comment on Saturn’s management of accounts receivables.

Solutions

Expert Solution

a. Quick ratio=(cash+accounts receivables)/(accounts payables+other current liabilities)=(10,000+50,000)/(30,000+20,000)=60,000/50,000=1.20

b. Average collection period=(accounts receivables/sales)*365=(50,000/800,000)*365=22.81 days

c. If their credit term is 30 days, it is taking 10 more days (30-20 days) to collect the recievbles when compared to the industry.


Related Solutions

A company has 60,000 in sales per day and sells on credit terms of NET 30....
A company has 60,000 in sales per day and sells on credit terms of NET 30. Its current receivables booking practices record the invoices immediately on the day the sale occurs. The firm's average collection experiences indicate that its typical customer pays by check, and the remittance is received at the firm's central processing location 50 days after the invoicing of the sale. Given the efficiency of the central processing center customer accounts are credited on the following day (51)....
Barnes and Noble has a total debt-equity ratio of 40 percent, sales of $800,000, a net...
Barnes and Noble has a total debt-equity ratio of 40 percent, sales of $800,000, a net profit margin of 7.5 percent, and total debt of $240,000. Calculate the firm’s ROE. If the firm increases its debt-equity ratio will the ROE increase or decrease? (Hint: think about the Dupont Identity.)    10.00 percent, increase    10.00 percent, decrease    38.99 percent, increase    38.99 percent, decrease    5.67 percent, increase   
Best Exports has noticed their current year net income is only $60,000. In order to get...
Best Exports has noticed their current year net income is only $60,000. In order to get a loan from their bank to assist the business they will need to provide a statement of cash flows. In reviewing the statement of cash flows, you notice a large increase ($80,000) in accounts receivable due to two of your largest customers being behind in payments. Since the bank looks at the operating activities, this increase will create concern. You make a suggestion to...
Lloyd Inc. has sales of $400,000, a net income of $28,000, and the following balance sheet:...
Lloyd Inc. has sales of $400,000, a net income of $28,000, and the following balance sheet: Cash $103,680 Accounts payable $117,720 Receivables 204,120 Notes payable to bank 44,280 Inventories 550,800 Total current liabilities $162,000 Total current assets $858,600 Long-term debt 205,200 Net fixed assets 221,400 Common equity 712,800 Total assets $1,080,000 Total liabilities and equity $1,080,000 The new owner thinks that inventories are excessive and can be lowered to the point where the current ratio is equal to the industry...
   Calculate the vertical analysis of the following data. Income Statement 2018 2019 Sales $ 800,000 $950,000...
   Calculate the vertical analysis of the following data. Income Statement 2018 2019 Sales $ 800,000 $950,000 Cost of Goods Sold 350,000 600,000 Gross Margin 450,000 350,000 Operating Expenses 250,000 280,000 Net Income $200,000 $ 70,000 From the following Balance sheet of A Co. Ltd., you are required to prepare a Schedule of Changes in Working Capital Liabilities 2011 2012 Assets 2011 2012 Share Capital 200000 210000 Cash at bank 105000 106000 Profit & loss A/c 20000 23000 Debtors 18000 28000...
34. Daniel is single and has the following income and expenses in 2017: Salary income $60,000...
34. Daniel is single and has the following income and expenses in 2017: Salary income $60,000 Net rent income 6,000 Dividend income 3,500 Payment of alimony 12,000 Mortgage interest on residence 4,900 Property tax on residence 1,200 Contribution to traditional IRA 5,000 Contribution to United Church 2,100 Loss on the sale of real estates (held for investment) 2,000 Medical expenses 3,250 State income tax 300 Federal income tax 7,000 a. Calculate Daniel’s AGI. b. Should Daniel itemize his deductions from...
Lloyd Inc. has sales of $150,000, a net income of $13,500, andthe following balance sheet:...
Lloyd Inc. has sales of $150,000, a net income of $13,500, and the following balance sheet: Cash $36,660 Accounts payable $34,320 Receivables 75,270 Notes payable to bank 16,380 Inventories 218,400 Total current liabilities $50,700 Total current assets $330,330 Long-term debt 50,700 Net fixed assets 59,670 Common equity 288,600 Total assets $390,000 Total liabilities and equity $390,000 The new owner thinks that inventories are excessive and can be lowered to the point where the current ratio is equal to the industry...
Exercise 3 : A firm has sales of $2,190, net income of $174, net fixed assets...
Exercise 3 : A firm has sales of $2,190, net income of $174, net fixed assets of $1,600, and current assets of $720. The firm has $310 in inventory. What is the common-size statement value of inventory? Also explain the implications of common size analysis.
Elements of the Income Statement for Hofstadter Experiments Ltd. follow: 2020 2019 Net Sales (all credit)...
Elements of the Income Statement for Hofstadter Experiments Ltd. follow: 2020 2019 Net Sales (all credit) $1,498,000 $1,200,000 Cost of goods sold 1,043,000 820,000 Net Income 91,000 76,500 Highlights of the Balance Sheet: 2020 2019 Cash $90,500 $64,700 Temporary Investments 75,000 60,000 Accounts receivable (net) 115,000 120,000 Inventories 264,000 283,000 Prepaid expenses 5,500 5,300 Total current liabilities 210,000 243,000 Total liabilities 310,000 443,000 Total common shareholders’ equity 829,500 787,500 Required: (Round all answers to 2 decimal places). Calculate the gross...
Elements of the Income Statement for Hofstadter Experiments Ltd. follow: 2020 2019 Net Sales (all credit)...
Elements of the Income Statement for Hofstadter Experiments Ltd. follow: 2020 2019 Net Sales (all credit) $1,498,000 $1,200,000 Cost of goods sold 1,043,000 820,000 Net Income 91,000 76,500 Highlights of the Balance Sheet: 2020 2019 Cash $90,500 $64,700 Temporary Investments 75,000 60,000 Accounts receivable (net) 115,000 120,000 Inventories 264,000 283,000 Prepaid expenses 5,500 5,300 Total current liabilities 210,000 243,000 Total liabilities 310,000 443,000 Total common shareholders’ equity 829,500 787,500 Required:   (Round all answers to 2 decimal places). Calculate the gross...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT