IRR calculation 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 request 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; if you have any comments, let me know through the comment section below.
Also, you can download the IRR calculation Workbook for free from the below link.
Why we don?t use Excel?s MIRR formula?
IRR Calculation in Excel: Formulae and Use
Are you someone involved with real estate feasibility?
We are excited to launch the next generation of real estate feasibility software by April 2023.
claim your 15% early-bird discount
Know more about the product features
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