Calculating a crossover rate can help you plan ahead when making certain business decisions. A crossover rate can help you determine how to manage your business investments in multiple securities, and it can also help you manage funding for projects and prepare reports for investor-relations documents. Most important, a crossover rate can be used to choose between different investment strategies, projects or securities, as it can be used to indicate which choice can be the most profitable for a business.
- Skill level:
Other People Are Reading
Things you need
- Cash-flow data for each project
- Online IRR calculator
- Paper and pencil
Organise your cash-flow data from the two projects. Ensure that the periods match up and are of equal length.
Calculate the differences in cash flow for each period between the first and second projects by subtracting each set of terms.
Type these differences into either an IRR calculator available on the Internet, or the standard IRR formula: 0 = - outlay + DCF1/(1+r)^1 + DCF2/(1+r)^2 +(etc)+ DCFn/(1+r)n, where outlay stands for the initial investment, DCF1 stands for first difference in cash flow, and DCFn stands for the last cash-flow difference period.
Press "Calculate" on the IRR calculator, or type the completed equation into a calculator and press "Enter."
Round the generated value, which is either the output value of the online calculator or the term "r" in the formula. This will produce the crossover rate in terms of percentage.
Tips and warnings
- Use the online calculator to save time and get a more accurate result.
- Crossover rates should not be used in lieu of proper investment advice.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for