Financial projections in a business plan normally start with the sales forecast. Sales refers to the monetary amount from the sale of goods or services in which the business normally trades. This sales forecast spreadsheet will help you to calculate total sales for use in our financial projections template.
![Forecast Forecast](https://image.jimcdn.com/app/cms/image/transf/dimension=723x10000:format=png/path/s2e2ea4a9b3965dd1/image/i3e46399a17779954/version/1408290009/image.png)
Our article on sales projections gives further details of the sales forecasting methods used for a product or service business.
The sales forecast spreadsheet, which is available for download below, helps estimate sales for the next five years. The excel spreadsheet can deal with up to four unit based and four non unit based products or services. Unit prices can be uplifted for each of the five years by a fixed percentage to allow for inflation and price increases.
Using the Sales Forecast Spreadsheet
The spreadsheet is available for download below and is used as follows:
![Forecast Bar 2 2 3 Download Free Forecast Bar 2 2 3 Download Free](https://thumbs.dreamstime.com/z/colorful-rainbow-finance-successful-bar-chart-diagram-d-34463780.jpg)
Forecast Bar 2.9.2 Crack + Activator. Forecast Bar, powered by Forecast.io, offers hyper-accurate, hyper-local live weather and forecasts right in your menu bar.With beautiful background images matching current weather conditions and time of day, along with a simple and clean interface, you will find yourself checking the weather non-stop! Download this app from Microsoft Store for Windows 10, Windows 8.1, Windows 10 Mobile, Windows Phone 8.1, Windows Phone 8, Windows 10 Team (Surface Hub), HoloLens, Xbox One. See screenshots, read the latest customer reviews, and compare ratings for MSN Weather. Forecast Bar 5.2.2 Multilingual macOS 46 mb Forecast Bar offers hyper accurate, hyper local live weather and forecasts right in your menu bar. Forecast Bar for iOS and Watch Also available for Mac and Apple TV. Forecast Bar offers hyper-accurate, hyper-local live weather and forecasts right at your fingertips. With full support for 3D Touch, iPad multitasking, and an automatic dark mode, Forecast Bar is the most modern and last weather app you'll ever need! Learn More Download Now. The final two columns compare the yearly totals for Year 2 vs Year 1 and Year 3 vs Year 2. In a business plan or presentation, you should probably use a chart to help communicate your forecast. We've included a few sample charts, both for the first year's data as well as all 3 years.
Enter units information
Enter the product name and an estimate of the number of units of the product which the business plans to sell for each of the next five years. If you simply want to uplift each year based on the previous year, a formula can be entered into the cell instead of a numeric amount. For example, for Product 1, if you wanted Year 2 (cell E4) to be 5% higher than Year 1 (cell D4), in cell E4 you would enter =D4*105%, and copy this formula across to each cell up to cell H4.Enter the unit price information
Enter the unit price of each product for Year 1, and the uplift percentage required for the following four years.The uplift is the expected percentage change in the unit price of the product over the year, for example, if the unit price for Year 1 is 12.00 and the expected uplift is 2%, then the price in Year 2 would be 12.00 x 102% = 12.24, and the price in Year 3 would be 12.24 x 102% = 12.48 and so on until year 5. If you anticipate the prices falling, then enter a negative percentage.The sales forecast spreadsheet calculates the unit prices, the monetary sales value for each product, and the total product sales for each of the five years.Enter the other sales information
For completeness, the sales forecast spreadsheet allows the sales of up to four non unit based products to be entered. The amount to enter is the total monetary value of each type of sale for each year. This allows a business to enter supplementary sales such as service income, or rental and hire income etc. to establish a complete picture of the total sales of the business for each year.Finally, the sales forecast spreadsheet calculates the total other sales and the total sales of the business for each of the next five years. This sales forecast can now be used as the starting point in our financial projections template.
Sales Forecast Spreadsheet Download
The sales forecast spreadsheet is available for download in Excel format by following the link below.
Notes and major health warnings
Users use this sales forecast spreadsheet at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is a sales forecast excel template that you might use when sales forecasting in Excel. It is purely illustrative of a sales forecasting tool. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the sample sales forecast template, please let us know and we will try to fix it.
Users use this sales forecast spreadsheet at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is a sales forecast excel template that you might use when sales forecasting in Excel. It is purely illustrative of a sales forecasting tool. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the sample sales forecast template, please let us know and we will try to fix it.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a BSc from Loughborough University.
This microsoft® Excel 5 year sales projections template estimates the main financial figures for any company for five years that allows to quickly fill your values to calculate a professional forecast report. The estimation includes shortened cash flow and income statements, and also a balance sheet. This comprises product price in addition to quantity variables to save sales. It is very functional for stock related companies or departments and very significant in inventory and record related business since it lays the establishment for enduring resource planning.
Forecast Bar 2 2 3 Download Free Download
Version: Excel 2010 or later
File Size: 22 KB
File Size: 22 KB
2 Times 2/3
Following is a download link and preview of this free 5 Year Projection Template,