The fastest, "back-of-the-envelope" trick for estimating Internal Rate of Return (IRR) is the Rule of 72, specifically for investments that roughly double in value: divide 72 by the number of years. For more complex scenarios, use the 75-80% of the total return rule, or use the Excel {Link: =IRR(range) https://www.youtube.com/watch?v=HgWHogdFUc4} function for accuracy.
So the rule of thumb is that, for “double your money” scenarios, you take 100%, divide by the # of years, and then estimate the IRR as about 75-80% of that value. For example, if you double your money in 3 years, 100% / 3 = 33%. 75% of 33% is about 25%, which is the approximate IRR in this case.
To use the rule, you simply divide 72 by the expected annual rate of return (expressed as a percentage, not a decimal). The result is the approximate number of years it will take for your investment to double.
What Is The Best Explanation Of IRR? The Internal Rate of Return (IRR) is a financial metric that calculates an investment's annual growth rate. It determines the percentage return where the net present value of cash flows equals zero. IRR helps investors assess project viability and compare investment opportunities.
(8) Can IRR be manipulated? Yes, IRR can be influenced by the timing of cash flows. For example, early large distributions can artificially inflate IRR, even if the subsequent returns are minimal. This is why it's important to consider IRR alongside other metrics like TVPI.
The manual calculation of the IRR metric involves the following steps: Step 1 ➝ Divide the Future Value (FV) by the Present Value (PV) Step 2 ➝ Raise to the Inverse Power of the Number of Periods (i.e. 1 ÷ n) Step 3 ➝ From the Resulting Figure, Subtract by One to Compute the IRR.
The "90-90-90 rule" in trading is a harsh reality check stating that 90% of new traders lose 90% of their money within the first 90 days, highlighting the high failure rate due to emotional decisions, poor risk management, and lack of education/strategy. It serves as a cautionary tale, emphasizing that success requires discipline, a solid trading plan, continuous learning, and strict risk control (like risking only 1-2% per trade) to avoid the common pitfalls that wipe out most beginners.
The formula for XIRR is: XIRR = (NPV of Cash Flows / Initial Investment) × 100. The ideal XIRR varies based on the type of fund and individual financial goals. For example, a conservative debt fund might target an XIRR of 5–6%, while an aggressive small-cap fund may aim for 12–15%.
The Internal Rate of Return (IRR) rule is a financial scale used to assess investment viability, indicating that a project is acceptable if its IRR exceeds the cost of capital and should be rejected if it falls below the benchmark.
"12% IRR" means the Internal Rate of Return for an investment is 12%, indicating it's expected to yield an average annual return of 12%, making all future positive cash flows equal in present value to the initial investment, essentially representing the compound growth rate of the investment. It's a key metric for deciding if an investment is profitable, with a 12% IRR suggesting the project breaks even (Net Present Value is zero) at that rate, so it's attractive if your required return is below 12% and less so if it's higher.
The table below shows the present value (PV) of $50,000 in 20 years for interest rates from 2% to 30%. As you will see, the future value of $50,000 over 20 years can range from $74,297.37 to $9,502,481.89.
The rules of 72 and 115 provide a quick way of seeing the value and speed of compounding. These are short cuts to determine how long it takes compounded money to double and triple. To calculate how long it takes money to double, divide the interest rate into 72. To see how long money triples, divide it into 115.
"22 IRR" means an investment is expected to yield an Internal Rate of Return (IRR) of 22%, representing the annualized rate of profit where the present value of future cash inflows equals the initial investment, making it a measure of profitability often compared to a company's cost of capital or hurdle rate. For many investors, especially in private equity or real estate, a 22% IRR is considered a strong return, signaling a potentially good investment opportunity.
Using the IRR function in Excel makes calculating the IRR easy. Excel does all the necessary work for you, arriving at the discount rate you are seeking to find. Enter Cash Flows: In an Excel spreadsheet, list all the cash flows associated with the investment or project.
XIRR is that single rate of return, which when applied to every installment (and redemptions if any) would give the current value of the total investment. XIRR is your personal rate of return. It is your actual return on investments.
Common Mistakes to Avoid While You Calculate XIRR
Formula for the Rule of 72
To calculate the time period that an investment will double, divide the integer 72 by the expected rate of return. The formula relies on a single average rate over the life of the investment.
Some have interpreted this to mean investing 70% of a portfolio in stocks and 30% in bonds, although work-outs seem to suggest special situations, which differ from bonds. Either way, Buffett has given different investment advice to investors based on their experience.