Sample Financial Statements in Excel.xls - Company ABC Inc Balance Sheet As of Assets Current Assets Cash And Cash Equivalents Short Term Investments

Sample Financial Statements in Excel.xls - Company ABC Inc...

This preview shows page 1 - 3 out of 3 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,Income StatementFor the year ending12/31/201312/31/201212/31/201112/31/2010Total Revenue14,492,000 14,883,000 13,322,000 11,990,000 Cost of Goods Sold7,352,000 7,780,000 6,993,000 6,260,000
Background image
Background image

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture