Question

In: Accounting

Balance Sheet Problem 1992 1993 1994 Annual Sales Growth (over prior yr) + 1% 0% +1%...

Balance Sheet Problem 1992 1993 1994 Annual Sales Growth (over prior yr) + 1% 0% +1% Current Ratio 3.5X 2X 1.2X Average Collection Period 25 days 30 days 55 days

What is happening to liquidity? What are some follow-up questions you would ask?

Solutions

Expert Solution

Liquidity ratio is determined by the combination of current ratio, quick ratio and average collection period.

Current ratio = Current Assets/Current liabilities

Quick ratio = (Current assets- inventory)/Current liabilities

Average collection period = Accounts receivable/(sales/365)

Current ratio determines ability of company to meet its current liabilities out of assets that can be disposed off within year. While, quick ratio defines ability to pay quickly all current liabilities.

In the given case, the current ratio is falling consistently which points out to deteriorating liquidity position. In order to determine quick position, the balances of current assets such as cash,cash equivalents and accounts receivables is to be asked.

Likewise average collection period is increasing meaning the days to collect receivables is increasing. Although sales has remained constant in year 1 and 3, collection period has more than doubled from 1992 to 1994. This reduction in cash collection has given rise to liquidity crunch in business which is evident in current ratio decline.

To provide detailed conclusion, balances of current assets such as cash,cash equivalents and accounts receivables along with sales need to be asked.


Related Solutions

Year Sales Net Income After Tax 1992 $2,000,000 $240,000 1993 2,750,000 338,000 1994 3,200,000 384,000 1995...
Year Sales Net Income After Tax 1992 $2,000,000 $240,000 1993 2,750,000 338,000 1994 3,200,000 384,000 1995 5,000,000 575,000 1996 5,7000,000 600,000 1997 6,2000,000 713,000 1998 7,3000,000 803,000 1999 8,5000,000 860,000 2000 9,1000,000 900,000 2001 10,3000,000 912,720 What is the compound rate of growth for the firm's sales and net income after-tax?
3.  Problem 3-11 (Balance Sheet Analysis) Balance Sheet Analysis Complete the balance sheet and sales information in...
3.  Problem 3-11 (Balance Sheet Analysis) Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.7 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 30% Total liabilities-to-assets ratio: 40% Quick ratio: 0.90 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.25 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial...
FCF Forecast ($ million) Year 0 1 2 3 4 Sales 240 Growth versus Prior Year...
FCF Forecast ($ million) Year 0 1 2 3 4 Sales 240 Growth versus Prior Year 12.50% 7.40% 6.90% 5.00% EBIT (10% of Sales) Less: Income Tax (37%) Less Increase in NWC (12% of Change in Sales)           Free Cash Flow Banco Industries expect sales to grow at a rapid rate over the next three years, but settle to an industry growth rate in year 4. The spreadsheet above is a template for forecasting Banco Industries' free cash flows (FCFs), with...
Problem 7-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that...
Problem 7-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.5 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 24% Total liabilities-to-assets ratio: 35% Quick ratio: 0.95 Days sales outstanding (based on 365-day year): 31.5 days Inventory turnover ratio: 5.0 Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $   Cost of goods...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.5 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 23% Total liabilities-to-assets ratio: 55% Quick ratio: 0.95 Days sales outstanding (based on 365-day year): 31.5 days Inventory turnover ratio: 6.0 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 2.6 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 23% Total liabilities-to-assets ratio: 40% Quick ratio: 1.15 Days sales outstanding (based on 365-day year): 34.5 days Inventory turnover ratio: 3.0 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.5 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 30% Total liabilities-to-assets ratio: 45% Quick ratio: 0.85 Days sales outstanding (based on 365-day year): 29.5 days Inventory turnover ratio: 7.0 Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $   Cost of goods...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 2.8 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 23% Total liabilities-to-assets ratio: 60% Quick ratio: 0.90 Days sales outstanding (based on 365-day year): 31.5 days Inventory turnover ratio: 5.0 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that...
Problem 3-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.8 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% Total liabilities-to-assets ratio: 55% Quick ratio: 1.00 Days sales outstanding (based on 365-day year): 32 days Inventory turnover ratio: 4.0 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information...
11.  Problem 4.22 (Balance Sheet Analysis) eBook Problem Walk-Through Complete the balance sheet and sales information using...
11.  Problem 4.22 (Balance Sheet Analysis) eBook Problem Walk-Through Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3× Days sales outstanding: 36.5 daysa Inventory turnover ratio: 5× Fixed assets turnover: 2.5× Current ratio: 2.0× Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answers to the nearest dollar. Balance Sheet Cash $   Current liabilities $   Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT