In: Finance
MC algo 5-12 Calculating Crossover Rate You are evaluating two projects with the following cash flows: Year Project X Project Y 0 −$547,200 −$516,500 1 218,600 208,300 2 228,500 218,100 3 235,700 226,000 4 195,400 186,800 What is the crossover rate for these two projects? Multiple Choice .66% 22.35% 11.72% 23.01% 10.65%
Project Y-Project X Cash flow values are as follows | |||||
Year | Cash flow stream | ||||
0 | 30700 | ||||
1 | -10300 | ||||
2 | -10400 | ||||
3 | -9700 | ||||
4 | -8600 | ||||
Incremental IRR is calculated based on difference of the cash flow of the two projects | |||||
Incremental CF | |||||
IRR is the rate at which NPV =0 | |||||
IRR | 10.65% | ||||
Year | 0 | 1 | 2 | 3 | 4 |
Cash flow stream | 30700 | -10300 | -10400 | -9700 | -8600 |
Discounting factor | 1 | 1.106503 | 1.224348 | 1.354744 | 1.499028 |
Discounted cash flows project | 30700 | -9308.61 | -8494.32 | -7160.02 | -5737.051 |
NPV = Sum of discounted cash flows | |||||
NPV Incremental CF = | -3.49231E-06 | ||||
Where | |||||
Discounting factor = | (1 + IRR)^(Corresponding period in years) | ||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||
IRR= | 10.65% | ||||