Modeling Quarterly Figures from Full Year Guidance

Hi All, 

As I continue to work on my modeling skills I need some guidance on how I should handle quarterly figures. I recently completed a modeling exam for a boutique ER team. In the test they had me update the first-quarter results and using the full-year guidance update Q2, Q3, and Q4 forecasts. 

Should I be using the historical % of revenue that each quarter represents of the year? 

I haven't found many courses or videos dedicated to quarterly figures, if anyone has a suggestion it would also be appreciated. 

 Thanks 

Comments (7)

Sep 1, 2021 - 9:44am
mutatio192, what's your opinion? Comment below:

Ok but if they provide a guidance range how am I to model the remaining quarters from that guidance, example below.  

"Management expects full year revenue to be in the range of $195M-$205M with operating expenses of $75M-$80M. Management also expects slight pressure on gross margins and expects a 50-100bps drop through 2021 from current levels.

Sep 1, 2021 - 11:30am
mutatio192, what's your opinion? Comment below:

ok, thanks for the response. Seems like it is resonable to take the midpoint of the guidance? 

Aug 31, 2021 - 8:58pm
IPAs and IPOs, what's your opinion? Comment below:

I would say it depends on the industry/company. Many have seasonality as a factor although some significantly more than others. Different revenue/product lines also differ. Without any context can't help a ton, but I would say look historically for any pattern, read through the transcript for any questions on pacing/seasonality etc... keywords like front/backloaded, see how their prior estimates were paced out for the year. Obviously important thing is making sure full year is within guidance unless you want to answer why you think the company is wrong and you are right and you better have a good reason. 

Sep 1, 2021 - 11:33am
mutatio192, what's your opinion? Comment below:

Thanks for the input, the company is Celsius Holdings (CELH). Celsius Holdings, Inc. develops, markets, distributes, and sells functional calorie-burning fitness beverages. I believe a sensitivity analysis of their historical earnings pattern would make sense but please add your input if you agree/disagree. 

Sep 3, 2021 - 3:18am
anon2702, what's your opinion? Comment below:

Repellendus sunt cupiditate omnis rem molestias vel temporibus. Voluptas eos iste reiciendis nisi. At sed sed numquam excepturi est ipsam.

Sint omnis saepe temporibus consequatur aut qui quas corporis. Quas consequatur rerum at minima enim. Sit dignissimos reiciendis beatae reprehenderit.

Ut rerum debitis dolores. Voluptatibus rerum officiis earum et facere nulla consequatur. Nemo vero eligendi omnis quo.

Start Discussion

Career Advancement Opportunities

September 2022 Investment Banking

  • Jefferies & Company (▲05) 99.6%
  • Lincoln International (= =) 99.2%
  • Bank of America Merrill Lynch (▲04) 98.8%
  • Financial Technology Partners (+ +) 98.5%
  • Evercore (▽02) 98.1%

Overall Employee Satisfaction

September 2022 Investment Banking

  • Jefferies & Company (▲12) 99.6%
  • Greenhill (▲07) 99.2%
  • Evercore (▲02) 98.8%
  • PJT Partners (▽02) 98.4%
  • Macquarie Group Limited ABN (▲21) 98.1%

Professional Growth Opportunities

September 2022 Investment Banking

  • Jefferies & Company (▲05) 99.6%
  • Lincoln International (▲03) 99.2%
  • PwC Corporate Finance (▲12) 98.8%
  • Bank of America Merrill Lynch (▲05) 98.5%
  • Houlihan Lokey (▲05) 98.1%

Total Avg Compensation

September 2022 Investment Banking

  • Director/MD (10) $613
  • Vice President (38) $392
  • Associates (209) $257
  • 2nd Year Analyst (130) $163
  • 3rd+ Year Analyst (19) $160
  • 1st Year Analyst (439) $152
  • Intern/Summer Associate (83) $150
  • Intern/Summer Analyst (319) $93