Course Hero Logo
Upload to Study
Expert Help

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

Doc Preview
Pages 3
Total views 100+
Company ABC, Inc, Balance Sheet As of12/31/201312/31/201212/31/201112/31/2010 Assets Current Assets Cash And Cash Equivalents1,587,0001,670,000906,0001,156,000 Short Term Investments61,00049,00052,00064,000 Net Receivables2,027,0001,899,0001,821,0001,858,000 Inventory2,634,0002,486,0002,502,0002,119,000 Other Current Assets271,000277,000350,000250,000 Total Current Assets 6,580,0006,381,0005,631,0005,447,000 Property Plant and Equipment486,000528,000484,000508,000 Long Term Investments120,000113,00099,000101,000 Goodwill1,204,0001,281,0001,553,0001,539,000 Total Assets 8,390,0008,303,0007,767,0007,595,000 Liabilities Current Liabilities Accounts Payable1,825,0001,790,0001,887,0001,694,000 Short/Current Long Term Debt1,347,0001,505,0001,291,0001,621,000 Other Current Liabilities1,265,0001,033,0001,017,0001,310,000 Total Current Liabilities 4,437,0004,328,0004,195,0004,625,000 Long Term Debt653,0001,207,000991,0001,342,000 Total Liabilities 5,090,0005,535,0005,186,0005,967,000 Stockholders' Equity Common Stock209,000209,000209,000931,000 Retained Earnings2,761,0001,905,0001,577,000535,000 Treasury Stock321,000641,000791,000159,000 Capital Surplus9,00013,0004,0003,000 Total Stockholder Equity 3,300,0002,768,0002,581,0001,628,000 Total Liabilities and Equity8,390,0008,303,0007,767,0007,595,000
Company ABC, Inc, Income Statement For the year ending12/31/201312/31/201212/31/201112/31/2010 Total 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
Course Hero Badge

End of preview

Want to read all 3 pages? Upload your study docs or become a member.
Unformatted text preview:Gross Profit 7,140,000 7,103,000 6,329,000 5,730,000 Operating Expenses 1,825,000 1,790,000 1,887,000 1,694,000 Research Development 1,347,000 1,505,000 1,291,000 621,000 Selling General and Administrative 1,265,000 1,033,000 1,017,000 1,310,000 Interest Expense 134,000 120,000 87,000 14,000 Other Expenses 145,000 1,450,000 234,000 1,344,000 Total Operating Expenses 4,716,000 5,898,000 4,516,000 4,983,000 Operating Income (or Loss) 2,424,000 1,205,000 1,813,000 747,000 Income Tax Expense 73,000 97,000 108,000 112,000 Net Income (or Loss) 2,351,000 1,108,000 1,705,000 635,000 Company ABC, Inc, Statement of Cash Flows For the year ending 12/31/2013 Cash flows from operating activities: Net income $2,351,000 Increase in accounts receivable ($128,000) Increase in inventory ($148,000) Increase in accounts payable $35,000 Net cash from operating activities $2,110,000 Cash flows from investing activities: Increase in Long-Term Investments ($7,000) Increase in Short-Term Investments ($12,000) Sale of equipment $42,000 Net cash from investing activities $23,000 Cash flows from financing activities: Decrease to Long-Term Debt ($554,000) Dividends Paid ($1,978,000) Sold Treasury Stock $316,000 Net cash from financing activities ($2,216,000) Net increase/(decrease) ($83,000) Cash, January 1, 2013 $1,670,000 Cash, December 31, 2013 $ 1,587,000