Financial Plan for a Business

ModelSheet: Custom spreadsheets in minutes

Customize a feature-rich financial plan to fit your 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.

StandardProPower Pro
  • Income statement
  • Balance sheet
  • Cash flow statement
  • Ratio report
  • Backup reports in many sectors
Includes all features of Standard plus:
  • larger dimensions and time series
  • See Features tab for long list of additional features
Includes all features of Pro plus:
  • larger dimensions and time series
  • See Features tab for long list of additional features
7 day free trial or $397 day free trial or $59$89

Compare Versions

 StandardProPower Pro
Financial Statements   
Income statement, balance sheet, cash flow statement, ratio report
Reconfigurable pivot table reports for income statement and balance sheet variables  
Income Statement - Sales Model   
Revenue, sales units, prices, discounts
Products, prooduct families, and product variants
Segment sales by channels / geographic locations
Seasonality model for product sales  
Revenue adjustments 
Price surcharges  
Product support contracts, with support term, payment schedules, and deferred revenue 
Sales funnel with backlog, lead quality levels 
Installed base
Installed base - conversion/upgrade to different base product  
3 scenarios with low, medium, high sales 
Income Statement - Cost of Goods & Gross Margin   
Specify cost of goods and services per sales unit or as a percentage of revenue
Direct material, direct labor, direct overhead
Direct material - several types of material 
Direct material - material units and minimum order quantity  
Direct labor - several types of labor 
Direct labor - hours per unit & cost per hour 
Direct labor - headcount & utilization 
Production learning curve  
Gross Margin
Income Statement - Expenses   
Organization - departments & job levels
Employment - headcount by department, job level & time
Employee headcount - explicit and driven by revenue with scale effects 
Employee expense - salaries, wages, bonus, commissions, payroll taxes
Two or more commission rates as revenue increases  
Employment - recruiting expense 
Marketing programs expense by program and time
Marketing programs expense - explicit and driven by revenue with scale effects
Facilities expense - fixed per time period
Facilities expense - by area per person, cost per unit area 
Facilities expense detail - rent, utliities, maintenance & other 
Department-specific expense accounts 
Allocate operating expenses to products (to estimate product profitability)  
Financial expense & income tax
Income tax - two income tax rates 
Value Added tax paid on revenue less purchases. Assumes VAT is paid in the time period it is incurred, so it has no effect on cash flow or income. 
Balance Sheet - Assets   
Short-term assets: Cash, receivables; inventory
Inventory - finished goods, raw material, supplies  
Inventory - gain (loss)  
Long-term assets - major assets with value, life, depreciation method, salvage value, gain on sale
Major assets - Custom depreciation schedule  
Minor assets with value, depreciation life 
Intangible assets with value, life, depreciation method, salvage value, gain on sale  
Prepaid expenses
Capitalized development spending
Outside investments - bonds held & other outside investments with return
Balance sheet - liabilities   
Short-term liabilities - payables, short loans
Deferred revenues, leases, bonds outstanding 
Term loans  
Long-term liabilities - long-term loans 
Short and long term interest on debt, interest earned on cash balance, tax rate, tax loss carried forward
Balance sheet - equity   
paid in capital, net stock issued, retained earnings, dividends
Cash Flow Statement   
Starting and ending cash balances, sources & uses of cash
Ratio Report   
Financial ratios
Operating ratios
Auxiliary businesses
valuation   
Valuation of discounted cash flow
Version size limits   
Time Periods364860
Products81624
product variants--2
Selling channels / locations4610
Types of contract sales-24
Lead quality levels (in sales funnel)-25
Types of direct labor - products-25
Types of direct labor - support-25
Types of direct material-24
Types of consumable supplies--4
Departments455
Job Levels044
Departmental expense accounts050150
Marketing programs4812
Leases4812
Tagged long-term assets033
Types of untagged long-term assets4812
Intangible assets--8
Prepaid expense types-515
Bonds held-1015
Outside investments---
Term loans--10
Bonds outstanding-1015
Auxiliary businesses--15
Microsoft Office Marketplace logo
Works with Microsoft® Excel® 2003 - 2010

Customize spreadsheets by filling in a simple form

Step 11. Choose
The model you want
Step 22. Customize
Online form does the work
Step 33. 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.
 
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
 
 

Copyright © 2010, 2011 by ModelSheet Software LLC | All Rights Reserved | Privacy

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.