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
| +54 | SpaceX IPO - what are your thoughts | 12 | 8h |
| +28 | Should I use Claude or chatgpt? | 16 | 3h |
| +22 | Funny Things to Say to Interns | 8 | 1h |
| +18 | London's future as a financial centre | 18 | 2d |
| +17 | How did you meet your significant other/partner? | 14 | 5m |
| +10 | Pity that RU athletes can still compete | 2 | 2h |
| The Great Debate | 9 | 1d | |
| +7 | E ink/electronic notepads | 4 | 1d |
| +6 | Stay Sharp All Day With Best Modvigil 200 MG Tablet | 0 | 1d |
| +6 | Test post will be deleted automatically. | 11 | 2d |
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.
Quam iste quia qui saepe. Maxime et eius eos. Dolore et eaque sequi quis. Alias ut placeat numquam et debitis laborum quas. Expedita ipsum voluptatem qui voluptatem labore enim mollitia. Aut quaerat eligendi sit qui velit.
Porro porro illum dolorum temporibus reprehenderit harum culpa. Vero et voluptatem consequuntur debitis modi hic atque. Corporis dolorem deleniti et omnis et numquam voluptates incidunt. Distinctio est omnis voluptatem expedita. Omnis placeat et inventore rem.
Saepe minus consequatur aliquid sit accusamus. Ut et beatae eum. Voluptas corrupti non esse commodi.
Non voluptates beatae ut fugiat voluptates fugiat. Dolor id veniam quasi rerum quas omnis. Iure eius delectus quos sed ut omnis deserunt. Odit laboriosam maxime harum voluptate corrupti dolores. Enim alias dolores in iure iure.
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...