So I just came across this free iPad app called uValue. Its created by a couple of professors at Stern and Dartmouth Business School and is essentially a skinned spreadsheet which values companies. It can do(detailed and simple), APV (detailed and simple), dividend growth and even value options. All junior bankers are now irrelevant.
On a more serious and useful note, I've played around with it and it's a pretty good learning / quick valuation tool. You get little tutorials on how each valuation process works and it explains each of the inputs required, and then even shows the model and how it got to the implied Enterprise Value or Share Value. Also gives some 'Data Guidance' sheets which give industry averages for risk-free rates and cost of equity which could be useful for reference!
Seems useful if someone wants to know if a company is over/undervalued by fundamentals or what share price they should be looking at or even just to sense check a model output.