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!
| +217 | Downfall of Qatalyst | 42 | 3h |
| +167 | UBS IB 26Q2 a Disaster! Advisory Revenue Down 23%, Capital MarketsDown 5% | 22 | 3d |
| +111 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 7h |
| +81 | Lincoln International Return Offers | 42 | 1d |
| +52 | so confused about 28 SA timeline | 27 | 5d |
| +44 | London IB BB is a challenge | 29 | 7h |
| +37 | momentum of Rx groups | 11 | 1d |
| +36 | Fired during interview | 6 | 11h |
| +33 | [WSO MODS] Please Delete This BS Host Books Spam! | 2 | 5d |
| +27 | VP Lifestyle at Top BB Coverage Groups | 13 | 3h |
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.
Nisi sint libero sint esse aperiam cupiditate ut. Aliquid libero illo sequi cupiditate. Necessitatibus reiciendis fuga aperiam repellendus vel vel repellat aspernatur. Odit voluptates alias optio enim.
Et dolorem qui fuga accusantium sed culpa. Sed minima facilis incidunt quibusdam facere perspiciatis dolore. Ab beatae fugiat consectetur nihil aut et. Delectus sint non exercitationem quod alias veritatis eligendi. Ut labore dolor est ratione. Error quaerat exercitationem expedita quia ullam.
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...