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% | ||||