IRR Function in Excel – Internal Rate of Return

Whenever a business is willing to invest in a project, it makes sure if it is a profitable investment or not. Let us say project A has 10% IRR whereas Project B has 12% IRR. A business would always invest in a project that has more IRR i.e Project B. In Financial Analysis, IRR is important to understand before investing in any project. In this tutorial, we would cover the function called the IFF formula to find the internal rate of return in excel.

Here we go 😎

When to Use IRR Function of Excel

The word IRR represents the “Internal Rate of Return”. The IRR formula in excel calculates the internal rate of return (IRR) for an initial investment. IRR refers to that rate of return where the present value of the series of cash flows equals the initial investment amount. It is that value where the NPV is zero. This function helps us to compare between different investments or projects.

IRR Function comes in the category of Financial Functions of Excel.

Syntax and Arguments

=IRR(values,[guess])

The below points contain a description of function arguments for the IRR Formula.

• values – This is the investment and a series of cash flows after investing money. The first value would specify the initial investment while the next values would specify the cash flow after 1 year, 2 years and so on.
• [guess] – This is an optional function argument. The [guess] is our guess about the IRR. If we do not specify the guess, Function assumes it as 0.10 or 10%.

Must to Know Points About IRR Function of Excel

The following points about IRR Function should be kept in mind before using the actual Function.

• IRR is the percentage of Discount rate making the net present value zero.
• Initial Investment is negative as it the cash outflow. After which, the cash flows will either be negative or positive depending on the outflow or inflow of cash.
• The Future cash inflows will have less value at present. In other words, we can say that \$1000 in 2023 would not be worth same as \$1000 in 2021. The future cash is discounted at a rate to get its present value. The percentage is called as Discount rate.
• Net present value is the sum of negative investment and present value of positive/negative cash flows in the coming years.
• The input parameter must contain at least one negative and one positive value to get the result of IRR Function or else it returns a #NUM! error.
• Any text, logical value, empty cells will be ignored when passed as the function arguments.
• The NPV and IRR both play an important role in comparing the Projects for investing money. A positive NPV would mean that the rate of return is more than the discount rate.

PMT PPMT IPMT Functions of Excel – Usage

The PMT, PPMT, and IPMT functions in excel are the three financial formulae in excel. These three function are quite related to each other. While taking any loan, you may be choosing which loan works best for you. What would be the interest? Does the loan provider charges weekly interest rate, monthly interest rate, or annual interest. What is going to be the interest amount that I would be paying once the loan is paid? All these questions will be answered by the combination of PMT, PPMT and IMPT formula in excel.

Let us see how these functions works. Here we go 😎

When to Use PMT, PPMT, IPMT Function of Excel

The word PMT stands for “payment” for each period. The PMT function of Excel gives the total payment (principal amount + interest money) which we need to pay when taking a loan or we receive on investment.

The word PPMT stands for “Principal Payment” for each period. The PPMT function of Excel gives the principal amount of money from the total payment transacted at the end or beginning of the period. If we took a loan, then the Interest amount will start decreasing with the coming periods whereas the principal amount is paid more to get the loan settled. This concept is explained in more details in the upcoming examples.

The word IPMT represents “Interest Payment”. The IPMT function of excel returns the amount that will be paid as interest. When we take a loan, we return the principal amount with the interest money in the coming periods. The interest lowers down as the money we took for a loan is getting returned in installments, reducing the amount on which we are paying the interest money.

The three functions are a part of Financial Functions of Excel.