How to forecast next month sales given current month revenue / volume data?

I have an entire month's worth of revenue and volume data. I can sort all of the data daily by product and channel (online vs. retail). What's the best way to use this to forecast subsequent month data? I feel like applying a standard m-m growth % is not the most effective way. Should I be looking at current month's week-over-week revenue and volume growth and apply similarly for future month?

I feel like it's simple, but I'm confusing myself over the complexity of how to do it.

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (6)

May 3, 2021 - 10:20pm

Could you provide the following 2 pieces of info:

Industry

Which Month you have and which month you are trying to forecast

I'm only asking this because the one thing I would worry about is some cyclical/seasonal pattern to the revenue depending on the industry/month (example trying to use retail December sales to forecast  retail January)

Array

May 4, 2021 - 2:18am

Industry: retail.

January sales provided -> required to forecast for February. For Jan, there are daily sales data provided with product launches, pricing changes, etc. throughout the month. The prompt is to use that data (and not to assume any other additional changes besides those factors) to forecast next month's sales.

Start Discussion

Total Avg Compensation

May 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (35) $364
  • Associates (194) $234
  • 2nd Year Analyst (110) $151
  • Intern/Summer Associate (96) $145
  • 3rd+ Year Analyst (26) $145
  • 1st Year Analyst (402) $131
  • Intern/Summer Analyst (327) $82