Excel Finance question
Consider the following two mutually exclusive projects:
|
Year |
Cash Flow (A) |
Cash Flow (B) |
|
0 |
−$455,000 |
−$65,000 |
|
1 |
58,000 |
31,000 |
|
2 |
85,000 |
28,000 |
|
3 |
85,000 |
25,000 |
|
4 |
572,000 |
19,000 |
Whichever project you choose, if any, you require a return of 11 percent on your investment.
Apply the following criterion/methods to each project
- Payback Criterion
- Discounted Payback Criterion
- NPV criterion
- IRR criterion
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"
