The spreadsheet fragment below shows a net present value and internal rate of return calculation for a

Question:

The spreadsheet fragment below shows a net present value and internal rate of return calculation for a project:

image

Use Data Table to do a sensitivity analysis on the NPV of the project, varying the discount rates from 0%, 3%, 6%, ?, 21% and varying the growth rates from 0%, 3%, ?, 12%.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Modeling

ISBN: 9780262027281

4th Edition

Authors: Simon Benninga

Question Posted: