Question
1. I need help filling out the Balance Sheet for Liquidity and Solvency Measures with the provided Computations. I need help filling out Profitability Measures
1. I need help filling out the Balance Sheet for Liquidity and Solvency Measures with the provided Computations.
- I need help filling out Profitability Measures with the provided Computations for the Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5
Mastery Problem: Financial Statement Analysis
Liquidity and Solvency Measures
Your friend, another accountant, has bet you that with your knowledge of accounting and just the computations for common analytical measures, you can figure out many aspects of a company's financial statements. You take the bet!
Match each computation to one of the liquidity and solvency measures in the table. (Hint: Begin by looking for simple computations and identifying the amounts in those computations. Look for other measures that use those amounts.)
Liquidity and Solvency Measures |
| Computations |
Working capital |
| $3,091,000 $860,000 |
Current ratio |
| $3,091,000 $860,000 |
Quick ratio |
| $1,866,000 $860,000 |
Accounts receivable turnover |
| $8,280,000 [($714,000 + $740,000) 2] |
Number of days' sales in receivables |
| [($714,000 + $740,000) 2] ($8,280,000 365) |
Inventory turnover |
| $4,100,000 [($1,072,000 + $1,100,000) 2] |
Number of days' sales in inventory |
| [($1,072,000 + $1,100,000) 2] ($4,100,000 365) |
Ratio of fixed assets to long-term liabilities |
| $2,690,000 $1,690,000 |
Ratio of liabilities to stockholders' equity |
| $2,550,000 $4,055,000 |
Times interest earned |
| ($989,400 + $127,000) $127,000 |
Balance Sheet
Use the following balance sheet form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part. You will identify other amounts for the balance sheet on the Profitability Measures part. If you have a choice of two amounts, assume the first amount in the ratio is for the end of the year. Compute any missing amounts.
Balance Sheet December 31, 20Y6 | |
Assets |
|
Current assets: |
|
Cash | $823,000 |
Marketable securities |
|
Accounts receivable (net) |
|
Inventory |
|
Prepaid expenses |
|
Total current assets |
|
Long-term investments |
|
Property, plant, and equipment (net) |
|
Total assets |
|
Liabilities |
|
Current liabilities |
|
Long-term liabilities |
|
Total liabilities |
|
Stockholders' Equity |
|
Preferred stock, $10 par |
|
Common stock, $5 par |
|
Retained earnings |
|
Total stockholders' equity |
|
Total liabilities and stockholders' equity |
|
Profitability Measures
Match each computation to one of the profitability measures in the table.
Profitability Measures |
| Computations |
Asset turnover |
| $8,280,000 [($5,781,000 + $5,591,000) 2] |
Return on total assets |
| ($801,420 + $127,000) [($6,605,000 + $6,415,000) 2] |
Return on stockholders' equity |
| $801,420 [($4,055,000 + $3,852,250) 2] |
Return on common stockholders' equity |
| ($801,420 $65,000) [($3,567,500 + $3,424,800) 2] |
Earnings per share on common stock |
| ($801,420 $65,000) 250,000 shares |
Price-earnings ratio |
| $35 $3.05 |
Dividends per share |
| $175,000 250,000 shares |
Dividend yield |
| $0.70 $35 |
Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5 | |||||||||||||||||
|
|
| Increase/(Decrease) | ||||||||||||||
| 20Y6 | 20Y5 | Amount | Percentage | |||||||||||||
Sales |
|
|
|
| $7,287,000 |
|
|
|
|
|
| % | |||||
Cost of goods sold |
|
|
|
| (3,444,000) |
|
|
|
|
|
| % | |||||
Gross profit |
|
|
|
| $3,843,000 |
|
|
|
|
|
| % | |||||
Selling expenses |
|
|
|
| $(1,457,600) |
|
|
|
|
|
| % | |||||
Administrative expenses |
| (1,242,000) |
|
| (1,106,000) |
|
|
|
|
|
| % | |||||
Total operating expenses |
|
|
|
| $(2,563,600) |
|
|
|
|
| % | ||||||
Operating income |
|
|
|
| $1,279,400 |
|
|
|
|
| |||||||
Other expense (interest) |
|
|
|
| (120,600) |
|
|
|
|
|
| % | |||||
Income before income tax expense |
|
|
|
|
|
| |||||||||||
|
|
|
|
|
|
| |||||||||||
Income tax expense |
|
|
|
|
|
| |||||||||||
Net income |
|
|
|
|
|
| |||||||||||
1. I need help filling out Balance Sheet for Liquidity and Solvency Measures with the provided
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started