What formulas to use in a DCF?
Hi guys, seen several types of formulas being used to link in numbers from the P&L to the DCF-model. Which one is considered the most “advanced”, since I want to show of on my upcoming internship. Yes it’s true, lol
Trending Content
| +81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 5d | |
| +32 | How the heck do you learn all of this stuff? | 10 | 17h | |
| +28 | Getting Frustrated | 10 | 4w | |
| +28 | My experience on the sell side | 20 | 2w | |
| +24 | Clues in Financial Reporting Analysis | 7 | 2d | |
| +17 | Am i fairly compensated? | 9 | 3d | |
| +14 | Data Science to PM | 8 | 1w | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
| +12 | ER - Remote Jobs? | 8 | 5d | |
| Equity Research at Bank vs IG, High Yield & Leveraged Loans Research at Asset Manager | 4 | 1d |
Career Resources
The kids just keep getting dumber and dumber don’t they
I'm sorry, can you try asking this again? I don't understand what you are asking, and you may want to do some more self study as most of this can be learned on your own (in more detail and more thoroughly) vs. getting answers on this forum.
Are you asking what is the most typical formula to get to UFCF from an operating model to run a DCF?
Haha this is kind of silly but what I'm asking about is basically if you just link cells in your UFCF model directly to e.g your IS (take revenue as an example). Or do you use some type of lookup formula or whatever instead of just linking it to the original cell?
Bankers tend to create templates for there DCFs and LBOs with formulas but friends of mine in research and AM don't care and just link it to the original cell with out any formula
Sint eligendi nemo sapiente omnis neque. Beatae dolores eos debitis ut non dolores dolorem. Facere nesciunt ut alias ut et itaque quibusdam perferendis. Odit molestiae quidem ratione consequatur quibusdam. Modi omnis doloremque temporibus hic. Illum dolor consequatur sint consectetur qui unde.
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...