Up Your Cash Flow Budgeting & cash flow forecasting software
Phone number 310-387-5403 Pacific
  • Home
  • Products
    • Up Your Cash Flow >
      • Product Features
      • Benefits
      • Sample Reports
    • Advisor Services
    • Free-Books To Download
  • Store
  • Support
    • Update Your File
    • How The Program Works
    • Benefits
    • Help Files
    • FAQ's
    • Contact Us
  • Company
    • About Us
    • Contact Us
    • Testimonials
    • Blog
  • Articles
    • Making More Money Helping Your Clients
    • Let's Begin The Forecasting Process
    • The Profit And Loss Forecast-Step 1
    • The Profit And Loss Forecast-Step 2
    • The Profit And Loss Forecast-Step 3
    • AP-AR Turnover Ratio
    • Inventory Turnover Ratio
    • Net Income To Net Sales Ratio
    • Net Income To Equity Ratio
    • Debt To Equity Ratio
    • Why Plan
    • Tough Blog
    • Importance Of The Balance Sheet
    • Business Financial planning A must
  • Blog
  • Business Planning Series
    • 1. Whose Business Is It, Anyway?
    • 2. How to Identify and Monitor the Key Financial Elements of Your Company
    • 3. Kill The Budget
    • 4. How to Foresee And Predict Your Financial Future
    • 5. The Dynamic Financial Planning Process
    • 6. Developing The Forecast
    • 7. Expenses
    • 8. The Cash Flow Forecast
    • 9. What Do You Do with Your Forecast Now That You Have One?
    • 10. In Summary
    • 11. What Do All the Numbers
    • 12. The Business Plan: We Must Plan For The Future
    • 13. Personal Planning Is a Must
    • 14. A Matter Of Minutes >
      • 15. A Final Word
  • Advisor Services
  • Special ADP Video On Planning
  • Library

The Profit And Loss Forecast - Step 1

Sales Forecast

The first step in the process is the sales forecast. Ideally, you should confer with customers, sales managers, and/or sales representatives to project the next years expected sales. Many owner-managers find the process of securing the input from others to be rather time-consuming, cumbersome, and of little accuracy. Here are two methods to help you predict the next year’s sales:

Method 1:Take the previous year’s sales dollar volume and add to it the current year’s expected price increases and anticipated volume increases. I call this a reasonable guess. 

 

 

Example:

 

 

 

 

 

 

 

Previous year’s sales

  1,580,000

 

 

Estimated price increases at  7½ %

          118,500

 

 

 

  1,698,500

 

 

Volume increased at 10 %

            169,850

 

 

 

 

 

 

Expected sales

    1,868,350

 

 

 

 

 

 

Use (rounded)

   1,870,000

 

 

 

 

 

Method 2:A more precise method in computing sales dollar volume is to begin with the number of units of product to be sold during the year. Convert units sold to a dollar value. If youcompute sales by product, it will be far more accurate than a reasonable guess.

The biggest problem here is figuring out the number of units to be sold for any product. The best way to do this would be by reviewing history, and then adding or subtracting units depending on your view of the coming twelve months. Include sales people in the process. 

 

 

Example:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Unit Sales
Previous year

 

This year
Increase

Total
Units

Unit**
Price

Total

 

 

 

Product A

 

50,000

 

10,000

 

60,000

 

11.50

 

   690,000

 

 

Product B

35,000

2,000

37,000

20.00

740,000

 

 

Product C

100,000

17,000

117,000

3.75

       438,750

 

 

 

 

 

 

 

 

 

 

Expected sales

 

 

 

 

  1,868,750

 

 

 

 

 

 

 

 

 

 

Use (rounded)

 

 

 

 

  1,870,000

 

 

 

 

 

 

 

 

 

Method 3:My favorite method is to forecast sales by customer. This is similar to Method 1, except it will be more precise due to developing data in greater detail (by customer). This method works best if you have a small number of customers that make up a substantial percent of the company’s sales. If you are able to do this, it may be the most accurate method of them all.

In practice, review the history of each customer and then add or subtract any changes expected for the coming twelve months. Again, include sales people in the process. 

 

 

Example:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sales
Previous year

 

This year
increase

Total
Units

 

Total

 

 

 

Customer A

 

500,000

 

100,000

 

600,000

 

 

   600,000

 

 

Customer B

350,000

20,000

370,000

 

370,000

 

 

Customer C

1,000,000

170,000

1,170,000

 

      1,170,000

 

 

 

 

 

 

 

 

 

 

Expected sales

 

 

 

 

  2,140,000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Source: Harvey A. Goldstein, CPA , Granville Publications

Copyright GoHagIt,Inc, Granville Software 2015,2016

Cash Flow Forecasting Software
| Business Budgeting Software | Business Budget Forecasting | Budgeting and Forecasting Software
 Financial Budgeting Software |  Business Budgeting | Cash Flow Analysis

.