ATC 1-812345678910111213141516171819202122232425262728293031323334A B CSimple CompanyIncome StatementFor Year Ended 12-31-13Revenue 700Expenses -300Net Income =SUM(B4,B5)Statement Of Changes In EquityFor Year Ended 12-31-13Beginning Common Stock 0Plus: Stock Issued 6100Ending Common Stock =SUM(B10,B11)Beginning Retained Earnings 0Plus: Net Income =SUM(B4,B5)Less: Dividends -100Ending Retained Earnings =SUM(B14,B15,B16)Total Stock Holders Equity =SUM(B12,B17)Balance SheetAs Of The End Of The Year 12-31-13Assets Cash 5000 Land 4400Total Assets =SUM(B24,B25)Liabilities 3000Stockholders Equity Common Stock =SUM(B10,B11) Retained Earnings =SUM(B14,B15,B16)Total Stockholders Equity =SUM(B30,B31)Total Liabilities and Stockholders Equity =SUM(B28,B32)ATC 1-812345678910111213141516171819202122232425262728293031323334D E FStatement Of Cash FlowsFor Year Ended 12-31-13Cash Flows From Operating Activites Cash Received From Customers 700 Cash Paid For Expenses -300Net Cash Flows From Operating Activites =SUM(F6,F7)Cash Flows from Investing Activites Cash Paid For Land -4400Cash Flows from Financing Activities Cash Received from Borrowing Funds 3000 Cash Paid to Reduce Debt 0 Cash Received from Stock Issue 6100 Cash Paid for Dividends -100Net Cash Flow from Financing Activites =SUM(F14,F15,F16,F17)Net Charge In Cash =SUM(F8,F11,F18)Plus: Beginning Cash Balance 0Ending Cash Balance
View Full Document