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

2years

3years

4years

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

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Use the financial benefits calculator spreadsheet to
Reference No:- TGS02879501

Expected delivery within 24 Hours