Question
NPV Calculations Discount rate 12% Project 1 Year 1 Year 2 Year 3 Year 4 Year 5 TOTAL Costs 220,000 35,000 35,000 25,000 20,000 ?
NPV Calculations
Discount rate | 12% |
|
|
|
|
|
|
|
|
|
|
|
|
Project 1 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL |
Costs | 220,000 | 35,000 | 35,000 | 25,000 | 20,000 | ? |
Discount factor | ?
| ? | ? | ? | ? |
|
Discounted costs | ? | ? | ? | ? | ? | ? |
|
|
|
|
|
|
|
Benefits | 0 | 80,000 | 80,000 | 65,000 | 60,000 | ? |
Discount factor | ? | ? | ? | ? | ? | ? |
Discount benefits | ? | ? | ? | ? | ? | ? |
Discounted benefits Discounted costs (NPV) |
-------- |
--------- |
--------- |
---------- |
----------- | ? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ROI = | ??? |
|
|
|
|
|
PAYBACK PERIOD IS WHAT YEAR? | ??? |
|
|
|
|
|
Write down the formula to calculate the discount factor:
____________________________________________________________________________
Write the down the formula for calculating 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