### Calculating Internal Rate of Return

The **internal rate of return (IRR)** is the calculation of the discount that would make the net present value of the cash flow from an investment equal to that of the investment. Since future values of money are adjusted to get a present value, the IRR calculation provides the rate of interest that needs to be earned so that the cost of the investment equals the adjusted cash flow.

Vision Inc. is going to make a $100,000 investment that will yield $60,000 per year for four years. Present value is the value in current dollars of a future payment discounted to the present and based on the required investor's return. The weighted average cost of capital (WACC) is used as the rate of return of 7 percent for the PV calculations. **Weighted average cost of capital (WACC)** is the formula for determining the relative average a company is expected to pay to all its security holders to finance its assets. Spreadsheets use an iterative formula, which means that the computer "guesses" an answer for the IRR, tests it in the NPV equation, and then makes another guess based on the amount it is off by. It continues to do this until it gives a rate where the cash flow equals the investment. In this example, the IRR is 47 percent.

#### IRR Calculations Using Spreadsheets

### Internal Rate of Return as Applied to Decision-Making

The **internal growth rate** is the maximum projected increase a company can sustain without getting outside financing such as loans and without selling bonds or stock. It is a percentage that uses only the company's sales and profit, not debt or stock issuance. Internal rate of return (IRR) analysis uses internal growth rate and weighted average cost of capital (WACC) as two benchmark figures. Since the internal growth rate is the normal expected rate of progress in a company, an IRR larger than the internal growth rate means that the investment will accelerate the overall growth of the company, adding value with the investment. The WACC is the minimum return ratio that the company must maintain to pay existing liabilities. An IRR greater than the WACC indicates that the investment will add value since it will generate greater cash flow over outflow at a rate higher than the company's current capital structure.

The IRR has a few disadvantages that make it a poor choice as a standalone analysis tool. The IRR assumes that the income from the new investment will be reinvested back into the project at the same rate. This is unlikely, since money will be pulled as part of general operations. Analysts will use a modified internal rate of return (MIRR), which removes the reinvestment component by using a risk-free rate, significantly lowering the IRR. If Vision Inc. has an IRR of 47 percent, the MIRR would be 25 percent. Another limitation of IRR is that it does not give cash flow. If Vision Inc. is reviewing two investment options, both greater than the WACC and the internal growth rate, it can conclude that both investments will add value, but it cannot say that the investment with the higher IRR is the best investment. IRR does not indicate cash flow, so it is often used in conjunction with the NPV.