Internal Rate of Return is the most-cited finance number that nobody calculates by hand. The math is recursive, the spreadsheets are clunky, and most online calculators force you to choose between equal cash flows and pay for a paid plan. This guide pairs Claude AI with two free MoneyFlock calculators (one for IRR, one for NPV) so you can run a defensible investment-grade analysis on any cash flow stream in under 5 minutes.
IRR is the speedometer; NPV is the destination map; you need both. Claude explains why a deal is or isn't worth doing. The free IRR Calculator on MoneyFlock returns the exact number with NPV, payback period, and a present-value breakdown. The free NPV Calculator runs the same math from the discount-rate perspective. Use them together.
This article walks through three real investment decisions: an equipment purchase, a rental property, and a reverse-IRR deal where you compute the maximum bid price. All numbers verified, all calculator inputs ready to paste.
Why IRR and NPV Are the Right Pair
Three reasons every investment-grade analysis runs both metrics.
First, IRR is intuitive. "This deal returns 15.24% per year" is a sentence anyone understands. NPV is harder to explain ("the present value of future cash flows minus the initial investment, discounted at our cost of capital") but it's the number that tells you whether the deal makes you richer in absolute dollars. You need both.
Second, IRR alone can mislead. Two deals can have the same 15% IRR but very different NPVs because the dollar size differs. A 15% return on $10,000 over 5 years is $5,500 of NPV at 10% discount. A 15% return on $1,000,000 over 5 years is $550,000 of NPV. IRR makes them look identical; NPV tells the truth.
Third, the discount rate matters. Your IRR is fixed by the cash flows. Your NPV depends on the discount rate you compare against. The MoneyFlock calculator lets you toggle the discount rate and watch NPV update.
15.24% IRR. $1,372.36 NPV at 10% discount. That's the standard textbook example: -$10,000 today, $3,000 each year for 5 years.
Claude AI walks through three IRR decisions with the matching NPV check.
How to Use Claude AI With the IRR + NPV Calculators
The workflow is three prompts. Total time about 5 minutes.
Prompt 1: Define the Cash Flows
Act as a CFO running an investment analysis. Walk me through computing IRR and NPV for this project: initial investment $X, then [list cash flows by year]. Use a discount rate of [WACC]%. Show the full present-value table and explain whether this beats my hurdle rate.
Prompt 2: Stress-Test
Now stress-test: what happens to IRR and NPV if (1) operating costs rise 15% in years 3-5, (2) a one-year recession cuts year-3 cashflow in half, (3) terminal value at year 5 is 10% lower than projected. Quantify each.
Prompt 3: Reverse-IRR (Max Bid Price)
Reverse-engineer the deal: given the projected cash flows and a target IRR of 18%, what is the maximum I should pay today as my initial investment? Show the math.
After each prompt, verify Claude's number in the MoneyFlock IRR Calculator. Paste the cash flows directly. The calculator returns the same IRR Claude does, plus a present-value table and the payback period.
Three Real Examples With Verified Numbers
Example 1: Equipment Investment
A small business is considering a $50,000 piece of equipment that will produce $14,000 of additional cash flow per year for 5 years. WACC is 10%.
- Cash flow stream: -$50,000, +$14,000, +$14,000, +$14,000, +$14,000, +$14,000
- IRR computed: 12.38%
- NPV at 10% discount: +$3,074
- Payback period: 3.57 years
- Verdict: IRR (12.38%) > WACC (10%), NPV positive. Buy the equipment. The 12.38% return beats the 10% hurdle by 238 basis points; over the life of the asset that's worth $3,074 in present-value dollars.
Verify Example 1 in the free MoneyFlock IRR Calculator
The math behind it: Claude solves IRR by Newton-Raphson, the calculator solves by bisection. Both converge on the same answer because the cash flow stream has only one sign change. The present-value table shows year-by-year PVs at the 10% discount: $12,727, $11,571, $10,519, $9,562, $8,694. Sum $53,074 minus the $50,000 initial equals the +$3,074 NPV. That decomposition is what makes the verdict defensible to a board, a partner, or your future self when you forget why you said yes.
Example 2: Rental Property (Cleveland, $180K)
Tying back to the Cleveland rental property analyzed in our real estate article: cash in $49,500, year-1 cashflow $728, growing at 3%, plus a $124,000 net sale at year 10.
- Cash flow stream: -$49,500, $728, $750, $773, $796, $819, $844, $870, $896, $923, $124,950 (year 10 includes sale)
- IRR computed: ~10.4%
- NPV at 8% discount (the 30-year mortgage rate as opportunity cost): +$5,400
- Verdict: IRR is above the cost of capital (the mortgage rate), NPV is modestly positive. Buy if you have 10-year patience and don't need cashflow today.
Example 3: Reverse-IRR (Maximum Bid Price)
A solar-installation deal projects $20,000 of cash flow per year for 8 years. You target a 15% IRR. What's the maximum you should bid today?
- Required: solve for initial investment so IRR = 15% on the projected stream
- Math: present value of $20,000 per year at 15% over 8 years = $20,000 x [(1 - 1.15^-8) / 0.15] = $89,747
- Maximum bid price: $89,747. Anything above this drops your IRR below 15%.
- If the seller asks $100,000, your IRR drops to about 12.0%. If they ask $80,000, your IRR rises to about 18.6%.
Run reverse-IRR scenarios in the MoneyFlock IRR Calculator
When IRR Misleads (and What to Do Instead)
IRR is the right metric for most retail-investor decisions, but it has three known failure modes worth understanding before you commit capital.
Failure 1: Multiple IRR Values
If your cash flow stream has more than one sign change (negative-positive-negative-positive), there are mathematically multiple valid IRR values. Each satisfies the equation but only one represents a meaningful return. The fix: switch to MIRR (modified IRR) which assumes a constant reinvestment rate. Or just trust NPV at your hurdle rate, which is unique.
Failure 2: Mutually Exclusive Project Comparison
Project A has 25% IRR on $10K of cash invested. Project B has 18% IRR on $100K. If you can only do one, B creates more wealth in absolute terms despite the lower percentage. NPV at the same discount rate ranks them correctly. IRR alone leads to the wrong choice.
Failure 3: Project Lifespan Differences
A 1-year IRR of 30% sounds great. A 10-year IRR of 12% sounds modest. But the 10-year deal compounds over 10 years and creates more terminal wealth. Compare equivalent annualized return over a common horizon, or compute terminal value at year 10 for both deals.
The Decision Rule for Retail Investors
For any investment decision: compute both IRR and NPV. If both are positive, proceed. If only IRR is positive but NPV is small or negative due to scale, get a bigger deal. If only NPV is positive but IRR is below your hurdle, you're getting absolute gain at sub-par efficiency; reconsider.
Reverse-IRR is the underused trick. Most investors compute IRR after deciding the price. Compute the price for a target IRR first, then negotiate.
MoneyFlock's free IRR Calculator. Plug your cash flows; get IRR, NPV, payback period, and the present-value breakdown.
Common Mistakes That Cost You
Mistake 1: Comparing IRR Across Different Time Horizons
A 25% IRR on a 1-year deal is a $0.25 gain per dollar. A 12% IRR on a 10-year deal compounds to roughly $2.10 per dollar. IRR alone makes the short deal look better. NPV at the same discount rate tells you the longer deal creates more wealth. Always run both metrics across deals with different durations.
Mistake 2: Using IRR on Non-Conventional Cash Flow Streams
A cash flow stream with multiple sign changes can have multiple valid IRR values. NPV is unique. When the cash flow stream has more than one sign change, trust NPV over IRR.
Mistake 3: Anchoring on the Wrong Discount Rate
Your discount rate should reflect either your weighted average cost of capital or your best alternative use of the money. For most retail investors, the discount rate is the long-term S&P 500 expected return, roughly 7-8% real. Don't use 4% just because it makes the NPV positive.
Mistake 4: Ignoring the Reinvestment Rate Assumption
IRR assumes you can reinvest interim cash flows at the IRR itself, which is often unrealistic. If your IRR is 25% but the realistic reinvestment rate for incoming cash is 8%, your effective return is closer to MIRR. For deals with large interim cash flows, MIRR is the more honest number.
Mistake 5: Not Including Terminal Value
Real-estate and business investments often have a large terminal value at exit. Ignoring it makes IRR look terrible because the present value of a future $300K sale is huge over 10 years. Always include the projected exit cash flow as the last entry in the cash flow stream.
Frequently Asked Questions
What discount rate should I use?
For corporate analysis: your weighted average cost of capital. For personal real estate: long-term S&P 500 expected return (~7-8% real). For passive income alternatives: your best risk-adjusted alternative return.
Can IRR be negative?
Yes. If you put $100 in and get back $50 over the life of the project, the IRR is negative. The calculator handles negative IRR correctly. Negative IRR means you're losing money relative to a zero-return alternative.
Why does my Excel IRR formula give a different answer?
Excel's IRR function uses an iterative solver that requires a starting guess. If your cash flow stream has multiple sign changes, Excel may converge to a different valid IRR than another tool. The MoneyFlock calculator is consistent.
Is IRR the same as ROI?
No. ROI is total gain / total investment, no time consideration. IRR is the annual rate of return that accounts for the timing of every cash flow. A project with 100% ROI over 10 years has only 7.2% IRR.
Key Takeaways
- IRR is intuitive (annualized return); NPV is the dollar-value answer. Run both.
- Equipment example: -$50K, +$14K x 5 yrs gives IRR 12.38%, NPV +$3,074 at 10% discount.
- Cleveland rental example: 10-year hold IRR ~10.4%, NPV +$5,400 at 8% discount.
- Reverse-IRR: target 15% on $20K x 8 years means max bid $89,747. Anything above drops IRR.
- Free MoneyFlock IRR + NPV calculators verify in seconds. Bookmark both.
- Trust NPV over IRR when cash flow stream has multiple sign changes.
- Always include terminal value (exit price). Ignoring it makes long-hold deals look worse than they are.
References
Free IRR Calculator on MoneyFlock: moneyflock.com/tools/irr-calculator
Free NPV Calculator on MoneyFlock: moneyflock.com/tools/npv-calculator
Investopedia primer on IRR: investopedia.com IRR
Claude AI: claude.ai