What is the IRR of Project X? (Do not round intermediate calculations. Enter you
ID: 2629660 • Letter: W
Question
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).)
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).)
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).)
Explanation / Answer
Discounting rate Year 8.93 Cash flow Dsic. Cash flow 0 1.00 -16000.00 -16000.00 1 0.92 6700.00 6150.74 2 0.84 7280.00 6135.31 3 0.77 4800.00 3713.63 IRR project X 8.93% -0.32 Year 8.89 Cash flow Dsic. Cash flow 0 1.00 -16000.00 -16000.00 1 0.92 7270.00 6676.46 2 0.84 7740.00 6527.77 3 0.77 3610.00 2796.04 IRR project Y 8.89% 0.27 Year 9.67 Cash flow (difference) Dsic. Cash flow 0 1.00 0.00 0.00 1 0.91 -570.00 -519.74 2 0.83 -460.00 -382.46 3 0.76 1190.00 902.16 -0.04 crossover rate 9.67%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.