Question

Using the following balance sheet, prepare and analyze the common size balance sheet: Assets    &nb...

Using the following balance sheet, prepare and analyze the common size balance sheet:

Assets                                                                   Liabilities and stockholders’ equity

Current assets Current liabilities             

Cash 4 Accounts payable 28

Short term investments 9 Current portion of long term debt 12

Accounts receivable 32 Total current liabilities 40

Inventory 41

Prepaid expenses 2 Long term liabilities

Deferred taxes, current 7 Long term debt    48

Total current assets 95 Total liabilities 88

Long term assets Stockholders equity

Property & equipment 53 Common stock and paid in capital 51

Goodwill 12 Retained earnings 30

Long term investments 8

Other assets 1                          Total stockholders’ equity    81

Total assets 169                         Total liabilities and equity 169

Analyze the common size income statements below for 3T Company:

2015                       2014

Net sales                                                                                            100%                     100%

COGS                                                                                                 89%                        87%

Gross margin                                                                                     11%                        13%

Selling, general and administrative expenses 7%                          9%

Restructuring, asset impairments and other charges 0%                          9%

Income / (loss) from operations 4%                          (5%)

Interest expense (1%)                       (2%)

Income / (loss) before taxes 3%                          (7%)

Provision for / (benefits from) income taxes 1%                          0%

Income/(loss) after taxes 2%                          (7%)

Discontinued operations, net 6%                          1%

Net income (loss) 8%                          (6%)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans

common size balance sheet

Particulars

($ )

as of

2015

(%ge )

as of

(2015)

Current assets
Cash $4 2.37%
Short term investments $9 5.33%
Accounts receivable $32 18.93%
Inventory $41 24.26%
Prepaid expenses $2 1.18%
Deferred taxes(current) $7 4.14%
Total current assets $95 56.21%
Total fixed assets $74 43.79%
Total Assets $169 100%
Current liabilities
Accounts payable $28 16.57%
Current portion of long term debt $12 7.10%
Total current liabilities $40 23.67%
Long-term debt $48 28.40%
Total liabilities $88 52.07%
Shareholders’ equity $81 47.93%
Total liabilities and equity $169 100%

analyze the common size balance sheet

From the table above, we can deduce that cash represents 2.37% of the total assets while inventory represents 24.26% of the total assets. In the liabilities section, we can deduce that accounts payable represent 16.57%, long-term debt 28.40%, and shareholder’s equity 47.93% of the total liabilities and stockholder’s equity.

ans

Analyze the common size income statements

By looking at this income statement, we can see that in 2015, the COGS of that the company is increase by 2% in comparison to 2014 due to this gross margin is decline in 2015 by 2 %. The company also pays interest to the shareholders, which is 1% of the total revenue for the year. The net operating income or earnings after interest and taxes for 2015 represent 2% of the total revenues, and it shows the health of the business’s core operating areas.

