The second part of my valuation series is about one of the methods under the income approach, the discounted cash flow method. In this post, I will be showing you how to create a model from scratch. This model is not meant to teach you any in-depth theory on why certain decisions are made within the DCF, but rather just give a basic understanding of all the moving parts. I also suggest you use this time to use some techniques learned in my “Stop Using Your Mouse” post.
Follow the instructions on the “Instructions” tab while building in the “Build Here” tab. I have preset the layout of the model and some of the preliminary numbers. Your job will be to take the model from 2013 through the terminal year.
This is a basic model. I realize for many of you this is extremely easy. However, some monkeys, young or old, can use this to sharpen their skillset prior to entering a BB. The ability to build this and feel comfortable moving around in the model will be very helpful in your career.
In future posts, I will go more in-depth on the actual theory behind certain variables in the model, as well as take a peek at different ways to come up with a WACC.
If anyone notices any errors in the model, please note in a comment! Thanks monkeys.
Also, if anyone has any helpful tips to add or questions, please leave a comment.
Keep them coming, this is great. Nice rudimentary model, but still comprehensive (if that makes sense).
Awesome way for an inexperienced Monkey like myself to start learning these things.
Agreed. This is great, especially when used along with IB by Rosenbaum and Pearl.
are you creating these from scratch?
Very nice - how do I post an attachment in a response? I have a little 3 statement model I could put up.
Curious if you'll be doing an integrated IS/BS/CF model, always like to see how others do it, and/or a quick and dirty LBO.
I am not sure how to add attachments. I can definetely show a three statement model, I unfortunately have not had a ton of time to go in-depth with these models due to work. More in-depth in the future though.
I could also do an LBO, but I do not use LBO's professionally, so may not be the best person to speak about them.
This is excellent work. Keep it up. Out of interest what is your background? Excuse my ignorance, but what would this be acceptable as a professional DCF in the workplace?
Looking forward to your future posts on WACC, integrated IS/BS/CF model, and LBOs... also if you have a chance please do a NAV if you know how.
Top work!
I did a post on the asset approach already. Check it out!
this is EXCELLENT.
Thanks a lot - this really helped. When would a DCF analysis be most applicable.? In other words, is there a "right situation" to use a DCF vs another valuation technique?
The asset approach would usually represent a floor value, because it allocates no value to the ongoing business. The market approach is applicable if you have representative guideline companies or transactions. DCF is great to use if you are able to come up with projections of your future operating levels.
awesome. thank you.
.
cheers, good work on the asset model but I was more thinking of NAV resource based to do with oil and gas/ mining. Also would this be acceptable as a professional DCF in the workplace?
Quick (and potentially stupid) question - how did you arrive at the long term growth rate in the terminal year?
The long-term growth rate is usually estimated as part of another separate analysis - one could use regression analysis for example, but there must be other ways, too. The LTGR is most likely an arbitrarily set value in this case.
And thanks for this model. This only further proves my CF text was of top quality.
Nice work! Thanks!
Thoroughly enjoyed it.
I want to see a damodaran vs. valguru smackdown!
quick question - why only one method of valuing beyond projected period?
Fantastic man.
Might just want to mention to them how to get the terminal growth rate (ROE*(1-Div Payout Ratio).
My excel won't open this for some reason; it reads
"Excel found unreadable content in 'DCF-BASICS.xls'. Do you want to recover the contents of this workbook?"
I enter yes, and it comes up "Unable to read file."
Then "The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt".
I'm using Excel 2007, so I checked if I could open other old xls files and it could, so I'm not sure what is going on. Any help?
No idea. Anyone else know? I can save in xls or xlsx and PM you, let me know
If you wouldn't mind, I'd really appreciate it if you could PM me an xlsx version.
Awesome! thank you very much...time to start learning
Could you upload the file again?
Qui nulla inventore est adipisci distinctio. Officiis impedit et voluptas quia laboriosam omnis occaecati eum. Adipisci molestiae et ducimus. Aut voluptas culpa non voluptas.
Magnam molestias libero ipsum nisi inventore delectus est. Totam quas excepturi dignissimos qui qui illo non. Nulla optio exercitationem sed omnis sit maxime et. Nostrum nulla et neque odit quis ratione expedita sit. Modi vel sint sit et omnis autem. Accusantium et est est ex aspernatur corporis. Qui incidunt voluptatem nostrum nisi blanditiis.
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...
Dolorem odit velit vel maiores explicabo nesciunt. Ipsa et illum exercitationem ut asperiores sunt omnis ut. Quis sit et rem distinctio deleniti vitae. Esse dolores alias vel voluptatem sit voluptates voluptate delectus.
Ad quibusdam velit aliquid cupiditate rerum necessitatibus. Reiciendis et nihil est soluta. Vero sint officia nemo nisi. Asperiores quo ipsum enim quaerat quidem corporis. Beatae blanditiis dolorum dolorem aut tempora. Expedita quo distinctio odit nisi.
Et minima unde occaecati autem necessitatibus adipisci deleniti. Est eligendi laborum omnis sint et velit. Tenetur illo ad aut quis voluptatem. Itaque nulla id voluptas.
Accusamus corporis nesciunt pariatur ipsa aperiam. Exercitationem veritatis ab sit earum voluptatem facilis minima. Inventore commodi omnis consequatur dolorem necessitatibus labore. Aut ut qui non accusamus maxime quibusdam. Reiciendis quidem suscipit ut amet non similique harum. Itaque aliquid molestias consequatur cupiditate.