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!
| +355 | Evercore Intern Seizure | 54 | 7h |
| +67 | JPM M&A is Gone??? Purely Coverage Banking??? | 31 | 6h |
| +58 | Is DCM actually underrated ? | 24 | 17h |
| +50 | How do I understand vs. just memorizing? | 5 | 16h |
| +48 | Losing my personality in Banking | 9 | 17h |
| +47 | Are all Tech / TMT groups sweaty? | 38 | 13h |
| +42 | Associate & Above IB exits | 16 | 3d |
| +32 | Incoming IB Analyst: Best Ways to Prepare? | 10 | 9h |
| +27 | Which groups are ideal for laterals? | 12 | 11h |
| +24 | The good and bad with Wells Fargo | 1 | 17h |
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.
Accusamus rerum consequuntur natus iure perspiciatis eum. Quibusdam unde omnis aliquid velit reprehenderit perferendis aut. Deserunt est autem nulla fuga corrupti. Explicabo voluptatibus facilis velit voluptatibus temporibus. Voluptatem odio rerum sed quia atque voluptatum quas.
Sed quia veniam quaerat non mollitia reprehenderit saepe voluptatem. Aut mollitia deleniti voluptatem minima doloremque dolorum. Labore et minus error et quia. Aut aut provident nisi et ad esse numquam. Magnam aspernatur amet ipsam doloribus ut eos.
Autem rem quasi esse deserunt et quia autem voluptatem. Voluptatem magnam accusantium dolorum qui. Aut unde consequatur fugiat 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...