Question Content Area

Mastery Problem: Financial Statement Analysis

Question Content Area

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 $860,000
Current ratio		3,095,000 $860,000
Quick ratio		$1,866,000 $860,000
Accounts receivable turnover		$8,270,000 [($714,000 + $740,000) 2]
Number of days' sales in receivables		[($714,000 + $740,000) 2] ($8,270,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,059,000
Times interest earned		($983,100 + $127,000) $127,000

Question Content Area

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 937d880b0f98fd5_1
Accounts receivable (net)	fill in the blank 937d880b0f98fd5_2
Inventory	fill in the blank 937d880b0f98fd5_3
Prepaid expenses	fill in the blank 937d880b0f98fd5_4
Total current assets	$fill in the blank 937d880b0f98fd5_5
Long-term investments	fill in the blank 937d880b0f98fd5_6
Property, plant, and equipment (net)	fill in the blank 937d880b0f98fd5_7
Total assets	$fill in the blank 937d880b0f98fd5_8
Liabilities
Current liabilities	$fill in the blank 937d880b0f98fd5_9
Long-term liabilities	fill in the blank 937d880b0f98fd5_10
Total liabilities	$fill in the blank 937d880b0f98fd5_11
Stockholders' Equity
Preferred stock, $10 par	$fill in the blank 937d880b0f98fd5_12
Common stock, $5 par	fill in the blank 937d880b0f98fd5_13
Retained earnings	fill in the blank 937d880b0f98fd5_14
Total stockholders' equity	$fill in the blank 937d880b0f98fd5_15
Total liabilities and stockholders' equity	$fill in the blank 937d880b0f98fd5_16

Question Content Area

Profitability Measures

Match each computation to one of the profitability measures in the table.

Profitability Measures		Computations
Asset turnover		$8,270,000 [($5,785,000 + $5,595,000) 2]
Return on total assets		($796,380 + $127,000) [($6,609,000 + $6,419,000) 2]
Return on stockholders' equity		$796,380 [($4,059,000 + $3,856,050) 2]
Return on common stockholders' equity		($796,380 $65,000) [($3,571,500 + $3,428,640) 2]
Earnings per share on common stock		($796,380 $65,000) 250,000 shares
Price-earnings ratio		$35 $3.05
Dividends per share		175,000 250,000 shares
Dividend yield		$0.70 $35

Question Content Area

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 94ecef01a01c000_1

$7,277,000

$fill in the blank 94ecef01a01c000_2

fill in the blank 94ecef01a01c000_3

%

Cost of goods sold

fill in the blank 94ecef01a01c000_4

(3,444,000)

fill in the blank 94ecef01a01c000_5

fill in the blank 94ecef01a01c000_6

%

Gross profit

$fill in the blank 94ecef01a01c000_7

$3,833,000

$fill in the blank 94ecef01a01c000_8

fill in the blank 94ecef01a01c000_9

%

Selling expenses

$fill in the blank 94ecef01a01c000_10

$(1,455,400)

$fill in the blank 94ecef01a01c000_11

fill in the blank 94ecef01a01c000_12

%

Administrative expenses

(1,240,500)

(1,104,500)

fill in the blank 94ecef01a01c000_13

fill in the blank 94ecef01a01c000_14

%

Total operating expenses

$fill in the blank 94ecef01a01c000_15

$(2,559,900)

$fill in the blank 94ecef01a01c000_16

fill in the blank 94ecef01a01c000_17

%

Operating income

$fill in the blank 94ecef01a01c000_18

$1,273,100

$fill in the blank 94ecef01a01c000_19

fill in the blank 94ecef01a01c000_20

%

Other expense (interest)

fill in the blank 94ecef01a01c000_21

(120,600)

fill in the blank 94ecef01a01c000_22

fill in the blank 94ecef01a01c000_23

%

Income before income tax expense

$fill in the blank 94ecef01a01c000_24

$1,152,500

$fill in the blank 94ecef01a01c000_25

fill in the blank 94ecef01a01c000_26

%

Income tax expense

fill in the blank 94ecef01a01c000_27

(180,720)

fill in the blank 94ecef01a01c000_28

fill in the blank 94ecef01a01c000_29

%

Net income

$fill in the blank 94ecef01a01c000_30

$971,780

$fill in the blank 94ecef01a01c000_31

fill in the blank 94ecef01a01c000_32

%