The Montclair Real Estate IRR (Internal Rate of Return) calculator is a free online simulator designed to help real estate investors accurately assess the true profitability of their rental investments. Unlike simpler metrics like gross or net rental yield, the TRI provides a comprehensive view by integrating all financial flows from acquisition to resale, including the crucial impact of credit, taxation on rental income, and capital gains tax upon resale.
This powerful tool allows users to simulate their investment scenarios both with and without leverage (credit), offering a clear comparison of how financing can significantly amplify returns on personal equity. Key features include:
- Detailed Input Fields: Users can input various parameters such as purchase price, notary fees (fixed or real amount), renovation costs, personal contribution, loan interest rate, loan duration, monthly rent (excluding charges), vacancy rate, non-recoverable annual charges (co-ownership, property tax, insurance, management), tax regime (Micro-foncier, Réel foncier, Micro-BIC, Réel BIC), marginal tax bracket, amortizable building value, estimated resale price, and selling fees.
- Comprehensive Output Metrics: The simulator provides critical outputs such as the TRI with credit (on personal equity), TRI for cash purchase (on total cost), total operation cost, borrowed capital, calculated monthly payment, first-year cash flow, remaining capital due at resale, capital gains tax, net amount recovered at resale, and total gain on the operation.
- Leverage Effect Analysis: A core strength is its ability to demonstrate the "leverage effect" of credit, showing how borrowing can enhance the TRI on personal funds, even in scenarios with negative monthly cash flow. This highlights that capital repayment is a form of forced saving, recovered at resale, rather than a pure expense.
- Dynamic Exit Strategy: The tool allows users to adjust the holding period (2 to 30 years) to understand its impact on capital gains tax abatements and the overall TRI, emphasizing that the exit strategy is as vital as the entry.
- Fiscal Optimization: By allowing users to switch between different tax regimes and marginal tax rates, the simulator helps in understanding how fiscal choices can dramatically alter the project's profitability.
The introduction also delves into the theoretical underpinnings of TRI, explaining it as the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. It contrasts TRI with gross yield, highlighting TRI's dynamic nature and its ability to account for time, actual taxation, net capital gain, and the leverage effect. It provides practical advice on integrating all relevant cash flows (initial contribution, notary fees, works, loan payments, non-recoverable charges, rental income, resale price, capital gains tax) and warns against common omissions that can distort results. The article further discusses target TRI ranges (below 5% as a warning, 5-8% for quality assets in tense areas, 8-12% for strong performance, and above 12% for exceptional cases) and offers guidance on calculating TRI using spreadsheets.
This tool is invaluable for both novice and experienced real estate investors seeking a robust and realistic assessment of their potential returns, moving beyond superficial metrics to a deep understanding of long-term profitability.
