Horizontal Analysis Example in Excel.xls - Company ABC,...

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

The 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 Assets6,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 Assets8,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 Liabilities4,437,0004,328,0004,195,0004,625,000Long Term Debt653,0001,207,000991,0001,342,000Total Liabilities5,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 Equity3,300,0002,768,0002,581,0001,628,000Total Liabilities and Equity8,390,0008,303,0007,767,0007,595,000
Company ABC, Inc,Balance SheetAs of12/31/201312/31/201212/31/201112/31/2010AssetsCurrent AssetsCash And Cash Equivalents137.28%144.46%78.37%100.00%Short Term Investments95.31%76.56%81.25%100.00%Net Receivables109.10%102.21%98.01%100.00%Inventory124.30%117.32%118.07%100.00%Other Current Assets108.40%110.80%140.00%100.00%Total Current Assets120.80%117.15%103.38%100.00%

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 4 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
N/A
Tags
Accounting, Balance Sheet, Generally Accepted Accounting Principles, long term debt

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture