Calculation of Profitability Index of Project Z | |||||
Year | Cash Flows | Discount Factor @6% | Discounted Cash flows | ||
A | B | C = 1/ (1+6%)^n | D = B*C | ||
1 | 510 | 0.943396226 | 481.1320755 | ||
2 | 640 | 0.88999644 | 569.5977216 | ||
3 | 810 | 0.839619283 | 680.0916193 | ||
4 | 460 | 0.792093663 | 364.3630851 | ||
5 | 260 | 0.747258173 | 194.2871249 | ||
Present value of Future Cash flows | 2289.471626 | ||||
Initial investment of Project Z = ($1800) | |||||
Profitability Index = Present value of Future Cash flows / Initial Investment | |||||
= 2289.471626 / 1800 | |||||
= 1.27 | |||||
Profitability Index for Project Z is 1.27 and it is greater than 1 | |||||
Hence, Project Z can be accepted |
Compute the PI statistic for Project Zer the appropriate cost of capital is 6 percent (Do...
Compute the PI statistic for Project Q if the appropriate cost of capital is 12 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project Q Time: 0 1 2 3 4 Cash flow –$11,600 $3,650 $4,480 $1,820 $2,450 PI Should the project be accepted or rejected? Rejected Accepted
Compute the PI statistic for Project Z if the appropriate cost of capital is 7 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project Z Time: 0 1 2 3 4 5 Cash flow: −$2,300 $610 $740 $910 $560 $360 Should the project be accepted or rejected? accepted rejected
Compute the IRR statistic for Project E. The appropriate cost of capital is 9 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project E Time: 0 1 2 3 4 5 Cash flow −$1,800 $670 $720 $680 $460 $260 IRR? Should the project be accepted or rejected?
Compute the IRR static for Project E. The appropriate cost of capital is 9 percent. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Project E Time: 0 1 2 3 4 5 Cash flow –$1,800 $670 $720 $680 $460 $260 IRR % Should the project be accepted or rejected? Rejected Accepted
Compute the IRR for Project F. The appropriate cost of capital is 11 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project F Time: Cash flow:-$10,100 $3,850 $4,680 $2,020 $2,650 IRR % Should the project be accepted or rejected? rejected O accepted Compute the IRR static for Project E. The appropriate cost of capital is 7 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project E...
Compute the discounted payback statistic for Project C if the appropriate cost of capital is 6 percent and the maximum allowable discounted payback period is three years. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Project C Time Cash flow -$2,700 $1,160 $990 $1,030 $640 $440 0 2 4 Discounted payback period years Should the project be accepted or rejected? Rejected Accepted
Compute the IRR statistic for Project F. The appropriate cost of capital is 12 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project F Time: 0 1 2 3 4 Cash flow: −$10,300 $3,950 $4,780 $2,120 $2,750 Should the project be accepted or rejected? rejected accepted
Compute the MIRR statistic for Project lif the appropriate cost of capital is 12 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project I Time: Cash flow: 0 -$11,300 1 $5,480 2 $4,330 3 $1,670 4 $2,150 MIRR % Should the project be accepted or rejected? rejected accepted
Compute the MIRR statistic for Project J if the appropriate cost of capital is 9 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project J Time: 0 1 2 3 4 5 Cash flow: −$1,100 $380 $1,530 −$530 $330 −$110 Should the project be accepted or rejected? accepted rejected
Compute the NPV statistic for Project Y if the appropriate cost of capital is 11 percent. (Ne minus sign. Do not round intermediate calculations and round your final answer to 20 Project Y Time: Cash flow: $8,400 $3,710 $4,540 $1,880 $660 NPV Should the project be accepted or rejected? rejected • accepted