Question

In: Accounting

Using the common size (vertical) balance sheet, identify the significant trends, and compare to the industry...

Using the common size (vertical) balance sheet, identify the significant trends, and compare to the industry standards.

FY 2015 % FY 2014 % Industry
ASSETS
Cash and cash equivalents $                   4,046 10.05% $                   2,210 5.34% 4.20%
Inventory                       8,601 21.36%                       8,790 21.23% 19.56%
Assets of discontinued operations                          322 0.80%                       1,333 3.22%
Other current assets                       1,161 2.88%                       1,754 4.24% 3.32%
Total current assets $                 14,130 35.10% $                 14,087 34.02% 30.88%
Property and equipment
    Land                       6,125 15.21%                       6,127 14.80%
    Buildings and equipment                     27,059 67.21%                     26,614 64.28%
    Fixtures and equipment                       5,347 13.28%                       5,346 12.91%
    Computer hardware and software                       2,617 6.50%                       2,553 6.17%
    Construction-in-progress                          315 0.78%                          424 1.02%
Accumulated depreciation                   (16,246) -40.35%                   (15,106) -36.48%
Property and equipment, net $                 25,217 62.63% $                 25,958 62.69% 69.12%
Noncurrent assets of discontinued operations                             75 0.19%                          442 1.07%
Other noncurrent assets                          840 2.09%                          917 2.21%
Total assets $                 40,262 100.00% $                 41,404 100.00% 100.00%
LIABILITIES
Accounts payable $                   7,418 18.42% $                   7,759 18.74% 13.37%
Accrued and other current liabilities                       4,236 10.52%                       3,783 9.14% 10.40%
Current portion of long-term debt and other borrowings                          815 2.02%                             91 0.22%
Liabilities of discontinued operations                          153 0.38%                          103 0.25%
Total current liabilities $                 12,622 31.35% $                 11,736 28.35%
Long-term debt and other borrowings $                 11,945 29.67% $                 12,705 30.69% 32.08%
Deferred income taxes                          823 2.04%                       1,321 3.19%
Noncurrent liabilities of discontinued operations                             18 0.04%                          193 0.47%
Other noncurrent liabilities                       1,897 4.71%                       1,452 3.51%
Total noncurrent liabilities $                 14,683 36.47% $                 15,671 37.85%
Total liabilities $                 27,305 67.82% $                 27,407 66.19% 60.52%
SHAREHOLDERS' INVESTMENT
Common stock $                        50 0.12% $                        53 0.13%
Additional paid-in capital                       5,348 13.28%                       4,899 11.83%
Retained earnings                       8,188 20.34%                       9,644 23.29%
Accumulated other comprehensive loss
    Pension and other benefit liabilities                         (588) -1.46%                         (561) -1.35%
    Currency translation adjustment and cash flow hedges                           (41) -0.10%                           (38) -0.09%
Total shareholders' investment $                 12,957 32.18% $                 13,997 33.81% 39.48%
Total liabilities and shareholders' investment $                 40,262 100.00% $                 41,404 100.00% 100.00%

Solutions

Expert Solution


Related Solutions

Using the horizontal analysis of the balance sheet, identify the significant trends FY 2015 FY 2014...
Using the horizontal analysis of the balance sheet, identify the significant trends FY 2015 FY 2014 $ Change % Change FY 2013 $ Change % Change ASSETS Cash and cash equivalents $                   4,046 $                   2,210 $   1,836 83.08% $                      670 $   1,540 229.85% Inventory                       8,601                       8,790 $    (189) -2.15%                       8,278 $      512 6.19% Assets of discontinued operations                          322                       1,333 $ (1,011) -75.84%                          793 $      540 68.10% Other current assets                       1,161                       1,754 $   ...
To create a common size balance sheet ____________ all items on the balance sheet by ____________....
To create a common size balance sheet ____________ all items on the balance sheet by ____________. 1. multiply; owners equity 2. multiply; total assets 3. divide; owners equity 4. divide; total assets 5. multiply; debt
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the...
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the base year. (Do not round intermediate calculations. Enter all common-size answers as a percent. Round your common-size answers to 2 decimal places (e.g., 32.16) and common-base-year answers to 4 decimal places (e.g., 32.1616).) JARROW CORPORATION 2013 Common-size 2014 Common-size Common-base year Assets   Current assets     Cash $8,964 % $10,904 %     Accounts receivable 22,353 % 24,837 %     Inventory 38,722 % 43,697 %         Total $70,039 % $79,438...
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.) ($ millions) January 31, 2015 February 1, 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 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...
A common size balance sheet expresses the balance sheet items as a percentage of total assets....
A common size balance sheet expresses the balance sheet items as a percentage of total assets. Select one: True False
Perform a horizontal, common-size analysis of the balance sheet items, using 2017 as the base year...
Perform a horizontal, common-size analysis of the balance sheet items, using 2017 as the base year (meaning each line item for 2017 is 100%). Also include a horizontal analysis of sales and net income. Balance Sheet April 30 (in thousands of dollars) 2019 2018 2017 Assets:    Current assets $ 1,700 $1,120 $1,544    Plant and equipment (net) 8,110 7,830 5,404    Other assets   1,004    695    772    Total assets $10,814 $9,645 $7,720 Liabilities and Stockholders' Equity:    Current liabilities $   950 $  880 $  772    Long-term liabilities...
Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each...
Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each company. Review each company's percentage of total assets. Are these companies operating with similar philosophies or in similar industries? What appears to be the major difference in financing for these two companies? Account Balance Sheet Company 1 Balance. Sheet Company 2 Current Assets Cash $5,377 $299 Investments $4,146 $354 Accts. Rec. $8,100 $221 Inventory $5,372 $494 Total Current $22,995 $1,368 Long Inv. $84 $307...
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi and Coca...
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi and Coca Cola for 2016 and 2017. Write a paragraph highlighting what you learn from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2016 and 2017 and between Coke and Pepsi.
​(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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT