How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
rate
How to Calculate IRR in Excel.
rate

How to Calculate IRR in Excel.

Rosemary Njeri

IRR is short for internal rate of return.

The internal rate of return is a metric used in financial analysis to estimate the profitability of potential investments.

Calculating the IRR will show if your company made or lost money on a project and if the project was worthwhile.

Formula to calculate IRR in excel.

Just like other functions, the IRR function is also available in excel.

=IRR(X1:Xn)

Example:

Lets consider a project whose useful life was 4 years.

PeriodCash flow
Initial Investment-70,000
Year 110,000
Year 230,000
Year 320,000
Year 415,000

We first of all need to transfer the data to an excel spreadsheet.

 Calculate IRR in Excel.

Then in the financial formulas section, find the IRR function and once you click on it something like this should appear.

Calculate IRR in Excel.

Put in the numbers you wan to calculate IRR for, in this case, its (B2:B6) and your answer should be generated in percentage form of course if you have formatted cells and put percentage.

Calculate IRR in Excel.

Therefore, your IRR is 2.77%.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

Calculate Principal from Interest.
Principal amount on a loan is the amount borrowed. The …

How to Calculate Principal from Interest.

Calculate Double Declining Balance.
The double declining balance (DDB) method of depreciation, also known as …

How to Calculate Double Declining Balance.

Leave a Reply

Cancel reply

Popular Posts

  • How to Calculate Degrees of Unsaturation.
    January 6, 2021 0
  • How to Calculate Buoyant Force.
    January 6, 2021 0
  • How to Calculate Stairs.
    January 6, 2021 0

Categories

learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

How To Calculate

Learn how to calculate anything

Pages

  • About Us
  • Contact Us
  • Privacy Policy
Copyright © 2021 How To Calculate

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh