Spreadsheet: 92368d1291933301-problem-with-cash-flow-reconciliation-copy-of-copy-of-financial-model-1
Sheet: Pro Forma Statements

 |  |  | 2008 | 2009 | 2010 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | FY 2011
 | Income Statement
 | Sales | (a) | 219261 | 141998 | 3648288.34
 | Cost of Sales | (b) | 188943 | 107825 | 3171101 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8
 | Gross Profit
 | SG&A |  | 396800 | 549798 | 573018
 | Depreciation |  |  |  | 17784.41 | 818.5997666666668 | 841.6231038888891 | 935.929385490741 | 995.3305623992286 | 1005.408386359241 | 1016.984913253254 | 1016.7018313657 | 1028.090134176272 | 1027.621965273334 | 1018.828265852111 | 1010.18112808791 | 993.344775953111
 | Other Expenses
 | EBIT
 | Interest Expense |  | 4639 | 14710 | 3587 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.08
 | Other ext. ordinary expenses |  | 62 | 93
 | Pre-Tax Income
 | Income Tax |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.24
 | Net-Income |  |  | -530428
 | Balance Sheet |  | 2008 | 2009 | 2010 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Assets
 | Current Assets
 | Cash & Cash Equivalents |  | 54744 | 7400 | 144102.7042299176 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 | Accounts Receivable |  | 64708 | 141436
 | Inventory |  | 1019 | 36873 | 6189 | 6189 | 6189 | 6189 | 6189 | 6189 | 6189 | 6189 | 6189 | 6189 | 6189 | 6189 | 6189
 | Other Current Assets
 | Total Current-Assets
 | Non-Current Assets
 | Fixed Assets |  | 39145 | 40936 | 42473
 | Other Assets |  | 10380 | 11454 |  | 9934 | 9934 | 9934 | 9934 | 9934 | 9934 | 9934 | 9934 | 9934 | 9934 | 9934 | 9934
 | Total Non-Current Assets
 | Total Assets
 | Liabilities and Shareholders' Equity
 | Current Liabilities
 | Accounts Payable |  | 233770 | 767673 | 2633636
 | Short-term debt |  | 0 | 0
 | Other Current Liabilities |  | 7409 | 72757 | 156265
 | Total Current Liabilities
 | Non-Current Liabilities
 | Long-term debt |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Deferred Income Tax |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other Non-Current Liabilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Non-Current Liabilities
 | Total Liabilities
 | Shareholders' Equity
 | Paid-In Capital |  | 150000 | 150000 |  | 930000 | 930000 | 930000 | 930000 | 930000 | 930000 | 930000 | 930000 | 930000 | 930000 | 930000 | 930000
 | [NAME] |  | -221183 | -751611 | -992371
 | Total Shareholders' Equity
 | Total Liabilities and Shareholders' Equity
 | Check
 | Cash Flow Statement
 | Operating Activities
 | Net-Income
 | Add Depreciation
 | Decrease/(Increase) Accounts Receivable
 | Decrease/(Increase) Inventory
 | Decrease/(Increase) Other Current Assets
 | Increase/(Decrease) Accounts Payable
 | Increase/(Decrease) Other Current Liabilities
 | Increase/(Decrease) Deferred Income Tax
 | Increase/(Decrease) Other Non-Current Liabilities
 | Total Cash Flow from Operations
 | Investing Activities
 | Divestment/(Investment) in Fixed Assets
 | Divestment/(Investment) in Other Assets
 | Total Cash Flow from Investing
 | Financing Activities
 | From Issuance/(Repayment) Short-term Debt
 | From Issuance/(Repayment) Long-term Debt
 | From Sale/(Repurchase) of Equity
 | Total Cash Flow from Financing
 | Net Change in Cash & Cash Equivalents
 | Check
 | Beginning Cash Balance
 | Ending Cash Balance
 | Net Change in Cash Balance