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

  • Asked By
  • Updated On:
    05-Feb-2021
  • Replies:
    2

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 for FREE, Get quick answers from our FINTRAKK community!
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 intrinsic value of stock and how it is calculated?

Intrinsic value basically means real stock value and can be calculated using these three ways:

  • Discounted cash flow analysis
  • Analysis based on financial metric
  • Dividend Discount method
Which is better FD vs. Mutual Fund vs. Real Estate Investment?

FD vs Mutual Fund vs Real Estate Investment has its advantages in terms of how much you invest and your investing period. Longer the period, higher the returns.

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.

How much money can you make as an Options Seller?

Option Selling can be considered as a full-time business for traders. Similar to a business, you cannot expect extraordinary returns in options selling. You, as an options seller have an edge over option buyers and the chances of making money are higher. Know how much money can be made by selling Options.

What is YTM in bonds?

YTM or yield to maturity is an effective way to find out the exact return that a bond offers when held till maturity. The YTM of bonds changes with the change in the purchase price of the bond. Even if a bond has a fixed coupon rate payable on the face value, the effective yield depends on at what price one purchases it.

Which is the best investment plan in India for 1 year?

The best investment plans in India for a year are to invest in fixed deposits, short-term funds, and ultra-short-term funds. These are less risky and produce relatively higher returns than banks.

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.

Is it a good time to invest in stocks? Bullish Stock Market

There are several questions that one can ask your advisor. These questions include whether its good time to enter or exit the market? Should in exit from debt and move to FD? do I continue my SIP portfolio? and other such questions.

Which is the best investment plan for monthly income?

There are several investment plans such as FD, Post office Monthly Savings Scheme, Government Bonds, Mutual Fund Monthly Income Plans. These can provide you with a very good monthly income.

Which is best Monthly Income Plan for Senior Citizen in India?

Several monthly income plans available such as senior citizen fixed deposit, senior citizen savings scheme, post office monthly income scheme, tax-free bonds, debt funds, and many more are the best monthly income place for senior citizens in India.