MIRR Google Sheets Formula - Function, Examples, How to Use
Tools
Pricing
Log in
Try for free

Convert your text instructions into Google Sheets formulas - powered by AI.

Syntax
Example Use Case
Generate
Explain

What is a MIRR?

The MIRR (Modified Internal Rate of Return) function in Google Sheets is a financial function used to calculate the profitability of an investment by considering the cost of financing and the reinvestment rate of cash flows. Unlike the traditional IRR function, MIRR provides a more accurate reflection of an investment's profitability by accounting for the cost of capital and the returns on reinvested cash flows.

In simpler terms, MIRR helps you evaluate the potential return on an investment by factoring in both the costs and the returns, making it a valuable tool for financial analysis.

A Practical Example

Imagine you are evaluating a project with the following cash flows over a 5-year period:

Cash Flows Table:

Year Cash Flow
0 -100,000
1 30,000
2 40,000
3 50,000
4 20,000
5 10,000

You also have the following rates:

  • Finance Rate: 10%
  • Reinvestment Rate: 8%

MIRR Formula

To calculate the MIRR for this project, you would use the MIRR function as follows:

EXCEL icon EXCEL
=MIRR(A2:A7, 10%, 8%)

In this formula:

  • A2:A7 is the range containing the cash flows.
  • 10% is the finance rate, representing the cost of capital.
  • 8% is the reinvestment rate, representing the rate at which cash flows are reinvested.

Result of the Formula

When you apply the MIRR formula to the cash flows, you would get a result that indicates the annualized return of the investment. For example, if the MIRR calculation returns 7.45%, it means that the project is expected to yield an annual return of 7.45% after accounting for the cost of financing and reinvestment.

Why Use MIRR?

MIRR is beneficial because it provides a more realistic assessment of an investment's profitability compared to traditional IRR. By incorporating both the cost of financing and the reinvestment rate, MIRR helps investors make more informed decisions. Additionally, it avoids some of the pitfalls of IRR, such as multiple rates of return for the same cash flow series.

Key Takeaways:

  • MIRR: A financial function that calculates the modified internal rate of return, considering financing and reinvestment rates.
  • Accurate Assessment: Provides a more realistic view of an investment's profitability compared to traditional IRR.
  • Investment Decision-Making: Helps investors evaluate projects and make informed financial decisions.
  • Common Use Cases: Ideal for capital budgeting, project evaluation, and any scenario where cash flow analysis is necessary.

MIRR is an essential function for anyone involved in financial analysis, providing a powerful way to assess the viability of investments and projects.

Happy investing!

Check out all of the Google Sheets formulas
Try our other free AI data tools
//e1b5c549a6dd5273e224cd87b24dd3fb.cdn.bubble.io/f1712248048835x171910885545995420/data%20analyser.svg_icon
//e1b5c549a6dd5273e224cd87b24dd3fb.cdn.bubble.io/f1711640762344x820626742105414500/excel-formula-generator_icon.svg_icon
//e1b5c549a6dd5273e224cd87b24dd3fb.cdn.bubble.io/f1724422435477x384387332830927740/sentiment-analysis-tool.svg_icon
missing element