Rental Property Calculator

Rental Property Calculator
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description

Rental Property Calculator

Model financing, rental operations, value growth, and an eventual sale in one live investment view.

Monthly cash flow $331.51 Cap rate 7.49% IRR 17.87% Cash invested $37,000.00

Property assumptions

Purchase and financing

Contract price before closing costs and repairs.
Financing
Turn off for an all-cash purchase.
Cash paid toward the price at closing.
Annual nominal mortgage rate.
Amortization period in years.
Lender, legal, title, and transaction costs.

Repairs

Renovation
Adds repair cash to the initial investment.
One-time cost before stabilized operations.
Starting value for appreciation when repairs apply.

Recurring operating expenses

ExpenseAnnual amountAnnual increase
Annual
Growth
Annual
Growth
Annual
Growth
Annual
Growth
Annual
Growth

Income and occupancy

Scheduled monthly rent in year one.
Applied at the start of each later year.
Parking, laundry, storage, or similar income.
Separate growth rate for ancillary income.
Share of scheduled rent not collected.
Percentage of effective rental income.

Sale assumptions

Exit value
Otherwise value grows by appreciation.
Annual property value change.
Gross price at the end of the holding period.
Years before the modeled sale.
Brokerage, transfer, legal, and closing costs.

Live investment results

Annualized return over 20 years
17.87%

Includes annual operating cash flow and net sale proceeds.

Total profit at sale
$288,616.97
After initial cash invested
Year-one monthly cash flow
$331.51
After mortgage and operating costs
Cash-on-cash return
780.05%
Cumulative profit ÷ initial cash
Capitalization rate
7.49%
Year-one NOI ÷ property value
Initial cash invested
$37,000.00
Down payment, closing, and repairs
Year-one NOI
$10,180.00
Income less operating expenses
Total rental income
$367,586.72
After vacancy over the hold
Net sale proceeds
$176,113.12
After selling costs and loan payoff

First-year expense breakdown

Mortgage and operating costs compared on one annual basis.

First-year expense breakdown Expense categories and values update with the calculator. Annual costs $10,421.83
Enter property and expense values to see the breakdown.
The largest first-year expense is the mortgage payment.

Operating performance over time

Net rental income, operating expenses, and operating cash flow use the same annual schedule shown below.

Annual rental property operating performance Annual income, expenses, and cash flow lines update with the calculator.
Enter income and holding-period values to see the timeline.
Growing rent improves operating cash flow when income increases faster than expenses.

Annual investment schedule

Each row combines rental operations, mortgage balance, equity, and the estimated result of selling at that year-end.

Year Net rental income Mortgage Operating expenses Cash flow incl. exit Cash-on-cash Equity Net sale proceeds IRR if sold
Mortgage payments are excluded from NOI. The final modeled year adds net sale proceeds to operating cash flow.
Model assumptions and calculation notes

The model uses monthly mortgage amortization, annual income and expense escalation, end-of-year cash flows, and a sale after the selected holding period. Management fees are applied to effective rental income after vacancy. Taxes and personal income-tax effects are not modeled.

How to analyze a rental property

What this calculator estimates

This calculator creates a before-tax rental property projection from acquisition through sale. It estimates the cash needed at closing, mortgage payment, first-year net operating income, monthly cash flow, capitalization rate, cumulative cash-on-cash return, equity, net sale proceeds, total profit, and annualized internal rate of return. The annual schedule makes the timing visible: rent and expenses change each year, the loan balance amortizes monthly, and the final year includes the modeled sale.

The output is a planning model, not a valuation, loan approval, tax return, or investment recommendation. Actual rent, vacancy, repairs, insurance, taxes, financing terms, and sale costs can differ materially. Review local leases and fair-housing obligations, and use qualified legal, tax, lending, and property professionals for decisions.

Purchase, loan, and repair inputs

Purchase price is the agreed property price before closing costs. A higher price increases the required equity and usually lowers the cap rate when income is unchanged. Use a mortgage loan switches between a financed and all-cash acquisition. For financing, enter the down payment as a percentage or dollar amount, the annual interest rate, and the loan term in years. The unit selector converts the current down payment rather than changing only its label. Higher leverage reduces initial cash but raises debt service and financial risk. Longer terms usually reduce payments while slowing principal reduction. The Consumer Financial Protection Bureau home-loan resources explain common mortgage concepts and closing documents.

