Calculate IRR in Excel (Formula, Examples) | IRR Calculation in Exceladmin June 29, 2020 6 Comments
In this video on IRR in Excel. We are going to discuss the IRR Formula in excel and how to use the IRR function in Excel along with practical IRR calculation examples.
𝐈𝐑𝐑 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
IRR in excel stands for Internal Rate of Return. This is one of the built-in functions available in MS Excel. This comes under the category of Financial Functions.
𝐈𝐑𝐑 𝐅𝐨𝐫𝐦𝐮𝐥𝐚 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
= IRR (range, [guess])
𝐑𝐚𝐧𝐠𝐞: is a required parameter. A range of cells that denote the series of cash flows for which the Internal Rate of Returns would be calculated.
𝐆𝐮𝐞𝐬𝐬: is an optional parameter. It denotes a number that you guess is close to the result of internal rate of return. If no value is mentioned, it takes the default value as 0.1 or 10%
“[ ]” denotes optional parameters