|
|
Model: Financial Plan for a Business
Available Versions
These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.
| Version | Description | | Download
Price |
| Light | The Light version has the same features as the Standard version, only it is smaller. It lets you try the customization process and download a customized working template for free. |
| Free |
|---|
| Standard | Includes income statement, balance sheet cash flow, and ratio report. Also backup detail on sheets for sales, cost of goods, operating expenses, employment, financial and tax expense, assets, liabilities, equity and firm valuation. |
| $99 $49 |
|---|
| Advanced | Includes all the features in the Standard version plus many optional features: a sales funnel with lead quality classes, customer support, deferred recognition of support revenue, contracts with deferred revenue, installed base, direct labor detail, recruiting costs, production learning effects, capitalized development spending, untagged assets, leases, bonds. The Advanced version also provides larger models with more products, sales channels, departments, job levels, and many other items. |
| $179 $89 |
|---|
| Advanced Extra-Large | Includes all the features of the Advanced version, plus larger models with more of everything. |
| $279 $149 |
|---|
* Customization and preview is always free. If applicable, you'll be asked to buy before downloading a working spreadsheet. Customizable Feature Comparison
| Feature |
Standard & Light
Versions |
Advanced & Extra-Large
Versions |
Comments |
| Financial Statements |
 |
|
Income statement, balance sheet, cash flow, ratio report |
| Income Statement Items |
| Sales model |
|
|
Sales units, list prices, discounts, revenues. Product line with product families |
|
|
|
|
Segment sales by geographic locations |
|
|
|
|
Customer support contracts, by product (hardware or software) |
|
|
|
|
Optional deferral and accrual of support revenue and expense during the term of an annual support contract |
- Contracts with deferred revenue
|
|
|
Optional contracts of several types that can defer and accrue revenue and expense during the life of each contract. |
|
|
|
|
3 scenarios with low, medium, high sales |
- Sales funnel with backlog
|
|
|
Track qualified sales leads and order backlog, with transition rates from leads to orders and from orders to sales. |
|
|
|
|
Sales return %, sales return processing expense |
|
|
|
|
Current installed base, based on sales units and estimated service life of each product and service. |
| Production, cost of goods |
|
|
Direct material, labor and services. Inventory targets and sales drive production schedule. |
|
|
|
|
Specify types of direct labor, labor cost/hour, labor hours per production unit, direct labor headcount and target utilization.
|
- Production learning curve effects
|
|
|
Optionally set learning curve for each product and cost type. Optionally pass on part of the cost savings as reduced prices.
|
| Employment |
|
|
Headcount, pay, benefits & taxes, bonus pool, sales commissions, by department & job level, driven by revenue |
|
|
|
|
Driven by revenue with scale effects |
|
|
|
|
Track open positions, recruited positions, recruiting fees |
| Marketing programs expenses |
|
|
Track expenses for multiple programs |
|
|
|
|
Driven by revenue with scale effects |
| Detailed expense accounts |
|
|
Include department-specific expense accounts. |
| General & Admin Expenses |
|
|
Several G&A expense types (except Light version). |
|
|
|
|
Driven by revenue with scale effects |
| Financial and tax expense |
|
|
Short and long term interest on debt, interest earned on cash balance. Tax rate, tax loss carried forward |
| Balance Sheet Items |
| Short-Term Assets |
|
|
Cash, receivables days & value, inventory (products, units, LIFO value, turnover) |
| Long-Term Assets |
|
|
Tagged assets with purchase value & date, life, 3 depreciation methods, salvage value |
|
|
|
|
Several types, depreciation, individual assets not tracked, purchases driven by headcount |
- Capitalized development spending
|
|
|
Supports capitalizing a fixed amount plus a percentage of development spending |
| Short-Term Liabilities |
|
|
Payables, payable days, short-term debt |
- Deferred revenue liability
|
|
|
Deferred revenue affects liabilities, cash flow and revenue. |
| Long-Term Liabilities |
|
|
Long-term loans |
|
|
|
|
Individual leases classified by type, with start and end dates, annual payments, initial and final payments |
|
|
|
|
Bonds/notes with sale date, face value, interest rate, initiation fee, balloon payment |
| Equity |
|
|
Paid in capital, net stock issued, retained earnings, dividends |
- Valuation of Discounted Cash Flow
|
|
|
Valuation of discounted cash flows, probability expected value of cash flows, using direct or CAPM discount rates, internal
rate of return |
Version Size Limits
| Feature |
Light Version |
Standard Version |
Advanced Version |
Extra-Large Version |
| Time Periods |
24 |
36 |
48 |
60 |
| Products |
4 |
8 |
16 |
24 |
| Departments |
3 |
4 |
8 |
12 |
| Job Levels |
3 |
6 |
9 |
12 |
| Types of contract sales |
0 |
0 |
2 |
4 |
| Selling Locations / Channels |
3 |
4 |
6 |
10 |
| Departmental expense accounts |
0 |
0 |
50 |
150 |
| Marketing Programs |
2 |
4 |
8 |
12 |
| Tagged long-term assets |
1 |
5 |
10 |
15 |
| Types of untagged long-term assets |
0 |
3 |
5 |
10 |
| Leases |
0 |
4 |
8 |
12 |
| Bonds |
0 |
5 |
10 |
15 |
|