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
Trending Content
| +87 | Are you “less ambitious” for having long term goals outside of NYC | 22 | 1d | |
| +67 | Affair with my Associate… In Desperate Need for Advice | 23 | 4d | |
| +56 | How to sound more eloquent? | 26 | 46m | |
| +40 | WSO Ranking On Resume??? | 10 | 1d | |
| +34 | Interviews Are So Fake | 20 | 15h | |
| +32 | 2024 UK Election - Tories finished? | 18 | 19h | |
| +29 | Why do people listen to Jim Cramer Investing Advice? | 13 | 20h | |
| +26 | Is my boss gaslighting me? | 3 | 4d | |
| +24 | Chaotic Insane investment banker who passed away in the 90s or 2000s | 12 | 5d | |
| +22 | Ideas for things to do with a free semester before starting ft? | 9 | 2h |
Career Resources
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.
Eveniet a tenetur sit alias consequatur vel fugiat. Libero optio minus optio eum et dolor.
Iusto vel autem rerum nemo ut sint. Illum nostrum consequuntur dolor qui. Maxime accusantium tempore facere voluptatibus eum.
Excepturi consequatur aut sunt ea rerum deserunt. Fugit possimus est cumque blanditiis. Impedit maiores corporis neque ratione occaecati rerum. Sint velit qui totam cumque repellat eos nam vero.
Itaque quaerat rerum fugiat amet necessitatibus dolor. Illum asperiores suscipit id ut dolores reprehenderit. Quas accusamus eligendi ut vitae. Autem nemo odio ducimus et nisi sit labore cum. Autem dolor repellendus repellendus quaerat enim et voluptate.
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...