Docstoc

Financial model

Document Sample
Financial model Powered By Docstoc
					Company name
Financial Model: Table of Contents

1) PRELIMINARY STATEMENTS - Instructions - Assumptions 2) SUMMARY STATEMENTS - Income Statement - Balance Sheet - Statement of Sources & Uses - Revenue, Gross Margin, & Profit Graph - Breakeven Chart 3) DETAILED FINANCIAL STATEMENTS - Receipts & Disbursements - Statement of Sources & Uses - Income Statement - Balance Sheet 4) SALES PROJECTIONS AND MARGIN ANALYSES - Product One - Product Two - Product Three - Services 5) STAFFING PLAN 6) EQUIPMENT PURCHASES 7) MANUFACTURING & INVENTORY 8) RENT & TAXES 9) FINANCING ACTIVITIES

Page 1 Page 2 Page 4 Page 5 Page 6 Page 7 Page 8 Page 9 Page 12 Page 15 Page 21 Page 24 Page 27 Page 30 Page 33 Page 36 Page 42 Page 48 Page 51 Page 54
Version 3.2 (manufacturing)

Company name
Financial Model: Instructions

1) ENTERING INFORMATION INTO THE MODEL: The DETAIL Worksheet. - Enter all inputs & assumptions in either the Assumptions page or the DETAIL worksheet. - Inputs are shaded yellow and appear blue when entered. - All other cells are protected and their formulas cannot be altered or seen without unprotecting the sheet. - At the top of the worksheet are three check lines. Values in each of these cells should always equal zero. - For information on the principles of financial projections, please contact a Coopers & Lybrand Emerging Company Services Consultant. 2) VIEWING THE RESULTS: The Assumptions Page, Summary Statements, and Revenue Growth and Breakeven Charts. - Click on the Assumptions tab to view all inputs and underlying assumptions for the financial model. - Click on the Summary Statements tab to view the annual Income Statement, Balance Sheet, and Statement of Sources & Uses for each of the five years projected. - At the top of the Summary Statements sheet are three check lines similar to those in the DETAIL worksheet. These should equal zero at all times as well. - Click on the Revenue Growth Chart tab to view the growth in revenues over the fiveyear projection period. - Click on the Breakeven Chart tab to view the cash flow breakeven point. - Data for the Assumptions page and Financial Charts are drawn automatically from the DETAIL worksheet. You do not need to add anything more to these sheets. 3) CUSTOMIZING THE FINANCIAL MODEL - To view the formula cells, choose Protection from the TOOLS menu and select Unprotect Worksheet. To protect the sheet again, choose Protection and select Protect Worksheet. - The variable inputs in the DETAIL worksheet are designed to accomodate most business models; however, the financial model can be tailored to suit specific business needs or operating procedures. - Structural changes to the model, such as additional product lines, extra departments, or embedded sales forecasts, require modifications of the underlying formulas. To make such changes, please contact an ECS Consultant. 4) PRINTING THE FINANCIAL STATEMENTS - To print the entire model, choose Print from the FILE menu and select "Entire Workbook". Click OK. - To print an individual worksheet (such as the Assumptions sheet only) click on the tab of the sheet you would like to print, choose Print from the FILE menu, and select "Selected Sheet". Click OK.
Page 1

Company name
Fin an cial Mo d el: A ssu m p tio n s

SALES

UNITS SALES Product One Product Two Product Three Services

2005 -

2006 -

2007 -

2008 -

2009 -

AVERAGE UNIT PRICE Product One Product Two Product Three Services

2005 -

2006 -

2007 -

2008 -

2009 -

COST OF GOODS

AVERAGE UNIT COST Product One Product Two Product Three Services

2005 -

2006 -

2007 -

2008 -

2009 -

Returns.................................................................................................................................................................................................." 0% (as a percentage of Product One revenue).................................................................................................................................................................................... Returns.................................................................................................................................................................................................." 0% (as a percentage of Product Two revenue).................................................................................................................................................................................... Returns.................................................................................................................................................................................................." 0% (as a percentage of Product Three revenue).................................................................................................................................................................................... Returns.................................................................................................................................................................................................." 0% (as a percentage of Services revenue)....................................................................................................................................................................................

BALANCE SHEET

Accounts Receivable (adjustable up to 360 days)................................................................................................................................................................................................................ 60 days (in days)................................................................................................................................................................................................................ Accounts Payable (fixed at 30 days)..................................................................................................................................................................................................................... 30 days (in days)..................................................................................................................................................................................................................... Salaries Payable (fixed at 15 days)............................................................................................................................................................................................................................ 15 days (in days)............................................................................................................................................................................................................................ Taxes Payable (fixed at 90 days)............................................................................................................................................................................................................................. 90 days (in days)............................................................................................................................................................................................................................. Inventory (adjustable up to 360 days).......................................................................................................................................................................................................................... 0 days (in days).......................................................................................................................................................................................................................... Available Credit Line......................................................................................................................................................................................................................................... 0% (as a percentage of net accounts receivable)................................................................................................................................................................................................ Maximum Credit Line Used..................................................................................................................................................................................................................................... $0 (amount borrowed not to exceed)................................................................................................................................................................................................... Capital Equipment Lease Term (1 year minimum).............................................................................................................................................................................................................. 3 years (in years).............................................................................................................................................................................................................. Long Term Borrowings Term (1 year minimum).............................................................................................................................................................................................................. 5 years (in years)..............................................................................................................................................................................................................

DEPRECIATION Content Engineering Sales & Marketing Administration

Hardware 3 years 3 years 3 years 3 years

Software 3 years 3 years 3 years 3 years

Furn & Fixtures 3 years 3 years 3 years 3 years

Page 2

Company name
Fin an cial Mo d el: A ssu m p tio n s

EXPENSES

HEADCOUNT Content Engineering Sales & Marketing Administration TOTAL

2005 -

2006 -

2007 -

2008 -

2009 -

PER PERSON EXPENSES Content Engineering Sales & Marketing Administration

Supplies 100 100 100 100

Travel & Meals 500 500 2,500 1,000

Phone/Postage 100 100 300 250

EQUIPMENT PURCHASES Content Engineering Sales & Marketing Administration

Hardware 3,000 3,500 2,500 1,500

Software 1,500 1,500 1,000 1,000

Furn & Fixtures 1,000 1,000 1,000 1,000

Benefits & Taxes....................................................................................................................................................................................... 25% (as a percentage of salaries)....................................................................................................................................................................................... Salary Increases.................................................................................................................................................................................................. 5% (as an annual percentage).................................................................................................................................................................................................. Sales Commissions..................................................................................................................................................................................................... 100% (as a percentage of sales)..................................................................................................................................................................................................... Total Sales Through Commissions................................................................................................................................................... 10% (as a percentage of total revenue)................................................................................................................................................... Business Insurance.................................................................................................................................................................................................. 1% (as a percentage of total revenue)................................................................................................................................................................................................... Anticipated Bad Debt................................................................................................................................................................................................... 1% (as a percentage of collections)........................................................................................................................................................................................................ Interest Revenue........................................................................................................................................................................................................................... 4% (as a percentage of cash balance)....................................................................................................................................................................................................... Interest Expense On Credit Line.................................................................................................................................................................................................... 10% (as a percentage of outstanding balance)...................................................................................................................................................................................................... Interest Expense On Capital Equipment Lease.................................................................................................................................................................................................... 10% (as a percentage of outstanding balance)...................................................................................................................................................................................................... Interest Expense On Long Term Borrowings.................................................................................................................................................................................................... 10% (as a percentage of outstanding balance)...................................................................................................................................................................................................... Combined Federal & State Tax Rate................................................................................................................................................................................. 40% (as a percentage of positive cumulative income)................................................................................................................................................... Office Rent................................................................................................................................................................................................................ $1.50 (per square foot)....................................................................................................................................................................................................... Minimum Office Space...................................................................................................................................................................................................................... 250 sq ft (square footage per person)....................................................................................................................................................................................................... Term of Office Lease...................................................................................................................................................................................................................... 12 mos (in months)....................................................................................................................................................................................................... Utilities Expense........................................................................................................................................................................................................... $0.15 (per square foot)....................................................................................................................................................................................................... Maintanence Expense................................................................................................................................................................................................ $0.10 (per square foot).......................................................................................................................................................................................................

Page 3

RECEIPTS & DISBURSEMENTS Company name
12-Nov-08 8:39 PM BEGINNING CASH Receipts Collections Financings Borrowings Interest Revenue Total receipts Disbursements Salaries Benefits & Empl Taxes Incentives/commissions Direct Material Returns Advertising Promotional Material Trade Shows Supplies/Materials Travel & Meals Telephone/Postage Maintenance & Repair Rent Utilities Insurance Consultants Professional Services Taxes Equipment Purchases Debt Repayments Interest Expense Prior Accounts Payable Total Disbursements Changes in Cash ENDING CASH Month 1 Jan-05 0 Month 2 Feb-05 0 Month 3 Mar-05 0 Month 4 Apr-05 0 Month 5 May-05 0 Month 6 Jun-05 0 Month 7 Jul-05 0 Month 8 Aug-05 0 Month 9 Sep-05 0 Month 10 Oct-05 0 Month 11 Nov-05 0 Month 12 Dec-05 0 Total 2005 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Page 9

RECEIPTS & DISBURSEMENTS Company name
12-Nov-08 8:39 PM BEGINNING CASH Receipts Collections Financings Borrowings Interest Revenue Total receipts Disbursements Salaries Benefits & Empl Taxes Incentives/commissions Direct Material Returns Advertising Promotional Material Trade Shows Supplies/Materials Travel & Meals Telephone/Postage Maintenance & Repair Rent Utilities Insurance Consultants Professional Services Taxes Equipment Purchases Debt Repayments Interest Expense Prior Accounts Payable Total Disbursements Changes in Cash ENDING CASH Month 13 Jan-06 0 Month 14 Feb-06 0 Month 15 Mar-06 0 Month 16 Apr-06 0 Month 17 May-06 0 Month 18 Jun-06 0 Month 19 Jul-06 0 Month 20 Aug-06 0 Month 21 Sep-06 0 Month 22 Oct-06 0 Month 23 Nov-06 0 Month 24 Dec-06 0 Total 2006 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Page 10

RECEIPTS & DISBURSEMENTS Company name
12-Nov-08 8:39 PM BEGINNING CASH Receipts Collections Financings Borrowings Interest Revenue Total receipts Disbursements Salaries Benefits & Empl Taxes Incentives/commissions Direct Material Returns Advertising Promotional Material Trade Shows Supplies/Materials Travel & Meals Telephone/Postage Maintenance & Repair Rent Utilities Insurance Consultants Professional Services Taxes Equipment Purchases Debt Repayments Interest Expense Prior Accounts Payable Total Disbursements Changes in Cash ENDING CASH Total 2007 0 Total 2008 0 Total 2009 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Page 11

STATEMENT OF SOURCES AND USES Company name
12-Nov-08 8:39 PM BEGINNING CASH Sources of Cash Net Income Add Depr/Amort Issuance of Preferred Stock Issuance of Common Stock Plus Changes In: Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Additions to Line of Credit (0% of net A/R) Additions to Capital Equipment Lease (3 years) Additions to Long Term Debt (5 years) Total Sources of Cash Uses of Cash Buyback of Preferred Stock Buyback of Common Stock Less Changes In: Net Accounts Rec Inventory (0 days) Gross Fixed Assets Reductions To Credit Line Reductions To Capital Equipment Lease Month 1 Jan-05 0 Month 2 Feb-05 0 Month 3 Mar-05 0 Month 4 Apr-05 0 Month 5 May-05 0 Month 6 Jun-05 0 Month 7 Jul-05 0 Month 8 Aug-05 0 Month 9 Sep-05 0 Month 10 Oct-05 0 Month 11 Nov-05 0 Month 12 Dec-05 0 Total 2005 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

Page 12

STATEMENT OF SOURCES AND USES Company name
12-Nov-08 8:39 PM BEGINNING CASH Sources of Cash Net Income Add Depr/Amort Issuance of Preferred Stock Issuance of Common Stock Plus Changes In: Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Additions to Line of Credit (0% of net A/R) Additions to Capital Equipment Lease (3 years) Additions to Long Term Debt (5 years) Total Sources of Cash Uses of Cash Buyback of Preferred Stock Buyback of Common Stock Less Changes In: Net Accounts Rec Inventory (0 days) Gross Fixed Assets Reductions To Credit Line Reductions To Capital Equipment Lease Month 13 Jan-06 0 Month 14 Feb-06 0 Month 15 Mar-06 0 Month 16 Apr-06 0 Month 17 May-06 0 Month 18 Jun-06 0 Month 19 Jul-06 0 Month 20 Aug-06 0 Month 21 Sep-06 0 Month 22 Oct-06 0 Month 23 Nov-06 0 Month 24 Dec-06 0 Total 2006 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

Page 13

STATEMENT OF SOURCES AND USES Company name
12-Nov-08 8:39 PM BEGINNING CASH Sources of Cash Net Income Add Depr/Amort Issuance of Preferred Stock Issuance of Common Stock Plus Changes In: Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Additions to Line of Credit (0% of net A/R) Additions to Capital Equipment Lease (3 years) Additions to Long Term Debt (5 years) Total Sources of Cash Uses of Cash Buyback of Preferred Stock Buyback of Common Stock Less Changes In: Net Accounts Rec Inventory (0 days) Gross Fixed Assets Reductions To Credit Line Reductions To Capital Equipment Lease Total 2007 0 Total 2008 0 Total 2009 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

0 0 0 0 0 0 0

Page 14

Reductions To Long Term Debt Total Uses CHANGES IN CASH ENDING CASH

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

Page 15

Reductions To Long Term Debt Total Uses CHANGES IN CASH ENDING CASH

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

Page 16

Reductions To Long Term Debt Total Uses CHANGES IN CASH ENDING CASH

0 0 0 0

0 0 0 0

0 0 0 0

Page 17

INCOME STATEMENT Company name
12-Nov-08 8:39 PM Revenue Product One Product Two Product Three Services Total Revenue Expenses Cost of Goods Sold Direct Labor Other Direct Costs Direct Materials Returns Total COGS Gross Margin % of Sales Operating Expenses ENGINEERING Headcount Salary Incentives Benefits & Taxes Consultants Supplies/ Materials Travel & Meals Telephone/Postage Operations Setup Depreciation Total Expenses % of Sales SALES & MARKETING Headcount Salary Incentives/Commissions Benefits & Taxes Supplies Travel & Meals Telephone/Postage Depreciation Total Expenses % of Sales Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

Page 18

INCOME STATEMENT Company name
12-Nov-08 8:39 PM Revenue Product One Product Two Product Three Services Total Revenue Expenses Cost of Goods Sold Direct Labor Other Direct Costs Direct Materials Returns Total COGS Gross Margin % of Sales Operating Expenses ENGINEERING Headcount Salary Incentives Benefits & Taxes Consultants Supplies/ Materials Travel & Meals Telephone/Postage Operations Setup Depreciation Total Expenses % of Sales SALES & MARKETING Headcount Salary Incentives/Commissions Benefits & Taxes Supplies Travel & Meals Telephone/Postage Depreciation Total Expenses % of Sales Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

Page 19

INCOME STATEMENT Company name
12-Nov-08 8:39 PM Revenue Product One Product Two Product Three Services Total Revenue Expenses Cost of Goods Sold Direct Labor Other Direct Costs Direct Materials Returns Total COGS Gross Margin % of Sales Operating Expenses ENGINEERING Headcount Salary Incentives Benefits & Taxes Consultants Supplies/ Materials Travel & Meals Telephone/Postage Operations Setup Depreciation Total Expenses % of Sales SALES & MARKETING Headcount Salary Incentives/Commissions Benefits & Taxes Supplies Travel & Meals Telephone/Postage Depreciation Total Expenses % of Sales Total 2007 Total 2008 Total 2009

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0 0%

Page 20

INCOME STATEMENT Company name
12-Nov-08 8:39 PM Adv/Promotion Advertising Trade Shows Collateral Total Adv/Promotion % of Sales ADMINISTRATION Headcount Salary Incentives Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

Page 21

INCOME STATEMENT Company name
12-Nov-08 8:39 PM Adv/Promotion Advertising Trade Shows Collateral Total Adv/Promotion % of Sales ADMINISTRATION Headcount Salary Incentives Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

Page 22

INCOME STATEMENT Company name
12-Nov-08 8:39 PM Adv/Promotion Advertising Trade Shows Collateral Total Adv/Promotion % of Sales ADMINISTRATION Headcount Salary Incentives Total 2007 Total 2008 Total 2009

0 0 0 0 0%

0 0 0 0 0%

0 0 0 0 0%

0 0 0

0 0 0

0 0 0

Page 23

Benefits & Taxes Office Supplies Travel & Meals Telephone/Postage Insurance Professional Services Bad Debt Office Rent Utilities Maint/Repair Depreciation Total Expenses % of Sales Total Operating Exp % of Sales Income Before Int & Taxes % of Sales Interest Interest Revenue (4% of cash) Interest Expense (10% of Credit Line) Interest Expense - (10% of Cap. Equip. Lease) Interest Expense - (10% of Long Term Debt) Net Interest Revenue Income Before Taxes Tax Exp Net Income % of Sales

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

Page 24

Benefits & Taxes Office Supplies Travel & Meals Telephone/Postage Insurance Professional Services Bad Debt Office Rent Utilities Maint/Repair Depreciation Total Expenses % of Sales Total Operating Exp % of Sales Income Before Int & Taxes % of Sales Interest Interest Revenue (4% of cash) Interest Expense (10% of Credit Line) Interest Expense - (10% of Cap. Equip. Lease) Interest Expense - (10% of Long Term Debt) Net Interest Revenue Income Before Taxes Tax Exp Net Income % of Sales

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

Page 25

Benefits & Taxes Office Supplies Travel & Meals Telephone/Postage Insurance Professional Services Bad Debt Office Rent Utilities Maint/Repair Depreciation Total Expenses % of Sales Total Operating Exp % of Sales Income Before Int & Taxes % of Sales Interest Interest Revenue (4% of cash) Interest Expense (10% of Credit Line) Interest Expense - (10% of Cap. Equip. Lease) Interest Expense - (10% of Long Term Debt) Net Interest Revenue Income Before Taxes Tax Exp Net Income % of Sales

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

0 0 0 0 0 0 0 0 0%

Page 26

BALANCE SHEET Company name
12-Nov-08 8:39 PM ASSETS Current Assets Cash Gross Accounts Receivable (60 days) Allow for Doubtful Accts (1%) Net Accounts Rec Inventory (0 days) Total Current Assets Gross Fixed Assets Computer Hardware Computer Software Furniture & Fixtures Total Gross Fixed Assets Accumulated Depreciation Computer Hardware Computer Software Furniture & Fixtures Total Accum Deprec Net Fixed Assets TOTAL ASSETS LIABILITIES Short Term Liabilities Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Line of Credit (0% of net A/R) Current Portion of Capital Equipment Lease Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 27

BALANCE SHEET Company name
12-Nov-08 8:39 PM ASSETS Current Assets Cash Gross Accounts Receivable (60 days) Allow for Doubtful Accts (1%) Net Accounts Rec Inventory (0 days) Total Current Assets Gross Fixed Assets Computer Hardware Computer Software Furniture & Fixtures Total Gross Fixed Assets Accumulated Depreciation Computer Hardware Computer Software Furniture & Fixtures Total Accum Deprec Net Fixed Assets TOTAL ASSETS LIABILITIES Short Term Liabilities Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Line of Credit (0% of net A/R) Current Portion of Capital Equipment Lease Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 28

BALANCE SHEET Company name
12-Nov-08 8:39 PM ASSETS Current Assets Cash Gross Accounts Receivable (60 days) Allow for Doubtful Accts (1%) Net Accounts Rec Inventory (0 days) Total Current Assets Gross Fixed Assets Computer Hardware Computer Software Furniture & Fixtures Total Gross Fixed Assets Accumulated Depreciation Computer Hardware Computer Software Furniture & Fixtures Total Accum Deprec Net Fixed Assets TOTAL ASSETS LIABILITIES Short Term Liabilities Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Line of Credit (0% of net A/R) Current Portion of Capital Equipment Lease Total 2007 Total 2008 Total 2009

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 29

Current Portion of Long Term Debt Total ST Liabs Long Term Liabilities Capital Equipment Lease (3 years) Long Term Debt (5 years) Total LT Liabs TOTAL LIABILITIES Equity Preferred Stock Common Stock Retained Earnings Total Equity LIABILITIES & EQUITY

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 30

Current Portion of Long Term Debt Total ST Liabs Long Term Liabilities Capital Equipment Lease (3 years) Long Term Debt (5 years) Total LT Liabs TOTAL LIABILITIES Equity Preferred Stock Common Stock Retained Earnings Total Equity LIABILITIES & EQUITY

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 31

Current Portion of Long Term Debt Total ST Liabs Long Term Liabilities Capital Equipment Lease (3 years) Long Term Debt (5 years) Total LT Liabs TOTAL LIABILITIES Equity Preferred Stock Common Stock Retained Earnings Total Equity LIABILITIES & EQUITY

0 0

0 0

0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 32

SALES PROJECTIONS & MARGIN ANALYSIS Product One
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 33

SALES PROJECTIONS & MARGIN ANALYSIS Product One
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 34

SALES PROJECTIONS & MARGIN ANALYSIS Product One
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Total 2007 Total 2008 Total 2009

0 0 0

0 0 0

0 0 0

1.00 0.00

1.00 0.00

1.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 35

SALES PROJECTIONS & MARGIN ANALYSIS Product Two
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

Page 36

SALES PROJECTIONS & MARGIN ANALYSIS Product Two
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

Page 37

SALES PROJECTIONS & MARGIN ANALYSIS Product Two
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Total 2007 Total 2008 Total 2009

0 0 0

0 0 0

0 0 0

0.00 0.00

0.00 0.00

0.00 0.00

Page 38

Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 39

Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 40

Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 41

SALES PROJECTIONS & MARGIN ANALYSIS Product Three
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 42

SALES PROJECTIONS & MARGIN ANALYSIS Product Three
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 43

SALES PROJECTIONS & MARGIN ANALYSIS Product Three
12-Nov-08 8:39 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Total 2007 Total 2008 Total 2009

0 0 0

0 0 0

0 0 0

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0.0%

Page 44

SALES PROJECTIONS & MARGIN ANALYSIS Services
12-Nov-08 8:39 PM Units s.k.u. 1 Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005

0

0

0

0

0

0

0

0

0

0

0

0

0

Page 45

SALES PROJECTIONS & MARGIN ANALYSIS Services
12-Nov-08 8:39 PM Units s.k.u. 1 Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006

0

0

0

0

0

0

0

0

0

0

0

0

0

Page 46

SALES PROJECTIONS & MARGIN ANALYSIS Services
12-Nov-08 8:39 PM Units s.k.u. 1 Total 2007 Total 2008 Total 2009

0

0

0

Page 47

s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Labor Other Direct Costs Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

Page 48

s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Labor Other Direct Costs Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

1.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

Page 49

s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Labor Other Direct Costs Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales

0 0

0 0

0 0

1.00 0.00

1.00 0.00

1.00 0.00

0 0 0 0.0%

0 0 0 0.0%

0 0 0 0.0%

0.00 0.00

0.00 0.00

0.00 0.00

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

0 0 0 0 0 0 0 0 0.0%

Page 50

STAFFING PLAN Company name
12-Nov-08 8:39 PM Content Senior Application Engineer Inventory Technical Support Mgr. Technical Support Tech. Support Assistant Total Staff Engineering CTO System Administration Project Manager Programming Quality Assurance Total Staff Sales & Marketing VP Marketing Mktg. Manager VP Sales Sales Representative Sales Engineer VP Business Development Customer Support Mktg. Assistant Total Staff Administration CEO CFO COO HR Manager Office Manager Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 51

STAFFING PLAN Company name
12-Nov-08 8:39 PM Content Senior Application Engineer Inventory Technical Support Mgr. Technical Support Tech. Support Assistant Total Staff Engineering CTO System Administration Project Manager Programming Quality Assurance Total Staff Sales & Marketing VP Marketing Mktg. Manager VP Sales Sales Representative Sales Engineer VP Business Development Customer Support Mktg. Assistant Total Staff Administration CEO CFO COO HR Manager Office Manager Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 52

