Football Field - Decent template?

here is what you do: put all your value ranges in excel and create a chart - tada

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.

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.

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.