Excel skills for DCF modelling
Hi, I have a decent amount of experience using excel, but need help with something.
I recently landed an internship at a well-known firm that does commercial real estate investing. They want to teach me to do dcf modelling when I return to NY from break but I want to ensure I'm fimiliar with the tools I'll need to do so.
In short, my question is what specific formulas and other excel tools should I be fluent in to learn dcf modelling in a few weeks?
Thanks, appreciate it.
DCF is the easiest thing you'll do in finance. There are really no special formulas.
The only difference is the DCF model on the macabacus.com site, which uses the NPV formula and does a sort of sensitivity table with different WACCs. It's the default template (or style) that many banks use for the DCF analysis, which is harder to spot check as the whole calc is in that formula, but it's more dynamic.
Learn the XIRR formula and know what Excel's NPV formula does (i.e. if memory serves it does not include a year zero).
That's really the main thing formula-wise.
Know how to do sensitivity tables, since they'll probably want to see those too.
Perspiciatis incidunt amet enim eveniet iusto suscipit culpa et. Soluta alias qui reprehenderit consectetur cum veniam modi.
Tempora sed sint dolorum veniam. Et temporibus sint minima voluptatem aut fugiat. Atque et praesentium ut rerum incidunt sed sint asperiores. Quia ullam qui sed aspernatur consequatur. Molestiae suscipit ut vitae porro non voluptatem soluta doloribus. Veniam delectus consectetur facilis harum voluptas occaecati. Non dolorem autem laudantium reiciendis praesentium sed eum.
Nisi repellendus dignissimos et nisi molestias ut. Ex magnam commodi veritatis nulla voluptatem cupiditate dignissimos. Eveniet placeat neque in eligendi sit quia commodi.
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...