copy of financial model 1
TRANSCRIPT
-
8/8/2019 Copy of Financial Model 1
1/92
Version 3.2 (manufacturing)
Company nameFinancial Model: Table of Contents
1) PRELIMINARY STATEMENTS
- Instructions Page 1
- Assumptions Page 2
2) SUMMARY STATEMENTS
- Income Statement Page 4
- Balance Sheet Page 5
- Statement of Sources & Uses Page 6
- Revenue, Gross Margin, & Profit Graph Page 7
- Breakeven Chart Page 8
3) DETAILED FINANCIAL STATEMENTS
- Receipts & Disbursements Page 9
- Statement of Sources & Uses Page 12
- Income Statement Page 15
- Balance Sheet Page 21
4) SALES PROJECTIONS AND MARGIN ANALYSES
- Product One Page 24
- Product Two Page 27
- Product Three Page 30
- Services Page 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
-
8/8/2019 Copy of Financial Model 1
2/92
Company nameFinancial Model: Instructions
1) ENTERING INFORMATION INTO THE MODEL: The DETAIL Worksheet.
-
- Inputs are shaded yellow and appear blue when entered.
-
-
-
2) VIEWING THE RESULTS: The Assumptions Page, Summary Statements, and Revenue Growth a
-
-
-
-
-Click on the Breakeven Chart tab to view the cash flow breakeven point.
-
3) CUSTOMIZING THE FINANCIAL MODEL
-
-
-
4) PRINTING THE FINANCIAL STATEMENTS
-
-
Enter all inputs & assumptions in either the Assumptions page or the DETAILworksheet.
All other cells are protected and their formulas cannot be altered or seen withoutunprotecting 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.
Click on the Assumptions tab to view all inputs and underlying assumptions for thefinancial model.
Click on the Summary Statements tab to view the annual Income Statement, BalanceSheet, 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 inthe 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 five-year projection period.
Data for the Assumptions page and Financial Charts are drawn automatically from theDETAIL worksheet. You do not need to add anything more to these sheets.
To view the formula cells, choose Protection from the TOOLS menu and selectUnprotect Worksheet. To protect the sheet again, choose Protection and select ProtectWorksheet.
The variable inputs in the DETAIL worksheet are designed to accomodate mostbusiness models; however, the financial model can be tailored to suit specific businessneeds 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. Tomake such changes, please contact an ECS Consultant.
To print the entire model, choose Print from the FILE menu and select "EntireWorkbook". Click OK.
To print an individual worksheet (such as the Assumptions sheet only) click on the tabof the sheet you would like to print, choose Print from the FILE menu, and select"Selected Sheet". Click OK.
-
8/8/2019 Copy of Financial Model 1
3/92
Company nFinancial Model: As
SALES
UNITS SALES 2005
Product One -
Product Two -
Product Three -
Services -
AVERAGE UNIT PRICE 2005
Product One -
Product Two -
Product Three -
Services -
COST OF GO
AVERAGE UNIT COST 2005
Product One -
Product Two -
Product Three -
Services -
Returns............................................................(as a percentage of Product One revenu
Returns............................................................(as a percentage of Product Two revenu
Returns............................................................(as a percentage of Product Three reven
Returns............................................................(as a percentage of Services revenue)...
BALANCE SH
Accounts Receivable (adjustable up to 360 days)...............................(in days).............
Accounts Payable (fixed at 30 days)....................................................(in days).............
Salaries Payable (fixed at 15 days)......................................................(in days).............
Taxes Payable (fixed at 90 days)......................................................... (in days).............
Inventory (adjustable up to 360 days).................................................(in days).............
Available Credit Line.............................................................................(as a percentage
Maximum Credit Line Used..................................................................(amount borrowe
Capital Equipment Lease Term (1 year minimum)..............................(in years)............
Long Term Borrowings Term (1 year minimum)..................................(in years)............
DEPRECIATION Hardware Software
Content 3 years 3 years
Engineering 3 years 3 yearsSales & Marketing 3 years 3 years
Administration 3 years 3 years
-
8/8/2019 Copy of Financial Model 1
4/92
Company nFinancial Model: As
EXPENSES
HEADCOUNT 2005
Content -
Engineering -
Sales & Marketing -
Administration -
TOTAL -
PER PERSON EXPENSES Supplies Travel & Mea
Content 100
Engineering 100
Sales & Marketing 100 2
Administration 100 1
EQUIPMENT PURCHASES Hardware Software
Content 3,000 1Engineering 3,500 1
Sales & Marketing 2,500 1
Administration 1,500 1
Benefits & Taxes...................................................................................(as a percentage
Salary Increases....................................................................................(as an annual pe
Sales Commissions...............................................................................(as a percentage
Total Sales Through Commissions........................................................(as a percentage
Business Insurance...............................................................................(as a percentage
Anticipated Bad Debt............................................................................(as a percentage
Interest Revenue..................................................................................(as a percentage
Interest Expense On Credit Line...........................................................(as a percentage
Interest Expense On Capital Equipment Lease....................................(as a percentage
Interest Expense On Long Term Borrowings........................................(as a percentageCombined Federal & State Tax Rate....................................................(as a percentage
Office Rent............................................................................................(per square foot)
Minimum Office Space..........................................................................(square footage p
Term of Office Lease.............................................................................(in months).........
Utilities Expense...................................................................................(per square foot)
Maintanence Expense...........................................................................(per square foot)
-
8/8/2019 Copy of Financial Model 1
5/92
ECEIPTS & DISBURSEMENTS
ompany name
17-Dec-10
1:06 AM
EGINNING CASH
eceipts
Collections
Financings
Borrowings
Interest Revenue
otal receipts
isbursementsSalaries
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
otal Disbursements
hanges in Cash
NDING CASH
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
6/92
RECEIPTS & DISBURSEMENTS
Company name
17-Dec-10
1:06 AM
BEGINNING CASH
Receipts
Collections
Financings
Borrowings
Interest Revenue
Total receipts
DisbursementsSalaries
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
Mo
N
-
8/8/2019 Copy of Financial Model 1
7/92
ECEIPTS & DISBURSEMENTS
ompany name
17-Dec-10
1:06 AM
EGINNING CASH
eceipts
Collections
Financings
Borrowings
Interest Revenue
otal receipts
isbursementsSalaries
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
otal Disbursements
hanges in Cash
NDING CASH
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
8/92
RECEIPTS & DISBURSEMENTS
Company name
17-Dec-10
1:06 AM
BEGINNING CASH
Receipts
Collections
Financings
Borrowings
Interest Revenue
Total receipts
DisbursementsSalaries
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
Mo
N
-
8/8/2019 Copy of Financial Model 1
9/92
RECEIPTS & DISBURSEMENTS
Company name
17-Dec-10
1:06 AM
BEGINNING CASH
Receipts
Collections
Financings
Borrowings
Interest Revenue
Total receipts
DisbursementsSalaries
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
To
20
-
8/8/2019 Copy of Financial Model 1
10/92
TATEMENT OF SOURCES AND USES
ompany name
17-Dec-10
1:06 AM
EGINNING CASH
ources of Cash
Net Income
Add Depr/Amort
Issuance of Preferred Stock
Issuance of Common Stock
lus 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)
otal Sources of Cash
ses of Cash
Buyback of Preferred Stock
Buyback of Common Stock
ess 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
otal Uses
HANGES IN CASH
NDING CASH
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
11/92
STATEMENT OF SOURCES AND USES
Company name
17-Dec-10
1:06 AM
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
Reductions To Long Term Debt
Total Uses
CHANGES IN CASH
ENDING CASH
M
N
-
8/8/2019 Copy of Financial Model 1
12/92
TATEMENT OF SOURCES AND USES
ompany name
17-Dec-10
1:06 AM
EGINNING CASH
ources of Cash
Net Income
Add Depr/Amort
Issuance of Preferred Stock
Issuance of Common Stock
lus 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)
otal Sources of Cash
ses of Cash
Buyback of Preferred Stock
Buyback of Common Stock
ess 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
otal Uses
HANGES IN CASH
NDING CASH
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
13/92
STATEMENT OF SOURCES AND USES
Company name
17-Dec-10
1:06 AM
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
Reductions To Long Term Debt
Total Uses
CHANGES IN CASH
ENDING CASH
M
N
-
8/8/2019 Copy of Financial Model 1
14/92
STATEMENT OF SOURCES AND USES
Company name
17-Dec-10
1:06 AM
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
Reductions To Long Term Debt
Total Uses
CHANGES IN CASH
ENDING CASH
To
20
-
8/8/2019 Copy of Financial Model 1
15/92
NCOME STATEMENT
ompany name
17-Dec-10
1:06 AM
evenue
Product One
Product Two
Product Three
Services
otal Revenue
xpenses
ost of Goods Sold
Direct LaborOther Direct Costs
Direct Materials
Returns
otal COGS
ross Margin
% of Sales
perating Expenses
NGINEERING
Headcount
Salary
Incentives
Benefits & Taxes
Consultants
Supplies/ Materials
Travel & Meals
Telephone/Postage
Operations Setup
Depreciation
otal Expenses
% of Sales
ALES & MARKETING
Headcount
Salary
Incentives/Commissions
Benefits & Taxes
SuppliesTravel & Meals
Telephone/Postage
Depreciation
otal Expenses
% of Sales
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
16/92
INCOME STATEMENT
Company name
17-Dec-10
1:06 AM
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
Expenses
Cost of Goods Sold
Direct LaborOther 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
SuppliesTravel & Meals
Telephone/Postage
Depreciation
Total Expenses
% of Sales
M
N
-
8/8/2019 Copy of Financial Model 1
17/92
NCOME STATEMENT
ompany name
17-Dec-10
1:06 AM
evenue
Product One
Product Two
Product Three
Services
otal Revenue
xpenses
ost of Goods Sold
Direct LaborOther Direct Costs
Direct Materials
Returns
otal COGS
ross Margin
% of Sales
perating Expenses
NGINEERING
Headcount
Salary
Incentives
Benefits & Taxes
Consultants
Supplies/ Materials
Travel & Meals
Telephone/Postage
Operations Setup
Depreciation
otal Expenses
% of Sales
ALES & MARKETING
Headcount
Salary
Incentives/Commissions
Benefits & Taxes
SuppliesTravel & Meals
Telephone/Postage
Depreciation
otal Expenses
% of Sales
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
18/92
INCOME STATEMENT
Company name
17-Dec-10
1:06 AM
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
Expenses
Cost of Goods Sold
Direct LaborOther 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
SuppliesTravel & Meals
Telephone/Postage
Depreciation
Total Expenses
% of Sales
M
N
-
8/8/2019 Copy of Financial Model 1
19/92
INCOME STATEMENT
Company name
17-Dec-10
1:06 AM
Revenue
Product One
Product Two
Product Three
Services
Total Revenue
Expenses
Cost of Goods Sold
Direct LaborOther 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
SuppliesTravel & Meals
Telephone/Postage
Depreciation
Total Expenses
% of Sales
To
20
-
8/8/2019 Copy of Financial Model 1
20/92
NCOME STATEMENT
ompany name
17-Dec-10
1:06 AM
dv/Promotion
Advertising
Trade Shows
Collateral
otal Adv/Promotion
% of Sales
DMINISTRATION
Headcount
SalaryIncentives
Benefits & Taxes
Office Supplies
Travel & Meals
Telephone/Postage
Insurance
Professional Services
Bad Debt
Office Rent
Utilities
Maint/Repair
Depreciation
otal Expenses
% of Sales
otal Operating Exp
% of Sales
ncome Before Int & Taxes
% of Sales
nterest
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)
et Interest Revenue
ncome Before TaxesTax Exp
et Income
% of Sales
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
21/92
INCOME STATEMENT
Company name
17-Dec-10
1:06 AM
Adv/Promotion
Advertising
Trade Shows
Collateral
Total Adv/Promotion
% of Sales
ADMINISTRATION
Headcount
SalaryIncentives
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 TaxesTax Exp
Net Income
% of Sales
M
N
-
8/8/2019 Copy of Financial Model 1
22/92
NCOME STATEMENT
ompany name
17-Dec-10
1:06 AM
dv/Promotion
Advertising
Trade Shows
Collateral
otal Adv/Promotion
% of Sales
DMINISTRATION
Headcount
SalaryIncentives
Benefits & Taxes
Office Supplies
Travel & Meals
Telephone/Postage
Insurance
Professional Services
Bad Debt
Office Rent
Utilities
Maint/Repair
Depreciation
otal Expenses
% of Sales
otal Operating Exp
% of Sales
ncome Before Int & Taxes
% of Sales
nterest
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)
et Interest Revenue
ncome Before TaxesTax Exp
et Income
% of Sales
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
23/92
INCOME STATEMENT
Company name
17-Dec-10
1:06 AM
Adv/Promotion
Advertising
Trade Shows
Collateral
Total Adv/Promotion
% of Sales
ADMINISTRATION
Headcount
SalaryIncentives
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 TaxesTax Exp
Net Income
% of Sales
M
N
-
8/8/2019 Copy of Financial Model 1
24/92
INCOME STATEMENT
Company name
17-Dec-10
1:06 AM
Adv/Promotion
Advertising
Trade Shows
Collateral
Total Adv/Promotion
% of Sales
ADMINISTRATION
Headcount
SalaryIncentives
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 TaxesTax Exp
Net Income
% of Sales
To
20
-
8/8/2019 Copy of Financial Model 1
25/92
ALANCE SHEET
ompany name
17-Dec-10
1:06 AM
SSETS
urrent Assets
Cash
Gross Accounts Receivable (60 days)
Allow for Doubtful Accts (1%)
Net Accounts Rec
Inventory (0 days)
otal Current Assets
ross Fixed Assets
Computer Hardware
Computer Software
Furniture & Fixtures
otal Gross Fixed Assets
ccumulated Depreciation
Computer Hardware
Computer Software
Furniture & Fixtures
otal Accum Deprec
et Fixed Assets
OTAL ASSETS
IABILITIES
hort 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
otal ST Liabs
ong Term Liabilities
Capital Equipment Lease (3 years)Long Term Debt (5 years)
otal LT Liabs
OTAL LIABILITIES
quity
Preferred Stock
Common Stock
Retained Earnings
otal Equity
IABILITIES & EQUITY
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
26/92
BALANCE SHEET
Company name
17-Dec-10
1:06 AM
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
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
M
N
-
8/8/2019 Copy of Financial Model 1
27/92
ALANCE SHEET
ompany name
17-Dec-10
1:06 AM
SSETS
urrent Assets
Cash
Gross Accounts Receivable (60 days)
Allow for Doubtful Accts (1%)
Net Accounts Rec
Inventory (0 days)
otal Current Assets
ross Fixed Assets
Computer Hardware
Computer Software
Furniture & Fixtures
otal Gross Fixed Assets
ccumulated Depreciation
Computer Hardware
Computer Software
Furniture & Fixtures
otal Accum Deprec
et Fixed Assets
OTAL ASSETS
IABILITIES
hort 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
otal ST Liabs
ong Term Liabilities
Capital Equipment Lease (3 years)Long Term Debt (5 years)
otal LT Liabs
OTAL LIABILITIES
quity
Preferred Stock
Common Stock
Retained Earnings
otal Equity
IABILITIES & EQUITY
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
28/92
BALANCE SHEET
Company name
17-Dec-10
1:06 AM
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
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
M
N
-
8/8/2019 Copy of Financial Model 1
29/92
BALANCE SHEET
Company name
17-Dec-10
1:06 AM
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
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
To
20
-
8/8/2019 Copy of Financial Model 1
30/92
ALES PROJECTIONS & MARGIN ANALYSIS
roduct One
17-Dec-10
1:06 AM
nits
s.k.u. 1
s.k.u. 2
otal Units
rice
s.k.u. 1
s.k.u. 2
evenues.k.u. 1
s.k.u. 2
otal Revenue
Proportion of Total Revenues
OGS
nit Cost
s.k.u. 1
s.k.u. 2
irect Materials Cost
s.k.u. 1
s.k.u. 2
otal Direct Materials
eturns (0% of product revenue)
otal COGS
ROSS MARGIN
ross Margin % of Sales
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-05
0 0 0
0 0 0
0 0 0
1.00 1.00 1.00 1.0
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.00 0.00 0.00 0.0
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
-
8/8/2019 Copy of Financial Model 1
31/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product One
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
Mo
N
-
8/8/2019 Copy of Financial Model 1
32/92
ALES PROJECTIONS & MARGIN ANALYSIS
roduct One
17-Dec-10
1:06 AM
nits
s.k.u. 1
s.k.u. 2
otal Units
rice
s.k.u. 1
s.k.u. 2
evenues.k.u. 1
s.k.u. 2
otal Revenue
Proportion of Total Revenues
OGS
nit Cost
s.k.u. 1
s.k.u. 2
irect Materials Cost
s.k.u. 1
s.k.u. 2
otal Direct Materials
eturns (0% of product revenue)
otal COGS
ROSS MARGIN
ross Margin % of Sales
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-06
0 0 0
0 0 0
0 0 0
1.00 1.00 1.00 1.0
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.00 0.00 0.00 0.0
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
-
8/8/2019 Copy of Financial Model 1
33/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product One
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
Mo
N
-
8/8/2019 Copy of Financial Model 1
34/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product One
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
To
20
-
8/8/2019 Copy of Financial Model 1
35/92
ALES PROJECTIONS & MARGIN ANALYSIS
roduct Two
17-Dec-10
1:06 AM
nits
s.k.u. 1
s.k.u. 2
otal Units
rice
s.k.u. 1
s.k.u. 2
evenues.k.u. 1
s.k.u. 2
otal Revenue
Proportion of Total Revenues
OGS
nit Cost
s.k.u. 1
s.k.u. 2
irect Materials Cost
s.k.u. 1
s.k.u. 2
otal Direct Materials
eturns (0% of product revenue)
otal COGS
ROSS MARGIN
ross Margin % of Sales
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-05
0 0 0
0 0 0
0 0 0
0.00 0.00 0.00 0.0
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.00 0.00 0.00 0.0
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
-
8/8/2019 Copy of Financial Model 1
36/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product Two
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
Mo
N
-
8/8/2019 Copy of Financial Model 1
37/92
ALES PROJECTIONS & MARGIN ANALYSIS
roduct Two
17-Dec-10
1:06 AM
nits
s.k.u. 1
s.k.u. 2
otal Units
rice
s.k.u. 1
s.k.u. 2
evenues.k.u. 1
s.k.u. 2
otal Revenue
Proportion of Total Revenues
OGS
nit Cost
s.k.u. 1
s.k.u. 2
irect Materials Cost
s.k.u. 1
s.k.u. 2
otal Direct Materials
eturns (0% of product revenue)
otal COGS
ROSS MARGIN
ross Margin % of Sales
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-06
0 0 0
0 0 0
0 0 0
0.00 0.00 0.00 0.0
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.00 0.00 0.00 0.0
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
-
8/8/2019 Copy of Financial Model 1
38/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product Two
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
Mo
N
-
8/8/2019 Copy of Financial Model 1
39/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product Two
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
To
20
-
8/8/2019 Copy of Financial Model 1
40/92
ALES PROJECTIONS & MARGIN ANALYSIS
roduct Three
17-Dec-10
1:06 AM
nits
s.k.u. 1
s.k.u. 2
otal Units
rice
s.k.u. 1
s.k.u. 2
evenues.k.u. 1
s.k.u. 2
otal Revenue
Proportion of Total Revenues
OGS
nit Cost
s.k.u. 1
s.k.u. 2
irect Materials Cost
s.k.u. 1
s.k.u. 2
otal Direct Materials
eturns (0% of product revenue)
otal COGS
ROSS MARGIN
ross Margin % of Sales
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-05
0 0 0
0 0 0
0 0 0
0.00 0.00 0.00 0.0
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.00 0.00 0.00 0.0
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
-
8/8/2019 Copy of Financial Model 1
41/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product Three
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
Mo
N
-
8/8/2019 Copy of Financial Model 1
42/92
ALES PROJECTIONS & MARGIN ANALYSIS
roduct Three
17-Dec-10
1:06 AM
nits
s.k.u. 1
s.k.u. 2
otal Units
rice
s.k.u. 1
s.k.u. 2
evenues.k.u. 1
s.k.u. 2
otal Revenue
Proportion of Total Revenues
OGS
nit Cost
s.k.u. 1
s.k.u. 2
irect Materials Cost
s.k.u. 1
s.k.u. 2
otal Direct Materials
eturns (0% of product revenue)
otal COGS
ROSS MARGIN
ross Margin % of Sales
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-06
0 0 0
0 0 0
0 0 0
0.00 0.00 0.00 0.0
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.00 0.00 0.00 0.0
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
-
8/8/2019 Copy of Financial Model 1
43/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product Three
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
Mo
N
-
8/8/2019 Copy of Financial Model 1
44/92
SALES PROJECTIONS & MARGIN ANALYSIS
Product Three
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
To
20
-
8/8/2019 Copy of Financial Model 1
45/92
ALES PROJECTIONS & MARGIN ANALYSIS
ervices
17-Dec-10
1:06 AM
nits
s.k.u. 1
s.k.u. 2
otal Units
rice
s.k.u. 1
s.k.u. 2
evenues.k.u. 1
s.k.u. 2
otal Revenue
Proportion of Total Revenues
OGS
nit Cost
s.k.u. 1
s.k.u. 2
irect Materials Cost
s.k.u. 1
s.k.u. 2
otal Direct Materials
abor
ther Direct Costs
eturns (0% of product revenue)
otal COGS
ROSS MARGIN
ross Margin % of Sales
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-05
0 0 0
0 0 0
0 0 0
1.00 1.00 1.00 1.0
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.00 0.00 0.00 0.0
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
-
8/8/2019 Copy of Financial Model 1
46/92
SALES PROJECTIONS & MARGIN ANALYSIS
Services
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
Mo
N
-
8/8/2019 Copy of Financial Model 1
47/92
ALES PROJECTIONS & MARGIN ANALYSIS
ervices
17-Dec-10
1:06 AM
nits
s.k.u. 1
s.k.u. 2
otal Units
rice
s.k.u. 1
s.k.u. 2
evenues.k.u. 1
s.k.u. 2
otal Revenue
Proportion of Total Revenues
OGS
nit Cost
s.k.u. 1
s.k.u. 2
irect Materials Cost
s.k.u. 1
s.k.u. 2
otal Direct Materials
abor
ther Direct Costs
eturns (0% of product revenue)
otal COGS
ROSS MARGIN
ross Margin % of Sales
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-06
0 0 0
0 0 0
0 0 0
1.00 1.00 1.00 1.0
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.00 0.00 0.00 0.0
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
-
8/8/2019 Copy of Financial Model 1
48/92
SALES PROJECTIONS & MARGIN ANALYSIS
Services
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
Mo
N
-
8/8/2019 Copy of Financial Model 1
49/92
SALES PROJECTIONS & MARGIN ANALYSIS
Services
17-Dec-10
1:06 AM
Units
s.k.u. 1
s.k.u. 2
Total Units
Price
s.k.u. 1
s.k.u. 2
Revenues.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
To
20
-
8/8/2019 Copy of Financial Model 1
50/92
TAFFING PLAN
ompany name
17-Dec-10
1:06 AM
ontent
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support Assistant
otal Staff
ngineering
CTOSystem Administration
Project Manager
Programming
Quality Assurance
otal Staff
ales & Marketing
VP Marketing
Mktg. Manager
VP Sales
Sales Representative
Sales Engineer
VP Business Development
Customer Support
Mktg. Assistant
otal Staff
dministration
CEO
CFO
COO
HR Manager
Office Manager
Admin. Assistant
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
51/92
STAFFING PLAN
Company name
17-Dec-10
1:06 AM
Content
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support Assistant
Total Staff
Engineering
CTOSystem 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
Admin. Assistant
Mo
N
-
8/8/2019 Copy of Financial Model 1
52/92
TAFFING PLAN
ompany name
17-Dec-10
1:06 AM
ontent
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support Assistant
otal Staff
ngineering
CTOSystem Administration
Project Manager
Programming
Quality Assurance
otal Staff
ales & Marketing
VP Marketing
Mktg. Manager
VP Sales
Sales Representative
Sales Engineer
VP Business Development
Customer Support
Mktg. Assistant
otal Staff
dministration
CEO
CFO
COO
HR Manager
Office Manager
Admin. Assistant
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
53/92
STAFFING PLAN
Company name
17-Dec-10
1:06 AM
Content
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support Assistant
Total Staff
Engineering
CTOSystem 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
Admin. Assistant
Mo
N
-
8/8/2019 Copy of Financial Model 1
54/92
STAFFING PLAN
Company name
17-Dec-10
1:06 AM
Content
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support Assistant
Total Staff
Engineering
CTOSystem 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
Admin. Assistant
To
20
-
8/8/2019 Copy of Financial Model 1
55/92
otal Staff
OTAL EMPLOYEES
revenue per employee
ALARIES PAID
ompany name
17-Dec-10
1:06 AM
ONTENT
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support Assistantotal Salaries Paid
NGINEERING
CTO
System Administration
Project Manager
Programming
Quality Assurance
otal Salaries Paid
ALES & MARKETING
VP Marketing
Mktg. Manager
VP SalesSales Representative
Sales Engineer
VP Business Development
Customer Support
Mktg. Assistant
otal Salaries Paid
DMINISTRATION
CEO
CFO
COO
HR Manager
0 0 0
0 0 0
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
56/92
Total Staff
TOTAL EMPLOYEES
revenue per employee
SALARIES PAID
Company name
17-Dec-10
1:06 AM
CONTENT
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support AssistantTotal Salaries Paid
ENGINEERING
CTO
System Administration
Project Manager
Programming
Quality Assurance
Total Salaries Paid
SALES & MARKETING
VP Marketing
Mktg. Manager
VP SalesSales Representative
Sales Engineer
VP Business Development
Customer Support
Mktg. Assistant
Total Salaries Paid
ADMINISTRATION
CEO
CFO
COO
HR Manager
Mo
N
-
8/8/2019 Copy of Financial Model 1
57/92
otal Staff
OTAL EMPLOYEES
revenue per employee
ALARIES PAID
ompany name
17-Dec-10
1:06 AM
ONTENT
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support Assistantotal Salaries Paid
NGINEERING
CTO
System Administration
Project Manager
Programming
Quality Assurance
otal Salaries Paid
ALES & MARKETING
VP Marketing
Mktg. Manager
VP SalesSales Representative
Sales Engineer
VP Business Development
Customer Support
Mktg. Assistant
otal Salaries Paid
DMINISTRATION
CEO
CFO
COO
HR Manager
0 0 0
0 0 0
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
58/92
Total Staff
TOTAL EMPLOYEES
revenue per employee
SALARIES PAID
Company name
17-Dec-10
1:06 AM
CONTENT
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support AssistantTotal Salaries Paid
ENGINEERING
CTO
System Administration
Project Manager
Programming
Quality Assurance
Total Salaries Paid
SALES & MARKETING
VP Marketing
Mktg. Manager
VP SalesSales Representative
Sales Engineer
VP Business Development
Customer Support
Mktg. Assistant
Total Salaries Paid
ADMINISTRATION
CEO
CFO
COO
HR Manager
Mo
N
-
8/8/2019 Copy of Financial Model 1
59/92
Total Staff
TOTAL EMPLOYEES
revenue per employee
SALARIES PAID
Company name
17-Dec-10
1:06 AM
CONTENT
Senior Application Engineer
Inventory
Technical Support Mgr.
Technical Support
Tech. Support AssistantTotal Salaries Paid
ENGINEERING
CTO
System Administration
Project Manager
Programming
Quality Assurance
Total Salaries Paid
SALES & MARKETING
VP Marketing
Mktg. Manager
VP SalesSales Representative
Sales Engineer
VP Business Development
Customer Support
Mktg. Assistant
Total Salaries Paid
ADMINISTRATION
CEO
CFO
COO
HR Manager
To
20
-
8/8/2019 Copy of Financial Model 1
60/92
Office Manager
Admin. Assistant
otal Salaries Paid
OTAL SALARIES PAID
Benefits & Taxes on Salary
Annual Salary Growth Factor
APITAL PURCHASES
ompany name
17-Dec-10
1:06 AM
ONTENT
Computer HardwareComputer Software
Furniture & Fixtures
otal Purchases for Period
of which Leased
NGINEERING
Computer Hardware
Computer Software
Furniture & Fixtures
otal Purchases for Period
of which Leased
ALES & MARKETING
Computer HardwareComputer Software
Furniture & Fixtures
otal Purchases for Period
of which Leased
DMINISTRATION
Computer Hardware
0 0 0
0 0 0
0 0 0
0 0 0
25% 25% 25% 25
100.0% 100.0% 100.0% 100.0
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
61/92
Office Manager
Admin. Assistant
Total Salaries Paid
TOTAL SALARIES PAID
Benefits & Taxes on Salary
Annual Salary Growth Factor
CAPITAL PURCHASES
Company name
17-Dec-10
1:06 AM
CONTENT
Computer HardwareComputer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
ENGINEERING
Computer Hardware
Computer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
SALES & MARKETING
Computer HardwareComputer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
ADMINISTRATION
Computer Hardware
Mo
N
-
8/8/2019 Copy of Financial Model 1
62/92
Office Manager
Admin. Assistant
otal Salaries Paid
OTAL SALARIES PAID
Benefits & Taxes on Salary
Annual Salary Growth Factor
APITAL PURCHASES
ompany name
17-Dec-10
1:06 AM
ONTENT
Computer HardwareComputer Software
Furniture & Fixtures
otal Purchases for Period
of which Leased
NGINEERING
Computer Hardware
Computer Software
Furniture & Fixtures
otal Purchases for Period
of which Leased
ALES & MARKETING
Computer HardwareComputer Software
Furniture & Fixtures
otal Purchases for Period
of which Leased
DMINISTRATION
Computer Hardware
0 0 0
0 0 0
0 0 0
0 0 0
25% 25% 25% 25
105.0% 105.0% 105.0% 105.0
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
63/92
Office Manager
Admin. Assistant
Total Salaries Paid
TOTAL SALARIES PAID
Benefits & Taxes on Salary
Annual Salary Growth Factor
CAPITAL PURCHASES
Company name
17-Dec-10
1:06 AM
CONTENT
Computer HardwareComputer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
ENGINEERING
Computer Hardware
Computer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
SALES & MARKETING
Computer HardwareComputer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
ADMINISTRATION
Computer Hardware
Mo
N
-
8/8/2019 Copy of Financial Model 1
64/92
Office Manager
Admin. Assistant
Total Salaries Paid
TOTAL SALARIES PAID
Benefits & Taxes on Salary
Annual Salary Growth Factor
CAPITAL PURCHASES
Company name
17-Dec-10
1:06 AM
CONTENT
Computer HardwareComputer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
ENGINEERING
Computer Hardware
Computer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
SALES & MARKETING
Computer HardwareComputer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
ADMINISTRATION
Computer Hardware
To
20
-
8/8/2019 Copy of Financial Model 1
65/92
Computer Software
Furniture & Fixtures
otal Purchases for Period
of which Leased
OTAL PURCHASES FOR PERIOD
of which leased
EPRECIATION
ompany name
17-Dec-10
1:06 AM
ONTENT
Computer Hardware (3 years)Computer Software (3 years)
Furniture & Fixtures (3 years)
otal Depreciation for Period
NGINEERING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
otal Depreciation for Period
ALES & MARKETING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)otal Depreciation for Period
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
66/92
Computer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
TOTAL PURCHASES FOR PERIOD
of which leased
DEPRECIATION
Company name
17-Dec-10
1:06 AM
CONTENT
Computer Hardware (3 years)Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
ENGINEERING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
SALES & MARKETING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)Total Depreciation for Period
Mo
N
-
8/8/2019 Copy of Financial Model 1
67/92
Computer Software
Furniture & Fixtures
otal Purchases for Period
of which Leased
OTAL PURCHASES FOR PERIOD
of which leased
EPRECIATION
ompany name
17-Dec-10
1:06 AM
ONTENT
Computer Hardware (3 years)Computer Software (3 years)
Furniture & Fixtures (3 years)
otal Depreciation for Period
NGINEERING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
otal Depreciation for Period
ALES & MARKETING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)otal Depreciation for Period
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
68/92
Computer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
TOTAL PURCHASES FOR PERIOD
of which leased
DEPRECIATION
Company name
17-Dec-10
1:06 AM
CONTENT
Computer Hardware (3 years)Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
ENGINEERING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
SALES & MARKETING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)Total Depreciation for Period
Mo
N
-
8/8/2019 Copy of Financial Model 1
69/92
Computer Software
Furniture & Fixtures
Total Purchases for Period
of which Leased
TOTAL PURCHASES FOR PERIOD
of which leased
DEPRECIATION
Company name
17-Dec-10
1:06 AM
CONTENT
Computer Hardware (3 years)Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
ENGINEERING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
SALES & MARKETING
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)Total Depreciation for Period
To
20
-
8/8/2019 Copy of Financial Model 1
70/92
DMINISTRATION
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
otal Depreciation for Period
OTAL DEPRECIATION FOR PERIOD
MANUFACTURING & INVENTORY
ompany name
17-Dec-10
1:06 AM
ONTENT
aborHeadcount
Salary
Incentives
Benefits & Taxes
otal Labor
ther Direct Costs
Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
otal Other Direct Costs
otal Operations
nventory (0 days)
NVENTORY: Beginning
Product One
Product Two
Product Three
Services
otal Beginning Inventory
DD: Purchases
Product One
Product Two
Product ThreeServices
otal Purchases
ESS: Materials Expense
Product One
Product Two
Product Three
Services
otal Materials Expense
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
71/92
ADMINISTRATION
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
TOTAL DEPRECIATION FOR PERIOD
MANUFACTURING & INVENTORY
Company name
17-Dec-10
1:06 AM
CONTENT
LaborHeadcount
Salary
Incentives
Benefits & Taxes
Total Labor
Other Direct Costs
Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
Total Other Direct Costs
Total Operations
Inventory (0 days)
INVENTORY: Beginning
Product One
Product Two
Product Three
Services
Total Beginning Inventory
ADD: Purchases
Product One
Product Two
Product ThreeServices
Total Purchases
LESS: Materials Expense
Product One
Product Two
Product Three
Services
Total Materials Expense
M
N
-
8/8/2019 Copy of Financial Model 1
72/92
DMINISTRATION
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
otal Depreciation for Period
OTAL DEPRECIATION FOR PERIOD
MANUFACTURING & INVENTORY
ompany name
17-Dec-10
1:06 AM
ONTENT
aborHeadcount
Salary
Incentives
Benefits & Taxes
otal Labor
ther Direct Costs
Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
otal Other Direct Costs
otal Operations
nventory (0 days)
NVENTORY: Beginning
Product One
Product Two
Product Three
Services
otal Beginning Inventory
DD: Purchases
Product One
Product Two
Product ThreeServices
otal Purchases
ESS: Materials Expense
Product One
Product Two
Product Three
Services
otal Materials Expense
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
73/92
ADMINISTRATION
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
TOTAL DEPRECIATION FOR PERIOD
MANUFACTURING & INVENTORY
Company name
17-Dec-10
1:06 AM
CONTENT
LaborHeadcount
Salary
Incentives
Benefits & Taxes
Total Labor
Other Direct Costs
Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
Total Other Direct Costs
Total Operations
Inventory (0 days)
INVENTORY: Beginning
Product One
Product Two
Product Three
Services
Total Beginning Inventory
ADD: Purchases
Product One
Product Two
Product ThreeServices
Total Purchases
LESS: Materials Expense
Product One
Product Two
Product Three
Services
Total Materials Expense
M
N
-
8/8/2019 Copy of Financial Model 1
74/92
ADMINISTRATION
Computer Hardware (3 years)
Computer Software (3 years)
Furniture & Fixtures (3 years)
Total Depreciation for Period
TOTAL DEPRECIATION FOR PERIOD
MANUFACTURING & INVENTORY
Company name
17-Dec-10
1:06 AM
CONTENT
LaborHeadcount
Salary
Incentives
Benefits & Taxes
Total Labor
Other Direct Costs
Supplies/ Materials
Travel & Meals
Telephone/Postage
Depreciation
Total Other Direct Costs
Total Operations
Inventory (0 days)
INVENTORY: Beginning
Product One
Product Two
Product Three
Services
Total Beginning Inventory
ADD: Purchases
Product One
Product Two
Product ThreeServices
Total Purchases
LESS: Materials Expense
Product One
Product Two
Product Three
Services
Total Materials Expense
To
20
-
8/8/2019 Copy of Financial Model 1
75/92
NVENTORY: Ending
Product One
Product Two
Product Three
Services
otal Ending Inventory
ENT & TAXES
ompany name
17-Dec-10
1:06 AM
ENT
Total Office Square FootageSquare Footage per Person (250 ft. minimum)
Price per Square Foot
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-05
0 0 0 0 0 0
1.50 1.50 1.50 1.5
-
8/8/2019 Copy of Financial Model 1
76/92
INVENTORY: Ending
Product One
Product Two
Product Three
Services
Total Ending Inventory
RENT & TAXES
Company name
17-Dec-10
1:06 AM
RENT
Total Office Square FootageSquare Footage per Person (250 ft. minimum)
Price per Square Foot
Mo
N
-
8/8/2019 Copy of Financial Model 1
77/92
NVENTORY: Ending
Product One
Product Two
Product Three
Services
otal Ending Inventory
ENT & TAXES
ompany name
17-Dec-10
1:06 AM
ENT
Total Office Square FootageSquare Footage per Person (250 ft. minimum)
Price per Square Foot
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-06
0 0 0 0 0 0
1.50 1.50 1.50 1.5
-
8/8/2019 Copy of Financial Model 1
78/92
INVENTORY: Ending
Product One
Product Two
Product Three
Services
Total Ending Inventory
RENT & TAXES
Company name
17-Dec-10
1:06 AM
RENT
Total Office Square FootageSquare Footage per Person (250 ft. minimum)
Price per Square Foot
Mo
N
-
8/8/2019 Copy of Financial Model 1
79/92
INVENTORY: Ending
Product One
Product Two
Product Three
Services
Total Ending Inventory
RENT & TAXES
Company name
17-Dec-10
1:06 AM
RENT
Total Office Square FootageSquare Footage per Person (250 ft. minimum)
Price per Square Foot
Tot
200
-
8/8/2019 Copy of Financial Model 1
80/92
Total Office Rent (12 month lease)
AXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
INANCING ACTIVITIES
ompany name
17-Dec-10
1:06 AM
EBT
dditions To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
otal Additions
ayments To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
otal Payments
QUITY
ssuance of:
Preferred Stock
Common Stock
otal Equity Investment
uyback of:
Preferred Stock
Common Stock
otal Stock Buyback
0 0 0
0 0 0
0 0 0
0 0 0
Month 1 Month 2 Month 3 Month 4
Jan-05 Feb-05 Mar-05 Apr-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
-
8/8/2019 Copy of Financial Model 1
81/92
Total Office Rent (12 month lease)
TAXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
FINANCING ACTIVITIES
Company name
17-Dec-10
1:06 AM
DEBT
Additions To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
Total Additions
Payments To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
Total Payments
EQUITY
Issuance of:
Preferred Stock
Common Stock
Total Equity Investment
Buyback of:
Preferred Stock
Common Stock
Total Stock Buyback
Mo
N
-
8/8/2019 Copy of Financial Model 1
82/92
Total Office Rent (12 month lease)
AXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
INANCING ACTIVITIES
ompany name
17-Dec-10
1:06 AM
EBT
dditions To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
otal Additions
ayments To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
otal Payments
QUITY
ssuance of:
Preferred Stock
Common Stock
otal Equity Investment
uyback of:
Preferred Stock
Common Stock
otal Stock Buyback
0 0 0
0 0 0
0 0 0
0 0 0
Month 13 Month 14 Month 15 Month 16
Jan-06 Feb-06 Mar-06 Apr-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
-
8/8/2019 Copy of Financial Model 1
83/92
Total Office Rent (12 month lease)
TAXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
FINANCING ACTIVITIES
Company name
17-Dec-10
1:06 AM
DEBT
Additions To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
Total Additions
Payments To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
Total Payments
EQUITY
Issuance of:
Preferred Stock
Common Stock
Total Equity Investment
Buyback of:
Preferred Stock
Common Stock
Total Stock Buyback
Mo
N
-
8/8/2019 Copy of Financial Model 1
84/92
Total Office Rent (12 month lease)
TAXES
Cumulative Loss
Taxable Income
Tax Expense (40%)
FINANCING ACTIVITIES
Company name
17-Dec-10
1:06 AM
DEBT
Additions To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
Total Additions
Payments To:
Line of Credit
Capital Equipment Lease
Long Term Borrowings
Total Payments
EQUITY
Issuance of:
Preferred Stock
Common Stock
Total Equity Investment
Buyback of:
Preferred Stock
Common Stock
Total Stock Buyback
To
20
-
8/8/2019 Copy of Financial Model 1
85/92
Company nameIncome Statement ($)
2005 2006 2007 2008
Revenue
Product One $0 $0 $0 $0
Product Two $0 $0 $0 $0
Product Three $0 $0 $0 $0
Services $0 $0 $0 $0
Total Revenue $0 $0 $0 $0
Cost of Goods Sold $0 $0 $0 $0
Gross Margin $0 $0 $0 $0
% of Revenue 0% 0% 0% 0%
Operating Expenses
Engineering $0 $0 $0 $0
% of Revenue 0% 0% 0% 0%
Marketing/Sales $0 $0 $0 $0
% of Revenue 0% 0% 0% 0%
Administration $0 $0 $0 $0
% of Revenue 0% 0% 0% 0%
Total Operating Expenses $0 $0 $0 $0
% of Revenue 0% 0% 0% 0%
Income Before Int & Taxes $0 $0 $0 $0
% of Revenue 0% 0% 0% 0%
Interest Expense $0 $0 $0 $0
Interest Revenue $0 $0 $0 $0
Income Before Taxes $0 $0 $0 $0
Tax Exp $0 $0 $0 $0
Net Income $0 $0 $0 $0
% of Revenue 0% 0% 0% 0%
-
8/8/2019 Copy of Financial Model 1
86/92
Company nameBalance Sheet ($)
2005 2006 2007 2008
ASSETS
Current Assets
Cash $0 $0 $0 $0
Net Accounts Rec $0 $0 $0 $0
Inventory (0 days) $0 $0 $0 $0
Total Current Assets $0 $0 $0 $0
Gross Fixed Assets $0 $0 $0 $0
Less Accum Depreciation $0 $0 $0 $0
Net Fixed Assets $0 $0 $0 $0
TOTAL ASSETS $0 $0 $0 $0
LIABILITIES
Short Term Liabilities
Accounts Payable (30 days) $0 $0 $0 $0
Salaries Payable (15 days) $0 $0 $0 $0
Taxes Payable (90 days) $0 $0 $0 $0
Line of Credit (0% of net A/R) $0 $0 $0 $0
Current Portion of Capital Equipment Lease $0 $0 $0 $0
Current Portion of Long Term Debt $0 $0 $0 $0
Total Short Term Liabilities $0 $0 $0 $0
Long Term Liabilities
Capital Equipment Lease (3 years) $0 $0 $0 $0
Long Term Debt (5 years) $0 $0 $0 $0
Total Long Term Liabilities $0 $0 $0 $0
TOTAL LIABILITIES $0 $0 $0 $0
Equity
Preferred Stock $0 $0 $0 $0
Common Stock $0 $0 $0 $0
Retained Earnings $0 $0 $0 $0
Total Equity $0 $0 $0 $0
LIABILITIES & EQUITY $0 $0 $0 $0
-
8/8/2019 Copy of Financial Model 1
87/92
Company nameStatement of Sources & Uses ($)
2005 2006 2007 2008
BEGINNING CASH $0 $0 $0 $0
Sources of Cash
Net Income $0 $0 $0 $0
Add Depr/Amort $0 $0 $0 $0
Issuance of Preferred Stock $0 $0 $0 $0
Issuance of Common Stock $0 $0 $0 $0
Plus Changes In:
Accounts Payable (30 days) $0 $0 $0 $0 Salaries Payable (15 days) $0 $0 $0 $0
Taxes Payable (90 days) $0 $0 $0 $0
Additions to Line of Credit (0% of net A/R) $0 $0 $0 $0
Additions to Capital Equipment Lease (3 yea $0 $0 $0 $0
Additions to Long Term Debt (5 years) $0 $0 $0 $0
Total Sources of Cash $0 $0 $0 $0
Uses of Cash
Less Changes In:
Net Accounts Rec $0 $0 $0 $0
Inventory (0 days) $0 $0 $0 $0
Gross Fixed Assets $0 $0 $0 $0
Reductions To Credit Line $0 $0 $0 $0
Reductions To Capital Equipment Lease $0 $0 $0 $0
Reductions To Long Term Debt $0 $0 $0 $0
Total Uses $0 $0 $0 $0
CHANGES IN CASH $0 $0 $0 $0
ENDING CASH $0 $0 $0 $0
-
8/8/2019 Copy of Financial Model 1
88/92
Page 7
2005 2006 2007 2008 2009
Forecasted Revenue, Gross Margin, & Income
Revenue Gross Margin Net Income
$MM
-
8/8/2019 Copy of Financial Model 1
89/92
Jan-05Feb-05
Mar-05Apr-05
May-05Jun-05
Jul-05Aug-05
Sep-05Oct-05
Nov-05Dec-05
Jan-06Feb-06
Mar-06Apr-06
May-06Jun-06
Jul-06Aug-06
Sep-06Oct-06
Nov-06Dec-06
100
Cash Flow Breakeven
Receipts Disbursements
$(000s)
-
8/8/2019 Copy of Financial Model 1
90/92
48159309.xls
Page 9
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 Jun-05 Jul-05 Aug-05 Sep-05
Receipts
Disbursements
-
8/8/2019 Copy of Financial Model 1
91/92
48159309.xls
Page 10
Oct-05 Nov-05 Dec-05 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06
-
8/8/2019 Copy of Financial Model 1
92/92
48159309.xls
Sep-06 Oct-06 Nov-06 Dec-06