Sales Forecast Template

A sales forecast is the starting point for every other financial projection. This template forecasts units and revenue by product or service for 12 months, using a starting volume and monthly growth rate for each line.

Preview of the Sales Forecast Template

Free download. No sign-up, no email.

Download Excel (.xlsx)7 KB
  • Formulas built in, just fill the yellow cells
  • Works in Excel, Google Sheets and LibreOffice
  • Example numbers show how it works

Who this template is for

  • Startups building projections
  • Businesses planning inventory and hiring
  • Sales managers setting targets

How to fill it in

  1. List up to five products or services.
  2. Enter price and starting monthly units.
  3. Set a monthly growth rate for each.
  4. Review monthly and annual revenue.
  5. Carry totals into your financial projections.

What is inside

  • Sheet: Sales Forecast
  • Product or service
  • Product A
  • Product B
  • Service C
  • Product D
  • Product E
  • Units sold
  • Total
  • Revenue

Writing a full business plan?

Browse 39 free sample plans by industry, each with startup costs and projections.

See sample plans

Frequently asked questions

How do you forecast sales for a new business?

Start with a realistic number of customers you can reach, a conversion rate and average sale, then grow it month by month. Base it on research, such as competitor data or pre-sales.

Should my forecast be conservative?

Yes. Many advisors suggest building a realistic case plus a lower case to show you can survive slower sales.

Is this sales forecast template free to use?

Yes. Download it, edit it and use it for your own business at no cost. No account or email address is required.

Related templates

Excel

Personal Financial Statement Template

Your personal assets and debts for a lender.

Excel

Business Loan Payment Calculator

Monthly payment and amortization schedule.

Excel

Pricing Calculator Template

Set prices from cost and target margin.

Word & PDF

Simple Business Plan Template

A short plan for small and local businesses.