Financial Analysis: The Big Picture
13–61
Be. 218
Vertical analysis (common-size) percentages for Austin Company’s sales, cost of goods sold, and
expenses are listed here.
Vertical Analysis 2018 2017 2016
Sales revenue 100.0% 100.0% 100.0%
Cost of goods sold 61.2 62.4 63.5
Operating expenses 26.5 27.4 28.5
Did Austin Company’s net income as a percent of sales increase, decrease, or remain unchanged
over the 3-year period? Provide numerical support for your answer.
Be. 219
Selected information from the comparative financial statements of Barcelona Company for the
year ended December 31 appears below:
2017 2016
Accounts receivable (net) $ 175,000 $200,000
Inventory 130,000 170,000
Total assets 1,100,000 800,000
Current liabilities 140,000 110,000
Long-term debt 410,000 300,000
Net credit sales 900,000 700,000
Cost of goods sold 600,000 530,000
Interest expense 40,000 25,000
Income tax expense 60,000 29,000
Net income 120,000 85,000
Net cash provided by operating activities 250,000 135,000
Instructions
Answer the following questions relating to the year ended December 31, 2017. Show
computations.
1. The inventory turnover for 2017 is __________.
2. The number of times interest earned in 2017 is __________.
3. The accounts receivable turnover for 2017 is __________.
4. The return on assets for 2017 is __________.
Test Bank for Financial Accounting: Tools for Business Decision Making, Eighth Edition
13–62
Be. 220
Selected data for Buechner Corporation appear below.
2017 2016
Net credit sales $630,000 $520,000
Cost of goods sold 409,500 312,000
Inventory at end of year 64,000 85,000
Accounts receivable at end of year 90,000 50,000
Instructions
Compute the following for 2017:
(a) Gross profit percentage
(b) Inventory turnover
(c) Accounts receivable turnover
Financial Analysis: The Big Picture
13–63
Be. 221
Corsig Corporation had the following comparative current assets and current liabilities:
Dec. 31, 2017 Dec. 31, 2016
Current assets
Cash $ 25,000 $ 30,000
Debt investments 40,000 10,000
Accounts receivable 60,000 90,000
Inventory 110,000 90,000
Prepaid expenses 35,000 25,000
Total current assets $270,000 $245,000
Current liabilities
Accounts payable $120,000 $110,000
Salaries and wages payable 40,000 30,000
Income tax payable 10,000 15,000
Total current liabilities $170,000 $155,000
During 2017, net credit sales and cost of goods sold were $570,000 and $350,000, respectively.
Net cash provided by operating activities for 2017 was $140,000.
Instructions
Compute the following liquidity measures for 2017:
1. Current ratio
2. Accounts receivable turnover
3. Inventory turnover
Test Bank for Financial Accounting: Tools for Business Decision Making, Eighth Edition
13–64
Be. 222
Selected data from the Florida Fruit Company are presented below:
Total assets $1,500,000
Average total assets 1,850,000
Net income 175,000
Net sales 1,300,000
Average common stockholders’ equity 1,000,000
Net cash provided by operating activities 275,000
Instructions
Assuming that no dividends were declared or paid during the period, calculate the following
profitability ratios from the above information:
1. Profit margin
2. Asset turnover
3. Return on assets
4. Return on common stockholders’ equity
Financial Analysis: The Big Picture
FOR INSTRUCTOR USE ONLY
13–65
Solution 222 (10-15 min.)
Be. 223
The following data are taken from the financial statements of Bar Harbor Company:
2017 2016
Average accounts receivable $ 530,000 $ 550,000
Net sales on account 5,800,000 5,200,000
Terms for all sales are 2/10, n/30
Instructions
(a) Compute the accounts receivable turnover and the average collection period for both years.
(b) What conclusion can an analyst draw about the management of the accounts receivable?
Test Bank for Financial Accounting: Tools for Business Decision Making, Eighth Edition
FOR INSTRUCTOR USE ONLY
13–66
Solution 223 (Cont.)
Be. 224
State the effect of the following transactions on the current ratio. Use increase, decrease, or no
effect for your answer.
(a) Collection of an accounts receivable
(b) Declaration of cash dividends
(c) Additional stock is sold for cash
(d) Accounts payable are paid
(e) Equipment is purchased for cash
(f) Inventory purchases are made for cash
(g) Temporary investments are purchased for cash
Be. 225
The balance sheet for Appalachian Corporation at the end of the current year includes the
following:
Bonds payable, 6% ……………………………………………… $5,000,000
6% Preferred stock, $100 par ……………………………….. 1,000,000
Common stock, $10 par ……………………………………….. 2,000,000
Net income was $565,000 and income tax expense for the current year amounted to $285,000.
Cash dividends paid on common stock were $200,000, and the common stock was selling for $28
per share at the end of the year. There were no ownership changes during the year.
Financial Analysis: The Big Picture
FOR INSTRUCTOR USE ONLY
13–67
Be. 225 (Cont.)
Instructions
Determine each of the following:
(a) Number of times that bond interest was earned.
(b) Earnings per share for common stock.
(c) Price-earnings ratio.
Be. 226
The income statement for the Carolina Service Company for the year ended December 31, 2017,
appears below.
Sales revenue $670,000
Cost of goods sold 390,000
Gross profit 280,000
Expenses 180,000*
Net income $100,000
*Includes $25,000 of interest expense and $20,000 of income tax expense.
Additional information:
1. Common stock outstanding on January 1, 2017, was 50,000 shares. On July 1, 2017, 10,000
more shares were issued.
2. The market price of Carolina’s stock was $22 at the end of 2017.
3. Cash dividends of $35,000 were paid, $5,000 of which were paid to preferred stockholders.
Test Bank for Financial Accounting: Tools for Business Decision Making, Eighth Edition
13–68
Be. 226 (Cont.)
Instructions
Compute the following ratios for 2017:
(a) Earnings per share.
(b) Price-earnings.
(c) Times interest earned.
Be. 227
Selected data taken from the 2017 financial statements of Phillips Card Company, Inc. are as
follows (in millions).
Net sales $295.9
Net cash provided by operating activities 17.0
Capital expenditures 2.6
Cash dividends 6.5
Instructions
Compute the free cash flow February 28, 2017; and briefly discuss your results.
Financial Analysis: The Big Picture
FOR INSTRUCTOR USE ONLY
13–69
EXERCISES
Ex. 228
Exeter Corporation had net income of $3,000,000 in 2016. Using 2016 as the base year, net
income decreased by 40% in 2017 and increased by 110% in 2018.
Instructions
Compute the net income reported by Exeter Corporation for 2017 and 2018.
Test Bank for Financial Accounting: Tools for Business Decision Making, Eighth Edition
FOR INSTRUCTOR USE ONLY
13–70
Ex. 229
The following items were taken from the financial statements of St. Johns, Inc., over a four-year
period:
Item 2018 2017 2016 2015
Net Sales $655,000 $640,000 $575,000 $500,000
Cost of Goods Sold 520,000 480,000 435,000 400,000
Gross Profit $135,000 $160,000 $140,000 $100,000
Instructions
Using horizontal analysis and 2015 as the base year, compute the trend percentages for net
sales, cost of goods sold, and gross profit. Explain whether the trends are favorable or
unfavorable for each item.
Ex. 230
Here is financial information for Valdez Express Inc.
December 31, 2017 December 31, 2016
Current assets $114,000 $80,000
Plant assets (net) 414,000 360,000
Current liabilities 91,000 65,000
Long-term liabilities 134,500 90,000
Common stock, $1 par 149,500 115,000
Retained earnings 153,000 170,000
Instructions
Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year.
Financial Analysis: The Big Picture
FOR INSTRUCTOR USE ONLY
13–71
Ex. 231
Here are the comparative income statements of Georgia Development Corporation.
GEORGIA DEVELOPMENT CORPORATION
Comparative Income Statements
For the Years Ended December 31
December 31, 2017 December 31, 2016
Net sales $600,000 $500,000
Cost of goods sold 414,000 350,000
Gross profit 186,000 150,000
Operating expenses 150,000 120,000
Net income $36,000 $30,000
Instructions
(a) Prepare a horizontal analysis of the income statement data for Georgia Development
Corporation using 2016 as a base. (Show the amounts of increase of decrease.)
(b) Prepare a vertical analysis of the income statement data for Georgia Development Corporation
for both years.
Test Bank for Financial Accounting: Tools for Business Decision Making, Eighth Edition
FOR INSTRUCTOR USE ONLY
13–72
Ex. 232
The comparative balance sheet of Delta Company appears below:
Delta COMPANY
Comparative Balance Sheet
December 31,
___________________________________________________________________________
Assets 2017 2016
Current assets …………………………………………………………………………. $ 450 $280
Plant assets …………………………………………………………………………….. 550 520
Total assets ……………………………………………………………………….. $1,000 $800
Liabilities and stockholders’ equity
Current liabilities ………………………………………………………………………. $ 180 $120
Long-term debt ………………………………………………………………………… 250 160
Common stock ………………………………………………………………………… 310 320
Retained earnings ……………………………………………………………………. 260 200
Total liabilities and stockholders’ equity ………………………………….. $1,000 $800
Financial Analysis: The Big Picture
FOR INSTRUCTOR USE ONLY
13–73
Ex. 232 (Cont.)
Instructions
(a) Using horizontal analysis, show the percentage change for each balance sheet item using
2016 as a base year.
(b) Using vertical analysis, prepare a common size comparative balance sheet.
Ex. 233
The following information was taken from the financial statements of Bjorg Company:
2017 2016
Gross profit on sales ………………………………………………………. $600,000 $680,000
Income before income taxes ……………………………………………. 230,000 221,000
Net income ……………………………………………………………………. 180,000 153,000
Net income as a percentage of net sales …………………………... 10% 9%
Instructions
(a) Compute the net sales for each year.
(b) Compute the cost of goods sold in dollars and as a percentage of net sales for each year.
(c) Compute operating expenses in dollars and as a percentage of net sales for each year.
(Income taxes are not operating expenses).
Test Bank for Financial Accounting: Tools for Business Decision Making, Eighth Edition
FOR INSTRUCTOR USE ONLY
13–74
Ex. 234
Operating data for Panola Land Corporation are presented below
2017 2016
Sales revenue $800,000 $600,000
Cost of goods sold 480,000 390,000
Selling expenses 120,000 78,000
Administrative expenses 80,000 54,000
Income tax expense 24,000 25,000
Net income 96,000 53,000
Instructions
Prepare a schedule showing a vertical analysis for 2017 and 2016.
Financial Analysis: The Big Picture
FOR INSTRUCTOR USE ONLY
13–75
Ex. 235
Armada Company has these comparative balance sheet data:
ARMADA COMPANY
Balance Sheets
December 31,
2017 2016
Cash $ 40,000 $ 30,000
Accounts receivable (net) 65,000 60,000
Inventory 60,000 50,000
Plant assets (net) 185,000 180,000
$350,000 $320,000
Accounts payable $ 50,000 $ 60,000
Mortgage payable (15%, due in 15 years) 100,000 100,000
Common stock, $10 par 140,000 120,000
Retained earnings 60,000 40,000
$350,000 $320,000
Additional information for 2017:
1. Net income was $25,000.
2. Sales on account were $450,000. Sales returns and allowances amounted to $25,000.
3. Cost of goods sold was $275,000.
4. Net cash provided by operating activities was $49,000.
5. Capital expenditures were $23,000, and cash dividends were $18,000.
Test Bank for Financial Accounting: Tools for Business Decision Making, Eighth Edition
FOR INSTRUCTOR USE ONLY
13–76
Ex. 235 (Cont.)
Instructions
Compute the following ratios at December 31, 2017.
(a) Current. (e) Days in inventory
(b) Accounts receivable turnover. (f) Free cash flow.
(c) Average collection period.
(d) Inventory turnover.
Ex. 236
Here is the income statement for Ginsberg, Inc.
GINSBERG, INC.
Income Statement
For the Year Ended December 31, 2017
___________________________________________________________________________
Sales revenue $400,000
Cost of goods sold 250,000
Gross profit 150,000
Expenses (including $12,000 interest and $22,000 income taxes) 100,000
Net income $ 50,000
Financial Analysis: The Big Picture
FOR INSTRUCTOR USE ONLY
13–77
Ex. 236 (Cont.)
Additional information:
1. Common stock outstanding January 1, 2017, was 30,000 shares, and 40,000 shares were
outstanding at December 31, 2017.
2. The market price of Gillman, Inc., stock was $15.86 in 2017.
3. Cash dividends of $16,000 were paid, $4,500 of which were to preferred stockholders.
Instructions
Compute the following measures for 2017.
(a) Earnings per share.
(b) Price-earnings ratio.
(c) Payout ratio.
(d) Times interest earned.
Ex. 237
Belcanto Corporation experienced a fire on December 31, 2017, in which its financial records were
partially destroyed. It has been able to salvage some of the records and has ascertained the
following balances.
December 31, 2017 December 31, 2016
Cash $ 40,000 $ 15,000
Accounts receivable (net) 84,000 126,000
Inventory 200,000 180,000
Accounts payable 50,000 10,000
Notes payable 30,000 20,000
Common stock, $100 par 400,000 400,000
Retained earnings 170,000 101,000