Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
MIRR
When it comes to evaluating investments in Excel, most people immediately jump to the familiar NPV and IRR functions. While these are incredibly powerful, they can lead to incorrect conclusions if we don’t fully understand how they work, especially when cash flows vary or are irregular. In this post, we’ll walk through six powerful finance…
Read More
When it comes to evaluating the performance of investment opportunities in Excel, many of us start with the IRR (Internal Rate of Return) function. While helpful, it carries assumptions that don’t always fit real-world situations … especially when financing costs or different reinvestment options are involved. That’s where MIRR (Modified Internal Rate of Return) becomes…
Read More