Closing cost covers transaction expenses paid at acquisition and is added to initial cash invested. Include lender, appraisal, title, legal, inspection, transfer, and recording costs when applicable. Enable initial repairs when the property requires work before stabilized rental operation. Repair cost is treated as an upfront cash outlay. Value after repairs becomes the starting property value for appreciation and cap-rate analysis when repairs are enabled. Do not confuse a contractor budget with a supported after-repair market value.

Operating expense inputs

Enter property tax, total insurance, HOA fees, maintenance, and other costs as annual year-one amounts. Each line has its own annual increase. A zero value is valid when a cost does not apply, but omitting a real expense overstates NOI and cash flow. Maintenance should include recurring upkeep and a reasonable reserve for irregular repairs; major capital projects may need a separate scenario. “Other costs” can include utilities paid by the owner, licensing, accounting, landscaping, pest control, or local fees.

Expense growth is compounded annually. A higher growth rate does not change year one, but it reduces later cash flow and total return. Property taxes and insurance can rise at different rates, so separate assumptions are more informative than one blended percentage. For U.S. residential rentals, IRS Publication 527 describes rental income and expense categories for federal tax reporting; this calculator does not calculate depreciation or tax liability.

Income, vacancy, and management inputs

Monthly rent is scheduled year-one rent before vacancy. Rent annual increase compounds from year two onward. Use a market-supported assumption rather than assuming rent always rises. Other monthly income can include parking, laundry, storage, pet, or service income, with a separate growth rate. Vacancy rate reduces scheduled rent to effective rental income. It should reflect both physical vacancy and collection loss where appropriate. A higher vacancy rate lowers income, NOI, cap rate, cash flow, sale-year profit, and IRR.

Management fee is modeled as a percentage of effective rental income after vacancy. Enter zero for self-management only when you deliberately value your own time separately. Management agreements may also include leasing, renewal, inspection, maintenance coordination, or minimum fees, so a simple percentage can understate the actual contract. Landlords should also understand the U.S. Department of Housing and Urban Development fair-housing guidance or the applicable rules in their jurisdiction.

Sale and holding-period inputs

Use value appreciation when you want the property value to grow or decline by a constant annual rate. Enable known sale price when you have a specific terminal value; the annual schedule then uses the implied compound growth path between the starting value and that final price. Holding length determines how many annual operating periods are modeled. A longer hold adds more rental cash flows and loan amortization, but also compounds uncertain assumptions.

Cost to sell can be entered as a percentage of the sale price or as a fixed dollar amount. It reduces sale proceeds before the remaining loan balance is repaid. Include brokerage, legal, transfer, staging, concessions, and closing items that are likely in the target market. A higher sale cost lowers net sale proceeds, total profit, and IRR.

How to interpret the results

IRR is the annual discount rate that sets the present value of modeled cash flows to zero. It incorporates initial cash, annual operating cash flow, and sale proceeds, so it is more complete than a one-year yield. A negative or unavailable IRR indicates that the modeled cash-flow pattern does not support a positive annualized return. Total profit at sale is all operating cash flow plus net sale proceeds minus initial cash invested. It is a dollar total, not an annual rate.

Year-one monthly cash flow is NOI minus mortgage payments, divided by 12. Negative cash flow means the owner must contribute cash during year one. Cash-on-cash return here is cumulative profit divided by initial cash invested, matching the full holding period; the schedule also shows each year’s operating cash flow divided by initial cash. Capitalization rate equals first-year NOI divided by the stabilized property value and excludes financing. This makes cap rate useful for comparing operating performance across different loan structures.

NOI is effective rental income minus operating expenses, excluding mortgage payments, income taxes, depreciation, and sale proceeds. Total rental income is cumulative effective income after vacancy. Net sale proceeds are the gross sale value less selling costs and loan payoff. The annual table shows the same model values used by the charts and Excel workbook.

Reading the charts and stress-testing assumptions

The expense donut compares year-one mortgage, vacancy, taxes and insurance, maintenance and HOA, and management and other costs. The time-series chart compares net rental income, operating expenses, and operating cash flow. When income grows faster than expenses while mortgage payments stay level, cash flow generally improves. The schedule adds equity, net sale proceeds, and the IRR that would result from selling at each year-end.

Test a base case, downside case, and upside case. In the downside case, reduce rent growth and appreciation, increase vacancy, maintenance, insurance, and selling costs, and consider a shorter unexpected hold. Check whether cash flow remains manageable without relying on appreciation. Compare projected rent with independent market evidence such as the HUD Fair Market Rent datasets where relevant, while recognizing that broad datasets do not replace property-level research. Common mistakes include omitting turnover costs, understating repairs, applying growth to the wrong period, ignoring sale costs, and treating a forecast as guaranteed.