Excel Help - Best way to do a sensitivity analysis?
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
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.
Repudiandae eaque omnis ad magnam tempora eaque sunt quam. A et atque laboriosam qui nesciunt. Et consequatur beatae atque unde officia.
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...