This financial plan has the features needed for planning financial and operating performance in most small businesses, and for presentation to investors.
The core of the plan is 4 financial statements:
- 1. Income statement
- 2. Balance sheet
- 3. Cash flow statement
- 4. Financial ratio report
Features
The model provides backup detail in these areas:
- 1. Sales
- Specify sales as revenue (without sales units and prices) or as sales units, list prices and price discounts
- Sales are recorded by product. Organize products in families
- Segment sales by sales locations
- 2. Production
- Tracks cost of goods and services
- As a percent of revenue; or
- As cost per unit produced.
- Computes production units and inventory (value & units)
- 3. Operating expense
- Tracks employment expense - wages, benefits, payroll taxes, bonuses, commissions
- Tracks employee headcount
- Tracks departments with expense accounts you specify
- 4. Balance Sheet - Assets
- Short term assets: cash, receivables, raw & finished inventory
- Long term assets: large tagged assets, small untagged assets
- 5. Balance Sheet - Liabilities
- Short term liabilities: accounts payable, short-term debt & interest expense
- Long term liabilities: loans and interest expense
- 6. Balance Sheet - Equity
- Paid-in capital and sale of stock
- Retained earnings and dividends
- 7. Valuation
- Values the business based on present value of net income
- Includes estimated cash flow after model time
- Internal rate of return (IRR)
Go to the Features tab to see which Features are in each version.
Easy to Use
Your spreadsheet includes:
- A logical and intuitive layout
- Comments on every variable table
- Collapsible groups to hide detail until you need it
- Easy to understand symbolic formulas
- Easy modifiable data and preferences
This model helps you focus on managing your business, not on building spreadsheets.
There’s nothing to install or learn.
Fully Customizable
Using our automated modelling technology you can create a report that exactly suits your needs. Turn on and off major features, specify time line and "dimensions" such as product lines, preferred currency symbols, and date formats in a simple online form.
This model is a smaller and simpler version of Financial Plan for a Business.