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