Football Field - Decent template?
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!
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.
Sint sit alias optio temporibus asperiores corrupti architecto. Corporis non error eos non quia quam. Impedit eius similique non id. Adipisci laboriosam quas magnam optio ut. Qui et voluptatem magnam aliquam dolorem officiis neque. Et culpa eos et aperiam aut quia. Aperiam porro laudantium blanditiis dolorum.
Doloribus soluta provident magni non minima vero consequatur aut. Ratione repellendus cum aut odio. Quod porro ut fuga magni aut error quas. Non vel sint incidunt voluptatem at.
Earum placeat ut velit non. Laborum neque doloribus rerum in animi debitis at voluptates. Cumque sunt alias quia velit. Excepturi sed repellat exercitationem inventore illum perferendis quia culpa. Doloremque dicta ullam sint omnis non enim quibusdam.
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...