Can anyone tell me the best way to do a sensitivity analysis for a DCF in Excel. I would like a table that displays the EV for several different WACCs and growth rates.
Thanks
| +98 | KISSED MY VP… HELP!!! | 16 | 20h |
| +28 | ADHD & Living This Life | 7 | 2d |
| +26 | How expensive is SF? | 14 | 1d |
| +19 | Would you / have you payed someone for a role in IB? | 9 | 3d |
| 0 | What is a tool that you wish you had and would use every day? | 3 | 22h |
| 0 | Future of New York as number 1 financial centre | 2 | 4h |
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.
Use a data table. This will allow you to test the sensitivity of a given output against two inputs . If you're using Excel 2007, it's Data>What-If-Analysis>Data Table. The help tutorial will explain how to set it up; it's a very important function to learn.
Velit quo aut atque quia qui quia aut eum. Ut ipsa nobis amet eos non sint. Fuga unde et quis fugiat. Officiis non fugit voluptas accusamus quos. Consequatur aliquid temporibus pariatur libero quo dolorum modi minus. Accusamus tempora est iure cum exercitationem.
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...