Exel dcf
can someone look over my simplified dcf file? i think the discounted TV is wrong.
can someone look over my simplified dcf file? i think the discounted TV is wrong.
+166 | How to stop feeling like shit for not making it in IB? | 63 | 26m | |
+121 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 7h | |
+85 | Updated LA Banking Scene (2024) | 61 | 3h | |
+40 | Ranking banks that went under | 24 | 4h | |
+38 | Burnt Out M&A ASO | 20 | 4h | |
+36 | Relevance of A-Levels for U.K. London recruiting | 25 | 1h | |
+33 | A strategy for SA applicants late to the game like myself | 17 | 1h | |
+27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
+27 | Intern Ettiquette | 4 | 1d | |
+23 | What are hours like at BBs in London? | 47 | 1d |
Career Resources
there's a few things wrong there. 1) tax row 9 is referenced to a rate in $C$9. Change it to $B$8 2) Cell B32 references E26 while B33 references H26. You won't get an error while E26 and H26 are the same but it will if you change them. Better to incorporate a separate perpetuity growth rate. 3) Cell B35 only discounts the TV back one year. You need to bring it back to today so change the formula in the cell to =B34/((1+D17)^5) 4) Cell B38 references to the undiscounted TV. Change the formula to =D19+B35 5) Change cell D23 to units rather than dollars.
Making these changes gets you the right Enterprise Value ($525), Equity Value ($426) and per share valuation ($1.42).
ok i looked it over. thanks for being meticulous. 1) should be anchored to B9 rather than B8.
did I just do your homework for you?
no, it was from the Training the Street training. i'm learning the concepts...
i will look at the model sometime later today. thanks in advance.
...so I did do your homework......grrrrrr.....
I don't see why people take those classes, just get some books on DCF and whatever other model you want to learn and do that. Their really not that hard to learn with some effort.
but for anybody else contemplating blowing $200 (or more) on some pa (personal account) training, do yourself a favour and use this website instead.
http://pages.stern.nyu.edu/~adamodar/
Then buy this book (I'm sure you'll be able to find it cheaper) and read it. http://www.amazon.com/Investment-Valuation-2nd-University-Set/dp/047128…
If that's too much for you to spend, download it here. Then consider a donation to charity once you have a paying job. http://pages.stern.nyu.edu/~adamodar/New_Home_Page/valn2ed/book.htm
good reference links.
i just think it is a bad return on time. e-TTS is concise and clearer. however, it does not expand on some concepts such as APV, Excel modelling....
While I understand that reading a book can help me learning modeling/financial analysis, do you believe that a Training-the-Street program holds more "brand recognition" with banks (if looking for an analyst role) and the interative e-learning programs are better and worth the $200 investment?
i did not invest 200 into this TTS. it is etraining for Citi employees.
I am CFA L2 candidate so most of this stuff is review. There is no "brand" recognition.
Reading the book and understanding the concepts will take longer and will be harder work but speaks volumes about your commitment. With a book, you force yourself to understand what is going on before you are able to move onto the next stage. If you don't then you it becomes gibberish and you stop reading.
Why was I able to take the model apart in a couple of minutes? It's because I fully understand the concepts, the structure, the inputs and the outputs. It's the whole teach a man to fish rather than giving him a fish argument.
What does having "completed Training the Street program" say about you on your CV? To me it says "doesn't think his/her background stacks up and has done this to compensate" (and has $200 to spare). The financial markets don't like desperate and needy.
On the other hand, saying "Because I do not have a background in finance, I have studied Domodaran in my spare time to become fully conversant with valuation methodologies" would interest me - it says self-starter and motivated. As long as the rest of your CV stacked up, I'd get you in for an interview. Of course, you'd then have to be able to back up this claim.
As for brand recognition, Damodaran is the daddy.
i'm curious why your handle is John Mack? Why not Stan Oneal or Charles Prince?
Vel quia excepturi beatae recusandae voluptates. Veniam rerum ducimus a quo et. Dolores non eum eum sequi fugiat asperiores quae.
Rerum aperiam illo fuga vel voluptas earum ullam. Nihil reiciendis nulla dolorem est laudantium assumenda. Ut et nobis nihil sit fuga.
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...