Calculate the crossover rate between two project cash flow series and compare each project’s NPV at an optional discount rate per period.
Related Calculators
- Cost Recovery Ratio Calculator
- Horizon Value Calculator
- Reverse Depreciation Calculator
- Variable Margin Calculator
- All Business Calculators
Crossover Rate Formula
The crossover rate is the discount rate at which two projects have the same net present value. The calculator finds it by subtracting Project B cash flows from Project A cash flows, then solving for the internal rate of return of the incremental cash flows.
IncrementalCF_t = CF_{A,t} - CF_{B,t}0 = \sum_{t=0}^{n} \frac{IncrementalCF_t}{(1 + CR)^t}For the optional NPV comparison, the calculator uses:
NPV = \sum_{t=0}^{n} \frac{CF_t}{(1 + r)^t}- CR = crossover rate per period
- CFA,t = Project A cash flow at time period t
- CFB,t = Project B cash flow at time period t
- IncrementalCFt = difference between Project A and Project B cash flows at time period t
- r = discount rate used for the optional NPV comparison
- t = time period, starting at 0
- n = final time period in the cash flow series
The main crossover rate function solves for the rate where the incremental NPV equals zero. At that rate, Project A and Project B have the same NPV. The optional discount rate field does not change the crossover rate. It simply calculates each project’s NPV at the rate you enter so you can see which project has the higher value at that specific rate.
How to Interpret the Crossover Rate
| Discount rate compared with crossover rate | What it means |
|---|---|
| Discount rate is below the crossover rate | One project has the higher NPV below the crossover point. Which project depends on the cash flow pattern. |
| Discount rate equals the crossover rate | Both projects have the same NPV. |
| Discount rate is above the crossover rate | The project preference switches, assuming there is one unique crossover rate. |
| Input item | How to enter it | Example |
|---|---|---|
| Time 0 cash flow | Usually the initial investment, entered as a negative number | -5000 |
| Future cash flows | Enter each period in order, separated by commas | 2500, 2500, 2500 |
| Discount rate for comparison | Enter as a decimal, not a percent | 0.10 for 10% |
Example Section
Example 1: Three-period projects
Project A cash flows: -5000, 2500, 2500, 2500
Project B cash flows: -4000, 2000, 2000, 2000
Incremental cash flows are:
-1000, 500, 500, 500
The crossover rate is the rate that makes the incremental NPV equal to zero:
0 = -1000 + \frac{500}{(1+CR)} + \frac{500}{(1+CR)^2} + \frac{500}{(1+CR)^3}The result is approximately 23.3752% per period.
Example 2: Projects with a 0% crossover rate
Project A cash flows: -10000, 6000, 6000
Project B cash flows: -8000, 3000, 7000
Incremental cash flows are:
-2000, 3000, -1000
The equation is:
0 = -2000 + \frac{3000}{(1+CR)} - \frac{1000}{(1+CR)^2}One crossover rate is 0.0000% per period.
FAQ Section
What does the crossover rate tell you?
The crossover rate tells you the discount rate where two projects have equal NPV. If your required return is on one side of the crossover rate, one project may have the higher NPV. If your required return is on the other side, the other project may be better by NPV.
Why might the calculator say the crossover rate was not found?
A crossover rate may not exist if the incremental cash flows do not cross zero in present value terms. It can also be difficult to identify a single result when the incremental cash flows change signs more than once, because that can create multiple possible IRRs.
Is the crossover rate the same as IRR?
It is an IRR calculation applied to the difference between two projects. Instead of finding the IRR of one project’s cash flows, the crossover rate finds the IRR of the incremental cash flows between Project A and Project B.
