Calculate the range for the NPV given each scenario. (Click on the icon here order to copy the contents of the data table below into a spreadsheet.) For the pessimistic scenario, the NPV is $. (Round to the nearest cent.) For the most likely scenario, the NPV is $ (Round to the nearest cent.) For the optimistic scenario, the NPV is $ (Round to the nearest cent.) The NPV range is $ (Round to the nearest cent.)