Question: Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 ?$16,000 ?$16,000 1 6,700 7,270 2 7,280 7,740 3 4,800
| Consider the following two mutually exclusive projects: |
| Year | Cash Flow (X) | Cash Flow (Y) |
| 0 | ?$16,000 | ?$16,000 |
| 1 | 6,700 | 7,270 |
| 2 | 7,280 | 7,740 |
| 3 | 4,800 | 3,610 |
| Requirement 1: |
| (a) | What is the IRR of Project X? (Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| IRR | % |
| (b) | What is the IRR of Project Y? (Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| IRR | % |
| Requirement 2: |
| What is the crossover rate for these two projects? Hint: see the crossover rate in my Excel file. (Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| Crossover rate | % |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
