Hi its me again.

We were given information to come up with 12 months income statement, and then Cash flow and balance.

I have started working on it too. But, thought of checking if you can help.

See attached docs for the spreadsheet to use and the PDF is the question page.

Income Statement Inputs Sales Cost of Sales Gross Profit Operating Expenses: Depreciation Labor Payroll Taxes Insurance Interest Expense Bad Debt Other Total Operating Expenses Profit Before Taxes Tax provision Net Profit INVENTORY Beginning balance Purchases Cost of goods sold Ending Inventory Start-up Month 1 Month 2 1 of 6 Month 3 Month 4 Month 5 Month 6 Income Statement Month 7 Sales Cost of Sales Gross Profit Operating Expenses: Depreciation Labor Payroll Taxes Insurance Interest Expense Bad Debt Other Total Operating Expenses Profit Before Taxes Tax provision Net Profit INVENTORY Beginning balance Purchases Cost of goods sold Ending Inventory Month 8 Month 9 2 of 6 Month 10 Month 11 Month 12 Total Cash Flow Projection Inputs CASH FLOWS Inflows Cash collections on: Current months sales prior month's sales 2 month's ago sales Investors' funds Debt proceeds TOTAL INFLOWS Outflows Inventory purchases Operating expenses: Labor Payroll taxes Insurance Other Asset acquisitions Debt repayment Taxes Shareholders TOTAL OUTFLOWS Net change in cash Beginning cash Ending cash Start-up Month 1 Month 2 3 of 6 Month 3 Month 4 Month 5 Month 6 Cash Flow Projection Inputs CASH FLOWS Inflows Cash collections on: Current months sales prior month's sales 2 month's ago sales Investors' funds Debt proceeds TOTAL INFLOWS Outflows Inventory purchases Operating expenses: Labor Payroll taxes Insurance Other Asset acquisitions Debt repayment Taxes Shareholders TOTAL OUTFLOWS Net change in cash Beginning cash Ending cash Month 7 Month 8 Month 9 4 of 6 Month 10 Month 11 Month 12 Total Balance Sheet Beginning Balance ASSETS Cash Accounts receivable Allowance for doubtful accounts Inventory Prepaid Insurance Fixed assets Accumulated depreciation Total Assets LIABILITIES & OWNERS' EQUITY Accounts payable Payroll taxes payable Income taxes payable Interest payable Long-term debt Owners' capital Retained earnings Total Liabilities & Owners' Equity Start-up Changes Month 1 5 of 6 Changes Month 2 Changes Month 3 Changes Month 4 Changes Month 5 Changes Month 6 Balance Sheet Changes Month 7 ASSETS Cash Accounts receivable Allowance for doubtful accounts Inventory Prepaid Insurance Fixed assets Accumulated depreciation Total Assets LIABILITIES & OWNERS' EQUITY Accounts payable Payroll taxes payable Income taxes payable Interest payable Long-term debt Owners' capital Retained earnings Total Liabilities & Owners' Equity Changes Month 8 Changes Month 9 6 of 6 Changes Month 10 Changes Month 11 Changes Month 12 Balance at 12/31/16