Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Income Statement
2008
(Pro Forma)
9 Months
Ended
9/30/08
2007 2006
Revenues (net) 59,766$ 44,227$ 52,994$ 47,443$
Cost of Goods Sold 27,269 20,224 24,806 22,930
Gross Margin 32,498 24,003 28,188 24,513
Operating Expenses
Balance Sheet
2008
(Pro
Forma)
9 Months
Ended
9/30/08
2007 2006 2005
Current Assets
Cash 5,930$ 5,448$ 5,258$ 4,701$ 4,178$
Accounts Receivable (net) 12,898 12,153 11,436 10,238 9,093
Inventories 6,767 6,216 6,000 5,371 4,770
Current Liabilities
Accounts Payable 4,496 4,348 4,423 3,960 3,516
Notes Payable 14,860 14,640 12,040 9,470 6,210
Tax Payable 384 253 368 239 111
Non-Current Liabilities
Long-term Debt 348 433 687 1,027 1,366
Owners' Equity
Common Stock 189 189 189 189 189
Additional Paid-in-Capital 4,546 4,546 4,546 4,546 4,546
Statement of Cash Flows
2008
(Pro Forma)
9 Months
Ended
9/30/08
2007 2006
OPERATIONS:
Net Income 3,738$ 2,570$ 2,630$ 1,707$
Adjustments to Reconcile:
Depreciation and Amortization 5,182 3,836 4,275 3,813
INVESTING:
Additions to PP&E 6,509 5,845 5,978 5,482
FINANCING:
Borrowing of Notes Payable 14,860 11,510 12,040 9,470
Repayments of Notes Payable (12,040) (8,910) (9,470) (6,210)
Long-term Borrowing - - - -
Staffing Budget
Current
FTE
Estimated
Attrition
Requested
FTE
Anticipated
Need
(Excess)
Estimated
Market
Adjustment
Manufacturing:
Management 4 - 4 - 3.0%
Supervisory 8 1 8 1 2.0%
Engineering:
Management 4 - 4 - 3.5%
Science 5 - 5 - 3.0%
Engineering 16 1 16 1 3.6%
Sales & Marketing:
Management 5 - 5 - 2.0%
Commissioned 4 1 5 2 1.5%
Finance Division:
Management 5 - 5 - 3.0%
Professional 9 1 9 1 3.0%
Technical 6 8 2 1.8%
2009 Budgeted Income Summary
Comments & Analysis
Revenues (net) 65,743$ 10% Growth
Cost of Goods
Direct Materials 12,742
Operating Expense
Selling
Salary & Wages 2,807 Includes est. commissions of $965 + $190 mgmt. bonus
Research & Development
Salary & Wages 4,934 Includes $210 for management bonuses
Depr. & Amortization 1,712 Includes $430 on 2009 investments.
Gen. & Admin.
Salary & Wages 6,567 Includes $445 for management bonuses
Total % Variable Variable Fixed
Revenues (net) 65,743$ 100% 65,743$ -
Cost of Goods
Direct Materials 12,742 100% 12,742 -
Direct Labor 6,959 0% - 6,959
Mfg. Overhead - -
Operating Expense
Selling
Salary & Wages 2,807 34% 965 1,842
Marketing & Advertising 5,036 15% 755 4,281
Gen. & Admin.
Salary & Wages 6,567 0% - 6,567
Depr. & Amortization 791 0% - 791
2009 Contribution I/S Percentage
Revenues 58,796$ 100.0%
Variable Expenses:
Fixed Expenses:
Product Costs 16,345$
Selling 6,210
Dollars
Balance Sheet FYE 2008 FYE 2009
Current Assets
Cash 5,930$ 5,652$ "five weeks operating expenditures"
Accounts Receivable (net) 12,898 12,079 "between 60 and 80 days of trailing sales"
Current Liabilities
Accounts Payable 4,496 4,496
Notes Payable 14,860 13,867 This should be the plug (goal seek: A = L +OE)
Tax Payable 384 -
Owners' Equity
Common Stock 189 189
- -
Statement of Cash Flows
2008
(Pro Forma)
2009
(Breakeven)
OPERATIONS:
Net Income 3,738$ -$ Breakeven net income is zero
Adjustments to Reconcile:
Depreciation and Amortization 5,182 5,651 Provided in the budget
INVESTING:
Additions to PP&E 6,509
Acquistitions of Technology Licenses
1,889
Cash Flow from (used by) Financing 2,481 (1,332)
2009 Contribution Income Statement Assumption - 14% - 50%
Revenues 58,576$ Breakeven at current price levels 51,399$ 29,883$
Variable Expenses:
Product Costs 12,032$ 20.5% of Revenue
Selling 4,768 8.1% of Revenue
Discretionary Fixed Expenses: Managers awarded budgeted bonuses
Product Costs 160
Selling 4,471
R & D 1,889
G & A 2,505 8,865
6,901
Balance Sheet FYE 2008 FYE 2009
Current Assets
Cash 5,930$ 5,089$ "five weeks operating expenditures"
Current Liabilities
Accounts Payable 4,496 3,858 Cash based on operating expense, A/R proportional to cash
Notes Payable 14,860 27,286 This should be the plug (goal seek: A = L + OE)
Tax Payable 384 -
Statement of Cash Flows
2008 2009
OPERATIONS:
Net Income 3,738$ 0$
INVESTING:
Additions to PP&E 6,509
Acquistitions of Technology Licenses 1,889
Cash Flow used for Investing Activities 8,398 5,960 Total provided in the budget
FINANCING:
