Using excel to calculate
0.00 | 1 | 2 | 3 | 4 | 5 | |
Project A | -1600 | 720 | 660 | 700 | 420 | 520 |
Discounted Cash Flow | -1600.00 | 666.67 | 565.84 | 555.68 | 308.71 | 353.90 |
Cumulative Cash flow | -1600.00 | -$933.33 | -$367.49 | $188.19 | $496.91 | $850.81 |
Discounted Payback Period | 2.66 | |||||
excel formula | 2+367.49/555.68 |
The Project should be accepted.
Compute the discounted payback statistic for Project if the appropriate cost of capital is 8 percent...
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 12 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "O" (zero).) Project D Time: Cash flow: 0 -$11,600 1 $3,410 $4,300 34 $1,640 $0 $1,120 Discounted payback period 0 years Should the project be accepted or rejected? accepted rejected...
Compute the discounted payback statistic for Project C if the appropriate cost of capital is 8 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 -$1,300 $600 $570 $610 $360 $160 2 4 5 years Should the project be accepted or rejected? O Rejected O Accepted
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 discounted payback statistic for Project D if the appropriate cost of capital is 13 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "O" (zero).) Project D Time: 2 4 Cash flow:-$11,500 $3,400 $4,280 $1,620 $0 $1,100 Discounted payback period years Should the project be accepted or rejected? O accepted O rejected
Compute the payback statistic for Project A if the appropriate cost of capital is 8 percent and the maximum allowable payback period is four years. (Round your answer to 2 decimal places.) Project A Time: Cash flow: -$2,800 $1,070 $1,020 $889 $660 $460 Payback years Should the project be accepted or rejected? accepted rejected
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 12 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "0" (zero).) Project D Time: 0 1 2 3 4 5 Cash flow: –$11,000 $3,350 $4,180 $1,520 $300 $1,000 Should the project be accepted or rejected? accepted rejected
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 10 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "O" (zero).) Project D Time: Cash flow: 1 1 -$12,900 $3,540 2 $4,560 3 $1,900 4 $0 5 $1,380 Discounted payback period years
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 11 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "0" (zero).) Project D Time: 0 1 2 3 4 5 Cash flow: –$12,700 $3,520 $4,520 $1,860 $0 $1,340 Discounted Payback Statistic:
Compute the payback statistic for Project A if the appropriate cost of capital is 7 percent and the maximum allowable payback period is four years. (Round your answer to 2 decimal places.) Project A Time: Cash flow: 0 -$2,300 1 $870 2 $870 3 $780 4 $560 5 $360 Payback years Should the project be accepted or rejected? accepted O rejected
Compute the payback statistic for Project A if the appropriate cost of capital is 7 percent and the maximum allowable payback period is four years. (Round your answer to 2 decimal places.) Project A Time: Cash flow: 0 -$2,300 1 $870 2 $870 3 $780 4 $560 5 $360 Payback years Should the project be accepted or rejected? accepted O rejected