šŸ“ˆ MIRR Calculator

Modified Internal Rate of Return

How to Use This Calculator

1

Enter Cash Flows

Include the initial investment (usually negative) and subsequent returns.

2

Set Rates

Finance = borrowing cost for negatives; Reinvest = rate for positives.

3

Calculate

Get MIRR as an annualized percentage.

Formula

MIRR = ( FV(positive, r_e) / āˆ’PV(negative, r_f) )^(1/(nāˆ’1)) āˆ’ 1

Where r_f is finance rate, r_e is reinvestment rate, and n is number of periods.

Frequently Asked Questions

How is MIRR different from IRR?

MIRR assumes positive cash flows are reinvested at a specified rate and negatives financed at another rate, avoiding multiple IRR issues.

What if there are no positive or negative flows?

MIRR requires at least one positive and one negative cash flow.