Spreadsheet: 81347d1281552199-macro-with-assigned-column-each-time-sample-cash-report
Sheet: Fin Stmts

FOR THE PERIOD OF JANUARY 1 - DECEMBER 31, 2010
 |  | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Forecast | Forecast | Forecast | Forecast | Forecast | TOTAL
 |  | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2010
Revenue:
Service
 | Revenue | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 1500000
 | [NAME] | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 80000 | 80000 | 80000 | 80000 | 80000 | 80000 | 840000
Gross Profit |  | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 70000 | 70000 | 70000 | 70000 | 70000 | 70000 | 660000
Gross Margin |  | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4666666666666667 | 0.4666666666666667 | 0.4666666666666667 | 0.4666666666666667 | 0.4666666666666667 | 0.4666666666666667 | 0.44
Product
 | Revenue | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 1000 | 5000 | 5000 | 5000 | 5000 | 5000 | 56000
 | [NAME] | 500 | 500 | 500 | 500 | 500 | 500 | 100 | 500 | 500 | 500 | 500 | 500 | 5600
Gross Profit |  | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 900 | 4500 | 4500 | 4500 | 4500 | 4500 | 50400
Gross Margin |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
 | TOTAL REVENUE | 105000 | 105000 | 105000 | 105000 | 105000 | 105000 | 151000 | 155000 | 155000 | 155000 | 155000 | 155000 | 1556000
 | TOTAL COGS | 60500 | 60500 | 60500 | 60500 | 60500 | 60500 | 80100 | 80500 | 80500 | 80500 | 80500 | 80500 | 845600
 | GROSS PROFIT | 44500 | 44500 | 44500 | 44500 | 44500 | 44500 | 70900 | 74500 | 74500 | 74500 | 74500 | 74500 | 710400
 | GROSS MARGIN | 0.4238095238095238 | 0.4238095238095238 | 0.4238095238095238 | 0.4238095238095238 | 0.4238095238095238 | 0.4238095238095238 | 0.4695364238410596 | 0.4806451612903226 | 0.4806451612903226 | 0.4806451612903226 | 0.4806451612903226 | 0.4806451612903226 | 0.4565552699228792
Operating Expenses:
 | Advertising, PR & Promotion | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 26000 | 25000 | 25000 | 25000 | 25000 | 25000 | 301000
 | Automobile Expenses | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Bank & Credit Card Fees | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Computer Expense | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Commissions (Outside Sales Force) | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Depreciation | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Equipment Leasing, Repairs & Maint | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Insurance Expense | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Meals & Entertainment | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | [NAME] | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Office Supplies & Expense | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Outside Services | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Professional Services | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Rent Expense | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5200 | 5200 | 5200 | 5200 | 5200 | 5200 | 61200
 | Telephone & Utilities | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
 | Travel | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 12000
Total Operating Expense |  | 44000 | 44000 | 44000 | 44000 | 44000 | 44000 | 45200 | 44200 | 44200 | 44200 | 44200 | 44200 | 530200
 | Net Income (loss) Pre-Tax | 500 | 500 | 500 | 500 | 500 | 500 | 25700 | 30300 | 30300 | 30300 | 30300 | 30300 | 180200