Based on a cost of $200,000 in year 0, and benefits of $600,000 for years 1 through 4, use the financial benefits calculator spreadsheet to…

1. Based on a cost of $200,000 in year 0, and benefits of $600,000 for years 1 through 4, use the financial benefits calculator spreadsheet to calculate the payback period of the project. What is the Payback Period of the project?

1 year

2 year

3 year

4 year

2.Based on a cost of $200,000 in year 0, and benefits of $600,000 for years 1 through 4, use the financial benefits calculator spreadsheet to calculate the  ROI of the project. What is the ROI of the project?

37%

235%

896%

-896%

3. Based on a cost of $200,000 in year 0, and benefits of $600,000 for years 1 through 4, use the financial benefits calculator spreadsheet to calculate the NPV of the project. What is the NPV of the project?

$1,792,000

$547,342

-$51,757

$2,560,275

Leave a Reply