Evaluate a rental-property purchase by connecting rent, vacancy, operating costs, capitalization rate, purchase price, and loan terms in one scenario-based workbook.
The calculator is structured around three side-by-side scenarios. You enter the property and financing assumptions in the highlighted input cells, then review calculated operating income, net operating income (NOI), capitalization metrics, debt service, cash flow, and cash-on-cash return to see how a potential deal changes under different assumptions.
Compare rental-income cases
Test different rent and vacancy assumptions and see the effect on monthly gross operating income.
Check price against NOI
Review annual NOI, a valuation based on the desired capitalization rate, and the actual capitalization rate at the entered purchase price.
See financing impact
Connect down payment, loan terms, interest, and debt service to the resulting monthly and annual property cash flow.
What this template helps you analyze
The workbook turns a small set of rental-property assumptions into a consistent comparison across three scenarios, making it easier to separate operating performance from financing effects.
Rental income and vacancy. Compare the number of properties, monthly rent per property, vacancy and credit-loss assumptions, other monthly income, and resulting gross operating income.
Operating expense load. Enter property-management fees, repairs and maintenance, land taxes, insurance, association or mortgage-holder fees, utilities, legal and accounting costs, and other expenses.
NOI and capitalization. Review annual operating income, annual operating expenses, NOI, a valuation derived from the desired capitalization rate, and the actual capitalization rate at the purchase price.
Loan economics. Compare down payment, loan amount, loan fees, mortgage term, interest rate, estimated monthly principal-and-interest payment, annual interest, annual principal, and total annual debt service.
Property-level cash return. See calculated monthly and annual cash flow before charges alongside the workbook's money-on-cash return measure for each scenario.
What is inside the workbook?
The model separates highlighted assumption cells from calculated cells and presents the results in tables with accompanying charts. Its core analysis is arranged as Scenario I, Scenario II, and Scenario III so you can change the assumptions rather than rebuild the analysis for every alternative.
Editable scenario inputs
Highlighted cells capture rent, vacancy, expenses, desired cap rate, purchase price, down payment, loan fees, mortgage term, and annual interest rate.
Calculated property economics
The workbook derives gross operating income, annual NOI, capitalization metrics, mortgage payment, annual debt service, and cash flow from those inputs.
Side-by-side visual outputs
Tables and charts place all three scenarios next to one another, helping you identify which assumptions are driving differences in income, expenses, financing, and return.
The monthly operating-income view compares rent, vacancy losses, other income, and gross operating income across three scenarios.
Start with rent and vacancy
Enter the property count, monthly rent per property, vacancy and credit-loss percentage, and any other monthly income. The calculated totals show how much gross operating income remains after vacancy losses, with a chart that makes the scenario differences easy to scan.
The loan-information view compares down payment, loan amount, fees, mortgage term, interest rate, payment, principal, interest, and annual debt service.
Test the financing structure
Compare how different down payments, loan amounts, mortgage terms, fees, and interest rates change the financing burden. The calculated monthly mortgage payment and annual principal, interest, and total debt service provide the bridge from property operations to cash flow after financing.
The NOI view links annual operating performance to a desired capitalization rate, calculated property valuation, purchase price, and actual cap rate.
Connect NOI to valuation
Annual operating income and expenses feed into NOI. The workbook then compares the implied property valuation at the selected capitalization rate with the entered purchase price and calculates the actual capitalization rate, giving you a consistent operating-value check for each scenario.
The return view compares monthly and annual cash flow with the workbook's money-on-cash return measure across the three scenarios.
Compare cash flow and return
After operating and financing assumptions are in place, use the cash-flow and return output to compare the scenarios on the same basis. This view makes it clear when a scenario produces negative cash flow, only a narrow cash surplus, or a stronger cash-on-cash result.
How do you use the template?
Set the three cases.
Name the scenarios if desired, then enter rental income, vacancy, and operating-expense assumptions in the highlighted cells.
Add valuation and financing inputs.
Enter the desired capitalization rate, purchase price, down payment, loan amount and fees, mortgage term, and annual interest rate for each case.
Review calculated results.
Compare NOI, valuation, actual cap rate, debt service, monthly and annual cash flow, and cash-on-cash return; then revise the inputs to test a different deal structure.
Who is this template for?
This workbook is suited to rental-property buyers, real estate investors, analysts, and finance professionals who want a structured first-pass view of a property's operating economics and financing. It is particularly useful when you need to compare several combinations of rent, vacancy, expenses, purchase price, and debt terms before deciding which assumptions deserve deeper due diligence.
For a deeper look at the borrowing side of a deal, use the Excel Loan Payment Template to focus on payment mechanics. If you are reviewing broader leverage and coverage measures, the Financial Debt Ratios Calculator complements the property-level debt-service view. For investments where discounted future cash flows are the central valuation method, the DCF Calculator provides a different valuation framework.
Choosing a selection results in a full page refresh.
