Question
16m Mastery Problem: Financial Statement Analysis Liquidity and Solvency Measures Your friend, another accountant, has bet you that with your knowledge of accounting and just
16m
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,095,000 $880,000 | |
Current ratio | $3,095,000 $880,000 | |
Quick ratio | $1,866,000 $880,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,570,000 $4,039,000 | |
Times interest earned | ($989,400 + $127,000) $127,000 |
Feedback
Look for patterns in the computations and match them to ratios that are related to each other. Identify the amounts in the computations and consider how they are related to amounts in other computations.
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 | fill in the blank e9486601efae000_1 |
Accounts receivable (net) | fill in the blank e9486601efae000_2 |
Inventory | fill in the blank e9486601efae000_3 |
Prepaid expenses | fill in the blank e9486601efae000_4 |
Total current assets | $fill in the blank e9486601efae000_5 |
Long-term investments | fill in the blank e9486601efae000_6 |
Property, plant, and equipment (net) | fill in the blank e9486601efae000_7 |
Total assets | $fill in the blank e9486601efae000_8 |
Liabilities | |
Current liabilities | $fill in the blank e9486601efae000_9 |
Long-term liabilities | fill in the blank e9486601efae000_10 |
Total liabilities | $fill in the blank e9486601efae000_11 |
Stockholders' Equity | |
Preferred stock, $10 par | $fill in the blank e9486601efae000_12 |
Common stock, $5 par | fill in the blank e9486601efae000_13 |
Retained earnings | fill in the blank e9486601efae000_14 |
Total stockholders' equity | $fill in the blank e9486601efae000_15 |
Total liabilities and stockholders' equity | $fill in the blank e9486601efae000_16 |
Feedback
Identify the amounts in the Liquidity and Solvency Measures panel and the Profitability Measures panel that are balance sheet items and enter them accordingly.
Profitability Measures
Match each computation to one of the profitability measures in the table.
Profitability Measures | Computations | |
Asset turnover | $8,280,000 [($5,785,000 + $5,595,000) 2] | |
Return on total assets | ($801,420 + $127,000) [($6,609,000 + $6,419,000) 2] | |
Return on stockholders' equity | $801,420 [($4,039,000 + $3,837,050) 2] | |
Return on common stockholders' equity | ($801,420 $65,000) [($3,551,500 + $3,409,440) 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 |
Feedback
Look for patterns in the computations and match them to ratios that are related to each other. Identify the amounts in the computations and consider how they are related to amounts in other computations. Note that two of the computations use shares.
Comparative Income Statement
Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part and on the Profitability Measures part. Compute any missing amounts and complete the horizontal analysis columns. Enter percentages as decimal amounts, rounded to one decimal place. When rounding, look only at the figure to the right of one decimal place. If < 5, round down and if 5, round up. For example, for 32.048% enter 32.0%. For 32.058% enter 32.1%.
Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5 | ||||||||||||
Increase/(Decrease) | ||||||||||||
20Y6 | 20Y5 | Amount | Percentage | |||||||||
Sales | $fill in the blank f48b6c07800d068_1 | $7,287,000 | $fill in the blank f48b6c07800d068_2 | fill in the blank f48b6c07800d068_3 | % | |||||||
Cost of goods sold | fill in the blank f48b6c07800d068_4 | (3,444,000) | fill in the blank f48b6c07800d068_5 | fill in the blank f48b6c07800d068_6 | % | |||||||
Gross profit | $fill in the blank f48b6c07800d068_7 | $3,843,000 | $fill in the blank f48b6c07800d068_8 | fill in the blank f48b6c07800d068_9 | % | |||||||
Selling expenses | $fill in the blank f48b6c07800d068_10 | $(1,457,600) | $fill in the blank f48b6c07800d068_11 | fill in the blank f48b6c07800d068_12 | % | |||||||
Administrative expenses | (1,242,000) | (1,106,000) | fill in the blank f48b6c07800d068_13 | fill in the blank f48b6c07800d068_14 | % | |||||||
Total operating expenses | $fill in the blank f48b6c07800d068_15 | $(2,563,600) | $fill in the blank f48b6c07800d068_16 | fill in the blank f48b6c07800d068_17 | % | |||||||
Operating income | $fill in the blank f48b6c07800d068_18 | $1,279,400 | $fill in the blank f48b6c07800d068_19 | fill in the blank f48b6c07800d068_20 | % | |||||||
Other expense (interest) | fill in the blank f48b6c07800d068_21 | (120,600) | fill in the blank f48b6c07800d068_22 | fill in the blank f48b6c07800d068_23 | % | |||||||
Income before income tax expense | $fill in the blank f48b6c07800d068_24 | $1,158,800 | $fill in the blank f48b6c07800d068_25 | fill in the blank f48b6c07800d068_26 | % | |||||||
Income tax expense | fill in the blank f48b6c07800d068_27 | (181,980) | fill in the blank f48b6c07800d068_28 | fill in the blank f48b6c07800d068_29 | % | |||||||
Net income | $fill in the blank f48b6c07800d068_30 | $976,820 | $fill in the blank f48b6c07800d068_31 | fill in the blank f48b6c07800d068_32 | % |
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