project management 2
NPV and ROI Calculations Case
Using the NPV-ROI Spreadsheet Template provided, which covers
three years, enter the following values to determine
the net present value (NPV), ROI percentage, and in what year payback is
achieved.
NPV-ROI Spreadsheet Template:
Discount Rate = 8.00%
Costs: Year 0 =$200,000;Year 1 = $20,000;Year 2 = $20,000;Year 3 = $20,000
Benefits: Year 0 = 0;Year 1 = $100,000 Year 2 = $100,000;Year 3 = $100,000