Question: Using Excel sheet, suppose the project will finish within 6 years ( Starting from year 0 ). Follow your instructor instructions about the value of:

Using Excel sheet, suppose the project will finish within 6 years (Starting from year 0). Follow your instructor instructions about the value of: Discount Rate 8% Cost for every year 20.000 Benefits for every year 25.0000 Your task is to calculate the following:

1- Discount factor for every year.

2- Discounted Benefits for every year.

3- Discounted Cost for every year.

4- Discounted Benefits-Cost for every year

5- Cumulative Benefits Cost

6- Calculate NPV

7- Calculate ROI

8- Determine the payback in which year (If possible).

9- Explain the situation of your project. (over, under, behind the budget). What your value means ?

then paste your Excel sheet here including your name(s).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!