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
| +73 | Uchicago is paradise | 14 | 2d |
| +58 | BofA VP killed in random NYC stabbing | 36 | 1d |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 1d |
| +13 | POLL: Optimistic or Pessimistic? | 9 | 4d |
| +11 | At what salary can you start calling it “fi-NANCE” | 3 | 16h |
| +7 | Who is making these posts on WSO Linkedin ? | 5 | 2d |
| +3 | Lindsay Clansey | 3 | 6h |
| +1 | Someone just coined "the view" | 3 | 3d |
| 0 | What Are the Best Ways to Keep Office Carpets Clean? | 1 | 1d |
| 0 | Abstention | 0 | 9h |
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.
Eligendi omnis enim hic reprehenderit placeat. Exercitationem eaque dolorem molestiae. Esse sit sint quasi maxime temporibus repudiandae.
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...