I am looking for some help regarding sensitivity analysis tables (spreadsheet attached for convenience). On tab "WACC" the sensitivity analysis works properly. However, my two sensitivity analysis tables on tab "Output Page" aren't working correctly. The enterprise value is the same moving across the rows and all of the analysis on the other table is 3.0%. I have highlighted the cells being referenced as well.
Please let me know what I have done wrong and any tips for the future. These tables always give me trouble. Thanks!
Bookmarks