Review “Excel for Corporate Finance Professionals” by Michael McDonald from LinkedIn . Sections “NPV Tests in Excel” and “NPV and Scenario Analysis” may be helpful for understanding this exercise.
Individually, complete all sets and parts. The file contains the following 5 worksheet tabs to complete:
Set 1, Part 1
Set 1, Part 2
Set 2, Part 1
Set 2, Part 2
Set 2, Part 3