Stubbed Operating Model Test Question - how to forecast

Case study — I have Q1 2026 financials given and FY25. I wonder if I can just forecast the future financials based on the past FYE fiscal year (or add a column reflecting LTM then do 2026A forecast/use Q1 financials to forecast rest of 2026A). But when it comes to DCF/LBO, I stub them? Or I should also stub the three statement operating model (how to? Assuming just use 1-stub on all line items?) 

6 Comments
 

When dealing with a stub period in an operating model, here's how you can approach it based on the most helpful WSO content:

  1. Forecasting Future Financials:

    • If you have Q1 2026 financials and FY25 data, you can calculate the Last Twelve Months (LTM) as of Q1 2026 by combining FY25 data with Q1 2026 and subtracting Q1 2025. This gives you a more accurate trailing view.
    • Use the LTM data or Q1 2026 financials to project the rest of 2026. For example, you can annualize Q1 2026 figures (multiply by 4) but adjust for seasonality or known trends.
  2. Stub Period in DCF/LBO Models:

    • For DCF or LBO models, stub periods are common when the forecast period doesn't align perfectly with the fiscal year. You would typically prorate the financials for the stub period (e.g., Q1 2026) and then forecast the remaining quarters separately.
    • In a DCF, this means adjusting your cash flow projections for the stub period and discounting them accordingly.
  3. Stub Period in a Three-Statement Operating Model:

    • Yes, you should stub the three-statement model as well. To do this:
      • Use the Q1 2026 actuals as the starting point.
      • Forecast the remaining quarters of 2026 based on historical trends, seasonality, or management guidance.
      • For each line item, prorate or adjust based on the stub period (e.g., if Q1 is 25% of the year, forecast the remaining 75% for the rest of the year).
  4. Practical Tips:

    • Ensure all line items in the income statement, balance sheet, and cash flow statement are consistent with the stub period adjustments.
    • For example, if you're forecasting revenue, ensure that COGS, operating expenses, and working capital items are adjusted proportionally.
    • Maintain logical flow and consistency across the three statements to ensure they balance.

By following these steps, you can effectively handle stub periods in both operating models and valuation models like DCF or LBO.

Sources: DCF Modeling Course ~ Pre-training text.pdf, FP&A planing foreacasting and budgeting process? please help, Structuring and Flow in an M&A Model

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Not just I totally get your question . In terms of forecasting, just do FY25 divided by 4 to roughly check what Q1 was so you can have a rough performance (obviously caveat of seasonalities) YOY, and use that on your FY25 numbers to forecast F26

The stub is just for the date of your valuation / entry. Is it 31st March entry? Either way, build the full year statement and then in your cash flows you just stub what you need (eg take 75% of the full year FCFE and add it to your entry cash overfunding the S&U). Am I missing anything or what’s your question specifically? 

 

Associate 1 in PE - LBOs

Not just I totally get your question . In terms of forecasting, just do FY25 divided by 4 to roughly check what Q1 was so you can have a rough performance (obviously caveat of seasonalities) YOY, and use that on your FY25 numbers to forecast F26

The stub is just for the date of your valuation / entry. Is it 31st March entry? Either way, build the full year statement and then in your cash flows you just stub what you need (eg take 75% of the full year FCFE and add it to your entry cash overfunding the S&U). Am I missing anything or what’s your question specifically? 

Thank you — was wondering if I need to stub the operating modeling for the line items across the three statements (feel like a lot of work to flow the stub thru), or I only need to factor in stubbing when it comes to doing the DCF cash flow and LBO (I.e forecast operating modeling based on FY25 figures but keep a column of LTMQ1 26) 


Was also quite wondering how to stub LBO when it comes to debt schedule, BS, and return analysis as well. 

 
Most Helpful

I am not sure I get your concept of stub 


You don’t need LTM figures other than to compute the entry valuation and sources and uses. Other than that The logic is that you can collect cash flows only for your ownership period. So if you assume march 31 entry, you are “entitled” to the cash generation until the end of the year So 75%. You need to build your statements for the entire year and up to any cash flows for debt repayment it doesn’t make a difference. You then. Assume you enter in March and will reset the cap structure to the deal cap structure. Now, if you have 100 of debt and 20 of cash as of entry, and you generate 30 of cash during the full year, the logic is that you can only use 75%* 30 to either pay down debt or add it to your cash balance. You shouldn’t stub the statements per se. Your IS doesn’t change (there’s some technicalities eg if the company has some debt you have the interest of the pre deal debt, and 75% of the full year interest of the new debt but this stuff doesn’t move the needle, I wouldn’t get bogged down for a case study)


As for the BS. I don’t know what the ask if but the way you should do it is just that you have a BS PF for the deal with the new cap structure etc (do you even have a full BS do? You just need some key lines). You have to imagine that’s the company BS as of 31st March 


Then for your Dec26 BS the cap structure side you will have the changed based on the stub cash generation described above. The easiest way to think about it is just to think from the company perspective

sorry for typos or broken English I’m in a rush

 

Ullam consequuntur harum pariatur eum et et doloremque. In magni eum optio. Iusto tenetur molestiae impedit porro sapiente cumque qui.

Tempore dolorum voluptatem enim beatae sit accusantium. Veniam similique ullam minus possimus tempora quam omnis ea. Eaque culpa assumenda voluptate omnis. Pariatur rerum saepe eveniet repudiandae aut modi laboriosam iusto.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • Intern/Summer Analyst (72) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
Betsy Massar's picture
Betsy Massar
98.9
8
DrApeman's picture
DrApeman
98.9
9
CompBanker's picture
CompBanker
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”