Question

In: Finance

​(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 left over after paying all of its expenses​ (including taxes)? d. Describe the relative importance of​ Patterson's major expense​ categories, including cost of goods​ sold, operating​ expenses, and interest expenses. a. How much cash does Patterson have on hand relative to its total​ assets? The cash Patterson has on hand relative to its total assets is nothing​%. ​(Round to one decimal​ place.)

Common-Size Balance Sheet 2016:

Cash and marketable securities $ 540 1.6 %

Accounts receivable 6,020 18.2

Inventory 9,510 28.7

Total current assets $ 16,070 48.5 %

Net property, plant, and equipment 17,040 51.5

Total assets $ 33,110 100.0 %

Accounts payable $ 7,210 21.8 %

Short-term notes 6,840 20.7

Total current liabilities $ 14,050 42.4 %

Long-term liabilities 7,000 21.1

Total liabilities $ 21,050 63.6 %

Total common shareholders’ equity 12,060 36.4

Total liabilities and shareholders’ equity $ 33,110 100.0 %

Common-Size Income Statement 2016:

Revenues $ 30,030 100.0 %

Cost of goods sold (19,960) 66.5

Gross profit $ 10,070 33.5 %

Operating expenses (7,980) 26.6

Net operating income $ 2,090 7.0 %

Interest expense (860) 2.9

Earnings before taxes $ 1,230 4.1 %

Income taxes (447) 1.5

Net income $ 783 2.6 %

Solutions

Expert Solution

Solution :-

( a ) The cash Patterson have on its hands relative to its total asset is :- 1.6% according to the common size statement given .

( b) The proportion of Patterson asset that has been financed by short term debt is :- 42.4%

The proportion of Patterson asset that has been financed by long term debt is :- 21.1%

( c) The revenue left over after paying all tge expenses ( including taxes ) are Net income .

So, the percentage of Net income to revenue is 2.6%

( d ) Relative importance of Patterson major expenses :-

Cost of goods sold represent 66.5 % of Patterson sales

Operating expenses represents 26.6 % of sales .

Interest expense represent 2.9 % of sales .


Related Solutions

​(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’...
Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $...
Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 470 1.4 % Accounts receivable 5,990 18.2 Inventory 9,450 28.7 Total current assets $ 15,910 48.4 % Net property, plant, and equipment 16,990 51.6 Total assets $ 32,900 100.0 % Accounts payable $ 7,150 21.7 % Short-term notes 6,790 20.6 Total current liabilities $ 13,940 42.4 % Long-term liabilities 7,040 21.4 Total liabilities $ 20,980 63.8 % Total common shareholders’ equity 11,920 36.2 Total...
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...
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...
Use the data from the following financial statements in the popup​ window, LOADING... . The company...
Use the data from the following financial statements in the popup​ window, LOADING... . The company paid interest expense of $ 18 comma 700$18,700 for 20172017 and had an overall tax rate of 40 %40% for 20172017. Complete the statement of retained earnings for 20172017​, and determine the dividends paid last year. The distributed earnings is ​$nothing Partial Income Statement Year Ending 2017 Sales revenue $350,200 Cost of goods sold $142,000 Fixed costs $43,000 Selling, general, and administrative expenses $28,100...
​Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts....
​Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts. Assets Cash $25,000 3.4% Accounts receivable $125,000 Inventory 27.1% Total current assets $350,000 Gross plant and equipment 95.0% Less: accumulated depreciation $313,000 42.5% Net plant and equipment Total assets $737,000 100.0% Liabilities Accounts payable 15.7% Notes payable $29,000 3.9% Total current liabilities Long-term debt $248,000 33.6% Total liabilities $393,000 Common stock ($.01 par, 450,000 shares) $4,500 0.6% Paid-in capital $220,500 29.9% Retained earnings Total...
Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts....
Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts. Assets Cash $25,000 3.4% Accounts receivable $125,000 Inventory 27.1% Total current assets $350,000 Gross plant and equipment 95.0% Less: accumulated depreciation $313,000 42.5% Net plant and equipment Total assets $737,000 100.0% Liabilities Accounts payable 15.7% Notes payable $29,000 3.9% Total current liabilities Long-term debt $248,000 33.6% Total liabilities $393,000 Common stock  ($.01 par, 450,000 shares) $4,500 0.6% Paid-in capital $220,500 29.9% Retained earnings Total stockholders’...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT