Rental Property ROI Calculator – Excel Real Estate Investment Analysis

Rental Property ROI Calculator

Know whether a rental deal really makes money before you make an offer. Type in the price, loan, rent and expenses and this calculator does the rest, from monthly cash flow to long-term IRR.

What you can do with it

• Deal analysis: Cash needed, loan amount, mortgage payment, effective income, operating expenses, NOI and monthly and yearly cash flow.
• Key investor metrics: Cap rate, cash-on-cash return, DSCR, gross rent multiplier, 1% rule, break-even occupancy and expense ratio, colour-coded.
• 30-year projection: Rent growth, expense growth and appreciation year by year, with loan balance, equity and cumulative cash flow.
• IRR at sale: Choose a holding period and see IRR, equity multiple, sale proceeds and total profit.
• Amortization schedule: Every monthly payment split into interest and principal.
• Compare deals: Put three properties side by side and see which gives the best cash-on-cash return.

What’s included

• Start Here – step-by-step instructions
• Analysis
• Projection
• Amortization
• Compare Deals

Every sheet uses clear colour coding: yellow cells are for your information, everything else calculates automatically. Example data is included so you can see how it works straight away.

Who it’s for

• First-time and experienced rental investors
• House hackers and BRRRR investors
• Real estate agents presenting deals to clients
• Students learning real estate finance

Compatibility

• Microsoft Excel 2010 or newer (Windows and Mac)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• Instant digital download (.xlsx). No physical product is shipped.

Frequently asked questions

Which metrics does it calculate?

Cash flow, NOI, cap rate, cash-on-cash return, DSCR, GRM, 1% rule, break-even occupancy, IRR, equity multiple and total profit.

Can I use it for multi-unit properties?

Yes. Enter the total rent for all units.

Does it work in Google Sheets?

Yes. It works in Excel 2010 or newer and in Google Sheets.

Is this investment advice?

No. It is an educational planning tool. Always verify taxes, insurance, rents and loan terms locally.

Licence

For personal use or use in one business. Please do not resell, share or redistribute the file.