Modified Internal Rate of Return (MIRR) Calculator

• Compounded Y1$181,500.00 (30.3%)
• Compounded Y2$198,000.00 (33.0%)
• Year 3$220,000.00 (36.7%)

Three bars compound to the $599,500.00 future value — earlier cash compounds longest.

What modified internal rate of return actually measures

Every valuation decision rests on knowing modified internal rate of return cold. The relationship MIRR = (FVpos/Initial)^(1/n) - 1 compresses an entire deal layer into one number you can track quarterly. Take the worked case: $150,000, $180,000 and $220,000 compounding at 10% grow to $599,500.00, giving a 6.24% MIRR on $500,000. That single reading tells you what the business is worth before the next negotiation. Owners who review it quarterly catch drift early — a half-point of multiple compression on $500,000 of earnings is $250,000 of missing deal value that monthly profit figures never reveal. Treat this metric as the headline of your valuation review, and make everyone who touches price, bids or equity able to define it in one sentence.

The math, step by step

Start with clean same-period inputs from the tax return and the ledger, never mixing trailing months with calendar years. Then apply MIRR = (FVpos/Initial)^(1/n) - 1 exactly as written, keeping units consistent — dollars with dollars, rates with rates. Work the example: $150,000, $180,000 and $220,000 compounding at 10% grow to $599,500.00, giving a 6.24% MIRR on $500,000. Notice how each operation has a deal meaning: multiplication scales earnings to price, division annualizes a rate, subtraction isolates the residual claim. Common slips include dividing by zero deal years, annualizing one input but not the other, and rounding mid-calculation. Do the division last, keep two decimals on money and one on multiples, and rerun the page calculator to confirm your hand math matches to the dollar.

Modified Internal Rate of Return (MIRR) Calculator versus its closest cousins

Confusing sibling metrics is the costliest beginner error in valuation. MIRR compounds interim cash at your real reinvestment rate, while IRR assumes reinvestment at IRR itself — MIRR never overstates. In our case: $150,000, $180,000 and $220,000 compounding at 10% grow to $599,500.00, giving a 6.24% MIRR on $500,000 — compare that against the benchmark band before quoting. Quoting the wrong cousin misprices risk: an asset quote on an earnings deal leaves money on the table, while an earnings quote on an asset deal scares buyers away. Keep both on one worksheet, label each clearly, and let this page own the modified internal rate of return definition your team quotes to brokers and buyers.

Benchmarks and what good looks like

A number without a benchmark is just trivia. The rule here: Accept when MIRR clears your WACC hurdle; MIRR below IRR is normal and more honest. Put the worked case against it: $150,000, $180,000 and $220,000 compounding at 10% grow to $599,500.00, giving a 6.24% MIRR on $500,000. If you sit inside the band, protect the routine that got you there — clean books, documented earnings, diversified customers. If you sit outside, attack the largest input first rather than spreading effort thin; one big lever (provable earnings, favorable terms, de-risked forecasts) usually moves modified internal rate of return more than five small adjustments. Recheck the industry benchmark table above for your vertical, then set a quarterly target one step tighter than today.

How modified internal rate of return drives real decisions

This metric answers what yield survives realistic reinvestment, which makes it a gate for listing, bidding, borrowing and partner buyouts. Work from the example: $150,000, $180,000 and $220,000 compounding at 10% grow to $599,500.00, giving a 6.24% MIRR on $500,000 shows exactly how much headroom the deal carries. A strong reading green-lights a premium ask and confident borrowing; a weak one triggers the playbook — normalize earnings upward with documented add-backs, de-risk the forecast, restructure terms, or walk away. Tie each input to an owner (finance owns earnings, ops owns assets, advisors own terms) and review the trio monthly while a deal is live, quarterly when monitoring.

Limits and blind spots

No single metric tells the whole valuation story, and modified internal rate of return is no exception. It is a snapshot: the case where $150,000, $180,000 and $220,000 compounding at 10% grow to $599,500.00, giving a 6.24% MIRR on $500,000 describes one set of inputs, not the trend, and timing spikes (a record year, a one-off contract) can flatter or punish it. It also ignores financing structure, buyer-specific synergies and contingent liabilities that move real bids. Pair it with a second method — a DCF against a multiple, or an asset cross-check — investigate any 10 percent swing within days, and never let one strong reading justify overpaying without diligence.