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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started