PlanWare - Home: business, plan, software, free, financial, model, budget, forecast, plan, planner, planning, projection, template, statement, analysis, business plan, business plan software, business planning, business planner, financial projections, financial planning, cash flow, cashflow, strategy, strategic
Software & free templates for business plans, financial projections, cashflow forecasting plus free business plan tools, models, samples, guides & planning papers
  Financial  
 Projection 
  Software  
 Cashflow 
  Forecasting  
  Software  
  Business  
      Plan      
  Software  
  Marketing 
       Plan       
  Software  
  Strategic  
    Planning    
  Software  
  Business  
      Plan      
     Guide     
   Business   
   Planning   
   Freeware   
    Online     
  Planning   
      Tools      
   Business   
   Planning   
    Papers    
     Other     
     Items     
                     

Bookmark and Share
 

Business Planning Papers:
Preparing Financial Projections

Page Contents

  1. Financial Models for Business Plan Projections
  2. Using a Computer for Financial Projections
  3. How Financial Planning Models Work
  4. Planning to Make Business Plan Projections
  5. Tips & Traps when Projecting Finances
  6. The Next Steps in Business Planning
  7. Introducing PlanWare
  8. Copyright & Legal Stuff

Need Financial Projections for Your Plan ?

Use Exl-Plan for preparing comprehensive financial projections for 1/3/5/7 years ahead. Ideal for a business plan, strategic planning, cash flow forecasting, raising finance, budgeting and financial appraisals. Get full details, download free or trial copies or buy & use now.




1. Financial Models for Business Plan Projections

Financial planning is a critical activity for every business irrespective of its age and size. For new enterprises, the preparation of financial projections is integral to the business planning process. For larger companies, financial planning forms part of annual budgeting and plays an important role in long-term planning, business appraisals, corporate development etc.

Central to the task of preparing a set of projections is the construction of a mathematical model to reflect the finances and activities of a business. Sales minus Costs equals Profits (i.e. S - C = P expressed as a formula) is an example of a very simple model for deriving projected profits from assumptions about future sales and costs.

In practice, financial planning models are much more complex as they must accommodate multiple time periods (months, quarters and years) and handle hundreds of variables relating to sales, costs etc. The volume of data mounts up very quickly when each variable is multiplied by the time horizon, for example, by twelve months. Figure 1 below lists typical assumption variables used to generate a set of financial projections.

Figure 1 - Some assumption variables used by a financial model to produce projected P&Ls, cashflows and balance sheets for a manufacturing business.
Sales volumes
Selling prices
Selling & distribution costs
Tax rates for inputs
Research & development
Interest rates
Tax rates for sales
Management/administration
Changes in loans/debt
Bad debt provisions
General overheads
Operating leases & HP
Target finished stocks
Depreciation rates
Current year debtors/creditors
Opening balance sheet
Fixed asset values
Intangible assets
Material costs
Accumulated depreciation
Prepayments/accruals
Material/WIP stocks
Capital expenditure
Share issues
Direct manpower levels
Capital & revenue grants
Dividends
Wage rates
Fixed asset disposals
Corporation tax
Other direct costs
Finance leases
Phasing of opening balances
Operational overheads

A comprehensive model can contain many thousands of formulae with functions ranging from simple addition to complex conditional statements (e.g. if projected cashflow is positive, reduce the overdraft before adding any residual balance to the cash account).

Financial models are used to compile forecasts and budgets; to assess possible funding requirements; and to explore the likely financial consequences of alternative funding, marketing or operational strategies. They can also be used for business planning, raising finance, investment or funding appraisals, financial analysis, corporate planning etc.

Used effectively, a financial model can help prevent major planning errors; identify or evaluate opportunities; attract external funding; provide strategic guidance; evaluate financial and development options; monitor progress etc.

Our Exl-Plan range of Excel-based planners are ideal for financial modeling and planning. Based on a user's assumptions, they generate fully-integrated projections for up to five years ahead. Also, Cashflow Plan produces fully-integrated cashflow projections for 12 months ahead and incorporates a roll-forward facility to simplify updating of projections.

Top - Business Plan WareTop of Page

 
 
Useful Links
More Info
Prepare projections
Make cashflow forecasts
Get free planner
Write business plan
Seek planning advice
Improve cash flow
Raise finance
See Also
Develop strategic plan
Write strategic plan
Get planning insights
Plan to plan
See planning surveys
Business plan guide
Software Tools
Financial Planner
Cashflow Forecaster
Business Planner
Expert Business Planner
Marketing Planners
Free Planners
Buy Software
Financial Projections
Cashflow Forecasts
Business Plans
Marketing Plans
Strategic Plans





   

2. Using a Computer for Financial Projections

A personal computer with appropriate software can help prepare financial projections. A computer-based model reduces the tedium of carrying out numerous repetitive calculations; simplifies the alteration of assumptions; and improves the presentation of results.

When using a computer, a manager or planner can utilize a spreadsheet to build a model from first principles. While the development of a spreadsheet model of a company's profit & loss account should be well within the capabilities of many managers, the development of an integrated and comprehensive financial planner is an infinitely more challenging, time consuming and difficult task. A manager must know when to draw the line between using a spreadsheet to plan and becoming a spreadsheet programmer.

As an alternative to a DIY model, a manager or entrepreneur can purchase a ready-made model which can be either (a) loaded as a template into a spreadsheet or (b) run as a stand-alone package.

The main advantage of building a bespoke model is that it can be fine- tuned to meet very specialized requirements. However, the drawback is that building a comprehensive, error-free and user-friendly financial model could require hundreds of hours of development and testing along with considerable programming and financial expertise. This work inevitably distracts from the real task of planning the business and begs the question as to why managers, entrepreneurs, advisers etc. should reinvent the wheel whenever a set of financial projections are required.

PlanWare offers a range of financial planning packages - Exl-Plan. These incorporate extensive help facilities and are suitable for start-up or established businesses ranging in turnover from $50,000 up to $99 million per annum. They can be used by planners, accountants, consultants etc. as well as by managers or business people with little or no previous experience of computers, finance or business planning. Also, have a look at Cashflow Plan, our range of fully-integrated cashflow planners which generate projections for 12 months ahead and incorporate a roll-forward facility to simplify updating of projections.
Get Help with Financial
Projections
financial projections Exl-Plan - Integrated Multi- Year Financial Planner
Requires: Excel 5, 7, 8, 95, 97, 2000, XP, 2003, 2007, 2010 or 2013 with Windows 95/98/
Me/NT/2000/XP/Vista/Win7.
Prices: Free to US$ 289.
Details  Trial Downloads
Buy + Use Now

Top - Business Plan WareTop of Page

 
   

3. How Financial Planning Models Work

A computer-based financial model is the electronic equivalent of a very large sheet of ruled paper which, depending on circumstances, could be 10 to 20 square feet in area. The computer's screen serves as a small window on this electronic sheet which usually displays variables and values along rows and time periods in columns.

A model utilizes assumptions for sales volumes, prices, operating costs, funding etc., to produce projected balance sheets, profit & loss accounts and cashflow statements. Typically, it makes monthly projections for the first year and less detailed projections for the following years. For example, PlanWare's models will produce projections (P&Ls, cashflows, balance sheets) for the first year on a monthly basis and for the following two years on a quarterly basis. As all the components of a model are linked by formulae, a change to any assumption in any period results in appropriate adjustments to profits, cashflows etc. throughout the model for the remaining months, quarters and years.

Once initial assumptions have been entered, they can be readily altered to evaluate alternative scenarios. For example, a model could be used to explore the extent to which future sales can be increased while holding borrowings within predetermined limits; to assess the effects of varying selling prices and/or volumes on net profits; or to determine the optimum level and mix of future funding for a business.

As a practical example, Figure 2 below shows the results of using one of PlanWare's models to undertake a "what-if" analysis where sales volumes and prices have been increased by a fixed percentage.

Figure 2 - Results of Sensitivity Analysis
Scenario: Base Case covering 12 months Sales Volumes increased by 20% Selling Prices increased by 10%
Sales ($000) 553 664 608
Sales (% change) n/a +20 +10
Pre-tax Profits ($000) 28 65 85
Pre-tax Profits (% Change) n/a +132 +204
Net Cashflow ($000) 43 68 93
Net Cashflow (% Change n/a +58 +116
Peak Monthly Loans ($000) 72 65 57
Peak Monthly Loan (% Change) n/a -10 -21
Full-Year Return on Capital (%) 16 30 35

Given a choice between a 20% increase in sales volumes or a 10% increase in selling prices, the model shows that the latter would be a far more attractive option. The results also offer an insight into the underlying cashflows and funding requirements. Our software planners, Exl-Plan and Cashflow Plan, offer extensive facilities and utilities for doing "what-if" sensitivity analyses.

Top - Business Plan WareTop of Page

 
   

4. Planning to Make Business Plan Projections

For managers of an existing business, or promoters planning a substantial new venture, financial modeling can be an invaluable tool to assist the preparation of a business plan. However, business planning should not be confused with the preparation of financial projections. The former must provide the foundation for the financial projections which can be derived arithmetically by a model. The model and its forecasts should contribute to but never dictate the contents of a written business plan.

Once basic issues relating to markets, sales and operations have been fully researched and considered, a model can be used to produce the financial projections. However, the veracity and usefulness of these projections will be completely determined by the quality and reliability of the underlying assumptions determined outside the model. For example, if sales or cost forecasts are unrealistic or inadequately researched, then the value of a model's output is greatly diminished. An impressive set of financial projections is of little benefit if unsupported by research or only based on speculation or wishful thinking.

Before using a financial model to help plan the future of a business, a manager or entrepreneur should:

  1. Decide at the very outset on the central purpose of the planning exercise (raise funds etc.); the target audience (co-directors, financial institutions etc.); and the time horizon (one year etc.).
  2. Identify and think through all the critical assumptions. Prepare outline projections to confirm their overall direction, examine the critical elements in detail and consider strategic issues relating to sales, profitability, funding etc.
  3. Check that all key assumptions (e.g. sales forecasts) and data (e.g. opening balance sheet and any prior-year financial results) are to hand, and have been adequately researched.

    There is a special facility, called Quik-Plan, within PlanWare's Exl-Plan and Cashflow Plan financial planning packages which is ideal for preparing 'first-cut' projections which can be progressively refined and expanded.

Recognize the danger of presenting too much detail or too many reports. Most senior managers, investors and financiers seek simple financial statements which have been based on detailed analysis and realistic assumptions.

Our Exl-Plan financial planner offers several summary reports, including a 3/5 year Textual Summary Report with self-modifying text, as well as numerous graphs & tables, to present the highlights of a plan or set of projections. Also, have a look at Cashflow Plan, our range of fully-integrated cashflow planners which generate projections for 12 months ahead and incorporate a roll-forward facility to simplify updating of projections.

Top - Business Plan WareTop of Page

 
   

5. Tips & Traps when Projecting Finances

When preparing financial projections, be conscious of the pitfalls and dangers listed in Figure 3 below. These can arise as the result of a lack of foresight or insight, or because of excessive optimism. As they can lead to underestimation of the resources required to develop a business with potentially disastrous consequences, it can be counterproductive to overstate its potential.

Figure 3 - Financial Planning Traps
  • Using financial forecasting as a substitute for business planning.
  • Ignoring historic trends or performances at company, sectoral and national levels.
  • Overstating market shares and growth, sales forecasts, and profit levels.
  • Giving insufficient consideration to working capital requirements.
  • Underestimating costs and delays likely to be encountered.
  • Disregarding industry performance norms and competitors' responses.
  • Breaching generally-accepted financial guide lines and ratios.
  • Making unduly optimistic assumptions about the availability of loans, trade credit, grants, equity etc.
  • Seeking spurious accuracy while failing to recognize matters of strategic importance.

Realistic views should always be taken of a business's prospects, prospective profits, funding requirements etc. There is often merit in compiling "worst" case projections to complement "most likely" or "best" forecasts. In practice, the realization of financial projections, especially for a new business without any trading history, might easily take twice as long and cost twice as much as expected. Remember that it is much less painful to deal with a flaw in a business at the planning stage, than later on when commitments have been made and the business has started trading. Our software planners - Exl-Plan and Cashflow Plan - offers comprehensive facilities for doing sensitivity analysis (using Quik-Plan and by changing individual values).

Top - Business Plan WareTop of Page

 
   

6. The Next Steps in Business Planning

Preparing a set of financial projections is only a means to an end. Once plans or projections have been approved or in the process of being implemented, they should be regularly updated and compared with the results being achieved.

A plan is only useful if it is being adhered to, if it serves as a benchmark for control purposes, and if the projected outcomes are being realized.

While a clear business plan with sound projections cannot guarantee success, the absence of a plan or poor projections could ensure the eventual failure of a business.

For further information on business planning issues, refer to other papers in this series which cover business planning, cashflow forecasting, strategic planning, devising business strategies and getting new business ideas. If planning to raise venture capital, business angel finance or bank loans, check the paper on raising finance.

Share or Bookmark this Page       More info
DiggDigg
Reddit
Newsvine
Delicious
StumbleUpon
Yahoo
Google
Facebook
Technorati
Windows Live


Free Tools from PlanWare
  • Business financial planner for high-level, integrated 2-year projections using Excel - details and download links for Exl-Plan Free.
  • Excel-based, comprehensive, rolling 6-month cash flow planner - details and download links for Cashflow Plan Free.
  • Business plan template & guidelines (Word format) - details & download link for Free-Plan.
  • Online strategic planner for creating a 3-page strategic plan - details and sample plan.
  • More free tools here.

Get Help with Financial
Projections
financial projections Exl-Plan - Integrated Multi- Year Financial Planner
Requires: Excel 5, 7, 8, 95, 97, 2000, XP, 2003, 2007, 2010 or 2013 with Windows 95/98/
Me/NT/2000/XP/Vista/Win7.
Prices: Free to US$ 289.
Details  Trial Downloads
Buy + Use Now
Get Help with Cash
Flow Planning
financial projections Cashflow Plan - Comprehensive Cash Flow Forecasts
Requires: Excel 5, 7, 8, 95, 97, 2000, XP, 2003, 2007, 2010 or 2013 with Windows. 95/98/
Me/NT/2000/XP/Vista/Win7
Prices: Free to US$ 199.
Details  Trial Downloads
Buy + Use Now

Top - Business Plan WareTop of Page

 

Bookmark and Share

 

7. Introducing PlanWare

PlanWare develops and sells a range of financial planning packages - Exl-Plan and Cashflow Plan - for businesses of all sizes & types. Trial versions can be downloaded from our PlanWare site here and from many other sources on the 'Net.

We also offer an extensive range of commercial software for writing business plans, market planning, assessing business ideas and evaluating strategies.

PlanWare also features:

Top - Business Plan WareTop of Page


8. Copyright & Legal Stuff

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs License. This means that this page and any related files are subject to the normal rules about copyright and attribution. If you wish to make an electronic or printed copy for YOUR PERSONAL USE, you are free to do so PROVIDED THAT IT IS UNMODIFIED AND REMAINS COMPLETE IN ALL RESPECTS. All copying for commercial use requires written prior permission secured from info@planware.org. You are free to quote short extracts provided our site's URL <www.planware.org> is acknowledged as the source.
PlanWare, Invest-Tech Limited, Ardmeen Park, Blackrock, Co. Dublin, Ireland
International Tel:
+353-1-283 4083
International Fax:
+353-1-278 2391
Email:
info@planware.org
WWW:
http://www.planware.org
Subscribe / Syndicate:
RSS  RSS- Business Plan Tips

Top - Business Plan WareTop of Page

 
 
  Financial  
 Projection 
  Software  
 Cashflow 
  Forecasting  
  Software  
  Business  
      Plan      
  Software  
  Marketing 
       Plan       
  Software  
  Strategic  
    Planning    
  Software  
  Business  
      Plan      
     Guide     
   Business   
   Planning   
   Freeware   
    Online     
  Planning   
      Tools      
   Business   
   Planning   
    Papers    
     Other     
     Items     
                     
PlanWare, Invest-Tech Limited, Ardmeen Park, Blackrock, Co. Dublin, Ireland
International Tel:
+353-1-283 4083
International Fax:
+353-1-278 2391
Email:
info@planware.org
WWW:
http://www.planware.org
Subscribe:
RSS  RSS-Planware's Bog
Follow:
Twitter Twitter
PlanWare, Cashflow Plan, Exl-Plan, Quik-Plan, Free-Plan, Biz-Plan, Easi-Plan, Cash-Plan, Pers-Plan, Your-Plan and Bank-Plan are trademarks or registered trademarks property of Invest-Tech Limited. Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Plan Write, Quick Insight and Business Insight are trademarks or registered trademarks property of BRS Inc. © Copyright 1999-2014. Invest-Tech Limited. All rights reserved.