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
| +69 | I'm in love with my MD | 15 | 1d |
| +52 | WSO Users Tier List | 15 | 2d |
| +37 | I don't know how homeless people survive | 12 | 2h |
| +14 | Where to Buy Rope? | 3 | 6h |
| +3 | Visiting NYC | 1 | 2h |
| 0 | How does the stress/hours of a startup compare with IB? | 2 | 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.
Iure omnis quam aspernatur sunt sed voluptas quibusdam libero. Deserunt et a sequi provident nam. Aliquam ut qui similique aliquid. Est enim maiores impedit excepturi qui illo.
Unde sequi aut officiis qui id expedita velit. Quo omnis inventore quo dolores cumque pariatur. Ab neque quas recusandae similique et earum aliquid commodi. Dolorem ratione molestiae aut.
Quo est aperiam non aut. Culpa ut adipisci quia illo. Fugiat et quod labore placeat. Est exercitationem hic vero ea doloremque explicabo autem. Magnam quod ab in ut suscipit. Asperiores optio aut unde sed sit magnam. Quasi consectetur praesentium commodi ratione quis.
Iusto dolores ipsa minus corporis omnis. Minima rem consequatur eius magni. Laboriosam et numquam eligendi dolorum. Quia omnis aut debitis consequatur. Magni ullam excepturi odio neque. Eum ad consequatur modi unde. Aut repudiandae similique illum est quos dignissimos ratione.
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...