DCF Valuation of an Investment Banker’s Life
By BankersBall on Oct 29, 2007 in Cube Life, Emails & Diversions, Excel
A UK reader forwards us “Project: Get a Life — Intrinsic Valuation of a Banker’s Life” — a DCF valuation. Enjoy!
Here’s the file. The file is saying the creator was someone from Credit Suisse, although that could have been changed along the way. A snippet below:
On Oct 30, 2007, Anonymous said:
Pure Genius
On Oct 31, 2007, VB said:
BTW, there is an error in the row Assumptions!48: in the first component $F$10 and $F$9 must be switched.
Anyway, the model is amazing =)
On Oct 31, 2007, Anonymous said:
Great stuff…only problem is BankersBall said CS, when the spreasheet has ML written all over it (literally). Doesnt matter one bit though. Bravo creator.
Bravo.
On Nov 1, 2007, hk said:
some more problems with this model, which is quite clearly a ML piece of junk (look at the bull). the terminal value assumes perpetuity growth which is clearly not the case, and an exit multiple. funny, i didn’t think bankers were for sale.
On Nov 1, 2007, BankersBall said:
um, yeah, saw the bull but the doc properties said CS buddies.
On Nov 2, 2007, John GS said:
You really are all stupid guys. Wondering if it is ML or CS…pathetic. HK, you idiot, bankers are for sale. Why do you think bankers move from simple banking institutions to GS? For the love of Mr. Goldman? Money, men, that’s all it is.
On Nov 3, 2007, damn said:
that is very entertainingly well done
On Feb 13, 2008, Amyq. said:
Hilarious
On Aug 28, 2008, erasmus said:
Awesome work…but disagree with terminal value assumptions which lead to large TV
On Dec 29, 2008, San said:
“$ in millions”?
More like “thousands”