Add a comment
Know the answer?
Add Answer to:
Using the following balance sheet, prepare and analyze the common size balance sheet: Assets    &nb...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Common-Size Balance Sheets Following is the balance sheet for 3M Company. Prepare common-size balance sheets for...

    Common-Size Balance Sheets Following is the balance sheet for 3M Company. Prepare common-size balance sheets for 2014 and 2013 Round answers to one decimal place. (i.e., 0.8867 88.7%) 3M Company and Subsidiaries Common-size Balance Sheets Dec. 31, 2014 Dec. 31, 2013 (s millions) Cash and cash equivalents Accounts receivable Total inventories 01% $3.337 ,253 3,864 0 9% 1,279 0% 12,733 1,575 8,652 ,345 1,688 $2,523 4,238 3,706 0% 0% Other current assets 1,298 11,765 930 8,489 7,050 Total current assets...

  • Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target's common-size balance sheets...

    Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target's common-size balance sheets as of January 31, 2015 and February 1, 2014 (Round your answers to one decimal place.) January 31, February 1, (5 millions) 2015 2014 Assets Cash and cash equivalents 52.210 5670 Inventory 8.790 Other current assets 2.625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders' investment Accounts payable 57,759...

  • Prepare a common-size balance sheet from the following information for Carla Vista Supply Company. (Round answers...

    Prepare a common-size balance sheet from the following information for Carla Vista Supply Company. (Round answers to 1 decimal place, e.g. 52.7%.) ​​​​​​​ Carla Vista Supply Company Balance Sheet as of June 30, 2017($ thousands) % of Assets Liabilities and Equity: Accounts payable Notes payable Assets: % of Assets Cash and marketable securities $395,000 706,000 1,162,000 42,600 $2,305,600 1,982,000 $817,000 112,000 43,100 $972,100 1,154,000 $2,126,100 1,312,000 849,500 $2,161,500 $4,287,600 Accounts receivable Inventory Accrued income taxes Other current assets Total current...

  • Analyzing. Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance...

    Analyzing. Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of General Mills, Inc. Income Statement, Fiscal Years Ended (in s millions) May 26, 2013 May 27, 2012 May 29, 2011 Net Sales $16.657.9 $14.380 2 Cost of Sales 11.350.2 10.613.2 892 Selling general and administrative expenses 3.5523 3.380.7 2. 1920 Divestitures (gain) Restructuring impairment, and other exit costs 101.6 Operating profit 2851.8 2562.4 27745 net 351.9 Earnings before income taxes and after...

  • Calculate common size balance sheet. Please include excel reference formulas. The requirement is to calculate a...

    Calculate common size balance sheet. Please include excel reference formulas. The requirement is to calculate a Common Size Balance Sheet. It is shown in green. glcons Screenshot - JW ADO- Charts Charts Мар- ✓ fi Dec 31, 2018 Paste Companies Financial Statements in Space proviced for each company: Make sure that you write if the info is in million COMPANY A: (Coca-Cola) Add most current fiscal year end date first last years Calculate Financial Info Common Size Balance Sheet Dec...

  • please complete the balance sheet. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following...

    please complete the balance sheet. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835,4 Selling general and administrative expenses 3.192.0 3,162.7 Divestitures (gain), net (17.4) Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2.606.1 Interest, net 401.6 Earnings before income tax...

  • Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance...

    Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of General Mills, Inc. Income Statement, Fiscal Years Ended (in $ millions) May 26, 2013 May 27, 2012 May 29, 2011 Net Sales $ 17,774. 1 5 16.657.9 5 14,880.2 Cost of Sales 11.350.2 10.613.2 8,926.7 Selling, general and administrative expenses 3.552.3 3.380.7 3.192.0 Divestitures (gain) (17.4) Restructuring, impairment and other exit costs 19.8 101.6 Operating profit 2.851.8 2.562.4 2.774.5 Interest, net 316.9...

  • Using vertical analysis, prepare a common size comparative balance sheet. (Round percentages to 0 decimal places,...

    Using vertical analysis, prepare a common size comparative balance sheet. (Round percentages to 0 decimal places, eg, 12%.) Delta COMPANY Comparative Balance Sheet December 31, 2017 2016 Amount Percentage Amounft $280 520 ssets Percentage Current assets $450 Plant assets 550 Total assets Liabilities and stockholders' equity Current liabilities Long-term debt Common stock $1,000 $800 $120 160 320 200 $180 250 310 Retained earnings 260 Total liabilities and stockholders' equity $1,000 $800

  • How to Analyze (A) company Common Size Balance Sheets? COMMON SIZE BALANCE SHEETS AS OF December...

    How to Analyze (A) company Common Size Balance Sheets? COMMON SIZE BALANCE SHEETS AS OF December 31, December 31, 2018 2008 December 31, 1998 19.5% 5.8% 10.6% 10.3% 46.2% 33.3% 11.5% 16.8% 12.4% 74.1% 4.0% 53.6% 4.6% 3.2% 65.5% 38.0% 8.9% 6.9% 100.0% 10.3% 5.3% 10.4% 100.0% 4.6% 28.7% 1.2% 100.0% ASSETS 9 Current Assets: 10 Cash and Equivalents 11 Marketable Securities 12 Inventories 13 Accounts Receivable and Other 14 Total Current Assets 15 16 Net Property and Equipment 17...

  • Common-Size Balance Sheet Cash and marketable securities Accounts receivable Inventory Total current assets Net property, plant,...

    Common-Size Balance Sheet Cash and marketable securities Accounts receivable Inventory Total current assets Net property, plant, and equipment Total assets Accounts payable 2016 470 5,990 9,550 16,010 17,000 33,010 7,150 1.4 % 18.1 28.9 48.5 % 51.5 100.0 % 21.7 % Short-term notes Total current liabilities Long-term liabilities Total liabilities Total common shareholders' equity Total liabilities and shareholders' equity 6,750 13,900 6,950 20,850 12,160 33,010 20.4 42.1 % 21.1 63.2 % 36.8 100.0 % $ Common-Size Income Statement 2016 100.0...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT