Financial Model 1

Company name
Financial Model: Table of Contents
1) PRELIMINARY STATEMENTS
- Instructions
- Assumptions
Page 1
Page 2
2) SUMMARY STATEMENTS
- Income Statement
- Balance Sheet
- Statement of Sources & Uses
- Revenue, Gross Margin, & Profit Graph
- Breakeven Chart
Page
Page
Page
Page
Page
4
5
6
7
8
3) DETAILED FINANCIAL STATEMENTS

- Receipts & Disbursements
- Statement of Sources & Uses
- Income Statement
- Balance Sheet
Page
Page
Page
Page
9
12
15
21
4) SALES PROJECTIONS AND MARGIN ANALYSES

- Product One
- Product Two
- Product Three
- Services
Page
Page
Page
Page
24
27
30
33
5) STAFFING PLAN
Page 36
6) EQUIPMENT PURCHASES
Page 42
7) MANUFACTURING & INVENTORY
Page 48
8) RENT & TAXES
Page 51
9) FINANCING ACTIVITIES
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
Financial Model: Assumptions
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
-
2007
-
2008
-
2009
-
COST OF GOODS
AVERAGE UNIT COST

Product One
Product Two
Product Three
Services
Returns...............................................................
(as
Returns...............................................................
(as
Returns...............................................................
(as
Returns...............................................................
(as
2005
-
a
a
a
a
percentage
percentage
percentage
percentage
of
of
of
of
2006
-
Product One revenue)............................................................................................

Product Two revenue)............................................................................................
Product Three revenue).........................................................................................
Services revenue)................................................................................................
0%
0%
0%
0%
BALANCE SHEET
Accounts Receivable (adjustable up to 360 days)..................................................

(in days)...................................................................................................
60 days
Accounts Payable (fixed at 30 days).................................................................
(in days)....................................................................................................
30 days
Salaries Payable (fixed at 15 days)..................................................................
(in days)....................................................................................................
15 days
Taxes Payable (fixed at 90 days).....................................................................
(in days)....................................................................................................
90 days
Inventory (adjustable up to 360 days)...............................................................
(in days)....................................................................................................
0 days
Available Credit Line...................................................................................
(as a percentage of net accounts receivable).......................................................0%
Maximum Credit Line Used.............................................................................
(amount borrowed not to exceed)...................................................................... $0
Capital Equipment Lease Term (1 year minimum)...................................................
(in years)..................................................................................................
3 years
Long Term Borrowings Term (1 year minimum).......................................................
(in years)..................................................................................................
5 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
Financial Model: Assumptions
EXPENSES
HEADCOUNT
Content
Engineering
Sales & Marketing
Administration
TOTAL
PER PERSON EXPENSES

Content
Engineering
Sales & Marketing
Administration
EQUIPMENT PURCHASES
Content
Engineering
Sales & Marketing
Administration
2005
-
Supplies
2006
-
2007
-
100
100
100
100
Travel & Meals

500
500
2,500
1,000
Phone/Postage
100
100
300
250
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
2008
-
2009
-
Benefits & Taxes........................................................................................

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

Company name
3-Jul-15
3:49 PM
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
BEGINNING CASH
Receipts
Collections
Financings
Borrowings
Interest Revenue
Total receipts
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Changes in Cash
ENDING CASH
Page 9

Company name
3-Jul-15
3:49 PM
Month 11
Nov-05
Month 12
Dec-05
Total
2005
BEGINNING CASH
Receipts
Collections
Financings
Borrowings
Interest Revenue
Total receipts
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Disbursements
Salaries
Direct Material
Returns
Advertising
Trade Shows
Supplies/Materials
Travel & Meals
Telephone/Postage
Rent
Utilities
Insurance
Consultants
Taxes
Equipment Purchases
Debt Repayments
Interest Expense
Total Disbursements
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Changes in Cash
ENDING CASH
Page 10

Company name
3-Jul-15
3:49 PM
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
BEGINNING CASH
Receipts
Collections
Financings
Borrowings
Interest Revenue
Total receipts
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Disbursements
Salaries
Direct Material
Returns
Advertising
Trade Shows
Supplies/Materials
Travel & Meals
Telephone/Postage
Rent
Utilities
Insurance
Consultants
Taxes
Equipment Purchases
Debt Repayments
Interest Expense
Total Disbursements
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Changes in Cash
ENDING CASH
Page 11

Company name
3-Jul-15
3:49 PM
Month 23
Nov-06
Month 24
Dec-06
Total
2006
BEGINNING CASH
Receipts
Collections
Financings
Borrowings
Interest Revenue
Total receipts
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Disbursements
Salaries
Direct Material
Returns
Advertising
Trade Shows
Supplies/Materials
Travel & Meals
Telephone/Postage
Rent
Utilities
Insurance
Consultants
Taxes
Equipment Purchases
Debt Repayments
Interest Expense
Total Disbursements
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Changes in Cash
ENDING CASH
Page 12

Company name
3-Jul-15
3:49 PM
Total
2007
Total
2008
Total
2009
BEGINNING CASH
Receipts
Collections
Financings
Borrowings
Interest Revenue
Total receipts
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Disbursements
Salaries
Direct Material
Returns
Advertising
Trade Shows
Supplies/Materials
Travel & Meals
Telephone/Postage
Rent
Utilities
Insurance
Consultants
Taxes
Equipment Purchases
Debt Repayments
Interest Expense
Total Disbursements
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Changes in Cash
ENDING CASH
Page 13
STATEMENT OF SOURCES AND USES

Company name
3-Jul-15
3:49 PM
BEGINNING CASH
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
CHANGES IN CASH
ENDING 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
Reductions To Long Term Debt
Total Uses
Page 14

Company name
3-Jul-15
3:49 PM
BEGINNING CASH
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
CHANGES IN CASH
ENDING CASH
Sources of Cash
Net Income
Add Depr/Amort
Plus Changes In:
Uses of Cash
Less Changes In:
Net Accounts Rec
Inventory (0 days)
Gross Fixed Assets
Total Uses
Page 15

Company name
3-Jul-15
3:49 PM
BEGINNING CASH
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
CHANGES IN CASH
ENDING CASH
Sources of Cash
Net Income
Add Depr/Amort
Plus Changes In:
Uses of Cash
Less Changes In:
Net Accounts Rec
Inventory (0 days)
Gross Fixed Assets
Total Uses
Page 16

Company name
3-Jul-15
3:49 PM
BEGINNING CASH
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
CHANGES IN CASH
ENDING CASH
Sources of Cash
Net Income
Add Depr/Amort
Plus Changes In:
Uses of Cash
Less Changes In:
Net Accounts Rec
Inventory (0 days)
Gross Fixed Assets
Total Uses
Page 17

Company name
3-Jul-15
3:49 PM
BEGINNING CASH
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
CHANGES IN CASH
ENDING CASH
Sources of Cash
Net Income
Add Depr/Amort
Plus Changes In:
Uses of Cash
Less Changes In:
Net Accounts Rec
Inventory (0 days)
Gross Fixed Assets
Total Uses
Page 18
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
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
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Expenses
Cost of Goods Sold
Direct Labor
Other Direct Costs
Direct Materials
Returns
Total COGS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Margin
% of Sales
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
Operating Expenses
ENGINEERING
Headcount
Salary
Incentives
Benefits & Taxes
Consultants
Supplies/ Materials
Travel & Meals
Telephone/Postage
Operations Setup
Depreciation
Total Expenses
% 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%
SALES & MARKETING

Headcount
Salary
Incentives/Commissions
Benefits & Taxes
Supplies
Travel & Meals
Telephone/Postage
Depreciation
Total Expenses
% 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%
Page 19
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
Month 11
Nov-05
Month 12
Dec-05
Total
2005
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Expenses
Cost of Goods Sold
Direct Labor
Other Direct Costs
Direct Materials
Returns
Total COGS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Margin
% of Sales
0
0%
0
0%
0
0%
Operating Expenses
ENGINEERING
Headcount
Salary
Incentives
Benefits & Taxes
Consultants
Supplies/ Materials
Travel & Meals
Telephone/Postage
Operations Setup
Depreciation
Total Expenses
% 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%
SALES & MARKETING

Headcount
Salary
Benefits & Taxes
Supplies
Travel & Meals
Telephone/Postage
Depreciation
Total Expenses
% 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%
Page 20
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
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
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Expenses
Cost of Goods Sold
Direct Labor
Other Direct Costs
Direct Materials
Returns
Total COGS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Margin
% of Sales
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
Operating Expenses
ENGINEERING
Headcount
Salary
Incentives
Benefits & Taxes
Consultants
Supplies/ Materials
Travel & Meals
Telephone/Postage
Operations Setup
Depreciation
Total Expenses
% 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%
SALES & MARKETING

Headcount
Salary
Benefits & Taxes
Supplies
Travel & Meals
Telephone/Postage
Depreciation
Total Expenses
% 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%
Page 21
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
Month 23
Nov-06
Month 24
Dec-06
Total
2006
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Expenses
Cost of Goods Sold
Direct Labor
Other Direct Costs
Direct Materials
Returns
Total COGS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Margin
% of Sales
0
0%
0
0%
0
0%
Operating Expenses
ENGINEERING
Headcount
Salary
Incentives
Benefits & Taxes
Consultants
Supplies/ Materials
Travel & Meals
Telephone/Postage
Operations Setup
Depreciation
Total Expenses
% 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%
SALES & MARKETING

Headcount
Salary
Benefits & Taxes
Supplies
Travel & Meals
Telephone/Postage
Depreciation
Total Expenses
% 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%
Page 22
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
Total
2007
Total
2008
Total
2009
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Expenses
Cost of Goods Sold
Direct Labor
Other Direct Costs
Direct Materials
Returns
Total COGS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Margin
% of Sales
0
0%
0
0%
0
0%
Operating Expenses
ENGINEERING
Headcount
Salary
Incentives
Benefits & Taxes
Consultants
Supplies/ Materials
Travel & Meals
Telephone/Postage
Operations Setup
Depreciation
Total Expenses
% 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%
SALES & MARKETING

Headcount
Salary
Benefits & Taxes
Supplies
Travel & Meals
Telephone/Postage
Depreciation
Total Expenses
% 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%
Page 23
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
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
Adv/Promotion
Advertising
Trade Shows
Collateral
Total Adv/Promotion
% 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%
ADMINISTRATION
Headcount
Salary
Incentives
Benefits & Taxes
Office Supplies
Travel & Meals
Telephone/Postage
Insurance
Bad Debt
Office Rent
Utilities
Maint/Repair
Depreciation
Total Expenses
% 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%
Total Operating Exp

% of Sales
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
Income Before Int & Taxes

% of Sales
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Income Before Taxes

Tax Exp
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
Net Income
% of Sales
Page 24
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
Month 11
Nov-05
Month 12
Dec-05
Total
2005
Adv/Promotion
Advertising
Trade Shows
Collateral
Total Adv/Promotion
% of Sales
0
0
0
0
0%
0
0
0
0
0%
0
0
0
0
0%
ADMINISTRATION
Headcount
Salary
Incentives
Benefits & Taxes
Office Supplies
Travel & Meals
Telephone/Postage
Insurance
Bad Debt
Office Rent
Utilities
Maint/Repair
Depreciation
Total Expenses
% 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%
Total Operating Exp

% of Sales
0
0%
0
0%
0
0%

% of Sales
0
0%
0
0%
0
0%
Interest
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Income Before Taxes

Tax Exp
0
0
0
0
0
0
0
0%
0
0%
0
0%
Net Income
% of Sales
Page 25
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
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
Adv/Promotion
Advertising
Trade Shows
Collateral
Total Adv/Promotion
% 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%
ADMINISTRATION
Headcount
Salary
Incentives
Benefits & Taxes
Office Supplies
Travel & Meals
Telephone/Postage
Insurance
Bad Debt
Office Rent
Utilities
Maint/Repair
Depreciation
Total Expenses
% 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%
Total Operating Exp

% of Sales
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%

% of Sales
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
Interest
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Income Before Taxes

Tax Exp
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
0
0%
Net Income
% of Sales
Page 26
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
Month 23
Nov-06
Month 24
Dec-06
Total
2006
Adv/Promotion
Advertising
Trade Shows
Collateral
Total Adv/Promotion
% of Sales
0
0
0
0
0%
0
0
0
0
0%
0
0
0
0
0%
ADMINISTRATION
Headcount
Salary
Incentives
Benefits & Taxes
Office Supplies
Travel & Meals
Telephone/Postage
Insurance
Bad Debt
Office Rent
Utilities
Maint/Repair
Depreciation
Total Expenses
% 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%
Total Operating Exp

% of Sales
0
0%
0
0%
0
0%

% of Sales
0
0%
0
0%
0
0%
Interest
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Income Before Taxes

Tax Exp
0
0
0
0
0
0
0
0%
0
0%
0
0%
Net Income
% of Sales
Page 27
INCOME STATEMENT
Company name
3-Jul-15
3:49 PM
Total
2007
Total
2008
Total
2009
Adv/Promotion
Advertising
Trade Shows
Collateral
Total Adv/Promotion
% of Sales
0
0
0
0
0%
0
0
0
0
0%
0
0
0
0
0%
ADMINISTRATION
Headcount
Salary
Incentives
Benefits & Taxes
Office Supplies
Travel & Meals
Telephone/Postage
Insurance
Bad Debt
Office Rent
Utilities
Maint/Repair
Depreciation
Total Expenses
% 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%
Total Operating Exp

% of Sales
0
0%
0
0%
0
0%

% of Sales
0
0%
0
0%
0
0%
Interest
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Income Before Taxes

Tax Exp
0
0
0
0
0
0
0
0%
0
0%
0
0%
Net Income
% of Sales
Page 28
BALANCE SHEET
Company name
3-Jul-15
3:49 PM
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
ASSETS
Current Assets
Cash
Gross Accounts Receivable (60 days)
Allow for Doubtful Accts (1%)
Net Accounts Rec
Inventory (0 days)
Total Current Assets
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Fixed Assets

Computer Hardware
Computer Software
Furniture & Fixtures
Total Gross Fixed Assets
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Accumulated Depreciation
Computer Hardware
Computer Software
Total Accum Deprec
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Net Fixed Assets
TOTAL ASSETS
Short Term Liabilities

Line of Credit (0% of net A/R)
Current Portion of Capital Equipment Lease
Current Portion of Long Term Debt
Total ST Liabs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Long Term Liabilities

Capital Equipment Lease (3 years)
Long Term Debt (5 years)
Total LT Liabs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL LIABILITIES
Equity
Preferred Stock
Common Stock
Retained Earnings
Total 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
LIABILITIES & EQUITY
LIABILITIES
Page 29
BALANCE SHEET
Company name
3-Jul-15
3:49 PM
Month 11
Nov-05
Month 12
Dec-05
Total
2005
ASSETS
Current Assets
Cash
Net Accounts Rec
Inventory (0 days)
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Fixed Assets

Computer Hardware
Computer Software
0
0
0
0
0
0
0
0
0
0
0
0
Computer Hardware
Computer Software
Total Accum Deprec
0
0
0
0
0
0
0
0
0
0
0
0
Net Fixed Assets
TOTAL ASSETS

Total ST Liabs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Total LT Liabs
0
0
0
0
0
0
0
0
0
TOTAL LIABILITIES
Equity
Preferred Stock
Common Stock
Retained Earnings
Total Equity
0
0
0
0
0
0
0
0
0
0
0
0
LIABILITIES
Page 30
BALANCE SHEET
Company name
3-Jul-15
3:49 PM
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
ASSETS
Current Assets
Cash
Net Accounts Rec
Inventory (0 days)
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Fixed Assets

Computer Hardware
Computer Software
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Computer Hardware
Computer Software
Total Accum Deprec
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Net Fixed Assets
TOTAL ASSETS

Total ST Liabs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Total LT Liabs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL LIABILITIES
Equity
Preferred Stock
Common Stock
Retained Earnings
Total 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
LIABILITIES
Page 31
BALANCE SHEET
Company name
3-Jul-15
3:49 PM
Month 23
Nov-06
Month 24
Dec-06
Total
2006
ASSETS
Current Assets
Cash
Net Accounts Rec
Inventory (0 days)
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Fixed Assets

Computer Hardware
Computer Software
0
0
0
0
0
0
0
0
0
0
0
0
Computer Hardware
Computer Software
Total Accum Deprec
0
0
0
0
0
0
0
0
0
0
0
0
Net Fixed Assets
TOTAL ASSETS

Total ST Liabs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Total LT Liabs
0
0
0
0
0
0
0
0
0
TOTAL LIABILITIES
Equity
Preferred Stock
Common Stock
Retained Earnings
Total Equity
0
0
0
0
0
0
0
0
0
0
0
0
LIABILITIES
Page 32
BALANCE SHEET
Company name
3-Jul-15
3:49 PM
Total
2007
Total
2008
Total
2009
ASSETS
Current Assets
Cash
Net Accounts Rec
Inventory (0 days)
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Gross Fixed Assets

Computer Hardware
Computer Software
0
0
0
0
0
0
0
0
0
0
0
0
Computer Hardware
Computer Software
Total Accum Deprec
0
0
0
0
0
0
0
0
0
0
0
0
Net Fixed Assets
TOTAL ASSETS

Total ST Liabs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Total LT Liabs
0
0
0
0
0
0
0
0
0
TOTAL LIABILITIES
Equity
Preferred Stock
Common Stock
Retained Earnings
Total Equity
0
0
0
0
0
0
0
0
0
0
0
0
LIABILITIES
Page 33
SALES PROJECTIONS & MARGIN ANALYSIS

Product One
3-Jul-15
3:49 PM
Month 1
Jan-05
Units
s.k.u. 1
s.k.u. 2
Total Units
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
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
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
Proportion of Total Revenues
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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%
Page 34
0
0.0%

Product One
3-Jul-15
3:49 PM
Month 11
Nov-05
Units
s.k.u. 1
s.k.u. 2
Total Units
Month 12
Dec-05
Total
2005
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
1.00
0.00
1.00
0.00
1.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 35

Product One
3-Jul-15
3:49 PM
Month 13
Jan-06
Units
s.k.u. 1
s.k.u. 2
Total Units
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
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
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
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 36
0
0.0%

Product One
3-Jul-15
3:49 PM
Month 23
Nov-06
Units
s.k.u. 1
s.k.u. 2
Total Units
Month 24
Dec-06
Total
2006
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
1.00
0.00
1.00
0.00
1.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 37

Product One
3-Jul-15
3:49 PM
Total
2007
Units
s.k.u. 1
s.k.u. 2
Total Units
Total
2008
Total
2009
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
1.00
0.00
1.00
0.00
1.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 38

Product Two
3-Jul-15
3:49 PM
Month 1
Jan-05
Units
s.k.u. 1
s.k.u. 2
Total Units
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
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
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
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
0
0.0%

Product Two
3-Jul-15
3:49 PM
Month 11
Nov-05
Units
s.k.u. 1
s.k.u. 2
Total Units
Month 12
Dec-05
Total
2005
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
0.00
0.00
0.00
0.00
0.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 40

Product Two
3-Jul-15
3:49 PM
Month 13
Jan-06
Units
s.k.u. 1
s.k.u. 2
Total Units
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
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
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
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
0
0.0%

Product Two
3-Jul-15
3:49 PM
Month 23
Nov-06
Units
s.k.u. 1
s.k.u. 2
Total Units
Month 24
Dec-06
Total
2006
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
0.00
0.00
0.00
0.00
0.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 42

Product Two
3-Jul-15
3:49 PM
Total
2007
Units
s.k.u. 1
s.k.u. 2
Total Units
Total
2008
Total
2009
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
0.00
0.00
0.00
0.00
0.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 43

Product Three
3-Jul-15
3:49 PM
Month 1
Jan-05
Units
s.k.u. 1
s.k.u. 2
Total Units
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
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
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
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
0
0.0%

Product Three
3-Jul-15
3:49 PM
Month 11
Nov-05
Units
s.k.u. 1
s.k.u. 2
Total Units
Month 12
Dec-05
Total
2005
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
0.00
0.00
0.00
0.00
0.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 45

Product Three
3-Jul-15
3:49 PM
Month 13
Jan-06
Units
s.k.u. 1
s.k.u. 2
Total Units
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
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
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
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 46
0
0.0%

Product Three
3-Jul-15
3:49 PM
Month 23
Nov-06
Units
s.k.u. 1
s.k.u. 2
Total Units
Month 24
Dec-06
Total
2006
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
0.00
0.00
0.00
0.00
0.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 47

Product Three
3-Jul-15
3:49 PM
Total
2007
Units
s.k.u. 1
s.k.u. 2
Total Units
Total
2008
Total
2009
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
0.00
0.00
0.00
0.00
0.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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
COGS
Unit Cost
s.k.u. 1
s.k.u. 2
s.k.u. 1
s.k.u. 2
Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 48

Services
3-Jul-15
3:49 PM
Month 1
Jan-05
Units
s.k.u. 1
s.k.u. 2
Total Units
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
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
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
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

s.k.u. 1
s.k.u. 2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Labor
Other Direct Costs
COGS
Unit Cost
s.k.u. 1
s.k.u. 2

Total COGS
GROSS MARGIN
###
0
0.0%
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
0
0.0%

Services
3-Jul-15
3:49 PM
Month 11
Nov-05
Units
s.k.u. 1
s.k.u. 2
Total Units
Month 12
Dec-05
Total
2005
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
1.00
0.00
1.00
0.00
1.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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

s.k.u. 1
s.k.u. 2
0
0
0
0
0
0
0
0
0
Labor
Other Direct Costs
COGS
Unit Cost
s.k.u. 1
s.k.u. 2

Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 50

Services
3-Jul-15
3:49 PM
Month 13
Jan-06
Units
s.k.u. 1
s.k.u. 2
Total Units
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
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
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
0
0.0%
0
0
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

s.k.u. 1
s.k.u. 2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Labor
Other Direct Costs
COGS
Unit Cost
s.k.u. 1
s.k.u. 2

Total COGS
GROSS MARGIN
###
0
0.0%
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
0
0.0%

Services
3-Jul-15
3:49 PM
Month 23
Nov-06
Units
s.k.u. 1
s.k.u. 2
Total Units
Month 24
Dec-06
Total
2006
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
1.00
0.00
1.00
0.00
1.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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

s.k.u. 1
s.k.u. 2
0
0
0
0
0
0
0
0
0
Labor
Other Direct Costs
COGS
Unit Cost
s.k.u. 1
s.k.u. 2

Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 52

Services
3-Jul-15
3:49 PM
Total
2007
Units
s.k.u. 1
s.k.u. 2
Total Units
Total
2008
Total
2009
0
0
0
0
0
0
0
0
0
Price
s.k.u. 1
s.k.u. 2
1.00
0.00
1.00
0.00
1.00
0.00
Revenue
s.k.u. 1
s.k.u. 2
Total Revenue
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

s.k.u. 1
s.k.u. 2
0
0
0
0
0
0
0
0
0
Labor
Other Direct Costs
COGS
Unit Cost
s.k.u. 1
s.k.u. 2

Total COGS
GROSS MARGIN
###
0
0.0%
0
0.0%
0
0.0%
Page 53
STAFFING PLAN
Company name
3-Jul-15
3:49 PM
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
Content
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support Assistant
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Engineering
CTO
System Administration
Project Manager
Programming
Quality Assurance
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Sales & Marketing

VP Marketing
Mktg. Manager
VP Sales
Sales Representative
Sales Engineer
VP Business Development
Customer Support
Mktg. Assistant
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Administration
CEO
CFO
COO
HR Manager
Office Manager
Admin. Assistant
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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 54
STAFFING PLAN
Company name
3-Jul-15
3:49 PM
Month 11
Nov-05
Month 12
Dec-05
Total
2005
Content
Inventory
Technical Support
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Engineering
CTO
Project Manager
Programming
Quality Assurance
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Sales & Marketing

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Administration
CEO
CFO
COO
HR Manager
Office Manager
Admin. Assistant
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Page 55
STAFFING PLAN
Company name
3-Jul-15
3:49 PM
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
Content
Inventory
Technical Support
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Engineering
CTO
Project Manager
Programming
Quality Assurance
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Sales & Marketing

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Administration
CEO
CFO
COO
HR Manager
Office Manager
Admin. Assistant
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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 56
STAFFING PLAN
Company name
3-Jul-15
3:49 PM
Month 23
Nov-06
Month 24
Dec-06
Total
2006
Content
Inventory
Technical Support
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Engineering
CTO
Project Manager
Programming
Quality Assurance
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Sales & Marketing

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Administration
CEO
CFO
COO
HR Manager
Office Manager
Admin. Assistant
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Page 57
STAFFING PLAN
Company name
3-Jul-15
3:49 PM
Total
2007
Total
2008
Total
2009
Content
Inventory
Technical Support
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Engineering
CTO
Project Manager
Programming
Quality Assurance
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Sales & Marketing

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Staf
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Administration
CEO
CFO
COO
HR Manager
Office Manager
Admin. Assistant
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Page 58
Total Staf
TOTAL EMPLOYEES
revenue per employee
SALARIES PAID
Company name
3-Jul-15
3:49 PM
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
CONTENT
Inventory
Technical Support
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
CTO
Project Manager
Programming
Quality Assurance
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
CEO
CFO
COO
HR Manager
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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 59
Total Staf
TOTAL EMPLOYEES
SALARIES PAID
Company name
3-Jul-15
3:49 PM
0
0
Month 11
Nov-05
Month 12
Dec-05
Total
2005
CONTENT
Inventory
Technical Support
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
CTO
Project Manager
Programming
Quality Assurance
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
CEO
CFO
COO
HR Manager
0
0
0
0
0
0
0
0
0
0
0
0
Page 60
Total Staf
TOTAL EMPLOYEES
SALARIES PAID
Company name
3-Jul-15
3:49 PM
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
CONTENT
Inventory
Technical Support
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
CTO
Project Manager
Programming
Quality Assurance
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
CEO
CFO
COO
HR Manager
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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 61
Total Staf
TOTAL EMPLOYEES
SALARIES PAID
Company name
3-Jul-15
3:49 PM
0
0
Month 23
Nov-06
Month 24
Dec-06
Total
2006
CONTENT
Inventory
Technical Support
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
CTO
Project Manager
Programming
Quality Assurance
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
CEO
CFO
COO
HR Manager
0
0
0
0
0
0
0
0
0
0
0
0
Page 62
Total Staf
TOTAL EMPLOYEES
SALARIES PAID
Company name
3-Jul-15
3:49 PM
0
0
0
0
0
0
Total
2007
Total
2008
Total
2009
CONTENT
Inventory
Technical Support
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
CTO
Project Manager
Programming
Quality Assurance
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

VP Marketing
Mktg. Manager
VP Sales
Sales Engineer
Customer Support
Mktg. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
CEO
CFO
COO
HR Manager
0
0
0
0
0
0
0
0
0
0
0
0
Page 63
Office Manager
Admin. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL SALARIES PAID
Benefits & Taxes on Salary

Annual Salary Growth Factor
CAPITAL PURCHASES
Company name
3-Jul-15
3:49 PM
25%
100.0%
Month 1
Jan-05
25%
100.0%
Month 2
Feb-05
25%
100.0%
Month 3
Mar-05
25%
100.0%
Month 4
Apr-05
25%
100.0%
Month 5
May-05
25%
100.0%
Month 6
Jun-05
25%
100.0%
Month 7
Jul-05
25%
100.0%
Month 8
Aug-05
25%
100.0%
Month 9
Sep-05
25%
100.0%
Month 10
Oct-05
CONTENT
Computer Hardware
Computer Software
Total Purchases for Period
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
Computer Hardware
Page 64
Office Manager
Admin. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
TOTAL SALARIES PAID

CAPITAL PURCHASES
Company name
3-Jul-15
3:49 PM
25%
100.0%
Month 11
Nov-05
25%
100.0%
Month 12
Dec-05
25%
100.0%
Total
2005
CONTENT
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
Computer Hardware
Page 65
Office Manager
Admin. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL SALARIES PAID

CAPITAL PURCHASES
Company name
3-Jul-15
3:49 PM
25%
105.0%
Month 13
Jan-06
25%
105.0%
Month 14
Feb-06
25%
105.0%
Month 15
Mar-06
25%
105.0%
Month 16
Apr-06
25%
105.0%
Month 17
May-06
25%
105.0%
Month 18
Jun-06
25%
105.0%
Month 19
Jul-06
25%
105.0%
Month 20
Aug-06
25%
105.0%
Month 21
Sep-06
25%
105.0%
Month 22
Oct-06
CONTENT
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
Computer Hardware
Page 66
Office Manager
Admin. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
TOTAL SALARIES PAID

CAPITAL PURCHASES
Company name
3-Jul-15
3:49 PM
25%
105.0%
Month 23
Nov-06
25%
105.0%
Month 24
Dec-06
25%
105.0%
Total
2006
CONTENT
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
Computer Hardware
Page 67
Office Manager
Admin. Assistant
Total Salaries Paid
0
0
0
0
0
0
0
0
0
TOTAL SALARIES PAID

CAPITAL PURCHASES
Company name
3-Jul-15
3:49 PM
25%
110.3%
Total
2007
25%
115.8%
Total
2008
25%
121.6%
Total
2009
CONTENT
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

Computer Hardware
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADMINISTRATION
Computer Hardware
Page 68
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL PURCHASES FOR PERIOD

of which leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
DEPRECIATION
Company name
3-Jul-15
3:49 PM
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
CONTENT
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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 69
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0

of which leased
0
0
0
0
0
0
DEPRECIATION
Company name
3-Jul-15
3:49 PM
Month 11
Nov-05
Month 12
Dec-05
Total
2005
CONTENT
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

0
0
0
0
0
0
0
0
0
0
0
0
Page 70
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

of which leased
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
DEPRECIATION
Company name
3-Jul-15
3:49 PM
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
CONTENT
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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 71
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0

of which leased
0
0
0
0
0
0
DEPRECIATION
Company name
3-Jul-15
3:49 PM
Month 23
Nov-06
Month 24
Dec-06
Total
2006
CONTENT
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

0
0
0
0
0
0
0
0
0
0
0
0
Page 72
Computer Software
of which Leased
0
0
0
0
0
0
0
0
0
0
0
0

of which leased
0
0
0
0
0
0
DEPRECIATION
Company name
3-Jul-15
3:49 PM
Total
2007
Total
2008
Total
2009
CONTENT
0
0
0
0
0
0
0
0
0
0
0
0
ENGINEERING
0
0
0
0
0
0
0
0
0
0
0
0
SALES & MARKETING

0
0
0
0
0
0
0
0
0
0
0
0
Page 73
ADMINISTRATION
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL DEPRECIATION FOR PERIOD
MANUFACTURING & INVENTORY

Company name
3-Jul-15
3:49 PM
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
CONTENT
Labor
Headcount
Salary
Incentives
Benefits & Taxes
Total Labor
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Other Direct Costs

Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
Total Other Direct Costs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total Operations
INVENTORY: Beginning
Product One
Product Two
Product Three
Services
Total Beginning Inventory
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADD: Purchases
Product One
Product Two
Product Three
Services
Total Purchases
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
LESS: Materials Expense

Product One
Product Two
Product Three
Services
Total Materials Expense
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Inventory (0 days)
###
Page 74
ADMINISTRATION
0
0
0
0
0
0
0
0
0
0
0
0

Company name
3-Jul-15
3:49 PM
Month 11
Nov-05
Month 12
Dec-05
Total
2005
CONTENT
Labor
Headcount
Salary
Incentives
Benefits & Taxes
Total Labor
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Other Direct Costs

Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total Operations
Product One
Product Two
Product Three
Services
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADD: Purchases
Product One
Product Two
Product Three
Services
Total Purchases
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Product One
Product Two
Product Three
Services
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Inventory (0 days)
###
Page 75
ADMINISTRATION
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Company name
3-Jul-15
3:49 PM
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
CONTENT
Labor
Headcount
Salary
Incentives
Benefits & Taxes
Total Labor
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Other Direct Costs

Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total Operations
Product One
Product Two
Product Three
Services
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADD: Purchases
Product One
Product Two
Product Three
Services
Total Purchases
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Product One
Product Two
Product Three
Services
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Inventory (0 days)
###
Page 76
ADMINISTRATION
0
0
0
0
0
0
0
0
0
0
0
0

Company name
3-Jul-15
3:49 PM
Month 23
Nov-06
Month 24
Dec-06
Total
2006
CONTENT
Labor
Headcount
Salary
Incentives
Benefits & Taxes
Total Labor
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Other Direct Costs

Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total Operations
Product One
Product Two
Product Three
Services
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADD: Purchases
Product One
Product Two
Product Three
Services
Total Purchases
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Product One
Product Two
Product Three
Services
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Inventory (0 days)
###
Page 77
ADMINISTRATION
0
0
0
0
0
0
0
0
0
0
0
0

Company name
3-Jul-15
3:49 PM
Total
2007
Total
2008
Total
2009
CONTENT
Labor
Headcount
Salary
Incentives
Benefits & Taxes
Total Labor
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Other Direct Costs

Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total Operations
Product One
Product Two
Product Three
Services
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ADD: Purchases
Product One
Product Two
Product Three
Services
Total Purchases
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Product One
Product Two
Product Three
Services
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Inventory (0 days)
###
Page 78
INVENTORY: Ending
Product One
Product Two
Product Three
Services
Total Ending Inventory
RENT & TAXES
Company name
3-Jul-15
3:49 PM
RENT
Total Office Square Footage
Square Footage per Person (250 ft. minimum)
Price per Square Foot
0
0
0
0
0
Month 1
Jan-05
0
0
1.50
0
0
0
0
0
Month 2
Feb-05
0
0
1.50
0
0
0
0
0
Month 3
Mar-05
0
0
1.50
0
0
0
0
0
Month 4
Apr-05
0
0
1.50
0
0
0
0
0
Month 5
May-05
0
0
1.50
0
0
0
0
0
Month 6
Jun-05
0
0
1.50
0
0
0
0
0
Month 7
Jul-05
0
0
1.50
0
0
0
0
0
Month 8
Aug-05
0
0
1.50
0
0
0
0
0
Month 9
Sep-05
0
0
0
0
0
Month 10
Oct-05
0
0
1.50
Page 79
0
0
1.50
INVENTORY: Ending
Product One
Product Two
Product Three
Services
RENT & TAXES
Company name
3-Jul-15
3:49 PM
RENT
0
0
0
0
0
Month 11
Nov-05
0
0
1.50
0
0
0
0
0
Month 12
Dec-05
0
0
1.50
0
0
0
0
0
Total
2005
0
0
1.50
Page 80
INVENTORY: Ending
Product One
Product Two
Product Three
Services
RENT & TAXES
Company name
3-Jul-15
3:49 PM
RENT
0
0
0
0
0
Month 13
Jan-06
0
0
1.50
0
0
0
0
0
Month 14
Feb-06
0
0
1.50
0
0
0
0
0
Month 15
Mar-06
0
0
1.50
0
0
0
0
0
Month 16
Apr-06
0
0
1.50
0
0
0
0
0
Month 17
May-06
0
0
1.50
0
0
0
0
0
Month 18
Jun-06
0
0
1.50
0
0
0
0
0
Month 19
Jul-06
0
0
1.50
0
0
0
0
0
Month 20
Aug-06
0
0
1.50
0
0
0
0
0
Month 21
Sep-06
0
0
0
0
0
Month 22
Oct-06
0
0
1.50
Page 81
0
0
1.50
INVENTORY: Ending
Product One
Product Two
Product Three
Services
RENT & TAXES
Company name
3-Jul-15
3:49 PM
RENT
0
0
0
0
0
Month 23
Nov-06
0
0
1.50
0
0
0
0
0
Month 24
Dec-06
0
0
1.50
0
0
0
0
0
Total
2006
0
0
1.50
Page 82
INVENTORY: Ending
Product One
Product Two
Product Three
Services
RENT & TAXES
Company name
3-Jul-15
3:49 PM
RENT
0
0
0
0
0
Total
2007
0
0
0
0
0
Total
2008
0
0
1.50
0
0
0
0
0
Total
2009
0
0
1.50
0
0
1.50
Page 83
Total Office Rent (12 month lease)
TAXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
FINANCING ACTIVITIES
Company name
3-Jul-15
3:49 PM
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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
DEBT
Additions To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
Total Additions
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Payments To:
Line of Credit
Total Payments
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Issuance of:
Preferred Stock
Common Stock
Total Equity Investment
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Buyback of:
Preferred Stock
Common Stock
Total Stock Buyback
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
EQUITY
Page 84
TAXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
Company name
3-Jul-15
3:49 PM
0
0
0
0
0
0
0
0
0
Month 11
Nov-05
Month 12
Dec-05
Total
2005
DEBT
Additions To:
Line of Credit
Total Additions
0
0
0
0
0
0
0
0
0
0
0
0
Payments To:
Line of Credit
Total Payments
0
0
0
0
0
0
0
0
0
0
0
0
Issuance of:
Preferred Stock
Common Stock
0
0
0
0
0
0
0
0
0
Buyback of:
Preferred Stock
Common Stock
Total Stock Buyback
0
0
0
0
0
0
0
0
0
EQUITY
Page 85
TAXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
Company name
3-Jul-15
3:49 PM
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
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
DEBT
Additions To:
Line of Credit
Total Additions
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Payments To:
Line of Credit
Total Payments
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Issuance of:
Preferred Stock
Common Stock
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Buyback of:
Preferred Stock
Common Stock
Total Stock Buyback
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
EQUITY
Page 86
TAXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
Company name
3-Jul-15
3:49 PM
0
0
0
0
0
0
0
0
0
Month 23
Nov-06
Month 24
Dec-06
Total
2006
DEBT
Additions To:
Line of Credit
Total Additions
0
0
0
0
0
0
0
0
0
0
0
0
Payments To:
Line of Credit
Total Payments
0
0
0
0
0
0
0
0
0
0
0
0
Issuance of:
Preferred Stock
Common Stock
0
0
0
0
0
0
0
0
0
Buyback of:
Preferred Stock
Common Stock
Total Stock Buyback
0
0
0
0
0
0
0
0
0
EQUITY
Page 87
TAXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
Company name
3-Jul-15
3:49 PM
0
0
0
0
0
0
0
0
0
Total
2007
Total
2008
Total
2009
DEBT
Additions To:
Line of Credit
Total Additions
0
0
0
0
0
0
0
0
0
0
0
0
Payments To:
Line of Credit
Total Payments
0
0
0
0
0
0
0
0
0
0
0
0
Issuance of:
Preferred Stock
Common Stock
0
0
0
0
0
0
0
0
0
Buyback of:
Preferred Stock
Common Stock
Total Stock Buyback
0
0
0
0
0
0
0
0
0
EQUITY
Page 88
Company name
Income Statement ($)
2005
2006
2007
2008
2009
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Cost of Goods Sold
$0
$0
$0
$0
$0
Gross Margin
% of Revenue
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
Operating Expenses
Engineering
% of Revenue
Marketing/Sales
% of Revenue
Administration
% of Revenue
Total Operating Expenses
% of Revenue
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%

% of Revenue
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
Interest Expense
Interest Revenue
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Income Before Taxes

Tax Exp
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Net Income
% of Revenue
$0
0%
$0
0%
$0
0%
$0
0%
$0
0%
Page 4
Company name
Balance Sheet ($)
2005
2006
2007
2008
2009
ASSETS
Current Assets
Cash
Net Accounts Rec
Inventory (0 days)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Gross Fixed Assets

Less Accum Depreciation
Net Fixed Assets
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
TOTAL ASSETS
$0
$0
$0
$0
$0
LIABILITIES
Total Short Term Liabilities
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Total Long Term Liabilities
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
TOTAL LIABILITIES
$0
$0
$0
$0
$0
Equity
Preferred Stock
Common Stock
Retained Earnings
Total 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
Page 5
Company name
Statement of Sources & Uses ($)
2005
BEGINNING CASH
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
Uses of Cash
Less Changes In:
Net Accounts Rec
Inventory (0 days)
Gross Fixed Assets
Total Uses
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
CHANGES IN CASH
$0
$0
$0
$0
$0
ENDING CASH
$0
$0
$0
$0
$0
Sources of Cash
Net Income
Add Depr/Amort
Plus Changes In:
Additions to Capital Equipment Lease (3 year
Page 6
$MM
Forecasted Revenue, Gross Margin, & Income
2005
2006
2007
Revenue
Gross Margin
2008
2009
Net Income
Page 7
Cash Flow Breakeven
$ (000s)
100
Receipts
Disbursements
Page 8
275319967.xls
Revenue Growth
2005
2006
2007
2008
2009
Revenue
Gross Margin
Net Income
Cash Flow Breakeven

Jan-05 Feb-05 Mar-05 Apr-05 May-05
Receipts
Disbursements
Page 9
Jun-05
Jul-05 Aug-05 Sep-05
275319967.xls
Oct-05 Nov-05 Dec-05
Jan-06 Feb-06 Mar-06 Apr-06 May-06
Page 10
Jun-06
Jul-06 Aug-06
275319967.xls
Sep-06 Oct-06 Nov-06 Dec-06
Page 11

Financial Model 1

Uploaded by

Copyright:

Available Formats

Financial Model 1

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Financial Model 1

Uploaded by

Copyright:

Available Formats

Company name

Financial Model: Table of Contents

3) DETAILED FINANCIAL STATEMENTS

4) SALES PROJECTIONS AND MARGIN ANALYSES

7) MANUFACTURING & INVENTORY

8) RENT & TAXES

Version 3.2 (manufacturing)

1) ENTERING INFORMATION INTO THE MODEL: The DETAIL Worksheet.

AVERAGE UNIT PRICE

AVERAGE UNIT COST

Product One revenue)............................................................................................

Accounts Receivable (adjustable up to 360 days)..................................................

Furn & Fixtures

PER PERSON EXPENSES

Travel & Meals

Furn & Fixtures

Benefits & Taxes........................................................................................

RECEIPTS & DISBURSEMENTS

RECEIPTS & DISBURSEMENTS

RECEIPTS & DISBURSEMENTS

RECEIPTS & DISBURSEMENTS

RECEIPTS & DISBURSEMENTS

STATEMENT OF SOURCES AND USES

STATEMENT OF SOURCES AND USES

STATEMENT OF SOURCES AND USES

STATEMENT OF SOURCES AND USES

STATEMENT OF SOURCES AND USES

SALES & MARKETING

SALES & MARKETING

SALES & MARKETING

SALES & MARKETING

SALES & MARKETING

Total Operating Exp

Income Before Int & Taxes

Income Before Taxes

Total Operating Exp

Income Before Int & Taxes

Income Before Taxes

Total Operating Exp

Income Before Int & Taxes

Income Before Taxes

Total Operating Exp

Income Before Int & Taxes

Income Before Taxes

Total Operating Exp

Income Before Int & Taxes

Income Before Taxes

Gross Fixed Assets

Net Fixed Assets

Short Term Liabilities

Long Term Liabilities

LIABILITIES & EQUITY

Gross Fixed Assets

Net Fixed Assets

Short Term Liabilities

Long Term Liabilities

LIABILITIES & EQUITY

Gross Fixed Assets

Net Fixed Assets