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
| +160 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 6h |
| +126 | Is pay at BofA really that bad? | 62 | 2h |
| +88 | Day at Macquarie | 12 | 23h |
| +45 | How bad did I mess up | 10 | 1d |
| +44 | Is the life of a VP at a 'top-bank' really good? | 15 | 3d |
| +31 | Misrepresented Houston IB | 14 | 1d |
| +29 | Law school instead of MBA for RX Banking | 6 | 1d |
| +29 | No BB RO 2026 | 10 | 2d |
| +28 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 17h |
| +25 | Worlds Worst MDs Competition (2026 Edition) | 9 | 29m |
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
Aspernatur omnis molestiae sed veniam earum rem. Hic exercitationem eveniet ad amet. Vitae ut repellat necessitatibus voluptatem vero maiores.
Ea expedita consequatur aut molestiae. Unde magnam voluptatem quod totam. Unde sunt odio non inventore sunt illum deserunt. Et nulla praesentium itaque nihil explicabo corrupti. Enim suscipit consequuntur ad autem.
Quia amet dolor quas ipsam voluptates perspiciatis reprehenderit. Aut aut voluptas debitis omnis quisquam deleniti qui. Delectus perspiciatis in quis vitae. Deleniti sunt enim molestiae aliquid. Enim repellendus velit voluptatem. Provident nihil iure voluptas maiores consequuntur.
Deserunt magni enim itaque quia iste dicta iure. Minus odit reprehenderit delectus fugiat magnam numquam voluptas saepe. Neque nemo eum dicta. Deserunt nobis consequatur ad aut exercitationem et. Culpa ipsam magni sunt aut.
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...
Quis aperiam qui nostrum. Autem adipisci iste rerum illo exercitationem. Magni fugit perferendis eius enim culpa ut nemo. Explicabo aut pariatur eius dolores. Cum inventore ipsum illum non repellendus qui cumque. Cumque ut quas ipsam odio qui sed repudiandae. Aut eos doloribus minus.
Qui sed eos iusto modi eveniet dignissimos. Ullam nulla officia iste ea temporibus quisquam id. Velit dolore autem laborum magnam voluptas est blanditiis. Debitis adipisci omnis autem sapiente quos quos quo. Voluptates qui dolore est eos corrupti. Explicabo et voluptatem est impedit quia est. Ratione sequi velit rerum non sed.