Excel MIRR vs IRR

When looking to compare similar projects tools such as IRR and MIRR are used. But what's the difference between these two when used for capital budgeting ranking? A major difference is that for IRR the cash inflows are reinvested at the project's IRR, while the MIRR is using an alternative re-investment rate for the cash inflows. The video covers the basics of how to use the Excel IRR and MIRR functions.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@wayneedmondson1065]

Thanks Doug! Great tips on the difference between IRR() and MIRR(). Thumbs up!!

[@DougHExcel]

Thanks for watching Wayne!

[@bharathikannan8941]

Good one....

[@DougHExcel]

Thank you! Cheers!

[@MWacad]

Quick questions. Why doesn't changing finance_rate number result in changing the MIRR? Although when I change reinvestment_rate number I can see reflection in the MIRR result.

[@yousfinassima7845]

Bonsoir,
Vous allez trop vite pour expliquer!

[@DougHExcel]

j'apprécie les commentaires. Merci de regarder la vidéo.