Tag: IRR

Internal rate of return (IRR) analysis allows to compare and rank different projects vs. their cost of capital

Commercial Real Estate Excel model which generates the cash flows of the project as well as for equity investors and calculates the relevant metrics (debt yield, debt service coverage ratio, cap rates, and interest coverage…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Financial model template for a high-level real estate brokerage firm that facilitates the buying and selling of real estate properties between buyers and sellers. Providing a sound financial plan and 5-yrs worth of financial projections…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

This is a collection of financial model templates for businesses in the Education Industry as well as its related sectors.

Price: $49.00
Add to wish list
$49.00 – Purchase Excluding 7.7% tax

This is a collection of financial model templates for projects or ventures in the Renewable Energy Industry and its related sectors.

Price: $77.00
Add to wish list
$77.00 – Purchase Excluding 7.7% tax

Internal Rate of Return (IRR)

The internal rate of return or also known as the IRR is the interest rate at which the net present value (NPV) of all the cash flows from a project equal zero. The term internal was derived from the fact that it excludes external factors such as inflation, cost of capital, or other various financial risks. In other words, the internal rate of return is the expected rate of return that will be earned on a project. It is usually used to evaluate if the project or investment is attractive. Basically, if the IRR of a new project exceeds a company’s required rate of return then that project is desirable, otherwise, the project is not worth it.

Another way of calling the internal rate of return of a project or investment is the “annualized effective compounded return rate” which sets the NPV of all cash flows, both positive and negative, from the project equal to zero. Therefore, it is the interest rate at which the NPV of the forecasted cash flows is equal to the initial investment and also it can be the discount rate at which the total present value of expenses (costs) equals to the total present value of the positive cash flows. Basically, the IRR is designed to account for the time preference of money and investments since a given ROI (return on investment) is worth more at a given time compared to the same amount of return received at a much later time.


Types of IRR for Different Types of Cash Flows

The internal rate of return is a time value of money metric which represents as the true annual rate of earnings on an investment. Depending on the type of cash flow of a project, there are different types of IRR that can be calculated, such as:

  1. Unlevered IRR – also known as the unleveraged IRR or Project IRR, is the internal rate of return of a string of cash flows without financing or the Free Cash Flow to Firm (FCFF). It takes its inflows that are needed to fund the project without accounting any debt or funding used for the project. Before accounting any funding from the outside sources, it is better to evaluate the project’s own feasibility by calculating the unlevered IRR. Therefore, it is usually recommended to determine the Unlevered IRR before proceeding with Levered IRR to check if the project is financially healthy or not.

  2. Levered IRR – also known as the leveraged IRR or Equity IRR, is the internal rate of return of a string of cash flows with financing included or the Free Cash Flow to Equity (FCFE) which means cash flows available for equity holders. Instead of using its inflows as funding, it takes account debt or funding to use for the project. The outflows are considered as cash flows from the project minus any interest and debt repayments. Basically, it is a case where the project is funded by a mix of debt and equity.

  3. Investor IRR – also known as the Cash in / Cash out to investor where the cash in represents the investment provided and the cash out represents the dividends or the sale of the investment. The investor IRR is basically exclusive for investors to calculate the share they’ll get according to the amount of investment they poured into the project.

To determine if the project is attractive, one must first calculate the unlevered IRR to check if the project is able to sustain itself without the help of outside funding and after step financing, one will then proceed with calculating the levered IRR to determine if the project can do better and higher IRR with funding provided.


Uses of Internal Rate of Return

There are many uses of internal rate of return, such as the following:

  • Determining the Profitability of a Project or an Investment. Usually, IRR is used in capital budgeting for corporations to compare the profitability of capital projects. To evaluate if a certain project will yield more than the costs of running the project, or to determine which project will yield more based on the IRR. To ensure maximizing the returns, the higher a project’s IRR is, the more attractive it is to proceed with the project. In cases where there are multiple projects, the ones with the highest IRR will be considered first.

  • To Maximize the Net Present Value as an indication of profitability, efficiency, quality, or yield of an investment. Though there are similarities between the IRR and NPV, the latter is more of an indicator of the net value added by making an investment. By applying the IRR method, any investment would be accepted because if the IRR exceeds the cost of capital represents that the project or investment has a positive net present value.

  • To Calculate the Fixed Income (calculating yield to maturity and yield to call).

  • Measuring new debt in terms of yield to maturity which often is used when a company raises a new debt for funding new projects. Since both IRR and NPV are applicable to liabilities as well as investments, in this case, the lower the IRR is, the more preferable it is for the company.

  • Evaluating share issues and stock buyback programs for corporations. This is in case the company wants to proceed with repurchasing their stocks and if the returning capital to the shareholders has a higher IRR that the candidate capital investment projects.

  • Used for Private Equity from the limited partner’s perspective, to measure the general partner’s performance as an investment manager. The IRR is used since it’s the general partner that controls the cash flows including the draw-downs of committed capital.

  • Analyzing projects or investments for private equity and venture capital which involves multiple investments over the life of a business and cash flow at the end through the sale of the business.

  • Determining the returns of the projects or investments and to compare or rank multiple projects based on their expected yield to prefer the ones with a resulting higher IRR.

  • To better understand and know of any user’s risk tolerance, investment needs, avoiding risky investments/projects, etc.


How to Calculate Internal Rate of Return

To calculate the internal rate of return, the expected cash flows of a project must be provided and the NPV must equal to zero. The formula below shows how to calculate the IRR:

For example:
A company is deciding whether to purchase an equipment for $400,000. The equipment would only last for 3 years but it is expected to generate annual profit for $200,000. After the equipment reaches its end, the company plan to salvage it and expects to receive about $20,000. By using IRR, the company can determine whether to make use of its own cash rather than go for investment options, which should return about 10%.

Here is how the IRR calculation looks like according to the drawn scenario above:

0 = -$400,000 + ($200,000) / (1 + r) + ($200000) / (1 + r)^ 2 + ($200,000) / (1 + r)^3 + $50000 / (1 + r)^4

The investment’s IRR will serve as the rate that makes the present value of an investment’s cash flows equal to zero. If the resulting rate is greater than the expected 10% then it can be said that the investment is feasible.