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

How to Calculate Aspect Ratio.
Aspect ratio is an image projection attribute that describes the …

How to Calculate Aspect Ratio.

How to Calculate Flow Rate.
Flow rate is the measure of a volume of liquid …

How to Calculate Flow Rate.

Leave a Reply Cancel Reply

Popular Posts

    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 © 2023 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