Financial Plan for a Small Business
ModelSheet: Custom spreadsheets in minutes
Design a financial plan that fits your small business
This model is offered in a number of fully customizable versions. Compare these below and choose
the one that suits your business size and needs. Once selected, customizing your spreadsheet is quick and
easy. Your business could be using powerful, professional Excel analysis in minutes.
Each version is free to customize and preview.
| Standard | Pro | Power Pro |
|---|
- Income statement
- Balance sheet
- Cash flow statement
- Ratio report
- Backup reports in some areas
| All features in Standard verion plus:
- Executive summary
- Sales scenarios, sales units
- Inventory units
- Employee count
- Major assets and depreciation
- Valuation and IRR
| All features in Pro version plus:
| | 7 day free trial or $19 | 7 day free trial or $29 | $39 |
|
|
|
|
|
Compare Versions
| | Standard | Pro | Power Pro |
| Executive Summary | | | |
|---|
| Provides financial overview on one sheet | |  | |
| Income Statement - Sales Model | | | |
|---|
| Specify sales in terms of sales units, prices, and discounts; or just as revenue | | | |
|
| Specify products and services that organize your sales model | | | |
|
| Segment sales by channels / geographic locations | | | |
|
| 3 scenarios with low, medium, high sales | | | |
| Income Statement - Cost & Gross Margin | | | |
|---|
| Specify cost of goods and services per sales unit or as a percentage of revenue | | | |
|
| Gross Margin | | | |
| Income Statement - Operating Expenses | | | |
|---|
| Salary, wages, benefits, payroll taxes, bonus, commissions - by department & job level | | | |
|
| Employee headcount by department and job level | | | |
|
| Segment employee expense and headcount by job level and department | | | |
|
| Specify department-specific expense accounts | | | |
|
| Short and long term interest on debt, interest earned on cash balance, tax rate, tax loss carried forward | | | |
| Balance Sheet | | | |
|---|
| Short-term assets: Cash, receivables days & value, inventory value & units, turnover | | | |
|
| Long-term untagged assets with depreciation, individual assets not tracked, purchases driven by headcount | | | |
|
| Tagged assets with purchase value & date, life, 3 depreciation methods, salvage value | | | |
|
| Short-term liabilities: payables days & value, short-term debt | | | |
|
| Long-term loans | | | |
|
| Equity: paid in capital, net stock issued, retained earnings, dividends | | | |
| Cash Flow Statement | | | |
|---|
| Cash balances, starting and ending cash | | | |
|
| Sources and uses of cash including net income, change in asset and liability accounts, new stock issue, dividends | | | |
| Ratio Report | | | |
|---|
| Margin percentages, liquidity ratios, ROI and other investment ratios | | | |
|
| Department expense ratios, turnover ratios | | | |
| Investment Measures | | | |
|---|
| Valuation of discounted cash flows, probability expected value of cash flows | | | |
|
| Internal rate of return of equity cash flows | | | |
|
| A separate sheet for input data | | | |
| Google Docs | | | |
|---|
| You can uploade smaller versions of this model to Google Docs. If it fits, a button to upload is automatically displayed. | | | |
| Version size limits | | | |
|---|
| Time Periods | 24 | 36 | 96 |
|
| Products | 4 | 6 | 6 |
|
| Selling channels / locations | 3 | 4 | 4 |
|
| Departments | 4 | 5 | 5 |
|
| Job Levels | 0 | 4 | 4 |
|
| Departmental expense accounts | 8 | 16 | 16 |
|
| Types of untagged long-term assets | 3 | 4 | 4 |
|
| Tagged long-term assets | 0 | 3 | 3 |
Works with Microsoft® Excel® 2003 - 2010
Customize spreadsheets by filling in a simple form
 | 1. Choose
The model you want |
 | 2. Customize
Online form does the work |
 | 3. Download
And it's ready to use |
Each spreadsheet offers:
- Carefully organized layout
- Comments on every variable table
- Collapsible groups hide details until wanted
- Easy-to-read symbolic formulas show what the model does
- Easily change input data, start date, label text...
Meet your exact needs better than any static template.
Watch our video on how easy it is to customize our models
Learn more about ModelSheet spreadsheet customization solutions
Can't find your solution
Need to know more?
Find out how our consulting services can help you create and manage your ideal custom spreadsheet models.
Go to Consulting Services