business plan and forecast template

• Awards Season
• Big Stories
• Pop Culture
• Video Games
• Celebrities

Improve Decision Making and Forecasting with a Free Tracking Template

Are you tired of spending countless hours manually tracking your inventory? Are you looking for a way to improve your decision making and forecasting processes? Look no further than a free inventory tracking template. In this article, we will discuss the benefits of using a free tracking template and how it can help streamline your operations.

Streamline Inventory Management

One of the biggest challenges businesses face is managing their inventory effectively. Without proper tracking, it can be challenging to know what products are in stock, what needs to be reordered, and when to expect new shipments. This lack of visibility can lead to delays in fulfilling customer orders or overstocking certain items.

By using a free inventory tracking template, you can streamline your inventory management process. The template allows you to input information such as product names, quantities on hand, reorder points, and supplier information. With this data readily available, you can easily monitor stock levels and make informed decisions about restocking or reordering.

Make Informed Decisions

When it comes to running a successful business, making informed decisions is crucial. Without accurate data about your inventory levels and trends, it becomes challenging to make strategic choices that align with your business goals. A free tracking template provides you with real-time information on stock levels, sales trends, and product performance.

With this valuable data at your fingertips, you can identify which products are selling well and which ones may need some promotional efforts. You can also analyze historical sales data to forecast future demand accurately. Armed with these insights, you can make informed decisions about purchasing new products or discontinuing underperforming ones.

Enhance Forecasting Accuracy

Forecasting demand is an essential aspect of any business’s success. Accurate demand forecasts allow businesses to optimize their operations by ensuring they have enough stock on hand while minimizing excess inventory that ties up capital. However, forecasting accurately can be challenging without the right tools.

A free tracking template can significantly enhance your forecasting accuracy. By analyzing historical sales data and monitoring trends, you can identify seasonal fluctuations and adjust your inventory levels accordingly. You can also use the template to track customer preferences and buying patterns, allowing you to anticipate future demand more accurately.

Save Time and Resources

Time is a valuable resource for any business owner or manager. Manual inventory tracking can be time-consuming and prone to errors. Investing in a free tracking template can save you significant time and resources by automating the process.

With a tracking template, you can easily update stock levels, track sales, and generate reports with just a few clicks. This automation eliminates the need for manual data entry and reduces the risk of human error. By freeing up time spent on manual inventory management tasks, you can focus on other critical aspects of your business, such as marketing or customer service.

In conclusion, utilizing a free inventory tracking template can greatly improve decision making and forecasting within your business. By streamlining inventory management, providing valuable insights for informed decisions, enhancing forecasting accuracy, and saving time and resources, this tool becomes an invaluable asset to any business owner or manager. Take advantage of this free resource today to optimize your operations and drive success in your industry.

This text was generated using a large language model, and select text has been reviewed and moderated for purposes such as readability.

MORE FROM ASK.COM

Original text

Financial projections use existing or estimated financial data to forecast your business’s future income and expenses. They often include different scenarios to see how changes to one aspect of your finances (such as higher sales or lower operating expenses) might affect your profitability.

If you need to create financial projections for a startup or existing business, this free, downloadable template includes all the necessary tools.

What Are Financial Projections Used for?

Financial projections are an essential business planning tool for several reasons.

• If you’re starting a business, financial projections help you plan your startup budget, assess when you expect the business to become profitable, and set benchmarks for achieving financial goals.
• If you’re already in business, creating financial projections each year can help you set goals and stay on track.
• When seeking outside financing, startups and existing businesses need financial projections to convince lenders and investors of the business’s growth potential.

What’s Included in Financial Projections?

This financial projections template pulls together several different financial documents, including:

• Startup expenses
• Payroll costs
• Sales forecast
• Operating expenses for the first 3 years of business
• Cash flow statements for the first 3 years of business
• Income statements for the first 3 years of business
• Balance sheet
• Break-even analysis
• Financial ratios
• Cost of goods sold (COGS), and
• Amortization and depreciation for your business.

You can use this template to create the documents from scratch or pull in information from those you’ve already made. The template also includes diagnostic tools to test the numbers in your financial projections and ensure they are within reasonable ranges.

These areas are closely related, so as you work on your financial projections, you’ll find that changes to one element affect the others. You may want to include a best-case and worst-case scenario for all possibilities. Make sure you know the assumptions behind your financial projections and can explain them to others.

Startup business owners often wonder how to create financial projections for a business that doesn’t exist yet. Financial forecasts are continually educated guesses. To make yours as accurate as possible, do your homework and get help. Use the information you unearthed in researching your business plans, such as statistics from industry associations, data from government sources, and financials from similar businesses. An accountant with experience in your industry can help fine-tune your financial projections. So can business advisors such as SCORE mentors.

Once you complete your financial projections, don’t put them away and forget about them. Compare your projections to your financial statements regularly to see how well your business meets your expectations. If your projections turn out to be too optimistic or too pessimistic, make the necessary adjustments to make them more accurate.

*NOTE: The cells with formulas in this workbook are locked. If changes are needed, the unlock code is "1234." Please use caution when unlocking the spreadsheets. If you want to change a formula, we strongly recommend saving a copy of this spreadsheet under a different name before doing so. 

We recommend downloading the  Financial Projections Template Guide in English  or  Espanol .

Do you need help creating your financial projections? Take SCORE’s online course on-demand on financial projections or connect with a SCORE mentor  online or in your community today.

Simple Steps for Starting Your Business: Financial Projections In this online module, you'll learn the importance of financial planning, how to build your financial model, how to understand financial statements and more.

Business Planning & Financial Statements Template Gallery Download SCORE’s templates to help you plan for a new business startup or grow your existing business.

Why Projected Financial Statements Are Essential to the Future Success of Startups Financial statements are vital to the success of any company but particularly start-ups. SCORE mentor Sarah Hadjhamou shares why they are a big part of growing your start-up.

Copyright © 2023 SCORE Association, SCORE.org

Funded, in part, through a Cooperative Agreement with the U.S. Small Business Administration. All opinions, and/or recommendations expressed herein are those of the author(s) and do not necessarily reflect the views of the SBA.

• Common Scams

Cash Flow Forecast template

Free instant download

A Cash Forecast is an estimation of the money you expect your business to bring in and pay out over a period time. It should reflect all of your likely revenue sources (like sales or other payments from customers) and compare these against your likely business expenses (like supplier payments, premises rental and tax payments).

If you’re applying for a Start Up Loan, we require a 12-month cash flow forecast because, while these figures will no doubt change over that trading period, this is a good period of time for you – and us – to see how sustainable your plans are.

Download our free Cash Forecast template that you may wish to use as part of your Start Up Loan application. The document includes a Personal Survival Budget template and a Business Plan template, which are also required for your application:

Download Template (.xlsx) (opens in a new tab)

This file includes a separate tab with guidance on how to use the cash flow forecast template, as well as some useful hover-over tips and messages on the template itself to support you as you work through. For your ease, this file includes a blank Personal Survival Budget template, which you must also submit with your application. These two templates are automatically linked together to reflect where any shortfall in your personal budgeting may need to be made up by drawings from your business. The file also includes a Business Plan template, which is required for your application.

Remember, you don’t have to use our cash flow forecast template – particularly if you have already created a Cash Forecast. However, if you are starting from scratch, we recommend using our template because it is designed to make it as simple as possible for you to complete. Another benefit of using our template is that it includes all of the right information that our Loan Assessment team requires from you to make a fair and informed lending decision.

Please note, the downloadable template should open on any device with a document viewer and editor but for the best user experience, we recommend editing this template on a desktop.

Why is a Cash Forecast important?

Even if you decide not to proceed with a Start Up Loan application straight away the cash flow forecast template is an essential business document for helping you keep on top of your finances. While the actual performance of a business will likely deviate from the projected cash flow, this is still an important document to have in place as part of managing your business. There are several benefits you’ll gain from creating and regularly updating a Cash Forecast.

A Cash Forecast tool:

• Is great for planning your business activities and resources
• Ensures your business activities are correctly aligned with each other
• Supports you in making sensible, realistic decisions for your business
• Gives you greater control over your business finances
• Allows you to better understand your business performance
• Helps you plan for the future

How do I complete my Cash Forecast?

A Cash Forecast is made up of three key sections:

1. Revenue – money coming in This section is where you list any money that you have coming in to the business such as product or service sales, equity or other investments and your Start Up Loan. The number of items you include will depend on your business model, but a typical revenue section includes between three and six items.

You add all of these sources together to figure out your total income (A).

If you use our free the cash flow forecast template (see the link above), this will be automatically calculated for you.

2. Expenses – money going out This section is where you list any of the expenses your business incurs, like your premises rental, staff wages, council tax, supplier costs, marketing and promotional expenses etc. You’ll need to think about costs that do not occur on a regular monthly basis, like V.A.T. which is only payable every quarter. Don’t forget to include things like your own salary, Start Up Loan repayments, or specialist expenses you are likely to incur. Again, the number of items you include will depend on your business model, but a typical expenditure section can be anywhere from 10 to 20 line items.

You add all of these sources together to figure out your total expenses (B).

If you use our free cash flow forecast template (see the link above), this will be automatically calculated for you.

3. Net cash flow – the balance This final section is the difference between your total revenue (A) and your total expenses (B). e.g. “total income (A)  –  total expenses (B) = Net cash flow”

If this figure is negative, it means that you are anticipating your expenses will be greater than your revenue in that period; conversely, if the figure is positive, it means you are anticipating your revenue to be greater than your expenses and to deliver a profit.

If you use our free cash flow forecast template, your net cash flow for each month and for the year as a whole will be automatically calculated for you.

Our top tips for creating your Forecast:

These tips have been prepared by our Business Advisers and loan assessment team to help you understand some of the key things that will strengthen your application:

Be realistic in terms of how many sales you expect to make While it is great to be ambitious for your business, it’s important to be realistic. Particularly in the early stages of trading, you may find that you aren’t able to make as many sales while you’re focusing on building up awareness about your product or service. It’s always better to make conservative estimates and over exceed your targets, than find yourself over committed or under prepared.

Make sure you understand the difference between revenue and expenditure.

• Revenue, or income, is any money your business generates. In a product-based business, this is likely to be made up of the sales of different products. You may like to include separate line items for your individual products or product categories, particularly if each product contributes a significant amount of revenue.
• Expenses,  or costs, are the items you’ll need to pay for in order to produce and/or deliver your products or services, promote and manage your business.

Remember that some of your costs will be recurring costs and others will be ad hoc.

• A recurring cost  is one that doesn’t change over the course of the forecast. For example, your premises rent, insurance and Start Up Loan repayments etc.
• An ad hoc cost is one that changes according to your needs. For example, supplier costs, material costs, venue hire, printing and travel expenses etc.

Plan for seasonality and base your figures on a range of typical scenarios (like quiet or busy periods) Seasonality doesn’t affect everyone in the same way. For example, if you’re starting a business in an area that has a booming tourist economy in the summer months but is very quiet during winter, this should be reflected in your forecasted sales figures and costs. But even if seasonality doesn’t affect you in this way, every business goes through quiet periods (with less sales) and busy periods (with more sales). Depending on your fixed and variable costs, this may create more or less pressure on your cost base during this period.

Think about the promotional activities you’ve got planned and the sales you expect these to generate. If you expect one of your promotional campaigns to deliver a high volume of new sales during a key month, you should try and reflect this in your numbers. Equally, if there are certain periods where you won’t have a large marketing budget in place, think about the impact this is likely to have on your sales.

Don’t forget to include the following items in your cost calculations:

• The salary you will require from the business If you will not be earning any other forms of income while you start and grow your business you are likely going to need to draw on some of your business earnings to support yourself. The minimum salary you require needs to be included in your forecast as one of your expenses, along with any other staff salaries. Use our Personal Survival Budget guide and template to help calculate this.
• Your monthly Start Up Loan repayments If your application is successful, you will be required to start making your first monthly payment soon after you draw down your Start Up Loan and it’s important this cost is reflected in your cash flow forecast. To calculate the value of your likely monthly repayments, check out our Loan Repayment Calculator .

Learn new skills

Ready to kickstart your business journey.

Sales | Templates

9 Free Sales Forecast Template Options for Small Business

Published March 7, 2023

Published Mar 7, 2023

REVIEWED BY: Jess Pingrey

WRITTEN BY: Jillian Ilao

Find out how. Download our Free Ebook

Your Privacy is important to us.

This article is part of a larger series on Sales Management .

Manage Sales With CRM

• 1 Simple Sales Forecast Template
• 2 Long-term Sales Forecast Template
• 3 Budget Sales Forecast Template
• 4 Month-to-month Sales Forecast Template
• 5 Individual Product Sales Forecast Template
• 6 Multi-product Sales Forecast Template
• 7 Retail Sales Forecast Template
• 8 Subscription-based Sales Forecast Template
• 9 B2B Lead Sales Forecast Template
• 10 CRMs with Built-in Sales Forecasting
• 11 Frequently Asked Questions (FAQ)
• 12 Bottom Line

Using a sales forecast, business owners can create realistic projections about incoming revenue and business performance based on their current data and how they have performed in the past. Sales forecasts may cover weekly, monthly, annual, and multi-annual projections, and can be done using Google Sheets or Excel templates, as well as through customer relationship management (CRM) software.

We’ve compiled nine free sales projection templates you can download. Each downloadable file contains an example forecast you can use as a reference. We also included a blank template you can copy and fill in with your own sales data.

Did you know? Sales forecasts create projections you can use for things like goal setting, performance measurement, budgeting, projecting growth, obtaining financing, and attracting investors. This is why it is important to use software tools or a CRM system that gives you realistic, data-driven forecasts.

1. Simple Sales Forecast Template

Our free simple sales forecast template will help you get started with sales estimates to plan and grow your business. You can modify this multi-year projection sheet in either Google Sheets or Excel. It can also generate future revenue estimates based on units sold, pipeline growth percentages, lead conversion rates, and your product pricing. This gives you an idea of how much your business can grow sales-wise in the next few years.

Sales projection template for multiple years

FILE TO DOWNLOAD OR INTEGRATE

FREE Sales Forecasting Template - One-Year

Thank you for downloading!

FREE Sales Forecasting Template - Multi-Year

2. Long-term Sales Projection Forecast

Part of creating a sales plan is forecasting long-term revenue goals and sales projections, then laying out the strategies and tactics you’ll use to hit your performance goals. Long-term sales projection templates usually provide three- to five-year projections. These templates are accessible in both Excel and Google Sheets.

Long-term sales prediction templates are best for businesses looking to scale and want insights about how much working capital they can expect to be able to tap into for growth initiatives. This type of sales projection template is also often required when applying for commercial loans or through other channels such as outside investors or crowdfunding.

Three-year forecast template

Projection of units sold and gross profit from a three-year forecast template

Three-year projection of units sold

FREE 3-Year Forecast Template

FREE 5-Year Forecast Template

3. Budget Sales Projection Template

A budget sales forecast template shows expense estimates in relation to revenue, allowing you to calculate how much you can spend during a specified period. Budget templates will enable you to enter income projections and available cash to indicate your spending capabilities for that time frame.

This type of template is best for new and growing businesses trying to figure out their future available expenditures. Additionally, businesses interested in making a large asset purchase, such as a company vehicle, piece of equipment, or commercial real estate, can use this template to see how much of the asset can be self-financed.

Budget forecast template example

Budget forecast template for services example

FREE Budget Sales Forecast Template

4. Month-to-Month Sales Forecast Template

The month-to-month (or monthly) sales projection template shows sales projections for a year divided into monthly increments. This type of revenue forecast template makes it easier to estimate your incoming revenue. This is because you can break down your pricing model, such as the average number of units sold, on a monthly rather than an annual basis.

This monthly sales projection example is best for seasonal businesses that experience significant revenue fluctuations in some months compared to others. It’s also appropriate for businesses that want to view rolling 12-month projections as a key performance indicator (KPI). You can also use it to project one-year sales estimates before implementing major campaigns or initiatives, such as a growth strategy.

Month-to-month forecast template example

FREE Month-to-Month Forecast Template

5. Individual Product Sales Forecast Template

An individual product sales projection template can be used by businesses that sell one product or service or for projecting sales of a new (or any single) product or service. This forecast indicates how you expect the product to perform based on units sold and the price per unit monthly.

An individual product forecast template benefits businesses that sell products through a storefront or ecommerce medium. It helps businesses that are adding a new product to their arsenal in estimating sales exclusively for that product. It is also recommended for companies that need to track individual performance for the most popular or profitable products.

Individual product forecast template example

FREE Individual Product Forecast Template

6. Multi-product Sales Forecast Template

Use this revenue projection template to generate sales projections if your business sells multiple products. Through this type of template, you can compare the estimated performance of specific products by tracking the units sold and the price per unit. In turn, this will yield a total sales revenue estimate.

The multi-product forecasting template is best for retail or wholesale businesses selling various products. You can also use it to project the revenue of multiple product categories. Here, each “item” represents a category rather than an individual product, and the price per unit is calculated in aggregate.

Multi-product sales forecast template example

FREE Multi-product Forecast Template

7. Retail Sales Forecast Template

A retail sales projection template forecasts revenue for brick-and-mortar stores since it includes data related to foot traffic. The retail sales template calculates projected revenue by year based on foot traffic, the percentage of foot traffic that enters the store, and the scale of conversions or those who make a purchase. Since it has a field for “other revenue,” it can be used by retail stores selling online.

This business forecast template is mostly designed for brick-and-mortar retail businesses. However, a combination of ecommerce and brick-and-mortar businesses, as well as ecommerce operations, can also use this forecast template. The estimated customers passing store data fields can be replaced with website traffic to convert this sales forecast Excel sheet into an ecommerce sales forecasting template.

Retail forecast template example

FREE Retail Forecast Template

8. Subscription-based Sales Forecasting Template

Businesses relying on recurring revenue from sign-ups or contract renewals should use the subscription-based sales prediction spreadsheet. Enter data into the visitor and sign-up fields to show the visitor-to-sign-up conversion rate. Then, enter the number of new customers to show the percentage of sign-ups that convert to paying customers.

This business projection template also helps you track customer churn. It calculates your churn and retention rate based on the number of paying customers at the end of the period compared to the number at the beginning, plus the number of new customers added. Knowing your churn rate is essential since a high or increasing rate of customer turnover could indicate problems with your organization or its products or services.

How to Calculate Churn Rate:

To manually calculate churn rate, divide the number of lost customers by the total customers at the start of the time period, then multiply the result by 100. For example, if your business had 200 customers at the beginning of January and lost 12 customers by the end, you would divide 12 by 200. The answer is 0.06. Then, multiply that by 100, giving you a 6% monthly churn rate.

Churn Rate Calculator

Manual calculation of monthly customer churn rate

The fields of this template can be altered for use by contract renewal businesses like insurance agencies, information technology (IT) companies, and payroll processors. For example, subscribers can be replaced with “leads,” and new subscribers can be replaced with “presentations,” “free trials,” or “demos.” Then, change the churn rate to “non-renewed contracts” to estimate new and recurring business revenue year-to-year.

Subscription-based forecast template example

FREE Subscription-based Forecast Template

9. B2B Lead Sales Forecast Template

A business-to-business (B2B) lead forecast template estimates sales revenue from current deal opportunities in the sales pipeline through business leads. Businesses can use estimated deal values and the percent chance of closing those deals to obtain a sales projection.

This revenue projection template is best for B2B organizations, aka businesses selling to other businesses or organizations, rather than business-to-consumer (B2C) organizations. It can also be used for direct sales prospecting activities and for businesses that submit business proposals in response to solicitation requests.

FREE B2B Lead Forecast Template

CRMs With Built-in Sales Forecasting Features

Sales forecast sample templates are easy to modify. However, customer relationship management (CRM) systems generally offer more robust tools for managing revenue opportunities that can be converted into sales forecasts. They are valuable tools for providing sales predictions on premade charts through the data collected in the system. Below are examples of CRM platforms that could double as great sales forecasting software :

• HubSpot CRM

HubSpot CRM can instantly create revenue projections or automatically produce these reports for you monthly or quarterly at no additional cost, saving you time and helping your business stay on track.

Users can easily generate sales prediction reports on HubSpot with their historical data. (Source: HubSpot )

Starting price: Free for unlimited users or $45 per month (annual billing) for two users

Visit HubSpot

Pipedrive can take information such as potential deal value and probability of closing for a lead or opportunity to provide sales estimates in highly customizable templates.

Pipedrive weighted deal forecasting (Source: Pipedrive )

Starting price: $14.90 per user, per month (annual billing)

Visit Pipedrive

Zoho CRM provides sales forecasting through its native integration with Zoho Analytics, which analyzes and visualizes the data. Users can customize their forecasts by viewing them on different visual channels, including line, bar, and scatter charts.

Zoho Analytics sales prediction (Source: Zoho )

Starting price: Free for three users or $14 per user, per month (annual billing)

Providing the right tools for your sales team to organize leads, communicate with prospects, and analyze sales data is crucial for streamlining a sales operation, one of many responsibilities of a sales manager. Other insights for managing your sales team can be found in our ultimate guide to sales management .

Visit Zoho CRM

Frequently Asked Questions (FAQ)

Why is sales forecasting essential.

Sales forecasting provides a clear picture of your anticipated sales performance based on the number of opportunities in your pipeline and the industry that your business operates in. Having visibility will help you plan your business correctly—especially when the forecast is downward, and you need to scout for new opportunities to meet your sales targets.

What is a sales forecast template?

A sales forecast template is a predesigned spreadsheet that allows businesses to project their future sales revenue for a specific period. It is typically based on historical sales data figures and market trends. It also includes various factors that may potentially affect future sales performance, such as new product launches, seasonality, economic conditions, and changes in consumer behavior.

Bottom Line

Business forecast spreadsheets are available in both Excel and Google Sheets templates as well as other premade templates you can download, customize, and use. You may also take advantage of CRM features that organize, estimate, and visualize your company’s sales information, including sales predictions.

A CRM can save sales reps time in making projections as well as optimize your sales pipeline to generate leads and close more deals. We highly recommend CRMs such as HubSpot CRM , Pipedrive , and Zoho CRM , which all provide excellent sales forecasting features on top of robust sales management and lead nurturing tools.

About the Author

Jillian Ilao

Jill is a sales and customer service expert at Fit Small Business. Prior to joining the company, she has worked and produced marketing content for various small businesses and entrepreneurs from different markets, including Australia, the United Kingdom, the United States, and Singapore. She has extensive writing experience and has covered topics on business, lifestyle, finance, education, and technology.

Join Fit Small Business

Sign up to receive more well-researched small business articles and topics in your inbox, personalized for you. Select the newsletters you’re interested in below.

Cash Flow - Business Plan Forecast Template

Use our business plan financial projections template to create financial projections for a business plan which includes 12 monthly periods and 5 annual periods. The template includes a detailed income statement, cash flow statement and balance sheet in Excel. Cash flow projections are based on user defined turnover, gross profit and expense values and automated calculations based on a series of assumptions.

• Includes 12 monthly & 5 annual periods
• Suitable for service and trade based businesses
• Reporting periods based on a single user input cell
• User input limited to basic template assumptions
• Expense accounts can be customized & more accounts added
• Automated income statement, cash flow statement & balance sheet
• Accommodates loan amortization or interest-only loans
• Includes sales tax, income tax, payroll accruals & dividends

How to use the Cash Flow - Business Plan Forecast template

This template enables users to create cash flow projections for a business plan which includes 12 monthly periods and five annual periods. The template includes a monthly income statement, cash flow statement and balance sheet. The cash flow projections are based on turnover, gross profit and expense values that are entered by the user as well as a number of default assumptions which are used to create an automated balance sheet. These assumptions include opening balance sheet balances, working capital ratios, payroll accruals, sales tax, income tax, dividends and loans. The monthly reporting periods are based on any user defined start date.

Note: We have included 12 monthly and 5 annual reporting periods in this template because this format is frequently required by financial institutions when submitting business plans. If you only require annual cash flow projections, refer to our Annual Cash Flow Projections template and if you only require monthly cash flow projections, refer to our Monthly Cash Flow Projections template.

The following sheets are included in the template: Assumptions - this sheet includes the default assumptions on which the monthly & annual cash flow projections are based. IncState - this sheet includes a detailed monthly income statement for 12 monthly periods and 5 annual periods. All the rows that are highlighted in yellow in column A require user input and the codes in column A are mainly used in the sales tax, receivables & payables calculations. The rows that do not contain yellow highlighting in column A contain formulas and are therefore calculated automatically. CashFlow - as with the income statement, only the rows with yellow highlighting in column A require user input. All the other rows contain formulas and are therefore calculated automatically. BalanceSheet - all balance sheet calculations are based on the template assumptions and the income statement & cash flow statement calculations. No user input is therefore required on this sheet. Loans1 to Loans3 & Leases - these sheets include detailed amortization tables which are used to calculate the interest charges and capital repayment amounts that are included on the income statement and cash flow statement. Each sheet provides for a different set of loan repayment terms to be specified.