STAFFING PLAN Company name
12-Nov-08 8:39 PM Content Senior Application Engineer Inventory Technical Support Mgr. Technical Support Tech. Support Assistant Total Staff Engineering CTO System Administration Project Manager Programming Quality Assurance Total Staff Sales & Marketing VP Marketing Mktg. Manager VP Sales Sales Representative Sales Engineer VP Business Development Customer Support Mktg. Assistant Total Staff Administration CEO CFO COO HR Manager Office Manager Total 2007 Total 2008 Total 2009

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Page 53

Admin. Assistant

0

0

0

0

0

0

0

0

0

0

0

0

0

Page 54

Admin. Assistant

0

0

0

0

0

0

0

0

0

0

0

0

0

Page 55

Admin. Assistant

0

0

0

Page 56

Company name
Income Statement ($) 2005 Revenue Product One Product Two Product Three Services Total Revenue Cost of Goods Sold Gross Margin % of Revenue Operating Expenses Engineering % of Revenue Marketing/Sales % of Revenue Administration % of Revenue Total Operating Expenses % of Revenue Income Before Int & Taxes % of Revenue Interest Expense Interest Revenue Income Before Taxes Tax Exp Net Income % of Revenue 2006 2007 2008 2009

$0 $0 $0 $0 $0 $0 $0 0%

$0 $0 $0 $0 $0 $0 $0 0%

$0 $0 $0 $0 $0 $0 $0 0%

$0 $0 $0 $0 $0 $0 $0 0%

$0 $0 $0 $0 $0 $0 $0 0%

$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%

$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%

$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%

$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%

$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%

Page 4

Company name
Balance Sheet ($) 2005 ASSETS Current Assets Cash Net Accounts Rec Inventory (0 days) Total Current Assets Gross Fixed Assets Less Accum Depreciation Net Fixed Assets TOTAL ASSETS LIABILITIES Short Term Liabilities Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Line of Credit (0% of net A/R) Current Portion of Capital Equipment Lease Current Portion of Long Term Debt Total Short Term Liabilities Long Term Liabilities Capital Equipment Lease (3 years) Long Term Debt (5 years) Total Long Term Liabilities TOTAL LIABILITIES Equity Preferred Stock Common Stock Retained Earnings Total Equity LIABILITIES & EQUITY 2006 2007 2008 2009

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0

$0 $0 $0 $0 $0
Page 5

Company name
Statement of Sources & Uses ($) 2005 BEGINNING CASH Sources of Cash Net Income Add Depr/Amort Issuance of Preferred Stock Issuance of Common Stock Plus Changes In: Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Additions to Line of Credit (0% of net A/R) Additions to Capital Equipment Lease (3 years) Additions to Long Term Debt (5 years) Total Sources of Cash Uses of Cash Less Changes In: Net Accounts Rec Inventory (0 days) Gross Fixed Assets Reductions To Credit Line Reductions To Capital Equipment Lease Reductions To Long Term Debt Total Uses CHANGES IN CASH ENDING CASH $0 2006 $0 2007 $0 2008 $0 2009 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0

Page 6

Forecasted Revenue, Gross Margin, & Income

$MM

2005

2006
Revenue

2007
Gross Margin Net Income

2008

2009

Page 7

Cash Flow Breakeven
100

$ (000s)

Jan-05

Apr-05

Jul-05

Oct-05
Receipts

Jan-06

Apr-06

Jul-06

Oct-06

Disbursements

Page 8

ecaa059b-eb66-457d-98e4-df77524ba601.xls

Revenue Growth 2005 Revenue Gross Margin Net Income 2006 2007 2008 2009

Cash Flow Breakeven ##### ##### ##### ##### ##### ##### Jul-05 ##### ##### ##### ##### ##### Receipts Disbursements

Page 9

ecaa059b-eb66-457d-98e4-df77524ba601.xls

##### ##### ##### ##### ##### ##### Jul-06 ##### ##### ##### ##### #####

Page 10


				
DOCUMENT INFO
Shared By:
Stats:
views:21866
posted:11/13/2008
language:English
pages:59
Description: Financial model