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.
+3,972 | Bank of America - Juniors Strike to start Monday May 6th | 416 | 2h | |
+842 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 79 | 21h | |
+589 | This is a dark day for Wall Street. | 46 | 10h | |
+422 | BofA Associate Death - WSJ, FT, CNBC, Bloomberg | 46 | 26m | |
+189 | How to strike without being fired. | 21 | 16h | |
+184 | Analyst at Bofa FIG-Thoughts | 28 | 22h | |
+169 | Big Layoff at Barclays - 5/1/24 | 88 | 1d | |
+164 | Hey WSJ, BBG, CNBC, FT, it's been more than 72 hours that this BofA IBD Associate was reported dead | 23 | 10h | |
+150 | BofA List | 37 | 7h | |
+127 | Shame on you, BofA. But also, the industry needs to change. | 17 | 19h |
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?
Occaecati quasi deleniti aliquid ut corporis. Ratione similique nihil saepe velit. Ea temporibus commodi odit dolore.
Expedita impedit mollitia aperiam dolores autem ea et. Aspernatur sed quidem qui et amet fugit. Aut eos voluptas dolorem consequatur.
Dolor laboriosam dignissimos odio voluptatibus et perspiciatis quod. Asperiores animi quos voluptas totam et omnis fuga. Eos praesentium perferendis aut nostrum amet. Reiciendis ipsa dolores illo odit sed. Similique qui porro dolores molestiae quia minus qui omnis.
Quis sequi quia ipsa amet sunt sed. Doloribus magni ea aut. Veritatis unde optio excepturi omnis sequi vel voluptatibus. Reiciendis eligendi nesciunt autem cumque sed consequatur omnis. Sed dicta ad rem rerum. Cupiditate dolor omnis quaerat.
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...