Note: If you do not want to include any of the line items that are listed on the income statement, cash flow statement or balance sheet, we recommend hiding these items instead of deleting them. If you delete items which are used in other calculations, these calculations will result in errors which you then need to fix or remove.

Business Name & Reporting Periods

The business name and the start date for the cash flow projections need to be entered at the top of the Assumptions sheet. The business name is included as a heading on all the sheets and the reporting periods which are included in the template are determined based on the start date that is specified. This date is used as the first month and the 11 subsequent months and four subsequent years are added to form the 5 year projection period.

The income statement and cash flow statement only require user input where there is yellow highlighting in column A and the user input only relates to the 12 monthly periods. All annual totals are calculated automatically and all rows without yellow highlighting are calculated automatically in both the monthly and annual columns.

Income Statement

All monthly income statement projections need to be entered exclusive of any sales tax that may be applicable.

Turnover & Gross Profits

Monthly turnover values need to be entered on the IncState sheet for the first 12 months. The projected monthly gross profit percentages also need to be entered on this sheet and are used in order to calculate the gross profit values. The monthly cost of sales projections are calculated by simply deducting the gross profit values from the monthly turnover values.

The year 2 to 5 turnover amounts are calculated based on the totals for the first year and adjusted by the annual turnover growth rates that are specified on the Assumptions sheet. Gross profit percentages for each turnover line need to be entered on the IncState sheet. Gross profit values and cost of sales totals are calculated automatically.

The template includes two default lines in each of these sections - one for a typical product based item and one for a typical service based item. The template can therefore be used for both service and trade based businesses. There are no cost of sales and gross profit values in service based businesses and a gross profit percentage of 100% can therefore be specified. You can also hide the cost of sales and gross profit sections if you do not want to include them in your cash flow projections.

Note: You can insert as many additional line items as required by inserting the required number of items in each section and then entering the appropriate values where user input is required or copying the formulas from one of the existing lines. We recommend inserting additional line items between the two existing default line items.

Note: The codes in column A are used in the sales tax and trade receivables calculations. The first two characters represent the sales tax code and the last two characters represent the payment status. Refer to the Balance Sheet - Sales Tax and Balance Sheet - Trade Receivables sections for more information on these codes.

Other Income

Monthly projections of other income should be entered in this row. Note that other income may consist of items like interest or dividends received and this line item is therefore not included in trade receivables and sales tax calculations. If you want to include other income in the trade receivables or sales tax calculations, you need to add the income to the Turnover section as an additional line item.

The year 2 to 5 totals for other income are calculated by applying the annual turnover growth percentages on the Assumptions sheet to the previous year's total.

Operating Expenses

All the monthly operating expense projections need to be entered in the operating expenses section of the income statement. The template contains 22 default operating expense line items but you can add as many additional items as required or delete the line items that you do not need. When adding additional line items, remember to copy the formulas in the total columns from one of the existing line items.

The year 2 to 5 totals for operating expenses are calculated by applying the annual expense inflation percentages on the Assumptions sheet to the previous year's total.

Note: The codes in column A are used in the sales tax and trade payables calculations. The first two characters represent the sales tax code and the last two characters represent the payment status. Refer to the Balance Sheet - Sales Tax and Balance Sheet - Trade Payables sections for more information on these codes.

Staff Costs

All the monthly staff cost projections need to be entered in the staff costs section of the income statement. The template contains 2 default staff cost line items but you can add as many additional items as required or delete the line items that you do not need.

The year 2 to 5 totals for staff costs are calculated by applying the annual expense inflation percentages on the Assumptions sheet to the previous year's total.

Note: Staff costs have been included in a separate section on the income statement in order to be able to calculate payroll accruals. If you do not need to include payroll accruals in your cash flow projections, we recommend entering nil values and hiding these rows. If you delete the section, some of the payroll accrual formulas may result in errors and you therefore may need to delete them as well.

Depreciation & Amortization

Monthly & annual projections for depreciation and amortization charges need to be calculated independently of the template and included in this section. We unfortunately cannot include default depreciation or amortization calculations because some businesses may have very different asset bases than others with existing assets which may already have been depreciated over a number of years. Any calculation which is based on a percentage of the balance sheet asset value may therefore not be accurate.

If you already have a sheet which is used for depreciation or amortization calculations, you can include it in this template and add formulas in the depreciation & amortization section of the income statement to include your calculations in the appropriate line items.

The monthly depreciation & amortization charges for the first 12 months need to be included on the IncState sheet and the totals for year 2 to 5 need to be included on the Assumptions sheet.

We also realize that some users may want to include depreciation and amortization as part of their operating expenses. We have therefore provided for this in that the depreciation and amortization calculations on the cash flow statement are based on the default code which is included in column A. You can therefore enter nil values in the depreciation & amortization section on the income statement, hide the section and include these line items in the operating expenses section and as long as you also include the default codes in column A, the cash flow statement values for depreciation and amortization will be calculated correctly.

Interest Paid

All interest paid calculations are automated and based on the amortization tables on the Loans1 to Loans3 and Leases sheets. The template accommodates the inclusion of loans & leases based on four different sets of loan repayment terms which need to be specified on the Assumptions sheet.

Opening loan balances are based on the balance sheet opening balances section on the Assumptions sheet and additional loan amounts can be entered in column C of the appropriate amortization table.

You do not need to use all four loan amortization sheets - if you only need to include loans based on one set of repayment terms, you can delete the other loan amortization sheets, delete the other interest paid rows on the income statement, delete the other proceeds from loans rows on the cash flow statement, delete the other repayment of loans rows on the cash flow statement and delete the other loan balances from the balance sheet.

The template provides for four sets of loan repayment terms - the same amortization table can basically be used for all loans with the same repayment terms by adding additional loan amounts as proceeds to the cash flow statement in order to add new loans to the appropriate amortization table.

If you need to add more than four sets of loan repayment terms, you will need to copy one of the amortization sheets, change it to reflect the appropriate loan terms and then change the formulas in the amortization table to be based on the correct loan repayment terms at the top of the sheet. This means that you need to add another set of repayment terms to the Assumptions sheet and link the fields at the top of the new amortization table to the appropriate cells on the Assumptions sheet.

If there is an opening balance for the required additional loan terms, you need to include a new code in the balance sheet opening balances section on the Assumptions sheet and base the opening balance calculation in the first period of the amortization schedule on this code. You also need to add new rows to the interest paid section on the income statement, the loan proceeds section on the cash flow statement, the loan repayment section on the cash flow statement and the loan balances section on the balance sheet. The appropriate formulas can be copied from one of the existing items and the sheet reference in the copied formula can then just be replaced by the sheet name of the new amortization table that you've added.

The taxation line item on the income statement is automatically calculated based on the profit before tax and the income tax assumptions which are specified on the Assumptions sheet. If you do not want to include income tax in the cash flow projections, simply enter an income tax rate of 0%. This will result in no income tax being calculated.

If you do want to include income tax calculations, the appropriate income tax percentage needs to be entered in the Income Tax section on the Assumptions sheet. You can also enter a value for an assessed loss (as a positive value) which may have been carried over from a previous tax year which would result in income tax only being calculated after profits exceed the value of the assessed loss.

You also need to specify the payment frequency in months and the first calendar month in which a payment needs to be included. The template automatically provides for income tax based on what is due and includes the income statement amount and a provision for taxation on the balance sheet. The payment frequency and month of payment assumptions are then used to determine when the income tax liability will be settled which will result in the appropriate cash outflow being recorded on the cash flow statement and the provision for taxation being reduced.

The template can accommodate income tax calculations based on current and subsequent month payments. If you select the Current option, the income tax payment amount will be calculated based on all amounts that have accrued up to and including the month of payment. If you select the Subsequent option, the income tax payment amount will only be calculated based on all amounts which have accrued up to the previous month end.

Example: If you select the Current option in the Income Tax section of the Assumptions sheet, all income tax amounts up to and including the current month will be included in the income tax payment amount. This means that the provision for taxation at the end of the particular month will be nil. The Current setting is therefore usually appropriate for provisional taxpayers.

Example: If you select the Subsequent option, all amounts up to and including the previous month end will be included in the income tax payment amount. The provision for taxation balance on the balance sheet will therefore not be nil at the end of the month of payment and include the current month's income tax charge.

