Financial projections template

Description

Financial projections template for business plan

1. An easy to use financial projections template for a business plan

Cash Forecaster is a simple to use 12 month to 7 year financial projections template for a business plan using Excel. An Excel projections template without the need for an in-depth knowledge or Excel. Plus you don’t need to know how to write Excel formulas.

Financial projections for startups and for established businesses too. Ideal for preparing 3 year financial projections to 5 year financial projection; all made easy with our best-selling Cash Forecaster software.

Professional financial projections with easy to use Excel-based template software and quick to get started.

How a client explained it: ” It has saved me hours on a recent clients projections.” Phil Taylor;

and another client said:

“The template is excellent – very easy to use. You can produce a professional set of forecasts very quickly.” Tim Moorhouse.

Speedy professional reports from our financial projections template.

Within no time, you’ll have professional reports which forecast for 12 months, 24 months, 3 years, 5 years and even up to 7 years. Reports that are ideal for banks to obtain bank lending; to present to investors to receive angel investment; for your management and directors meetings; or to support your business plans and annual budgets. Save time, save money…all for a small $147 investment.

2. Double entry done for you with balance sheet projections produced automatically

Preparing Excel spreadsheets from scratch is at best time-consuming. Working out the formulas and which numbers go were can lead to headaches for some. Also, there’s no guarantee your figures will balance at the end.

With Bowraven’s financial projections template; you simply enter the data, and the template does the rest, as all the hard work and difficult formulas have already been calculated for you. Save time, look professional and get the job done fast.

How a client explained it: “You can spend your time producing accurate figures rather than trying to work out how to make the balance sheet balance with the cash flow forecast!” Tim Moorhouse.

3. VAT (Sales Tax/GST) entries calculated automatically

Making the correct VAT-inclusive* or VAT-exclusive* entries are complicated. Getting them on the right reports can be tricky too.

It’s important to differentiate between the ‘net of VAT (Sales Tax) figures,‘ which are reported on the profit and loss projection reports; vs the numbers that are shown on the cash flow forecasts.

However, this is all taken care of with our financial projections template for you.

Cash Forecaster Software makes this quick and easy. VAT* entries are done for you. You just need to know which products, expenses or services are Vatable*…simple.

 * The financial projections template is also set up to account for sales tax and/or GST.

4. Capital expenditure and asset disposal entries are also made easy. As is asset depreciation, which is calculated automatically

Most small businesses have capital expenditure. Where your financial projections are for a short 12 month period over a longer 5 year period, it’s likely that your business will have both capital expenditure and asset disposals. Capital expenditure could include buildings, motor vehicles, plant, equipment, computers, furniture and other assets.

Using our financial projections template you enter your opening fixed assets. Then add any new planned-for capital expenditure and any planned disposals in the forecast period.

It’s extremely easy to enter the asset type; the fixed asset cost; the fixed asset purchase date; the VAT (Sales Tax) rate; the sale date of assets disposed of; and the software does the rest for you, including automatic depreciation calculations.

All the numbers are put in the right places on right reports, including the five year cash flow projections; the five year profit and loss forecasts; and the 5 year projected balance sheets; it couldn’t be any easier.

5. Business loans, hire purchase investor finance made easy

Our financial projections template incorporates business bank loans or hire purchase contracts for fixed asset purchases.

Your financial projections can also be used to calculate any bank overdraft facility requirements for your small business.

This easy to use loan function includes many different loans types that are available to small businesses. The template has built-in loan and hire purchase functionality to suit most types of business loan facility.

6. Sensitivity analysis will save you time

Another time-saving feature is the sensitivity analysis tool. It’s important to stress test your financial projections.

With Cash Forecaster, this is made really easy whereby you can quickly increase or decrease your sales and/or cost of sales with the click of a button. This feature saves you time by not having to re-enter your data over and again.

Banks and investors often want to know your best case or worst case business scenarios, before they will lend or invest. Our simple financial projections template makes the task of your what-if scenarios quick and easy.

7. Feature you require not listed in our simple financial projections template…

Everyone benefits when our Cash Forecaster software is upgraded. Most of the new features we include are suggestions from customer that have already purchased. Recently a client was recommended to use our software by Lloyds Bank Plc. This customer asked for a specific report, so we upgraded Cash Forecaster free of charge, as it would benefit future customers too.

This is a key commitments to our customers. So if you’d like us to add a new feature that will help you prepare cash flow forecasts for your small business, we will include it free of charge. The only caveats are: the feature required is possible to do; and we feel that it will benefit other clients too.

And remember, this unique service is provided completely free of charge. Also, if your initial purchase was dependent on this new feature being included, and we are not able to deliver on this promise, we will extend the 30 day money back guarantee to the point at which we are not able to deliver on your request. In which case you’ll get 100% of your money back…not questions asked

However, so far we’ve managed to cater for all requests, some take longer than others to incorporate, but it does mean that this version of a Cash Forecaster software is full of extra ‘customer-requested-features.’

This offer is a win-win scenario for you and for us. You receive a free upgrade, whilst we can offer the new feature to future customers.

For this feature rich financial projection template, all you pay is a small $147 investment.

£147.00Add to basket

Here’s a list of features included in our best selling simple financial projections template profit and loss, cash flow and balance sheet projection template:

Profit and loss projections reports…

The profit and loss projections includes the following features:

• Month by month projections for 12 months; 24 months; 3 years; 5 years; 6 years and 7 years.
• 20 product/sales lines with associated cost of sales lines.
• Detailed overhead expenses.
• Accruals and prepayment feature to easily adjust your startup forecasts to tie in with payment timings and what’s charged to the profit and loss.

Balance sheet projections report at each month end and at each year end…

The projected balance sheet for your business includes the following features:

• Ten loan or hire purchase accounts. These include many great functions and features; including: Interest rate; Loan term; Final lump payment; Set your own payment amount; Loan repayment holidays; Interest charged to the loan or to the bank; plus more.
• Capital expenditure and fixed assets.
• Asset depreciation rates including automatic calculations.
• Stock and work in progress feature.
• Factoring or Invoice discounting feature. If your company factors/invoice discounts its invoices or is looking to see how this affects business cash flows, this feature is included.
• Other debtors and other creditor facility.
• Opening balances facility – easily enter your opening trial balance or closing balance sheet.

The cash flow projection template includes these additional functions and features…

• International currency symbol on all reports – £, $ and € (or any other currency).
• VAT, Sales Tax and GST terms – Cash Forecaster software does all the necessary calculations for you.
• Automatic overdraft interest or deposit interest calculations.
• Flexible customer payment terms – With up to 12 months credit terms.
• Prepaid income with up to 24 months advance payments.
• Flexible supplier payment terms – Payment terms include cash through to 12 month payment terms.
• Credit card charge calculations.
• Payroll taxes and wages deductions.
• Company/Corporation tax calculator with great features, including adjusting the profit for tax purposes.
• Sensitivity analysis tool to speedily trial various scenarios.
• Owner dividends or drawings/capital introduced or director/partner loans.
• Flexible headings that can be changed to suit your business.

The main reports include in the financial projections template are a profit and loss projection, projected ‘Cash Flow Statement’, cash flow projections and a projected balance sheet for 12 months to 7 years.

The main reports included in Cash Forecaster include:

Assumptions report

The assumptions report details the main assumptions used in the financial projections period.

Details include the rate of interest that would apply to an overdraft that may be required in the forecast period. Versus interest income on money in the bank that would apply to surplus cash in your forecast period.

The projected assumptions report also details information about the depreciation rates of fixed assets and also shows information on company taxation rates.

The tax detail shows the projected adjusted profit for tax, along with the tax rate for that future period and the estimated tax too.

Hover your mouse over the image to enlarge.

 

Summary projections

The projected summary report is a quick glance report of the profit and loss and cash flow forecast.  with a break-even analysis.

The cash flow summary includes a 12-monthly detail of opening and closing bank balances, together with the net income and payments.

The summary profit and loss includes the turnover, cost of sales and gross profit detail, together with a summary of the expenditure and taxation charge. At the bottom of the forecast profit and loss is the break even analysis.

Hover over the image to enlarge.

Projected cash flow report

The projected cash flow report provides the breakdown of ‘cash-in‘ vs ‘cash-out‘ for each 12 month; 24 month; 3 years, 4 years, 5 years; 6 years and 7 year period.

Projected ‘cash-in’s‘ include future payments received from customers, loan advances, proceeds on sale of assets and any other income.

The ‘cash-outs‘ include payments to suppliers, capital expenditure, loan repayments, tax payments, dividends and any other cash out-flows.

Hover over the image to enlarge.

Projected profit and loss report

The projected profit and loss report provides a breakdown between the projected sales, cost of sales and gross profit and the future expenditure detail. These projections are for 12 month; 24 month; 3 year; 4 year; 5 year; 6 year; and 7 year profit and loss projections.

The projected expenditure detail is summarised between wages and salary costs, general overheads, financial overheads and depreciation.

Hover over the image to enlarge.

Projected ‘Cash Flow Statement‘

In addition to having the conventional cash flow projections report, Cash Forecaster also includes a projected ‘Cash Flow Statement‘.

The Cash Flow Statement provides a projection for 12 months to 7 years. It’s broken down between operating projections, projected investing and projected financing activities and follows FRS 102 guidance for its layout.

The projected Cash Flow Statement shows inflow and outflow of cash and cash equivalents from various activities of your business during the projected period under review. The main headings are your projections of your operating activities, your investing activities and your financing activities.

Information provided through the Cash Flow statement is useful to assess the ability of your business to generate cash and cash equivalents, whilst providing information on the needs of your enterprise to utilise those cash flows.

Hover over the image to enlarge.

Forecast trading summary report

The forecast trading summary report provides a breakdown sales and cost of sales, which provides the detail to support the profit and loss forecast.

The forecast trading summary is split between the breakdown of turnover and shows the various sales lines and the breakdown of cost of sales.

The sales are adjusted where appropriate for any advanced sales or provisions for prepaid sales too. Whereas cost of sales is adjust for any movements in stock and/or work in progress and accruals.

Hover over the image to enlarge.

Projected overheads report

The projected overhead report provides the detail to your estimated projection of overheads for your business and supports the proposed profit and loss report.

The projected overheads report provides the breakdown of the main expenditure headings for the projected profit and loss, which are your anticipated ‘Wages and salary costs,’ ‘General overheads’ and ‘Financial overheads.

The reported numbers on the projected overheads report are net of any accruals and/or prepayments provided for in the projected period.

Hover over the image to enlarge.

Projected balance sheet report

The projected balance sheet report is a proposed balance sheet at the end of each year of your estimated periods. Which can be anything from 12 months to a longer term cash flow forecast of up to 7 years.

The projected balance sheet provides the usual analysis between fixed assets, current assets, current liabilities, long term liabilities and share capital and reserves.

The forecast figures included on the balance sheet are calculated automatically by the financial projections template.

The projected balance sheet is one of the most important components of a set of projections and business plans.

Hover over the image to enlarge.

 

 

 

 

Monthly projected balance sheet

In addition to the end of year projected balance sheet, Cash Forecaster also has a monthly projected balance sheet too.

The monthly balance sheet projections provides the same information as the planned period end balance sheets, except that the information is reported at the end of each and every month of the financial projections period.

Hover over the image to enlarge.

 

Fixed asset projections report

The fixed asset projections report provides the detail of your planned additions, disposals and depreciation of fixed assets in the forecast period. This report supports the balance sheet projections too.

The projected report is split between the planned cost of the fixed assets and the estimated depreciation projections.

The projected cost of fixed assets shows the movements relating to additions and disposals during the projected period on a month by month basis.

The planned depreciation section of the report shows the month by month depreciation charge for each of the fixed asset headings.

Finally, the report also provides a breakdown of your future asset disposals and shows the profit or loss on the planned disposals.

Hover over the image to enlarge.

Projected loan and hire purchase report

The projected loan and hire purchase report provides a detailed breakdown of your loans and hire purchase projections in each of the planned periods.

The projected loan report is split between each of the ten possible loans you can have in the forecast period.

