Settling a debate - what does your bank use when building out 3 statement models? Vertical (ie 3 statements on 1 tab) or horizontal (3 statements across 3 tabs)? Also, in each of these cases, are inputs and outputs on separate tabs? THANK YOU!
Trending Content - Investment Banking Forum
Career Resources
Vertical. Inputs and outputs are on same sheet. We use summary tabs for beginning of the model though plus for printing
I do 3statements on same tab.
If it’s just a run-if-the-mills financial model then inputs on same tab.. any special chart outputs on separate tab
If it’s a deep dive model that builds to financials through operations, then inputs often not on same tab as the 3 statement
Note that it’s often not the banks decision, it’s often times whoever builds the models decision on how to lay stuff like this out. Sometimes there are templates laid out a certain way but there are times when you won’t touch the template
Vertical models with inputs on a different page typically unless its not going to be seen by investors then inputs on the same page. I prefer horizontal models but doesn't seem like most people do..
Vertical models.
I like to have each line item built up (expenses, revenue build, capex/depreciation, etc.) on individual tabs and feed all of it into a 3 statement model on one tab. Outputs and various return analysis on separate tabs. I also like to do any capital structure adjustment on the three statement tab (more like 4 statements) so that there is not an empty column between historical and projected financials.
I prefer looking @/working with vert.
I like having: - every line as own tab - every year as own workbook - every statement in different folder - then a separate file on my desktop with a bunch of indirects pulling stuff into outputs
the sad part is that FP&A people actually will do that for some reason and then we have to make the interns put it all together to make it look right
Noway they do what is laid out in the comment lol (which amounts to one number per sheet in a massive cluster of worksheets)
I could see someone doing indirects on their desktop though which is just a total disaster lmao
Inputs on 2-3 different tabs, vertical model, and outputs on a separate tab.
Vertical model people: how do you feel about the 2-3 columns of adjustments on the balance sheet that make it hard to have each year on the same column in a 3 statement model?
This is the sole reason I prefer horizontal
Add a few extra columns to do bs adjustments
Add them all into one column, group them together so you can collapse it
Tab 1: Summary tab (w transaction assumptions, summary returns, PF balance sheet, etc.) Tab 2: Model (full three statement with returns calc), vertical style Tab 3: Operating build
Generally all you need. I tend to create additional tabs for outputs / presslinks for presentations.
Obviously, depending on where you are in deal processes, these get much more complex. Deal that we just signed up has the following:
Summary tab Charts output tab S&U tab Historical P&L output tab Model cases P&l output tab LBO Model tab Operating build tab Top customer build tab
and then a few support tabs that are from various VDR files that i used to build the model. This is also fairly simple compared to a few others i've made that had probably 5-8 additional tabs dedicated to operating builds
I do like to have a drivers page on its own tab. Is especially nice when the models get more and more complicated
Models are always better when they’re horizontal
100% horizontal - especially since it’s easier for others to follow once you have more in depth revenue builds, detailed capex, etc. type tabs.
Always used to do like “summary” then “is” “bs” “cf” and then have a “backups ->” tab like “wc” “depr” “amort” “debt” all following.
I think it depends on the model type. I'd never do a horizontal LBO model I don't think
It depends on the level of complexity of the model. I like to keep constant assumptions (same for all years) on a cases tab because I can screw with column widths. I then do a vertical model tab for 3 statements. If there is a complex revenue build, that can go on a separate tab. I do a separate tab for complex ABL availability builds as well. Debt schedule ideally goes on the vertical model tab unless it is too complex. I have the luxury and burden of having complete control over the model, so I can do pretty much whatever I want. I try and make it so everything can be print formatted to avoid having to output tons of stuff to PowerPoint every time I share the model with my boss or management. Lenders and bankers are happy to get in XLS.
Always vertical
We used to do an exec summary/inputs page as the first tab that would have a (very) boiled down 3 statement model on it along with key outputs, the full three statement model on the next tab and then another tab for the three statements individually.
Horizontal models, though could be cause of the sector I cover
Velit quo molestiae cum voluptas. Labore consectetur et dolorem asperiores.
Culpa natus quo eveniet molestiae. Ipsa porro doloribus tenetur optio ab in. Fugit omnis eaque hic in et aut possimus. Facilis dolores placeat voluptatum esse hic cumque. Ut deserunt unde corporis eos accusamus.
Nesciunt ab debitis similique sit voluptatem consequatur modi. Nemo quia officiis est optio adipisci odio. Quidem vitae molestias dicta rerum in. Dolorem nobis et voluptates omnis.
Amet voluptatibus unde labore laudantium explicabo architecto. Unde eos at necessitatibus pariatur fuga. Magni maxime vel deleniti possimus ut.
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...
Ut amet incidunt voluptatem nihil. Provident ipsa fuga magni autem voluptatum molestias rerum qui. Ea velit beatae eaque ut. Laborum labore sit libero quas est.
Iusto officiis voluptates magni modi suscipit. Minus ut aut asperiores consequatur dolorem rerum est. Voluptatem consequuntur corrupti aut rem. Optio excepturi quia eaque vel molestias animi enim. Dolorem quia quidem harum molestiae consequatur eius. Ea dolorem odio placeat expedita veritatis et est nisi. Exercitationem sed est consequatur.
Laboriosam velit magnam repudiandae. Quidem corporis sed consequatur aliquid. Et consequatur qui natus et ut. Vero at aut officia non.