Question
Using information about the estimated costs, estimated benefits and a discount rate of 9% for Project XYZ, calculate the discount factor for each year, the
Using information about the estimated costs, estimated benefits and a discount rate of 9% for Project XYZ, calculate the discount factor for each year, the discounted costs, the discounted benefits, the return-on-investment (ROI) and the net-present value (NPV). In which year does the payback occurs?
Year | Total | ||||||
0 | 1 | 2 | 3 | 4 | 5 | ||
Estimated Costs | 175,000 | 22,500 | 22,500 | 22,500 | 22,500 | 22,500 | |
Discount Factor | ? | ? | ? | ? | ? | ? | |
Discounted Costs | ? | ? | ? | ? | ? | ? | ? |
Estimated Benefits | 0 | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | |
Discount Factor | ? | ? | ? | ? | ? | ? | |
Discounted Benefits | ? | ? | ? | ? | ? | ? | ? |
Discounted Benefits - Costs | ? | ? | ? | ? | ? | ? | ? |
Cumulative Benefits -Costs | ? | ? | ? | ? | ? | ? | |
Return on Investment (ROI) | ? |
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