Question

In: Finance

​(Preparing common-size financial​ statements) As the newest hire to the financial analysis group at Patterson Printing​...

​(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

%

Solutions

Expert Solution

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%


Related Solutions

As the newest hire to the financial analysis group at Patterson Printing​ Company, you have been...
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: LOADING.... 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....
Problem 3-18 Common-Size and Common-Base-Year Financial Statements In addition to common-size financial statements, common-base-year financial statements...
Problem 3-18 Common-Size and Common-Base-Year Financial Statements In addition to common-size financial statements, common-base-year financial statements are often used. Common-base year financial statements are constructed by dividing the current-year account value by base-year account value. Thus, the result shows the growth rate in the account.    Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2016 as the base-year. (Do not round intermediate calculations. Enter all common-size answers as a percent. Round your common-size answers to...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 500 1.5 % Accounts receivable 6,000 18.2 Inventory 9,450 28.7 Total current assets $ 15,950 48.4 % Net property, plant, and equipment 16,980 51.6 Total assets $ 32,930 100.0 % Accounts payable $ 7,240 22.0 % Short-term notes 6,750 20.5 Total current liabilities $ 13,990 42.5 % Long-term liabilities 6,990 21.2 Total liabilities $ 20,980 63.7 % Total common shareholders’...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: LOADING... to respond to your​...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: LOADING... to respond to your​ boss' request that you write up your assessment of the​ firm's financial condition.​ Specifically, write up a brief narrative that responds to the following​ questions: a. How much cash does Patterson have on hand relative to its total​ assets? b. What proportion of​ Patterson's assets has the firm financed using​ short-term debt?​ Long-term debt? c. What percent of​ Patterson's revenues does the firm have...
Problem 12-89A Preparing Common Size Statements The financial statements for Burch Industries follow: Burch Industries Consolidated...
Problem 12-89A Preparing Common Size Statements The financial statements for Burch Industries follow: Burch Industries Consolidated Income Statements (in thousands, except per share data) Year ended December 31, 2019 2018 2017 Revenues $3,930,984 $3,405,211 $3,003,610 Costs and expenses: Cost of goods sold $2,386,993 $2,089,089 $1,850,530 Selling and administrative 922,261 761,498 664,061 Interest 25,739 30,665 27,316 Other expenses (income) 1,475 2,141 (43) Total costs and expenses $3,336,468 $2,883,393 $2,541,864 Income before income taxes $594,516 $521,818 $461,746 Income taxes 229,500 192,600 174,700...
In a financial statement analysis, you are examining the common-size income statements for the XYZ Metrical...
In a financial statement analysis, you are examining the common-size income statements for the XYZ Metrical Company for the past 5 years and have noticed that the cost of goods as a percentage of sales has been increasing steadily. At the same time, EBIT as a percentage of sales has been decreasing. What might account for the trends in these ratios? What actions might managers take to improve these ratios?
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup window: LOADING... . Which company is doing a better job of getting sales dollars to net income? Where is the one company having an advantage over the other company in turning revenue into net income? Complete the table below: (Round to two decimal places. Net income to three decimal places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window: Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below: (Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart, Inc. Starbucks...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window:   LOADING... . Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below:  ​(Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
n addition to common-size financial statements, common-base year financial statements are often used. Common-base year financial...
n addition to common-size financial statements, common-base year financial statements are often used. Common-base year financial statements are constructed by dividing the current year account value by the base year account value. Thus, the result shows the growth rate in the account.    Construct the common-size balance sheet and common-base year balance sheet for the company. Use 2018 as the base year. (Do not round intermediate calculations. Enter your common-size answers as a percent and your common base year answers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT