IRR calculation in Excel can be done very easily. It can be calculated using three different formulas - IRR, XIRR and MIRR. We have discussed the syntax and specific use of each formulas in a previous post.
On the requests of our readers we did a video on IRR calculation in Excel. It is posted on YouTube on our channel and also embedded here.
Hope you enjoyed this video on IRR calculation in Excel; if you have any comment, let me know through the comment section below.
Also you can download the IRR calculation in Excel Workbook for free from the below link.
Further Readings:
Why we don?t use Excel?s MIRR formula?
IRR Calculation in Excel: Formulae and Use
progect 1 house, investment 300k
Loan 650k commissions 60k at closing with buyer money, total cost 1M sale 1.2M profit 200K, duration 2 years
IRR?