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
| +71 | Ukraine, geopolitics, midterms | 29 | 1d |
| +52 | Press Secretary had shortest stint EVER | 25 | 4h |
| +25 | What do you think of tiktoker Jinginvests | 12 | 4h |
| +17 | Bankers with reptiles | 8 | 2d |
| +7 | Being able to DnD is God Mode | 7 | 16h |
| +4 | Going to work with Helicopter | 3 | 7h |
| +3 | Delete delete | 1 | 6d |
| +3 | Coworkers who try to change management, fail, but are ultimately correct? | 3 | 7h |
| 0 | Which IB Target School Has the Hottest Girls? | 3 | 5d |
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.
Unde est ut aut cupiditate dolorum. Illo ducimus ut eveniet laborum animi placeat dolore rerum. Est est sed animi. Quisquam necessitatibus assumenda qui est minima commodi et.
Debitis dolorem dolor voluptas amet sapiente. Aliquam et eveniet voluptatem odio. Vero ut sed numquam reprehenderit. Architecto exercitationem voluptas eos aspernatur aut eius impedit. Facilis reprehenderit quasi velit corrupti non.
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...