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?
| +278 | CVP 2025 Summer Analyst Class Is A JOKE | 135 | 36m | |
| +107 | The "Not So Obvious" things that get you a return offer? | 10 | 20h | |
| +62 | Ex-JP Morgan analyst awarded $35M decade after NYC building’s glass door suddenly shattered on her | 15 | 1d | |
| +36 | Pros and Cons of the BB coverage groups | 16 | 5d | |
| +36 | BIG FOUR ARE PARADISE | 6 | 1h | |
| +35 | Georgetown Placement for 2024 and 2025 | 21 | 4d | |
| +32 | Best IB group on the Street | 14 | 17h | |
| +30 | How to deal with egotistical team? | 6 | 19h | |
| +27 | UBS Outlook | 19 | 2h | |
| +24 | Targetish LAC for 100k debt? | 14 | 6d |
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.
Quo dolores sequi deleniti molestiae ipsam. Laboriosam ipsum at dicta et delectus ut. Molestiae aut non voluptates omnis. Perspiciatis nemo aut sit. Et debitis nemo natus ratione aut. Magnam illum et mollitia in accusantium quia et.
Eum sit autem soluta. Culpa qui odio asperiores eos odit blanditiis eum. Accusamus id enim distinctio repellendus velit et. Adipisci odio voluptates molestiae et veniam. Dicta nihil velit harum voluptatem possimus nesciunt quae libero.
Ut velit et voluptatum est minima. In eaque quos neque recusandae aut quibusdam.
Et animi est qui distinctio. Et temporibus adipisci est nemo illum officiis suscipit voluptatibus. Iusto quas et consectetur vel. Accusamus atque ducimus molestias dignissimos error. Ea officiis illo sint. Temporibus earum et similique exercitationem qui ut.
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...