• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

PropertyMetrics

  • Home
  • Blog
  • Products
    • Proforma Software
    • Publisher Software
    • Courses
  • Sign In
    • Software Login
    • Courses Login
  • Contact Us
  • Build a Proforma

Simple MIRR Calculator

The Modified Internal Rate of Return (MIRR) is an important return metric that fixes the problems associated with the Internal Rate of Return (IRR). As such, the MIRR is metric that finance professionals must understand. This simple MIRR calculator is based on Excel and makes it easy to quickly calculate and visualize the MIRR for any set of cash flows.

 

MIRR Calculator

Fill out the quick form below and we'll email you our free MIRR Calculator that can handle any set of cash flows you need to analyze.

 

How to Use The MIRR Calculator

Here is how you can use this MIRR calculator, step by step.

  1. Download the MIRR calculator using the form above.
  2. Adjust the number of periods you want in your holding period.
  3. Input your cash flows.
  4. View the calculated MIRR

As you can see, we’ve made it simple to use our MIRR calculator.

 

MIRR Calculator Example

Let’s walk through a simple example using this MIRR calculator. Suppose we have the following cash flows:

MIRR Calcultor

As you can see there are 3 different internal rates of return calculated for this set of cash flows. To solve this problem we can instead use the modified internal rate of return to analyze these cash flows. Here’s how this is done with our modified internal rate of return calculator:

MIRR Calculator

As you can see, the projected cash flows result in an MIRR of 6.50%. This assumes a safe rate of 5% and a reinvestment rate of 10%. This 6.50% MIRR allows us to set our reinvestment and finance rates, which will produce a more reliable rate of return. Also, the MIRR can easily solve the multiple IRR problem.

 

MIRR Calculator

Fill out the quick form below and we'll email you our free MIRR Calculator that can handle any set of cash flows you need to analyze.

Primary Sidebar

What is PropertyMetrics?

PropertyMetrics provides web-based software for commercial real estate analysis and presentation.

Recent Posts

  • How the Development Spread Works
  • Understanding the Texas Ratio
  • Understanding the Construction Draw Schedule
  • How The Double Net Lease Works
  • How to Calculate an Interest Reserve for a Construction Loan

WHAT OTHERS ARE SAYING

"I'm a 30+ year seasoned veteran in shopping center development. PropertyMetrics is an excellent source of information with professional grade software for analysis and presentation. I highly recommend it."
- Frank C. Guess | Barnhart Guess Properties, LLC


"PropertyMetrics is very helpful in my understanding of commercial real estate. The presentation and information provided is astute and always to the point with great clarity. PropertyMetrics is truly appreciated."
-Sheriar Khorsandian, CCIM | Osceola Partners, LLC


"I am very impressed with your product. I have to also compliment your company on clearly explaining valuation concepts to me. To put this into context, I asked my professor in my investment class last week if he knew of a way to value an income property using discounted cash flow analysis. Long story short...you guys are smarter than my professor. THANKS PropertyMetrics! "
-Jonathan Torres | College Student


"I want to compliment PropertyMetrics for providing clear and concise tools for analyzing commercial real estate. As the head of a local Taxpayers Association with a considerable amount of municipal real estate, your data provides me with the information needed to show how much current lease terms cost the town in lost revenue, making my task much easier. Thank you!"
-Jerome Scott | Taxpayers Association of Jamestown


I am a professor at NYU's real estate program and I always tell my students that PropertyMetrics has the best and most easily understood explanations of real estate concepts. Great job!!!"
-J. Weinberg, Adjunct Professor | New York University


"I want you to know how much I appreciate PropertyMetrics. As a 30 year real estate attorney focusing primarily on commercial leasing and purchase and sale of commercial properties, it is extremely helpful to see the principles I have learned and used for so many years explained so clearly."
-Jon K. Ladd | Business and Real Estate Law Group


"I am commercial real estate lender for a large regional bank and I recommend PropertyMetrics to everyone."
-Andrew Levin | Commercial Lender


"Frankly, since I have been getting your emails we have one of the best educated offices in our market!"
-William C. Colucci | Associate Real Estate Broker


"PropertyMetrics is awesome. I actually just went ranting and raving about it to a few other analysts at my company and everyone has been thanking me for referring them!"
-Richard Cadena Jr. | Analyst


"PropertyMetrics is great. Invaluable."
-Peter Knobloch | President/CEO

Footer

My Account

Software Login

Courses Login

Contact Us

Do you have questions, comments, or feedback? Drop us a line and let us know. Get in touch.

Get Our Best Content First

Solutions | Blog | Resources | Contact | Terms | Privacy

Copyright © 2021 PropertyMetrics.com

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OK