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 

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 (10)

Sep 1, 2021 - 9:44am

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 - 10:25am

So if you have 1Q completed, then what you have left is FY - 1Q = 2Q + 3Q + 4Q. So the forecasts for the next quarters should take out the results from 1Q and keep doing the seasonality approach for 2/3/4Q. If revenue was $30m in 1Q, and guidance is still $195-$205m, then there's $170m over 3 quarters left ($200m-$30m = 2Q + 3Q + 4Q).

Aug 31, 2021 - 8:58pm

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

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. 

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Sep 3, 2021 - 3:18am

Dolores ducimus iure ullam maxime illo. Voluptatum reiciendis ut molestiae unde aut sit iure recusandae.

Ea autem doloribus sed dolor rerum libero. Doloremque temporibus consectetur animi iusto. Est et nulla ut praesentium suscipit. Consequuntur libero porro illo dolore harum accusamus eos. Assumenda dolorum mollitia quis similique praesentium provident.

Veritatis est at cupiditate nobis aut id. Temporibus ipsam soluta dolorem. Reiciendis molestiae debitis optio necessitatibus voluptatem repudiandae. Dolorum iste temporibus et quia praesentium.

Start Discussion

Popular Content See all

Investment Banking is Paradise
+276IBby Partner in PE - LBOs
Public banging
+183OFFby Intern in PE - LBOs
Oncycle is a fucking joke
+167PEby Analyst 2 in IB - Cov
MD’s Daughter/Son has student loans?
+115REby Analyst 1 in RE - Comm
How often do you get "matches" on apps?
+113OFFby Associate 1 in AM - Other
Dating smart girls
+99OFFby Analyst 2 in Consulting
Who manages your money?
+96INVby TechnoPanther

Total Avg Compensation

September 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (38) $367
  • Associates (218) $232
  • 2nd Year Analyst (132) $153
  • 3rd+ Year Analyst (30) $147
  • Intern/Summer Associate (102) $144
  • 1st Year Analyst (483) $135
  • Intern/Summer Analyst (375) $82