What is IRR or Internal Rate of Return Formula in excel? IRR Meaning

Short Answer

IRR or Internal rate of return is the expected rate of return on an investment or project. The rate of interest at which future cash flows are discounted so that NPV of those cash flows is zero. It is also referred to as Discounted cash flow rate of return.

Detailed Answer

This is normally useful while comparing one investment with other. For calculating IRR:

  1. You are provided the expected cash flows of a project/investment
  1. NPV = O (zero)
  1. Initial cash investment= Present Value of Future Cash Flows for that investment i.e. Cost paid= PV of future cash flows. Hence, the NPV= 0

There is an easy way, not getting into too much details, here's IRR or Internal rate of return formula in excel:

Just click on the Formula bar > Financial > IRR

A pop-up window will open where you need to fill following details:

  1. Values i.e. a reference to the cells for which you wish to calculate IRR and
  1. Guess i.e. a number close to the IRR result. If not given, it is assumed to be 10% only.

The result shall be displayed immediately.

After calculating IRR or Internal rate of return, it is compared to company's cost of capital.

  • If IRR>=Cost of capital: the company shall prefer to accept the project.
  • If IRR< Cost of capital: the company shall not accept it.
Tagged With: irrinternal rate of returnirr meaningirr formula
Categories: Investment
Ask your query and our expert community would be happy to help
Discussion (1)

    IRR function in excel has made it quite easy to calculate Internal rate of return. Just give the required range and details, there you go. We can grab a quick answer and avoid doing lengthy calculations on our own. I remember how we used to learn the formula and actually calculate it. Thanks to MS Excel and this fintech world for making complicated things simpler.

Related FAQs

What is a good Rate of Return on investments (ROI)?

A good return on investment is where a person makes considerable profits form their investments after a long period. However, the profits can vary form one person to another.

Where to invest money for good returns in India? High Return Investments

We all look to earn good returns on the money we invest. Putting money in High return investments is one way of generating better income. The different places to get good returns are mutual funds, equity, and gold investment in India.

What is difference between Fixed Deposit vs Mutual Fund? Meaning

Fixed Deposit (FD) are saving tools offered by banks to deposit lump sum amount for a fixed period of time on a higher interest rate than saving accounts. Mutual funds are investment products which pool money from numerous small investors to create a fund.

What are things to remember while filing your Income Tax Return?

There are plenty of things that should be kept in mind while filing your tax returns. These include sources of income, necessary documents, choosing the right form, filling in the correct details, tax liability, switching jobs report, TDS deduction, filing before the deadline and much more.

What are arbitrage Funds? Meaning, Taxation

Arbitrage Funds are mutual funds with an objective to profit from inefficiency in the price of securities in two different markets. We look at their taxation, meaning and difference with liquid funds in this post. The fund invests in equity and debt instruments.

What is the best way to get 15% p.a. return on investment?

There are multiple avenues through which a 15% p.a. return on investment can be made. These are through equity, mutual funds, fixed deposits, government bonds, and schemes, etc.

What is the formula for shares allotment in an IPO?

If a lot of investors show their interest in an IPO, then it is allocated through lottery and in case of a small number of potential investors SEBI defined norms are followed.

What is Mutual Fund? Meaning

A Mutual Fund is an expertly overseen speculation subsidize that pools cash from a few speculators to purchase protections. These financial specialists could likewise be retail or institutional in nature.

What are Liquid Funds? Meaning & Details

Liquid funds, a type of mutual funds which invest in different money market instruments. The withdrawals from these funds are processed within 24 hours and that's why these are regarded as liquid assets. The fund manager gets flexibility to meet immediate redemption requests.

What is Fixed Deposit? Meaning & Types of Fixed deposits in India

A fixed deposit is quite a common investment option provided by banks to help boost our savings. You deposit certain sum of money with the bank and earn interest on it. However, there are many types of fixed deposits or FD's. To learn more, we have useful details provided it here.