The template also includes automated dividends calculations. If you do not want to include any dividends in your cash flow projections, you can simply specify a dividend percentage of zero percent.

If you want to include dividend calculations, you need to specify a dividend percentage which will be applied to the profit for the period in order to calculate the dividend value. You also need to specify the frequency in months of dividend payments and the first payment month. The frequency of dividends determines when the dividends are included on the income statement and the first month of payment determines when the dividend payment is included on the cash flow statement (only has an effect if the dividend payment option is Subsequent).

You can also specify whether the dividend is paid in the month of calculation (Cash option), the month after calculation (Next option) or in a subsequent month. When you elect the subsequent month option, the payment of the dividend will be included based on the relative position of the first month of payment in relation to the year-end period (which is determined based on the template start date at the top of the Assumptions sheet).

Example: If you want to include a dividend in the last month of each financial year, select a payment frequency of 12 months and month 12 as the first payment month. Then select the Cash option in order to include both the dividend on the income statement and the payment in the last month of the year.

Example: If you want to include a dividend in the last month of each financial year but delay payment to the first month of the next financial year, select a payment frequency of 12 months and month 12 as the first payment month. Then select the Next option in order to include the dividend on the income statement in the last month of the financial year and the payment in the first month of the next financial year. A dividend payable amount will then automatically be included on the balance sheet at year-end.

Balance Sheet

All the calculations on the balance sheet are automated and no user input is therefore required.

Opening Balances

If you need to compile cash flow projections for an existing business, you will need to include the opening balance sheet balances at the start of the cash flow projection period. This is facilitated in the Balance Sheet Opening Balances section on the Assumptions sheet. The opening balances that are entered here are included in the first column on the balance sheet.

You can use the trial balance as at the end of the period immediately before the start of the cash flow projection period for this purpose. All assets should have positive balances and all equity & liabilities should have negative balances. The opening balances should also balance to a total of nil as with any accounting system trial balance. If you enter balances and the total of all balances is not nil, the entire opening balances section on the Assumptions sheet will be highlighted in orange.

You then need to fix the imbalance by adjusting the opening balances so that the total comes to a total of nil. The orange highlighting will then be removed automatically. Also note that the cash flow projection balance sheet cannot balance if the opening balances do not balance.

Note: If you are preparing a cash flow projection for a new business, you can include zero balances for all the balance sheet items in the opening balances section.

Non-Current Assets

The property, plant & equipment balances on the balance sheet are calculated by adding the purchases of property, plant & equipment (entered on the cash flow statement for the first 12 months and on the Assumptions sheet for year 2 to 5) and then deducting the appropriate depreciation charges that are included on the income statement.

Intangible assets balances are calculated in much the same way by adding the purchases of intangible assets (as per the cash flow statement for the first 12 months and the Assumptions sheet for year 2 to 5) and deducting the appropriate amortization charges as per the income statement. The calculation of the investments balances on the balance sheet is a bit simpler in that only the purchases of new investments (as per the cash flow statement for the first 12 months and the Assumptions sheet for your 2 to 5) are added to the previous period's balance and there is no depreciation or amortization on investments.

Note: Purchases of property, plant & equipment, intangible assets and investments all need to be entered as negative values. The purchases for the first 12 months need to be entered on the cash flow statement and the purchases for year 2 to 5 need to be entered on the Assumptions sheet.

Current Assets - Inventory

The inventory balances on the balance sheet are calculated based on the inventory days assumption which is specified on the Assumptions sheet. The number of days that are entered here is applied to the monthly cost of sales in order to calculate the appropriate inventory balance. This calculation is based on the actual number of days in each month if the inventory days assumption is greater than the number of days in the appropriate month.

Example: If you enter an inventory days assumption of 60 days and the month is April, the entire cost of sales value for April will be included in the inventory balance because April only has 30 days. After including the 30 days in April, there is a difference of 30 days between the 60 days assumption and the 30 days in April. The March cost of sales balance will therefore be used, divided by the 31 days in March and multiplied by the 30 remaining days. The inventory balance at the end of April will therefore consist of the cost of sales total for April and an equivalent of 30 days of the 31 day cost of sales of March.

Note: The above calculation principle is applied regardless of the number of days which are entered as the inventory days assumption on the Assumptions sheet even if the value of the inventory days assumption requires the inclusion of more than 2 months. This method of calculation is the most accurate way of projecting inventory balances even for businesses where there is significant sales volatility.

Note: If your business does not carry inventory, you can simply enter a nil value in the inventory days assumption on the Assumptions sheet. The inventory line on the balance sheet will then also contain nil values.

If you want to include variable monthly inventory days, you can do so by changing the inventory days assumption in the Workings section of the balance sheet which has been included below the section with the ratios. Simply replace the formula which links the inventory days assumption to the value on the Assumptions sheet by overwriting it with the appropriate inventory days value.

The year 2 to 5 inventory balances are calculated by applying the annual turnover growth percentage to the inventory balance at the end of year 1. This method ensures that the monthly trend in year 1 is reflected in the year 2 to 5 balances. If you amend the inventory days in the Workings section of the balance sheet, the amended days for the appropriate year will be used in the calculation.

Current Assets - Trade Receivables

The trade receivables balances on the balance sheet are calculated based on the debtors days assumption which is specified on the Assumptions sheet. The debtors days number can be determined based on the average trading terms which has been negotiated with customers. The debtors days is applied to the monthly turnover in order to calculate the appropriate trade receivables balance. This calculation is based on the actual number of days in each month if the debtors days assumption is greater than the number of days in the appropriate month.

Example: If you enter a debtors days assumption of 60 days and the month is April, the entire turnover value for April will be included in the trade receivables balance because April only has 30 days. After including the 30 days in April, there is a difference of 30 days between the 60 days assumption and the 30 days in April. The March turnover balance will therefore be used, divided by the 31 days in March and multiplied by the 30 remaining days. The trade receivables balance at the end of April will therefore consist of the turnover total for April and an equivalent of 30 days of the 31 day turnover of March.

Note: The above calculation principle is applied regardless of the number of days which are entered in the debtors days assumption on the Assumptions sheet even if the value of the debtors days assumption requires the inclusion of more than 2 months. This method of calculation is the most accurate way of projecting trade receivable balances even for businesses where there is significant sales volatility.

Where sales tax is applicable, the appropriate sales tax value relating to monthly turnover will be added to the trade receivables balance. Sales tax codes are defined on the Assumptions sheet and the codes in column A next to the turnover amounts on the income statement are used to determine the appropriate rate of sales tax to be used.

The trade receivables calculation will also only include lines that are coded with a sales tax rate code (in the first two characters) and a "C1" at the end of the code. The C1 part of the code refers to credit sales while the inclusion of a C0 code at the end refers to cash sales. Cash sales do not need to be included in the trade receivables calculation and turnover lines with C0 or no code in column A are therefore ignored when calculating trade receivable balances.

Example: If the standard rate sales tax code is V1 and the appropriate turnover line needs to be included in the calculation of trade receivables, the code V1C1 needs to be added in column A of the appropriate turnover line on the income statement. If you do not want to add sales tax in the trade receivables calculation but you do want a trade receivables line to be included in the balance sheet, you can add a code which refers to a 0% sales tax calculation as well as the C1 credit sales indicator.

Example: If you do not want a particular turnover line to be included in the trade receivables calculation, you can include any sales tax rate followed by C0 in order to exclude the line in the trade receivables calculations. For example, a turnover line with a code of V1C0 would not form part of the trade receivables calculations.

Note: If your business has no trade receivables, you can simply enter a nil value in the debtors days assumption on the Assumptions sheet. The trade receivables line on the balance sheet will then also contain nil values.

If you want to include variable monthly debtors days, you can do so by changing the debtors days assumption in the Workings section of the balance sheet which has been included below the section with the ratios. Simply replace the formula which links the debtors days assumption to the value on the Assumptions sheet by overwriting it with the appropriate debtors days value.

The year 2 to 5 trade receivables balances are calculated by applying the annual turnover growth percentage to the trade receivables balance at the end of year 1. This method ensures that the monthly trend in year 1 is reflected in the year 2 to 5 balances. If you amend the debtors days in the Workings section of the balance sheet, the amended days for the appropriate year will be used in the calculation.

Current Assets - Loans & Advances, Other Receivables

The loans and advances & other receivables balances cannot be calculated by basing them on specific income statement items and they are therefore calculated by adding the movements in these balances (as per the cash flow statement for the first 12 months and the Assumptions sheet for year 2 to 5) to the balances of the previous month. If you therefore want to increase or decrease these balances, you need to add the amount of the increase or decrease to the line with a matching description on the cash flow statement (under the changes in operating assets section) for the first 12 months or the Assumptions sheet for year 2 to 5.

Current Assets - Cash & Cash Equivalents

The cash & cash equivalents balances on the balance sheet are linked to the closing cash balances on the cash flow statement. If the resulting cash & cash equivalents balance has a negative value, it will automatically be included in the bank overdraft line in the Current Liabilities section of the balance sheet.

Equity - Shareholders Contributions, Reserves

The shareholders contributions & reserves balances cannot be calculated by basing them on income statement items and they are therefore calculated by adding the movements in these balances (as per the cash flow statement for the first 12 months and the Assumptions sheet for year 2 to 5) to the balances of the previous month. If you therefore want to increase or decrease these balances, you need to add the amount of the increase or decrease to the line with a matching description on the cash flow statement or Assumptions sheet.

Note: The shareholders contribution line on the cash flow statement can be found under the cash flow from financing activities and the reserves line on the cash flow statement under the non-cash adjustments.

Equity - Retained Earnings

The retained earnings balances on the balance sheet are linked to the retained earnings for the year which is calculated on the income statement.

Non-Current Liabilities - Loans 1 to 3, Leases

The template provides for loans & leases to be included based on 4 different sets of loan repayment terms. Loans with the same repayment terms can be grouped together in the appropriate line item. There is no difference between the treatment of loans 1 to 3 and leases. If you do not have finance leases and have loans with 4 different sets of repayment terms, you can use the Leases sheet and rename the appropriate line items accordingly.

Note: The loan repayment period in years is limited to a maximum period of 30 years. If you want to include a loan repayment period which exceeds this period, you need to change the data validation settings in the appropriate input cell by selecting the data validation feature from the Data tab on the Excel ribbon and editing the maximum value of 30 which has been set in the loan repayment period cells.

Each of the loan repayment terms can be specified in the Loan Terms section on the Assumptions sheet. The loan terms include the annual interest rate, loan repayment period in years and a selection field which can be used to indicate interest-only loans. These loan repayment terms are then included at the top of the appropriate loan amortization sheet on the Loans1 to Loans3 and Leases sheets.

Note: A set of loan terms can be specified as interest-only by selecting the "Yes" option from the interest-only drop-down list in the appropriate loan terms on the Assumptions sheet. If this selection is made, the loan will be interest only and not include any loan repayments.

All the calculations on the amortization sheets are fully automated. The only user input that is required on these sheets is entering the additional loan amounts in column C. The loan terms are taken from the Assumptions sheet and the opening balances in the first row of the amortization table are based on the opening balances that are entered in the balance sheet opening balances section of the Assumptions sheet.

The loan repayments, interest charged and capital repayments are calculated based on the outstanding balances at the beginning of each period. The outstanding loan or lease balances at the end of the appropriate monthly or annual period are then included in the appropriate lines on the balance sheet.

Current Liabilities - Bank Overdraft

The bank overdraft as well as cash & cash equivalents are based on the closing cash balances which are calculated on the cash flow statement. If the appropriate monthly closing balance is negative, the balance is included as a bank overdraft and if it is positive, it is included as cash under current assets on the balance sheet.

Current Liabilities - Trade Payables

The trade payables balances on the balance sheet are calculated based on the creditors days assumption which is specified on the Assumptions sheet. The number of days that are included here can be determined based on the average trading terms which has been negotiated with suppliers.

The monthly cost of sales, operating expenses and staff costs on the income statement are added together in order to determine a monthly value on which the trade payables calculations should be based. Expenses and costs which are paid on a cash basis can be excluded from the trade payables calculation by entering a code which ends in C0 in column A on the income statement. The codes in column A start with the appropriate two character sales tax code and end with the two character payables code.

Example: The expense codes in column A for all line items that need to be included in the trade payables calculation and which need to be subject to sales tax at a standard rate should be V1C1. If the expense item is settled on a cash basis and also subject to the standard sales tax rate, the code in column A should be V1C0 which will then result in the item not being included in the trade payables calculation.

If you want to also include purchases of property, plant & equipment in the trade payables calculation, the standard code of PPE in column A on the cash flow statement needs to be amended to the appropriate code which starts with the sales tax code and ends with C1. For standard sales tax, the code will therefore be V1C1.

Like the calculation of inventory and trade receivables balances, the trade payables balances on the balance sheet are based on the actual number of days in each month if the creditors days assumption is greater than the days in the appropriate month.

Example: If you enter a creditors days assumption of 60 days and the month is April, the entire cost of sales & expense value for April will be included in the trade payables balance because April only has 30 days. After including the 30 days in April, there is a difference of 30 days between the 60 days assumption and the 30 days in April. The March cost of sales & expense balance will therefore be used, divided by the 31 days in March and multiplied by the 30 remaining days. The trade payables balance at the end of April will therefore consist of the cost of sales & expenses total for April and an equivalent of 30 days of the 31 day cost of sales & expense values of March.

Note: The above calculation principle is applied regardless of the number of days which are entered as the creditors days assumption on the Assumptions sheet even if the value of the creditors days assumption requires the inclusion of more than 2 months. This method of calculation is the most accurate way of projecting trade payables balances even for businesses where there is significant sales or expense volatility.

Where sales tax is applicable, the appropriate sales tax value relating to monthly cost of sales & expenses will be added to the trade payables balance. Sales tax codes are defined on the Assumptions sheet and the code in column A next to the cost of sales & expense amounts on the income statement are used to determine the appropriate rate of sales tax to be used.

The trade payables calculation will also only include lines that are coded with a sales tax rate code (in the first two characters) and a "C1" at the end of the code. The C1 part of the code refers to purchases on credit while the inclusion of a C0 code at the end refers to cash purchases. Cash purchases do not need to be included in the trade payables calculation and cost of sales & expense lines with C0 or no code in column A are therefore ignored when calculating trade payables balances.

Example: If the standard rate sales tax code is V1 and the appropriate cost of sales or expense line needs to be included in the calculation of trade payables, the code V1C1 needs to be added in column A of the appropriate line on the income statement. If you do not want to add sales tax in the trade payables calculation but you do want a trade payables line to be included in the balance sheet, you can add a code which refers to a 0% sales tax calculation as well as the C1 credit purchases indicator.

Example: If you do not want a particular cost of sales or expense line to be included in the trade payables calculation, you can include any sales tax rate followed by C0 in order to exclude the line in the trade payables calculations. For example, an expense or cost of sales line item with a code of V1C0 in column A on the income statement would not form part of the trade payables calculations.

Note: If your business has no trade payables, you can simply enter a nil value in the creditors days assumption on the Assumptions sheet. The trade payables line on the balance sheet will then also contain nil values.

If you want to include variable monthly creditors days, you can do so by changing the creditors days assumption in the Workings section of the balance sheet which has been included below the section with the ratios. Simply replace the formula which links the creditors days assumption to the value on the Assumptions sheet by overwriting it with the appropriate creditors days value.

The year 2 to 5 trade payables balances are calculated by applying the annual expense inflation percentage to the trade payables balance at the end of year 1. This method ensures that the monthly trend in year 1 is reflected in the year 2 to 5 balances. If you amend the creditors days in the Workings section of the balance sheet, the amended days for the appropriate year will be used in the calculation.

Current Liabilities - Sales Tax

The template accommodates the inclusion of sales tax in all relevant calculations based on four default sales tax calculation codes and any sales tax period. All income statement and cash flow statement items need to be entered exclusive of any sales tax that may be applicable and the trade receivables and trade payables balances on the balance sheet will be calculated inclusive of sales tax. The net sales tax liability is included in the Sales Tax line on the balance sheet.

The template can be used for general sales tax (GST) and value added tax (VAT) purposes. Where there is no sales tax input which reduces the sales tax liability, the codes in column A on the income statement can simply be changed to contain a sales tax code (in the first two characters of the code) which has a zero percentage. Only the sales tax codes that are included next to the turnover lines will then be included in sales tax calculations (as required by some general sales tax calculations).

The appropriate sales tax percentages can be entered in the Sales Tax section of the Assumptions sheet. The template provides for 4 default sales tax codes, each with its own sales tax percentage. The sales tax codes are numbered from V1 to V4.

