Vertical Analysis Example in Excel.xls - Company ABC Inc Balance Sheet As of Assets Current Assets Cash And Cash Equivalents Short Term Investments Net

Vertical Analysis Example in Excel.xls - Company ABC Inc...

This preview shows page 1 - 3 out of 4 pages.

Company ABC, Inc,Balance SheetAs of12/31/201312/31/201212/31/201112/31/2010AssetsCurrent AssetsCash And Cash Equivalents1,587,0001,670,000906,0001,156,000Short Term Investments61,00049,00052,00064,000Net Receivables2,027,0001,899,0001,821,0001,858,000Inventory2,634,0002,486,0002,502,0002,119,000Other Current Assets271,000277,000350,000250,000Total Current Assets 6,580,0006,381,0005,631,0005,447,000Property Plant and Equipment486,000528,000484,000508,000Long Term Investments120,000113,00099,000101,000Goodwill1,204,0001,281,0001,553,0001,539,000Total Assets 8,390,0008,303,0007,767,0007,595,000LiabilitiesCurrent LiabilitiesAccounts Payable1,825,0001,790,0001,887,0001,694,000Short/Current Long Term Debt1,347,0001,505,0001,291,0001,621,000Other Current Liabilities1,265,0001,033,0001,017,0001,310,000Total Current Liabilities 4,437,0004,328,0004,195,0004,625,000Long Term Debt653,0001,207,000991,0001,342,000Total Liabilities 5,090,0005,535,0005,186,0005,967,000Stockholders' EquityCommon Stock209,000209,000209,000931,000Retained Earnings2,761,0001,905,0001,577,000535,000Treasury Stock321,000641,000791,000159,000Capital Surplus9,00013,0004,0003,000Total Stockholder Equity 3,300,0002,768,0002,581,0001,628,000Total Liabilities and Equity8,390,0008,303,0007,767,0007,595,000
Background image
Company ABC, Inc,Balance SheetAs of12/31/201312/31/201212/31/201112/31/2010AssetsCurrent AssetsCash And Cash Equivalents18.92%20.11%11.66%15.22%Short Term Investments0.73%0.59%0.67%0.84%Net Receivables24.16%22.87%23.45%24.46%Inventory31.39%29.94%32.21%27.90%Other Current Assets3.23%3.34%4.51%3.29%Total Current Assets 78.43%76.85%72.50%71.72%
Background image
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture