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

PlanWare's Blog

Blog Home  Bookmark and Share

Recently in Exl-Plan Software Category

When preparing financial projections for a business plan, you may need to consider raising finance from venture capitalists, business angels and/or banks.

Here are some tips. They assume you are using a fully-integrated financial planning tool, like our Exl-Plan range, to prepare projected income statements, cashflows and balance sheets covering a time horizon of 3-5 years or so.

  1. Use "most likely" (highly probable) assumptions to generate initial projections but exclude, for time being, any assumptions about external funding. When the financial model runs without this funding, it should automatically build up a substantial overdraft (cash shortfall) based on projected net cash outflows.
  2. Review the trend in the overdraft and identify its peak month/quarter and value.
  3. Review the desired mix of external funding - overdraft, grants, loans and equity - and inject funding amounting to the peak overdraft into the model.
  4. Rerun the model and check that key ratios - especially debt/equity and quick ratio - look sensible for all months/years. If needs be, adjust the mix of funding to improve these ratios. For example, if the debt/equity ratio is 100%, consider reducing the debt level and increasing the equity content.
  5. Take note of the timing and amounts of proposed external funding.
  6. Undertake sensitivity analyses by running the model with revised projections for sales volumes/prices, costs and/or overheads in order to identify a realistic "worst" case.
  7. Repeat points 2-5 to determine "worst" case funding.
  8. If desired, raise the projections with altered sales volumes/prices, costs and/or overheads to see the "best" case funding and help sell the business's potential to investors.

Base funding needs on the "most likely" projections but take account of higher requirements suggested by the "worst" case. - it may be prudent to seek too much money rather than too little!

For more guidance:

Yes. Tax-related items in Exl-Plan, our range of financial projection tools, are parameter-driven so it can easily handle a diversity of regimes for corporation tax, payroll taxes as well as VAT, GST and other sales/input taxes. As evidence of this, Exl-Plan is used in over a hundred countries.

For corporation taxes, you specify effective tax rates after taking account of any losses forward, capital allowances and other adjustments.

Payroll taxes and social insurance type charges are expressed as a percentage of payroll costs.

In the case of VAT, GST etc., Exl-Plan accommodates several different tax rates for sales and inputs and lets the user specify the payment/refund frequency.

Get a detailed description of the Exl-Plan range. Note that all versions are available as either US/Canadian or UK/International editions.

About this Archive

This page is an archive of recent entries in the Exl-Plan Software category.

Cashflow Plan Software is the previous category.

Financial Projections is the next category.

Find recent content on the main index or look in the archives to find all content.

Top 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