Real Estate Investment Analysis Model — NOI, Cap Rate, IRR & DSCR

Description
This Excel model helps real estate investors and analysts evaluate the financial viability of a property investment in minutes. It includes automated NOI calculation (following standard industry convention, excluding replacement reserve), an exact mortgage amortization schedule (CUMIPMT/CUMPRINC, not a linear approximation), Cap Rate, Cash-on-Cash Return, and DSCR calculations, a 5-year cash flow projection with IRR analysis, a sensitivity analysis sheet to stress-test key assumptions, and a visual dashboard summarizing all key metrics.

The model is built for real-world underwriting: input your purchase price, financing terms, rental income, and operating expenses, and the workbook automatically calculates every key metric lenders and investors look for. The sensitivity analysis lets you test how changes in interest rate, vacancy, or rent growth affect your returns, so you can stress-test a deal before committing capital. The workbook includes data validation on the down payment input to prevent entry errors, and all formula sheets are protected so only input cells are editable, keeping the model reliable even for less experienced users.


Available in both English and Spanish versions, this template is ideal for real estate investors evaluating a specific deal, analysts comparing multiple properties side by side, consultants preparing investment cases for clients, and students learning real estate underwriting fundamentals. Format: Excel (.xlsx), no macros required, compatible with Excel 2016+ and Google Sheets with minor formatting adjustments.