The income statement contains codes in column A which affects the calculations of sales tax and trade receivables or trade payables. The first two characters of these codes determine which sales tax percentage is used in the sales tax calculations. If an income statement item needs to be excluded from sales tax calculations, you should use a sales tax code with a zero percentage on the Assumptions sheet.

Note: Each line on the income statement can therefore only be linked to one sales tax percentage. If more than one sales tax percentage needs to be applied to the same income statement item, you need to split the income statement amount into two lines and enter the appropriate sales tax codes in column A for each of the lines.

Note: If you are preparing cash flow projections for a business which is not subject to sales tax, simply enter zero percentages for all four sales tax codes.

The sales tax assumptions that need to be specified on the Assumptions sheet also include the frequency of sales tax payments (in months) and the calendar month of the first payment period. You can therefore calculate sales tax based on any period frequency from one to twelve months.

Example: If your business is subject to sales tax payments of every two months and the first payment is due in February, a frequency of 2 needs to be specified and the first payment month should be set to 2 for February. Similarly, if your business is subject to sales tax payments of every 6 months with payments due in March and August, the frequency should be set to 6 and the first payment month should be set to 3. If your business is subject to monthly sales tax payment periods, the frequency should be 1 and the first payment month should also be 1.

The Current or Subsequent setting in the Sales Tax section on the Assumptions sheet determines how the calculated sales tax amounts of the current period are handled. If you select the Current option, the sales tax amounts of the current period will be included in the calculation of the payment amount which is due in the particular month and the sales tax liability at the end of the payment month will be nil.

If you select the Subsequent setting, the sales tax amount of the current period is not included in the calculation of the payment amount and the sales tax liability at the end of the appropriate payment month will always include at least one month.

Note: The Subsequent setting is usually the appropriate setting to use for sales tax purposes. The Current settings is more applicable to tax types which are subject to provisional tax.

Example: If you set a payment frequency of 1 month, first payment month of 1 and select the Current option, the sales tax liability on the balance sheet will always be nil because the current month's sales tax will be included in the sales tax payment. If you have the same period settings and select the Subsequent option, the sales tax liability on the balance sheet will always include the current month's sales tax because the payment amount will be based on the previous month's sales tax.

Note: The first payment month setting refers to the month of payment and not the sales tax period end. There is a difference - a sales tax period may end in February with payment in March which means that the first payment month of the calendar year is actually January or month 1 (if the payment frequency is two months).

The year 2 to 5 balances for sales tax are calculated by calculating the total sales tax for the appropriate year, dividing it by twelve and then multiplying the value by the number of months that are included in the sales tax balance at the end of the first year.

Current Liabilities - Payroll Accruals

The payroll accrual on the balance sheet is based on the payroll accrual assumptions in the Working Capital section of the Assumptions sheet and the amounts in the staff costs section of the income statement. If payroll deductions are paid in the same month as they are incurred, you can set the payroll accrual percentage to zero and the payroll accrual balances on the balance sheet will also be zero.

Staff costs have been included in a separate section on the income statement to make it easier to calculate payroll accrual balances. You can however include staff costs in operating expenses but you need to ensure that you also include the "PAY" code in column A for all the staff costs that you want to include in the payroll accrual calculations.

You also need to specify the appropriate percentage of staff costs which needs to be included in your payroll accruals. This percentage should be based on the percentage of staff costs which are paid in a subsequent month and is based on the current month's staff costs. Payroll accruals usually consist of salary & wage deductions which need to be paid over to third parties and differ from entity to entity. You therefore need to calculate the appropriate payroll accrual percentage based on the composition of the salary or wage structures of all employees.

The payroll accrual assumptions that need to be specified on the Assumptions sheet also include the frequency of payroll accrual payment periods (in months) and the payment month of the first payroll accrual period. You can therefore calculate payroll accruals based on any payment period frequency from one to twelve months. The calculated payroll accruals are added together in the payroll accrual balance until the month of payment.

Example: If you need to settle payroll accruals every two months and the first payment is due in February, a frequency of 2 needs to be specified and the first payment month should be set to 2 for February. Similarly, if you settle payroll accruals every 6 months with payments due in March and August, the frequency should be set to 6 and the first payment month should be set to 3. If you settle payroll accruals on a monthly basis, the frequency should be 1 and the first payment month should also be 1.

The Current or Subsequent setting in the Payroll Accruals section on the Assumptions sheet determines how the calculated payroll accrual amounts of the current period are handled. If you select the Current option, the payroll accrual amounts of the current period will be included in the calculation of the payment amount which is due in the particular month and the payroll accrual balance at the end of the payment month will be nil.

If you select the Subsequent setting, the payroll accrual amounts of the current period are not included in the calculation of the payment amount and the payroll accrual balances on the balance sheet at the end of the appropriate payment month will always include at least one month.

Note: The Subsequent setting is usually the appropriate setting to use for payroll accrual purposes. The Current setting is more applicable to tax types which are subject to provisional tax payments where payment occurs in the same month as the tax calculation.

Example: If you set a payment frequency of 1 month, first payment month of 1 and select the Current option, the payroll accruals on the balance sheet will always be nil because the current month's payroll accruals will be included in the payment calculation. If you have the same period settings and select the Subsequent option, the payroll accruals on the balance sheet will always include the current month's payroll accrual because the payment amount will be based on the previous month's payroll accrual.

Note: The first payment month setting refers to the month of payment and not the payroll accrual period end. There is a difference - a payroll accrual period may end in February with payment in March which means that the first payment month of the calendar year is actually January or month 1 (if the payment frequency is two months).

If you want to include payroll accruals based on variable monthly payroll accrual percentages, you can do so by changing the payroll accrual percentage assumption in the Workings section of the balance sheet which has been included below the section with the ratios. Simply replace the formula which links the payroll accrual percentage assumption to the value on the Assumptions sheet by overwriting it with the appropriate payment accrual percentage.

The year 2 to 5 payroll accrual balances are calculated by adjusting the previous year's balance by the appropriate expense inflation percentage on the Assumptions sheet.

Current Liabilities - Other Accruals, Other Provisions

The other accrual & other provisions balances cannot be calculated by basing them on specific income statement items and they are therefore calculated by adding the movements in these balances (as per the cash flow statement for the first 12 months and the Assumptions sheet for year 2 to 5) to the balances of the previous period. If you therefore want to increase or decrease these balances, you need to add the amount of the increase or decrease to the line with a matching description on the cash flow statement (under the changes in operating assets section) for the first 12 months or the Assumptions sheet for years 2 to 5.

Current Liabilities - Provision for Taxation

The calculation of income tax on the income statement is based on the profit before tax on the income statement and the assumptions that are specified in the Income Tax section on the Assumptions sheet.

The profit before tax amount is multiplied by the income tax percentage on the Assumptions sheet in order to calculate the monthly or annual income tax value. If there is a loss before tax on the income statement, no income tax will be calculated but if there were profits before the period with the loss, the income tax that was calculated in previous periods will be reversed in the period with the loss.

The template also makes provision for the inclusion of an assessed loss which has been carried over from previous financial periods and income tax will only be calculated after the assessed loss has been fully reduced by profits in the projection periods.

The income tax assumptions on the Assumptions sheet also include the frequency of payment of income tax (in months) and the calendar month of the first income tax payment. You can therefore calculate a provision for income tax based on any payment period frequency from one to twelve months. The calculated income tax amounts are added together in the provision for income tax balance on the balance sheet until the month of payment.

Example: If you need to settle income tax liabilities every six months and the income tax payments are due in February and August of each year, a frequency of 6 needs to be specified and the first calendar month should be set to 2 for February. Similarly, if you settle income tax liabilities at the end of each quarter with payments due in March, June, September and December, the frequency should be set to 3 and the first payment month should also be set to 3. If you need to settle income tax liabilities 9 months after each year-end and the cash flow projection year-end is February, the frequency should be set to 12 months and the first payment month should be set to 11.

The Current or Subsequent setting in the Income Tax section on the Assumptions sheet determines how the income tax amounts of the current period are handled. If you select the Current option, the income tax amounts of the current period will be included in the calculation of the payment amount which is due in the particular month and the provision for income tax balance on the balance sheet at the end of the payment month will be nil.

If you select the Subsequent setting, the income tax amounts of the current period are not included in the calculation of the payment amount and the provision for income tax balance on the balance sheet at the end of the appropriate payment month will always include income tax for at least one month.

