Hello,
Does anyone here have a decent football field template? It would be great if someone could PM a decent template.
I really appreciate it.
Thanks!
| +305 | I Snuck Into UBS Office And Took A Shit On The Floor | 28 | 1d |
| +291 | TPH V.S. Mizuho [HOU] | 36 | 2d |
| +248 | Houston 2026 Oil & Gas Investment Banking Rankings | 61 | 2h |
| +244 | Why leave restructuring for M&A? | 30 | 1d |
| +232 | Best Power/Renewables/Energy Teams? | 39 | 7h |
| +193 | Predicted 1Q 2027 Story - UBS IB blames Outlook Outage for Down Quarter | 36 | 11h |
| +187 | Centerview HC group falling off? | 30 | 1d |
| +184 | Actual EB List | 27 | 1d |
| +180 | Incoming TPH Analysts Larping as PWP on LinkedIn | 26 | 4h |
| +21 | What’s the current state of IBD at BofA? | 26 | 14h |
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.
here is what you do: put all your value ranges in excel and create a chart - tada
Wow, so helpful. Glad you took 2 seconds of your time to waste mine :)
I call it a drive chart. Either way you can make it horizontally or vertically. Do a stacked bar graph and just have the lower section clear so it looks like the bars are floating.
It is used to show valuation ranges. DCF, Comps, etc.
Thanks, I know how to create it, but was hoping someone already had an automated template where even the axiis titles would update with the multiples, etc.
by the time you came on here to ask someone for their template you could have made one. what TNA said is correct
I suppose you could create a macro or something. Maybe build a template a head of time which would be as simple as taking an old drive chart and just putting in place holder figures.
IMO, sometimes it is more work to make simple tasks automated. Also, it leaves you prone to errors as you rely on the automation too much.
Thanks, was hoping someone already had a template so I didn't have to recreate the wheel.
blatantly lazy....if you would've read what ANT suggested and done it yourself you wouldn't have to recreate a fucking wheel. you just don't want to put effort into doing something as simple as a football field yourself.
PM me.
I would feel more comfortable with something I made over something I got via WSO... Just saying.
I would spend more time checking it for errors than it would take me to make my own..
Yeah, not to harp on anyone, but there is no automated template. You just make a simple stacked bar chart. Like if you need to automate that I don't know what to say.
When I was in banking we had a template that was incredibly automated. You input the beginning of the x-axis, the increments, and then the multiple ranges. Could populate the football field in under 60 seconds. I agree that automation is the way to go here, but I also agree that you should just go out and build one or at least ask other analysts at your company. WSO is NOT the best location to go to ask for proprietary files...
Don't waste the man's time:
http://i296.photobucket.com/albums/mm173/sflpic/football_field.jpg
I also don't like how he's kind of being a douche about asking for it.
Iusto sed quia quia facilis. Adipisci repellat ea corporis fugiat enim maiores dicta. Placeat quas voluptas dolores est ab id qui placeat. Maiores ullam maxime tempora dolorum ipsa non sit ipsam.
Qui soluta veniam minus et ut. Et et porro atque dolorem quia suscipit. Dolorem quos deleniti dignissimos unde dolores doloribus qui. Omnis vitae ullam voluptates voluptatibus quidem et. Ab nihil qui alias quis tenetur sit cum voluptas.
Consequatur fugit a non iusto commodi tenetur odio inventore. Hic quis sapiente dolorem qui.
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...