Final Project - Pro Forma
Richard Holmes
ENTRPFinalProject_FinacialModelTemplate.xlsxAssumptions
| Sample Company | ||||||||||||||||||||||||
| General Assumptions | ||||||||||||||||||||||||
| Operating Plan | ||||||||||||||||||||||||
| Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | |
| Employment Related: | ||||||||||||||||||||||||
| Payroll taxes | 9% | 7% | 7% | 7% | 7% | 7% | 7% | 7% | 7% | 7% | 7% | 7% | 9% | 9% | 9% | 9% | 9% | 9% | 9% | 9% | 9% | 9% | 9% | 9% |
| Employee benefits | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% |
| Raise pool | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 3% | 3% | 3% | 3% | 3% | 3% | 3% | 3% | 3% | 3% | 3% | 3% |
| Sales commissions | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% |
| (Not Used at this time) | ||||||||||||||||||||||||
| B&O Taxes: | ||||||||||||||||||||||||
| Standard B&O rate | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% |
| % of sales subject to B&O | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% | 100% |
| Effective B&O rate | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% | 1.60% |
| Income Tax Rate | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% | 34.0% |
| Financing Related: | ||||||||||||||||||||||||
| Int rate: Cash Balances | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% | 0.1% |
| Int rate: Start up loans | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% | 10.0% |
| Int rate: Convertible notes | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% | 6.0% |
| Other Assumptions: | ||||||||||||||||||||||||
| A/R (See BS) | 0 - 30 | 0% | 31 - 60 | 70% | 61 - 90 | 30% | 91 - 120 | 0% | ||||||||||||||||
| A/P (% of expenses) | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% |
&F &A Page &P of &N Denali Financial Consulting - &D &T
Income Statement
| Sample Company | ||||||||||||||||||||||||||
| Operating Plan | ||||||||||||||||||||||||||
| Profit & Loss, and Cash Flow | ||||||||||||||||||||||||||
| Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Total 2021 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Total 2014 | |
| Revenue: | ||||||||||||||||||||||||||
| Subscriptions | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Open | 0 | 0 | 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 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 |
| Cost of Revenues: | ||||||||||||||||||||||||||
| Data Center | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Merchant fees | 0 | 0 | 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 cost of 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 |
| 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 |
| Gross margin % | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Operating expenses: | ||||||||||||||||||||||||||
| Employee Headcount: | ||||||||||||||||||||||||||
| Salaries | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Commissions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Bonus | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Payroll taxes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Employee benefts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Employee headcount subtotal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Recruiting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Professional fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Rent & utilities | 0 | 0 | 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 |
| Travel & entertainment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Office expense & other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Subtotal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Operating income | 0 | 0 | 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 inc (exp): | ||||||||||||||||||||||||||
| Interest income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Interest 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 |
| Income (loss) before taxes | 0 | 0 | 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 taxes | 0 | 0 | 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 (loss) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Cash Balance: | ||||||||||||||||||||||||||
| Net income (loss) from above | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Cash Adjustments: | ||||||||||||||||||||||||||
| Capital 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 |
| Founder 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 | |
| Investors | 0 | 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 | 0 | 0 | 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 | 0 | 0 | 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 change in cash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Cash - Beginning | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Cash - Ending | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
&F &A Page &P of &N Denali Financial Consulting - &D &T
Revenue & COR
| Sample Company | ||||||||||||||||||||||||
| Revenue & Cost of Revenue | ||||||||||||||||||||||||
| Operating Plan | ||||||||||||||||||||||||
| Description | Dec-16 | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17 | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Jul-18 | Aug-18 | Sep-18 | Oct-18 | Nov-18 |
| REVENUE | ||||||||||||||||||||||||
| New Customers | ||||||||||||||||||||||||
| Cumulative Customers | ||||||||||||||||||||||||
| Annual subscription | ||||||||||||||||||||||||
| Annual subscription 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 |
| COST 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| $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 Cost 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 |
| 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 |
| Gross Margin % | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
Headcount Detail
| Sample Company | |||||||||||||||||||||||||||||
| Headcount Detail | |||||||||||||||||||||||||||||
| Operating Plan | |||||||||||||||||||||||||||||
| Name | Position | Base Slry | Start Date | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Total | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Total |
| SALARIES: | |||||||||||||||||||||||||||||
| Name | Title | $0 | 42735.0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Name | Title | $0 | 0 | 0 | 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
| Bonus Pool: | |||||||||||||||||||||||||||||
| Open | $0 | $0 | |||||||||||||||||||||||||||
| Open | 0 | 0 | |||||||||||||||||||||||||||
| Open | 0 | 0 | |||||||||||||||||||||||||||
| Subtotal, Bonuses | $0 | $0 | $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 and bonuses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
| Headcount | (Beg) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| COMMISSIONS: | |||||||||||||||||||||||||||||
| Commission rate | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | - | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | - | |||
| Commissions calculations: | |||||||||||||||||||||||||||||
| Commissions based on 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 | |||
| % commission applied | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | - | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | - | |||
| $ commissions applied | 0 | 0 | 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, Bonuses, and Commissions | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
| TAXES & BENEFITS: | |||||||||||||||||||||||||||||
| Assumptions (Linked): | |||||||||||||||||||||||||||||
| FICA, Medicare & Other | 9.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | - | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | - | |||
| Medical Benefits | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | - | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | - | |||
| Expenses: | |||||||||||||||||||||||||||||
| FICA, Medicare & Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
| Medical Benefits | 0 | 0 | 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 Taxes & Benefits | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
| RECRUITING: | |||||||||||||||||||||||||||||
| Open | 0 | 0 | |||||||||||||||||||||||||||
| Open | 0 | 0 | |||||||||||||||||||||||||||
| Open | 0 | 0 | |||||||||||||||||||||||||||
| Total recruiting fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
&F &A Page &P of &N Denali Financial Consulting - &D &T
Expenses
| Sample Company | ||||||||||||||||||||||||||
| Operating Expenses | ||||||||||||||||||||||||||
| Operating Plan | ||||||||||||||||||||||||||
| Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Total | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Jan-04 | Total | |
| Other Operating expenses: | ||||||||||||||||||||||||||
| $0 | $0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| 0 | 0 | 0 | 0 | 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 other operating expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Insurance: | ||||||||||||||||||||||||||
| Premium payments: | ||||||||||||||||||||||||||
| D&O | $0 | $0 | ||||||||||||||||||||||||
| Liability | 0 | 0 | ||||||||||||||||||||||||
| Workers Comp. | 0 | 0 | ||||||||||||||||||||||||
| Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Travel & Entertainment: | ||||||||||||||||||||||||||
| Airfare | $0 | $0 | ||||||||||||||||||||||||
| Lodging | 0 | 0 | ||||||||||||||||||||||||
| Meals & Entertainment | 0 | 0 | ||||||||||||||||||||||||
| Parking & Mileage | 0 | 0 | ||||||||||||||||||||||||
| Rental car | 0 | 0 | ||||||||||||||||||||||||
| Travel - Misc | 0 | 0 | ||||||||||||||||||||||||
| Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accounting & Legal: | ||||||||||||||||||||||||||
| Accounting: | ||||||||||||||||||||||||||
| Open | $0 | $0 | ||||||||||||||||||||||||
| Open | 0 | 0 | ||||||||||||||||||||||||
| Open | 0 | 0 | ||||||||||||||||||||||||
| Open | 0 | 0 | ||||||||||||||||||||||||
| Total accounting | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Legal: | ||||||||||||||||||||||||||
| Open | $0 | $0 | ||||||||||||||||||||||||
| Open | 0 | 0 | ||||||||||||||||||||||||
| Open | 0 | 0 | ||||||||||||||||||||||||
| Open | 0 | 0 | ||||||||||||||||||||||||
| Total legal | $0 | $0 | $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 Accounting and Legal | $0 | $0 | $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 | ||||||||||||||||||||||||||
| Advertising | $0 | $0 | ||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| Business development | 0 | 0 | ||||||||||||||||||||||||
| 0 | 0 | |||||||||||||||||||||||||
| Forums & conferences | 0 | 0 | ||||||||||||||||||||||||
| Other | 0 | 0 | ||||||||||||||||||||||||
| Salesforce | 0 | 0 | ||||||||||||||||||||||||
| Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Rent Expense: | $0 | $0 | ||||||||||||||||||||||||
&F &A Page &P of &N Denali Financial Consulting - &D &T
5 Year Projections
| Company Name | Draft 1.0 | |||
| 5 Year Income Statement Projection | ||||
|
Ron Johnson: PAGE-VIEW ================================ 5 YEAR INCOME STATEMENT PROJECTION This statement is prepared from the operating plan detail for the first two years (commonly called a "Bottoms-Up" approach) and from a summary percentage extrapolation basis, commonly called a "Top-Down" approach, for the last three years. The percentages in the middle of the worksheet are used to calculate revenue gross margin and expense growth. The blue fields are input fields. Some discreet number input cells are shown on the Balance Sheet. | (Dollars) | |||
| Year | Year | Year | ||
| 1 | 2 | 3 | ||
| REVENUE | ||||
| Product 1 | - 0 | - 0 | ||
| -- | - 0 | - 0 | ||
| -- | - 0 | - 0 | ||
| - 0 | - 0 | |||
| - 0 | - 0 | |||
| - 0 | - 0 | |||
| - 0 | - 0 | |||
| - 0 | - 0 | |||
| Revenue | - 0 | - 0 | - 0 | |
| 0% | 0% | |||
| COST OF GOODS SOLD | 0 | - 0 | - 0 | |
| GROSS MARGIN | - 0 | - 0 | - 0 | |
| Gross Margin % | 0% | 0% | 0% Ron Johnson: Gross Margin % - Manually adjust your gross margin to your expectations for year 3 - 5. |
|
|
Ron Johnson: Gross Margin % - Manually adjust your gross margin to your expectations for year 3 - 5. |
Ron Johnson: Gross Margin % - Manually adjust your gross margin to your expectations for year 3 - 5. | OPERATING EXPENSES | ||
| Operating Expenses | - 0 | - 0 | - 0 | |
| 0% | 0% | 0% | ||
| Operating Income | - 0 | - 0 | - 0 | |
| Net Margin | 0% | 0% | 0% | |
| Interest Income | - 0 | |||
| Interest Expense | - 0 | - 0 | - 0 | |
| Depreciation | - 0 | - 0 | - 0 | |
| Net Income | - 0 | - 0 | - 0 | |
| Net/Net Margin | 0% | 0% | 0% | |
| Cumulative Net Income (Loss) | - 0 | - 0 | - 0 | |
| Company Name | ||||
| 3 Year Balance Sheet Projection | ||||
| (Dollars) | ||||
| Beginning | Year | Year | Year | |
| Balance | 1 | 2 | 3 | |
| ASSETS | ||||
| Current Assets | ||||
| Cash | $ 100,000.00 | - 0 | ||
| Accounts Receivable (60) | - 0 | - 0 | - 0 | - 0 |
| Inventory | - 0 | - 0 | - 0 | - 0 |
| Deposits | - 0 | - 0 | - 0 | - 0 |
| Other | - 0 | |||
| Total Current Assets | $ 100,000.00 | - 0 | - 0 | - 0 |
| Fixed Assets | ||||
| Computer Equipment | - 0 | - 0 | - 0 | - 0 Ron Johnson: Fixed Assets - Computers - This is the total amount of computer equipment you expect to have on hand at the end of the year. |
| Furniture & Fixtures | - 0 | - 0 | - 0 | - 0 Ron Johnson: Fixed Assets - Furnishings - This is the total dollar value of furnishings you expect to have on hand at the end of this year. |
| Accum. Depreciation | - 0 | - 0 | - 0 | - 0 |
| Total Fixed Assets | - 0 | - 0 | - 0 | - 0 |
| Total Assets | - 0 | |||
| LIABILITIES | ||||
| Current Liabilities | ||||
| Accounts Payable (30 days) | - 0 | - 0 | - 0 | - 0 |
| Other | - 0 | - 0 | - 0 | - 0 |
| Line of Credit | - 0 | - 0 | - 0 | - 0 |
| Total Current Liabilities | - 0 | - 0 | - 0 | - 0 |
| Long-Term Liabilities | ||||
| Notes Payable | - 0 | - 0 | - 0 | - 0 |
| Capital Lease | - 0 | - 0 | - 0 | - 0 |
| Other | - 0 | - 0 | - 0 | |
| Total Long Term Liabilities | - 0 | - 0 | - 0 | - 0 |
| Total Liabilities | - 0 | - 0 | - 0 | - 0 |
| EQUITY | ||||
| Capital Stock | - 0 | - 0 | ||
| Paid-In Capital | - 0 | - 0 | - 0 | - 0 |
| Retained Earnings | - 0 | - 0 | ||
| Net Income | - 0 | |||
| Total Equity | - 0 | - 0 | - 0 | - 0 |
| Total Equity & Liability | - 0 | - 0 | - 0 | - 0 |
| (difference) | ||||
| Company Name | ||||
| 5 Year Cash Flow Projection | ||||
| (Dollars) | ||||
| Year | Year | Year | ||
| 1 | 2 | 3 | ||
| Net Income (Loss) | ||||
| Add Back: Depreciation | - 0 | - 0 | - 0 | |
| Changes in Working Capital | ||||
| (Inc) Dec in Current Assets | - 0 | - 0 | - 0 | |
| (Inc) Dec in Fixed Assets | - 0 | - 0 | - 0 | |
| Inc (Dec) in Current Liabilities | - 0 | - 0 | - 0 | |
| Inc(Dec) in Long Term Liabilities | - 0 | - 0 | - 0 | |
| Increase In Funding | - 0 | - 0 | - 0 Ron Johnson: Increase in Funding - The additional amount of equity funding which will be required. |
|
| Cash Flow From Operations | - 0 | - 0 | - 0 | |
| Net Cash Flow | - 0 | - 0 | - 0 | |
| Beginning Cash Balance | - 0 | - 0 | ||
| Net Cash Flow | - 0 | - 0 | - 0 | |
| ENDING CASH BALANCE | - 0 | - 0 | - 0 | |
