• Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to Use the IRR Function to Calculate Internal Rate of Return in Excel

0 Comments

How to Use the IRR Function to Calculate Internal Rate of Return in Excel: The IRR function is used to calculate the internal rate of return of a cash flow series to evaluate the profitability of an investment or project. This article will guide you on how to use the IRR function in Excel.

1. IRR Function Syntax

The syntax of the IRR function is as follows: =IRR(values, [guess])
Where:

  • Values: Required argument. It is an array or references to cells containing cash flow data. The initial investment value should be negative. The subsequent values represent annual profits of the project. Note that these values should be in chronological order.
  • Guess: An estimated percentage close to the IRR result, usually defaulted to 10%.

Note:

  • Values must contain at least one negative value and one positive value.
  • The IRR function uses the order of values as the order of cash flows. Therefore, it’s important to enter payment or income sequences correctly.
  • The IRR function only calculates numeric values within arrays or references of values; empty cells, logical values, text, or error values will be ignored.
  • Excel uses iteration in the IRR calculation. Starting with the guess, IRR iterates until the result is accurate within 0.00001%. If IRR cannot reach a result after 20 iterations, it returns the #NUM! error value.
  • The IRR function has a close relationship with the NPV function because the interest rate returned by IRR is the rate at which NPV equals zero.

2. Using the IRR Function

For example, let’s consider an investment project with an initial cost of 100 million at the beginning of the project. The revenue, expenses, and profits of the project over 5 years are shown in the project analysis table below. We need to calculate the IRR for each year of the project.

How to Use the IRR Function to Calculate Internal Rate of Return in
In the analysis table, we can see that the initial investment cost of the project is 100,000,000. In the IRR calculation, this value should be negative because it represents an outgoing cash flow.

The annual profit of the project is positive numbers. In the IRR calculation, these values should be positive as they represent incoming cash flows.

The IRR formulas for each year are as follows:

  • Year 1: =IRR(G5:G6) = -73%
  • Year 2: =IRR(G5:G7) = -32%
  • Year 3: =IRR(G5:G8) = -8%
  • Year 4: =IRR(G5:G9) = 6%
  • Year 5: =IRR(G5:G10) = 15%

Therefore, after 4 years, the project becomes feasible when the IRR is positive.

How to Use the IRR Function to Calculate Internal Rate of Return in Excel

How to Use the IRR Function to Calculate Internal Rate of Return in Excel

That’s it! This article has guided you on how to use the IRR function to calculate the internal rate of return in Excel. Good luck with your calculations!

3
54 Views
How to Use the PMT Function to Calculate Periodic Loan Payments in ExcelPrevHow to Use the PMT Function to Calculate Periodic Loan Payments in ExcelMay 22, 2023
How to Convert Columns to Rows (and Vice Versa) in ExcelMay 22, 2023How to Convert Columns to Rows (and Vice Versa) in ExcelNext

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $11.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.