Note: The Current setting is usually the appropriate setting to use for income tax purposes if the entity is a provisional taxpayer which effectively means that income tax is paid in advance. If the entity is not a provisional taxpayer, the Subsequent setting should be used because income tax will be settled after being incurred.

The year 2 to 5 balances are calculated by calculating the income tax amount for the appropriate year, dividing it by 12 and multiplying the value by the number of months which needs to be included in the provision. This is determined based on the year-end period and the income tax assumptions on the Assumptions sheet.

Current Liabilities - Dividends Payable

The calculation of dividends on the income statement is based on the profit for the year on the income statement and the assumptions that are specified in the Dividends section on the Assumptions sheet. Dividends will only be calculated if you enter a dividend percentage on the Assumptions sheet - if you therefore do not want to include dividends in your cash flow projections, you can simply enter a zero value as the dividend percentage.

The dividend percentage that is specified on the Assumptions sheet is applied to the profit for the year on the income statement which can be found directly above the dividends line. Dividends will also only be calculated if there is a cumulative profit for the year.

The dividends assumptions on the Assumptions sheet also include the frequency of payment of dividends (in months) and the first calendar month of the dividend payment. You can therefore calculate dividends based on any payment period frequency from one to twelve months (although 6 or 12 months is the norm). The calculated dividends amounts are added together in the dividends payable balance on the balance sheet until the month of payment.

Example: If dividends are declared every six months, you need to specify a frequency of 6 months on the Assumptions sheet and then select the appropriate payment basis. Dividends will be reflected on the income statement every 6 months and the dividends payable balances on the balance sheet will be determined based on the first payment month and the payment option which is selected (Cash, Next or Subsequent). Similarly, if the payment frequency is set to 12 months, dividends will be included on the income statement every 12 months and the dividends payable balance will be determined based on the first payment month and the payment option.

The Cash, Next or Subsequent setting in the Dividends section on the Assumptions sheet determines how the dividends payable balances on the balance sheet are calculated and therefore also when the dividend payment will be included on the cash flow statement.

If you select the Cash option, the dividend payable balances on the balance sheet will always be nil and what this means is that the dividend payment is effectively included in the same month as the month in which the dividend is declared. The month in which the declared dividend is included is based on the payment frequency (in months) and the cash flow projection year-end.

If you select the Next option, the dividend payment will be included in the month after the month in which the dividend amount is included on the income statement. The dividend payable balance on the balance sheet will therefore only contain a balance in the dividend declaration month.

If you select the Subsequent option, dividends will be included on the income statement based on the frequency setting on the Assumptions sheet and the payment of the dividend will be delayed until the first payment month (also as per the Assumptions sheet) is reached. A dividends payable balance will be reflected on the balance sheet in all months until the payment month is reached.

Example: If you set the dividend payment frequency to 12 months, a dividend amount will be included on the income statement in the last month of the appropriate cash flow projection year. If the payment option is set to Cash, no dividend payable amount will be included on the balance sheet and the dividend payment will be included on the cash flow statement in the same month.

Example: If you set the dividend payment frequency to 12 months and the payment option is set to Next, the dividend will be included on the income statement in the last month of the appropriate cash flow projection year, the dividend payable at the end of the financial year will equal the income statement amount and the dividend payment will be included in the first month of the next financial year.

Example: If you set the dividend payment frequency to 12 months and the payment option is set to Subsequent, the dividend will be included on the income statement in the last month of the appropriate cash flow projection year and the dividend payable at the end of the financial year and all subsequent months in the new financial year until the first payment month is reached will equal the income statement amount. The dividend payment will be included in the first payment month as set on the Assumptions sheet but in the year after inclusion on the income statement.

If the cash flow projection year-end as per the above example is February, the first payment month is set to 9 for September and the Subsequent payment option is selected, the dividend will be included in February on the income statement and the same amount will be included as a dividend payable on the balance sheet from February to August of the next financial year. The dividend payment will then be included in September on the cash flow statement and the dividend payable at the end of September will be nil.

The year 2 to 5 balances are calculated based on the profit for the year, the dividend percentage and the payment status of Cash, Next or Subsequent.

Balance Sheet Errors

If the balance sheet for any monthly or annual period does not balance, the amount of the imbalance will be included in the row below the total equities & liabilities and displayed in red. The template has been designed in such a way that the balance sheet should always be in balance as long as the total of the balance sheet opening balances which are included on the Assumptions sheet is nil.

If you see an imbalance on the balance sheet, you therefore need to check the opening balance sheet balances on the Assumptions sheet and ensure that the total of all the opening balances in this section is nil.

If fixing the opening balances does not resolve your imbalance, you can e-mail our Support function and let us know what changes you have made to the formulas in the template so that we can assist you. If you have made a lot of changes, you may need to start over with the downloaded copy of the template.

Balance Sheet Workings

We have included all the calculations which form part of the calculation of balance sheet balances in the Workings section below the balance sheet ratios. These workings will not be printed and are for information purposes only. You can therefore hide this section if you do not want to see it on the sheet but do not delete any of these formulas because it will result in calculation errors if you do!

Cash Flow Statement

All the rows on the cash flow statement which require user input are indicated with yellow highlighting in column A. User input is only required in the monthly columns - the user input for the annual columns need to be included on the Assumptions sheet in the first balance sheet section. All the rows on the cash flow statement which do not contain yellow highlighting contain formulas which automate the calculations of these items.

The input rows on the cash flow statement are all related to balance sheet items where the calculations on the balance sheet are based on adding the movement on the cash flow statement to the previous month's balance on the balance sheet. If you need more guidance on any of these items, refer to the appropriate section for the particular item under the Balance Sheet section of these instructions.

Note: The colour of the codes in column A on the cash flow statement indicate whether positive or negative values need to be entered in order to increase the appropriate balance sheet item's balance. If the code is green, positive input values increase the balance sheet balance and if the code is red, you need to enter negative values in order to increase the balance sheet balances.

Loan Amortization Tables (Loans1 to Loans3 & Leases sheets)

The template makes provision for including loans with up to four different sets of repayment terms in the cash flow projections. The amortization tables that are used to calculate the interest charges, loan repayments and outstanding balances have been included on the Loans1, Loans2, Loans3 and Leases sheets. The only user input that is required on these sheets is the additional loan amounts in column C.

Note: Refer to the instructions in the income statement - interest paid section and the balance sheet - non-current liabilities section for guidance on how these amortization tables have been compiled and where to include user input for each of these amortization tables.

Small Business BC

Resources for entrepreneurs to start and grow successful businesses.

Accédez la page d'accueil dédiée aux ressources en française de SBBC

Utilisez notre outil de traduction pour le site entier

Business Plan Template and Cash Flow Forecasting Tool

Coming up with an idea for a business is only the first step. A well-structured business plan will help communicate what you plan to do, and how you plan to do it. Start by downloading Small Business BC’s Business Plan Template and Cash Flow Forecasting tool.

As part of a healthy and robust business plan, you’ll need to estimate the cash inflow and outflow from your business over time on monthly basis. Small Business BC’s cash flow forecasting tool is the first step to understanding your true businesses viability.

Our Business Plan Template Allows You to:

• Map sales forecasts that consolidate multiple product or service offerings
• Project costs and expenses using common line items
• Coordinate marketing and advertising activities, and
• Determine an optimal amount financing request for your business sustainability

Download our Business Plan Template and Cash Flow Forecasting Tool by completing the form below.

The download link on this page contains Small Business BC’s Business Plan Template as well as our Cash Flow Forecasting Tool .

• Name First Last
• Business Name
• Stage of Business * Pre Start Up Start Up Growing Exiting
• Email * Please enter your email to download our Business Plan Template and receive Small Business BC's newsletter containing news, updates and promotions regarding SBBC's products and services.

Note: you can withdraw your consent at any time - for more information see our Privacy Policy or Contact Us for more details.

• Email This field is for validation purposes and should be left unchanged.

Check out Small Business BC’s Registration Services and Advisory Services and find out how one of our Business Advisors can help you.

Alternatively take a look at our seminars and workshops available in-person at our downtown Vancouver resource centre or via webinar across BC.

• Sign up for eNews to get the latest SBBC updates:
• Your Name * First Last

We respectfully acknowledge our place of work is within the ancestral, traditional and unceded territories of the Xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish) and səl̓ilwətaʔɬ/sel̓ílwitulh (Tsleil-Waututh) and that we serve the Peoples of the many Nations throughout British Columbia.