I've been reading a little bit about DCFs and want to practice modeling out a DCF on my own. Does anyone know what the best way to get started on doing something like this is? I'm guessing that trying to model a very large company would be challenging, so would it be best to start with a small cap? Also, any tips about doing this in general?
| +190 | Evercore > Goldman and I don’t think it’s particularly close anymore | 65 | 20h |
| +157 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 1d |
| +86 | UBS Offer Day | 32 | 3h |
| +84 | Think Twice before Recruiting for HOUSTON IB!! | 44 | 7h |
| +71 | I hate Wells Fargo | 19 | 1d |
| +52 | No return offer - feeling like a failure is an understatement | 21 | 10h |
| +49 | How cooked am I as an incoming WF IB SA 2027? | 17 | 1d |
| +47 | WF Return offers | 28 | 3d |
| +40 | 2026 Investment Banking Return Offer Climate | 25 | 1d |
| +39 | Should I go back into a junior IBD role for comp? | 16 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Pick a company with clear financials and avoid specialized industries (FIs, resources, etc) for which you won't know the drivers/accounting. If you've never done it before it will be more a practice of accounting and how the statements flow as DCF itself is straight forward.
check inbox
I didn't see a PM...
i'm interested too since I have interviews pretty soon.
thx
Me three please !
if not you can only try macabacus.com
I did a practice recently and sent it to a formr banker who said it was pretty good.
For a standalone DCF,
Import historical I/S into excel.
Project out based on relevant drivers (read analyst estimates for revenues, etc). Project down to ebit.
Project relevant Working Capital Items, (noncash current assets, non debt current liabilities)........you have to use the relevant drivers, (i.e, for A/R, days receivable, etc).
Project Capex (read 10K, or for simplicity, % sales Project D&A (some will say as a % of sales, but you should build out a PP&E sched and depreciate per asset excluding land and incorporate capex)
EBIT(1-T)+D&A-increase in WC-capex=unlevered FCF.
the rest straightforward, calculate wacc, discount unlevered FCF, calc terminal value, sum them to get to enterprise value, net debt, equtiy value../shares outstanding=pps
for a full three statement it's a little different btw..this is just simple
let me know if u'd like a sample, i'll send it to u, pm email address
^PM sent
Do you still have the sample DCF you could send me? Thanks
It's been a while this post is active, but if anyone could send me a sample DCF as well, that would be great.
Macabus.
DCF and PV practice questions (Originally Posted: 09/15/2009)
Hi there,
Could anyone point me to university court sites that have powerpoints/lecture notes/practice problems for DCF and PV? I'm trying to get some extra practice in and I usually used MIT's opencouseware but they don't have any corporate finance classes available.
Preferably elite schools.
Proffesor Damodoran at NYU.
You da best.
Praesentium et placeat vel odit. Nulla iusto ipsa velit praesentium. Laborum voluptate odio voluptates sequi veniam.
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...