medium10 pts · first answer countsexcel-modellingsensitivity-analysis
Using an Excel data table
You want to show project NPV for discount rates from 8% to 14% in one table, all calculated from your existing model. Which Excel feature is designed for this?
Discussion 0
Join free to post in the discussion.
Related questions
- Totals by region and monthFinancial Analyst
- Locking a cell referenceFinancial Analyst
- When to use Goal SeekFinancial Analyst
- XLOOKUP default behaviourFinancial Analyst
- Two-way lookup in a gridFinancial Analyst
- Operating leverage and EBITFinancial Analyst
- Reading a tornado chartFinancial Analyst
- Fixed costs rise, break-even movesFinancial Analyst