In: Finance
(Preparing common-size financial statements) As the newest hire to the financial analysis group at Patterson Printing Company, you have been asked to perform a basis financial analysis of the company's most recent financial statements. The 2016 balance sheet and income statement for the Patterson are shown here:
Patterson Printing Company |
||
Balance Sheet, December 31, 2016 |
||
Cash and marketable securities |
$500 |
|
Accounts receivable |
6,000 |
|
Inventory |
9,500 |
|
Total current assets |
$16,000 |
|
Net property, plant, and equipment |
17,000 |
|
Total assets |
$33,000 |
|
Accounts payable |
$7,200 |
|
Short-term debt |
6,800 |
|
Total current liabilities |
$14,000 |
|
Long-term liabilities |
7,000 |
|
Total liabilities |
$21,000 |
|
Total common stockholders' equity |
12,000 |
|
Total liabilities and stockholders' equity |
$33,000 |
Patterson Printing Company |
||||
Income Statement for the Year Ended December 31, 2016 |
||||
Revenues |
$30,000 |
|||
Cost of goods sold |
(20,000) |
|||
Gross profit |
$10,000 |
|||
Operating expenses |
(8,000) |
|||
Net operating income |
$2,000 |
|||
Interest expense |
(900) |
|||
Earnings before taxes |
$1,100 |
|||
Income taxes |
(400) |
|||
Net income |
a. After discussing your training asignment with a fellow analyst who was hired last year, you learn that the first step in your completing the assignment is to prepare a common-size balance sheet for Patterson.
b. The second step is to prepare a common-size income statement for the firm.
a. After discussing your training asignment with a fellow analyst who was hired last year, you learn that the first step in your completing the assignment is to prepare a common-size balance sheet for Patterson. Complete the common-size balance sheet below: (Round to one decimal place.)
Common-Size Balance Sheet |
2016 |
|||
Cash and marketable securities |
$ |
500 |
% |
|
Accounts receivable |
6,000 |
|||
Inventory |
9,500 |
|||
Total current assets |
$ |
16,000 |
% |
|
Net property, plant, and equipment |
17,000 |
|||
Total assets |
$ |
33,000 |
% |
|
Accounts payable |
$ |
7,200 |
% |
|
Short-term debt |
6,800 |
|||
Total current liabilities |
$ |
14,000 |
% |
|
Long-term liabilities |
7,000 |
|||
Total liabilities |
$ |
21,000 |
% |
|
Total common stockholders’ equity |
12,000 |
|||
Total liabilities and shareholders’ equity |
$ |
33,000 |
% |
a. Common-size balance sheet mainly uses value of total assets as the base value. Each item of assets is represented as a percentage of total assets while each item of liabilities and shareholders’ equity is represented as a percentage of total liabilities and shareholders’ equity as follows:
Patterson Printing Company |
||
Common-Size Balance Sheet |
||
Amount |
Percent |
|
Cash and marketable securities |
$500 |
1.5% |
Accounts receivable |
$6,000 |
18.2% |
Inventory |
$9,500 |
28.8% |
Total current assets |
$16,000 |
48.5% |
Net property, plant, and equipment |
$17,000 |
51.5% |
Total assets |
$33,000 |
100.0% |
Accounts payable |
$7,200 |
21.8% |
Short-term debt |
$6,800 |
20.6% |
Total current liabilities |
$14,000 |
42.4% |
Long-term liabilities |
$7,000 |
21.2% |
Total liabilities |
$21,000 |
63.6% |
Total common stockholders' equity |
$12,000 |
36.4% |
Total liabilities and shareholders' equity |
$33,000 |
100.0% |
b. The base item in common-size income statement is usually total revenues or total sales. It represents each income statement line item as a percent of sales as follows:
Patterson Printing Company |
||
Common-Size Income Statement |
||
Amount |
Percent |
|
Revenues |
$30,000 |
100.0% |
Cost of goods sold |
$20,000 |
66.7% |
Gross profit |
$10,000 |
33.3% |
Operating expenses |
$8,000 |
26.7% |
Net operating income |
$2,000 |
6.7% |
Interest expense |
$900 |
3.0% |
Earnings before taxes |
$1,100 |
3.7% |
Income taxes |
$400 |
1.3% |
Net Income |
$700 |
2.3% |