All resources related to IRR for Excel and Google Sheets.

All articles
IRR

Learn how to Calculate Your Money Weighted Rate of Return in Excel

Before we look at how to calculate your money weighted rate of return in excel, it is important to first understand what it means. What is money weighted rate of return? This is simply a measure of the performance of an asset or portfolio of assets. To calculate the weighted...

Here is How You Can Calculate the Quartlery IRR in Excel

Excel allows a user to get the quarterly internal rate of return of an investment using the XIRR function. With defined quarterly periods, we will get the exact IRR. This step by step tutorial will assist all levels of Excel users to learn how to calculate the quarterly IRR in...

Learn How to Solve Issues with a Multiple IRR in Excel

Excel allows a user to manipulate with multiple internal rates of return using the IRR function. Multiple IRR occurs when there is a cash flow project with cash outflow. This step by step tutorial will assist all levels of Excel users to learn how to solve issues with a multiple...

What is the Difference Between the IRR and XIRR Functions in Excel?

Excel allows a user to get an internal rate of return of an investment with returns occurring at regular or irregular intervals. If we want to use regular intervals we should use the IRR function. If we want to calculate for irregular intervals, then we need the XIRR function. This...

Learn How to Calculate an IRR with a Terminal Value in Excel

Excel allows a user to calculate an IRR with a terminal value using the IRR function. This step by step tutorial will assist all levels of Excel users in getting an IRR of the free cash flow with the terminal value. Figure 1. The result of the IRR function Syntax...

How to Calculate the IRR in Excel When Cashflow Timing is Uneven

Excel allows a user to get an internal rate of return of an investment when the returns timing is uneven using the XIRR function. If we want to calculate an internal rate where returns occur at regular intervals, we need to use the IRR function. This step by step tutorial...

Learn How to Find the Equity IRR for a Project in Excel

Excel allows a user to get an internal rate of return of an investment using the IRR function. This step by step tutorial will assist all levels of Excel users in getting an IRR of an investment. Figure 1. The result of the equity IRR function Syntax of the SUM...

How to Find the Modified Internal Rate of Return in Excel

Excel allows a user to get a modified internal rate of return of an investment using the MIRR function. This function includes a discount rate and reinvestment rate in the calculation. This step by step tutorial will assist all levels of Excel users in finding a modified internal rate of...

Learn How to Calculate NPV and IRR in Excel

Excel allows a user to get an internal rate of return and a net present value of an investment using the NPV and IRR functions. This step by step tutorial will assist all levels of Excel users in calculating NPV and IRR Excel. Figure 1. The result of the NPV...

Can You Use Excel to Display a Negative IRR?

Excel allows a user to get a negative internal rate of return of an investment using the IRR function. This step by step tutorial will assist all levels of Excel users in displaying a negative IRR. Figure 1. The result of the IRR function Syntax of the IRR Formula The...