![]() ![]() ![]() In PC/Windows Excel, the shortcut is Alt, D, T or Alt, A, W, T (there is no shortcut in Mac Excel):Ī properly set-up and formatted sensitivity table looks like this (taken from the Walmart DCF, where we vary the Discount Rate and Terminal Growth Rate to assess the company’s implied value): Internally in Excel, sensitivity analyses are known as “data tables,” and you can access them in the ribbon menu under the Data tab and “What-If Analysis”: ![]() Read our Privacy Policy Sensitivity Analysis Excel: Data Tables and How to Build Them
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |