In this article, we are going to see how to use the MIRR Function In Excel Office 365. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
MIRR Function
This function returns the Modified interest rate of return for the financial data having Investment, finance rate & reinvestment_rate , and it returns modified interest rate of return in percentage.
MIRR Function Syntax
=MIRR (values, finance_rate, reinvest_rate)
Syntax Explanation:
- Values: Investment amount (both positive & negative amount) or cash flows in array.
- Finance_rate: Required rate of return (discount rate) as a percentage.
- Reinvest_rate: Interest rate received on cash flows reinvested as percentage.
Example1
- Firstly, you have to create a sample data with Investment, Finance_rate & reinvestment_rate.
- Then, you need to calculate the MIRR Function value.
- Now, you have to use the following formula given below.
=MIRR(A2:A6, B2, C2)
A2:A6: investment amount or cash flow.
B2: finance_rate.
C2: Reinvest_rate.
- Finally, the MIRR function returns the modified interest rate of return is 8.1%.
Example2
- Firstly, you have to create a sample data with Investment, Finance_rate & reinvestment_rate.
- Then, you need to calculate the MIRR Function value.
- Now, you have to use the following formula given below.
=MIRR(A2:A6, B2, C2)
A2:A6: investment amount or cash flow.
B2: finance_rate.
C2: Reinvest_rate.
- Finally, the MIRR function returns the modified interest rate of return is 12.5%.
Check this too:
Wind-Up
We hope that this short tutorial gives you guidelines to use the MIRR Function In Excel Office 365. ** Please leave a comment in case of any **queries, and don’t forget to mention your valuable suggestions as well. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!
Read Next:
Top comments (0)