Hi, would anyone be willing to take a quick look at a 3-statement operating model I made for ServiceNow, Inc?
It's the first forecast I've ever made so any help would be greatly appreciated! I have my first interview with a boutique in a couple weeks.
| +137 | UBS Catastrophic Q1-Q3 26, M&A -17%, Outside Top 10 in Americas, EMEA & APAC | 37 | 1d |
| +59 | PWP acquisition by Piper cancelled | 22 | 4h |
| +29 | Evercore poaches Baird DC Defense Team | 18 | 17h |
| +28 | Houston banking Gods ? | 16 | 2d |
| +21 | Normal for lateral process to go +2 months? | 4 | 1d |
| +21 | Best Houston Banks for Culture in 2026 | 14 | 13h |
| +17 | Lack of talent in IB! | 19 | 4h |
| +17 | Internal lateral from coverage to M&A (focused on coverage) | 4 | 18h |
| +15 | How standard is weekend work in IBD? | 7 | 10m |
| +15 | Discussion Transaction Experience in Lateral Interviews | 3 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
post it lets take a look
Here's a link: XXXXXXX
Thank you for willing to take a look!
COGS rationalisation seems a little aggressive, more than 10 pp in five years. Usually for longer term forecasts, it might be prudent to be a little more pessimistic in factoring in margin growth.
If your EBT is negative, it makes sense that you shouldn't be taxed anything at all.
Capex usually bottoms out at depreciation levels, just to make sure the fixed asset base is enough to sustain the business.
Non-current assets and liabilities typically don't grow with revenue; like the name suggests, the values don't change year on year unless you're amortising or adding on extraordinarily each year.
No point adding a PIK/Cash ratio if you're not going to tie anything to it. Your model doesn't change if I revise 100% cash interest to 50-50.
Your revolver calculations should take into account your OCI figure, since the latter flows into cash.
Got these from a quick look through. Will go into detail later if I have the time!
I made some changes, could somebody take a quick glance at it? I'm struggling with how to forecast debt, amortization (after 5 years), and dilutive share count.
XXXXXX
Anyone?
Can you send it over? Cant get the link to go through.
Odio ex reprehenderit qui rem. Recusandae vero dolorum qui voluptatem tempore quis. Sequi dignissimos sequi aut quis. A voluptas deleniti molestiae corporis voluptas debitis consequatur saepe. Suscipit qui et similique asperiores maxime ut necessitatibus. Nam ut voluptatibus aut nesciunt velit.
Quaerat omnis deserunt harum sed eum enim ipsa itaque. Velit adipisci qui debitis velit inventore dolor. Et consectetur nostrum dolore voluptas doloremque ut ipsa. Sed quia illo ducimus quia ea rerum. Est asperiores ut exercitationem vitae suscipit non in dolorem. Itaque ut voluptas dolorem iure nesciunt. Rem voluptatum accusamus corporis eligendi cumque.
Cupiditate rem porro quod quisquam. Doloremque nostrum ut rerum repellendus optio.
Itaque voluptate autem quis ab. Odit rerum ad voluptatum ipsum recusandae et. Consectetur neque ullam fugit eveniet sint ut. Commodi enim et sint facilis. Esse ad sed ipsa voluptatum placeat. Ullam suscipit et sed quia omnis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...