On loan report page is a summary of the main elements of each loan. This information consists of the loan interest rate, the loan or hire purchase term, first month of the loan repayment, the capital sum borrowed and projected total interest and loan repayments over the loan term.

The report also includes an analysis of the projected month by month repayments and interest charges throughout the period of the loan.

The projected loan and hire purchase report provides the breakdown for the balance sheet.

Hover over the image to enlarge.

VAT/Sales Tax/GST projections report

The VAT (Sales Tax/GST) projections report provides a breakdown of your projected VAT (Sales Tax) entries in the cash and profit projections.

The VAT (Sales Tax) report is split between the amount of VAT (Sales Tax) charged on sales and the VAT (Sales Tax) paid on cost of sales and expenses.

The report shows how the net payments or refunds are made up that appear on the cash flow projections.

The closing balance that appears on the projected balance sheet is also shown on the VAT projections report.

Hover over the image to enlarge.

Payroll taxes projections report

The Payroll Taxes projections report (which in the UK is PAYE) provides a breakdown of your estimated payroll tax entries in the forecast period.

The report summarises the projected deductions from your payroll entries in the forecast period either from direct wage costs or from your overhead wages expense deductions.

The report also displays the amounts and when these are anticipated to be paid to the Government and supports the projected cash flow report. The closing balance that appears on the projected balance sheet is also shown too.

Hover over the image to enlarge.

Projected forecast factoring or invoice discounting report

The projected forecast factoring or invoice discounting report provides a detailed analysis and breakdown of factoring entries in the forecast period.

The report analyses the factored sales projections and shows the movements in factor advances and repayments during the forecast period.

The numbers shown support the cash flow report payments and receipts, as well as the projected balance sheet report to backup the closing balance on factoring or invoice discounting at the end of each moth of your projections.

Hover over the image to enlarge.

Backup report

The backup report provides a detailed breakdown to support the projected profit and loss, cash flow and balance sheet reports.

On the projected backup report there’s a more detailed breakdown of expected customer payments between the various credit terms. There’s also a more detailed analysis of the factoring cash movements on the cash flow forecasts.

Also, there’s an analysis of the projected supplier payments, which are separated out between the various credit terms.

Hover over the image to enlarge.

 

 

Projected monthly reports

The forecast monthly reports are designed to pull-out whatever period you like. This includes comparatives of your choice for the profit and loss and projected balance sheet.

In the example forecast monthly report the two periods chosen are the 12 months from 1 January 2018 to 31 December 2018 and the comparative is for the 12 month period from 1 January 2019 to 31 December 2019.

These periods can be changed to suit whatever period you would like to pull out from the forecast numbers.

The forecast month report consists of a forecast profit and loss report, an overhead breakdown report, a projected balance sheet and a profit and loss reconciliation report.

Hover over the image to enlarge.

Here are a sample of the reports generated from our financial projections template – Cash Flow Forecasting Reports

£147.00Add to basket

The types of business and reasons for needing a financial projection template

Financial projections template for startup

Financial projects for a startup are probably more challenge to prepare than they are for an established business.

The reason for the difficulty is that for any new busibness there are no prior periods to base any projections or assumptions on. With a startup you are starting from scratch and preparing financial projections from a blank canvas.

Having said that, having financial projections for a startup is a key part of the startup process. This is especially true where you are raising either bank finance or investment finance.

Our financial projections template is ideal for startups. One of the main reasons why is due to the speed and easy of use.

This is how one of our customers explained it…

“It took only 10 minutes and I had a complete cash and profit forecast printed and ready for the bank, including balance sheets.” Adrian B in the UK.

The main difference for a startup business over an existing business is there are usually no opening balances to enter. Out financial forecast template includes an ‘Open’ data entry section, but where your startup business doesn’t have opening balances, this can easily be ignored.

Tech startup financial projections template

What if your new startup business is a tech startup? Not a problem, as our financial projection template caters for every business type.

This includes if your tech startup receives prepaid income from customers. The template has the option to enter prepaid income which is paid for up to 24 months in advance. It’s easy to enter your income projections for however many months you require them to be. Once your sales projections have been entered, select the ‘prepaid-period’ from a drop-down list, and the financial projections template does ‘the rest‘ for you.

‘The rest‘ includes putting the correct sales projections on the projected profit and loss reports. The template will also include the correct amounts of ‘cash-in’s’ and ‘cash-outs’ on your projected cash flow report and projected ‘Cash Flow Statement’ too.

Financial projections template for restaurant

Restaurants are probably one of the most popular startup and run businesses across the world. However, restaurants are also responsible for the highest business failures too.

Therefore, as a restaurant business is so risky, this makes preparing a business plan even more important. It’s vital that the business plans are supported by a carefully thought out financial projection too.

As the saying goes “fail to plan and you plan to fail.”

Using a financial projections template for your business plan is key to your restaurants survival.

24 month financial projections template

If you’re looking for a 24 month financial projections template, then our template caters for you. The template will project for any period from 12 months through to 7 years.

The 24 month projection would be split across two pages, with each page representing 12 months of the full 24 month period.

The 24 month financial projections template will also provide you with a projected balance sheet at the end of each an every month of your full 24 months, as well as at the end of each year end.

3 year financial projection template Excel

Another popular period is a 3 year projection. If your looking for a 3 year financial projections template, then our template caters for you too.

Similar to the 24 month of 2 year projection, the 3 year projections will be split across  three pages. Each page would represent 12 months of the full 3 year projection period.

You have the option to print either a period end projected balance sheet at the end of each of the 3 years, or to print the monthly balance sheet. The projected monthly balance sheet shows a balance sheet at the end of each and every month of the 3 year period and would be split across three separate pages.

5 year business financial projections template

Of all the long term-term financial projections the 5 year financial projection is the most popular. So if you’re looking for a 5 year financial projection template using Excel, then our template caters for you too.

The 5 year projection would be split across five 5 pages in this case, with each page representing one of the 5 years of the forecast. You also have the option of a single period end projected balance sheet at the end of each of the five years, or to use the monthly projected balance sheet report.

30-DAY MONEY BACK GUARANTEE:

Our 30-Day Promise To You: If for whatever reason you buy our cash flow forecasting software and don’t like it, we will refund all your money; no questions asked.

Also, please notify us immediately of a feature you’d like included when you purchase Cash Forecaster software, and we’ll extend this guarantee to the point we deliver on including your requested feature. If we are not able to add the feature you require, for whatever reason, you will receive your money back.

And remember, adding a feature in this way, is completely free of charge too.

What our customers are saying about our products:

“We can recommend the cash flow forecaster as being a very simple programme to use, producing professional-looking reports, very reasonably priced and saved us many hours of work compiling our own initial spreadsheet. The after-sales service was also extremely efficient.”Jane Heard Associates.

“Works a treat, a friend entered my data into the Sage Forecasting program to see if there would be any differences in outcome. Of course it did not!” Matt, ERAMA Ltd.

Software requirements:

The financial projections template is Excel-based software. You will need to have Microsoft Excel installed on your computer, in order run the software. But, you don’t need to have expert knowledge of Excel or Spreadsheets in order to use the program, as it is easy to use and fully explained in the user manual that accompanies the software.

Frequently asked questions about this financial projections template can be found here: FAQs

What you receive when you order your copy of Cash Forecaster

When you purchase our financial projection template, you’ll receive two files, as follows:

• Cash Forecaster The financial projections template software built using Excel.
• Cash Forecaster The financial projections template user guide.

How your the financial projection template is delivered to you

Once you’ve completed your purchase after you’ve checked out, you’ll be redirected to a download page. There will be a download link on that page where you can download Cash Forecaster straight to your computer.

You’ll also receive an order confirmation email, which will contain a link to the software download.

So if you’re not at your computer when you buy our financial projection template and you’re not ready to download Cash Forecaster right away, you’ll have an email to link to your download afterwards.

The link to your download will remain active for 30 days after your purchase. This gives you plenty of time to download your product.

Frequently asked questions about our financial projection template

Frequently asked questions about our financial projection template Cash Forecaster are here – FAQs