Real Estate Calculator

How to use the real estate investment model

This calculator estimates the economics of purchasing, operating, and eventually selling a rental property. It separates operating performance from financing so you can see how rent, vacancy, expenses, mortgage terms, appreciation, and selling costs interact. The output is a planning model rather than a valuation opinion: real transactions can include taxes, lender reserves, capital expenditures, lease-up costs, irregular repairs, and local legal requirements that are not predictable from a single set of assumptions.

Purchase and financing inputs

Purchase price is the contract price of the property. Enter the asset price before closing costs and repairs. A higher price increases the cash required, loan amount, and denominator used for the cap rate. Use a mortgage determines whether the purchase is financed. When financing is disabled, the full purchase price becomes part of initial cash and mortgage payments and loan balances become zero.

Down payment is entered as a percentage of purchase price. A larger down payment lowers the loan and monthly debt service but increases upfront cash, which can reduce cash-on-cash return even when annual cash flow improves. Mortgage interest rate is the nominal annual rate used to calculate a level monthly payment. Loan term is the amortization period in years. Longer terms usually reduce the payment but slow principal reduction and can increase total interest. Closing costs are paid upfront and should include lender, legal, title, inspection, transfer, and other transaction charges that are not financed. The U.S. Consumer Financial Protection Bureau provides practical guidance on comparing mortgage terms and closing disclosures through its home-buying resources.

Income and vacancy assumptions

Monthly rent is scheduled rent before vacancy. Use a supportable market amount rather than the highest advertised rent. Other monthly income can include parking, storage, laundry, utility reimbursements, or similar recurring revenue. Vacancy rate reduces scheduled income to reflect vacant periods and uncollected rent. A higher vacancy rate lowers effective income, NOI, cash flow, cap rate, and IRR. Management fee is modeled as a percentage of income remaining after vacancy. Set it to zero only when self-management is realistic and the owner does not want to assign an economic cost to that work.

The advanced rent growth and other income growth inputs apply from year two onward. Positive growth compounds, so small changes become material over long holding periods. Negative values can model rent pressure or planned concessions, but the calculator prevents growth below negative 99% to avoid impossible sign reversals.

Operating expenses and repairs

Property tax, insurance, HOA fees, maintenance, and other operating costs are annual amounts. They are deducted before mortgage payments when calculating net operating income. Maintenance should cover routine upkeep; major replacements such as roofs, HVAC systems, or structural work may require a separate capital expenditure reserve. Each category has its own advanced growth rate because taxes, insurance, association fees, and maintenance do not always rise at the same pace.

Enable initial repairs when renovation cash is required before normal operations. Repair cost increases initial cash invested. Value after repairs becomes the starting property value for appreciation, while the mortgage remains based on purchase price unless the financing structure itself funds renovation. For U.S. rental-property tax concepts, recordkeeping, depreciation, and expense categories, consult IRS Publication 527. Tax treatment varies by jurisdiction and individual circumstances.

Exit assumptions

Holding period controls the number of annual projection rows and the modeled sale year. Annual appreciation compounds the starting property value when a known sale price is not supplied. Appreciation can be negative. Selling costs are deducted as a percentage of gross sale price and commonly include brokerage, legal, transfer, staging, and closing charges. Enable known sale price when you have a specific exit estimate; otherwise the model uses appreciation. Net sale proceeds equal sale price minus selling costs and the remaining loan balance. Housing counselors approved by the U.S. Department of Housing and Urban Development can provide independent education on purchase and financing decisions; see the HUD counseling directory.

Understanding the results

Annualized return (IRR) is the discount rate that sets the net present value of initial cash, annual operating cash flows, and final sale proceeds to zero. It accounts for timing, unlike a simple profit percentage. A positive IRR indicates that modeled inflows exceed the initial investment on a time-adjusted basis; a negative IRR indicates that the sequence of modeled cash flows does not recover the investment at a positive annual rate.

Total profit at sale is cumulative effective rental income plus final net sale proceeds, less mortgage payments, operating expenses, and initial cash. Total cash-on-cash return divides that profit by initial cash invested; it is cumulative, not annualized. Year-one cash flow is effective income less operating expenses and mortgage payments. Cap rate divides first-year NOI by the starting property value and excludes financing, making it useful for comparing operating yield across properties. Monthly mortgage is principal and interest only. Initial cash required includes down payment or full cash purchase, closing costs, and enabled repairs.

Reading the charts and projection table

The outflow donut shows how first-year mortgage payments, vacancy loss, management, and operating expense categories share total cash outflow. Categories with zero values are omitted; when more than five categories are active, smaller items are combined into Other. The equity chart shows projected property value, remaining loan balance, and equity. Equity can grow through appreciation and principal repayment, but it can also decline when property value falls.

The annual table is the audit trail. Effective income is scheduled rent after vacancy and management. Operating expenses exclude mortgage payments. Cash flow is NOI less debt service, except the final year also includes net sale proceeds. Property value follows the selected appreciation or known-sale assumption, loan balance follows the amortization schedule, and “IRR if sold” recalculates the annualized return for a hypothetical sale at each year-end. Use the “Key years” option for a concise view without changing the underlying calculations or Excel export.

Practical interpretation and common mistakes

• Stress-test vacancy, maintenance, insurance, and exit price rather than relying on one optimistic case.
• Do not confuse cap rate with cash-on-cash return: cap rate ignores financing, while cash-on-cash depends heavily on leverage and upfront cash.
• Include realistic selling costs and remaining debt; gross property value is not the cash received at exit.
• Separate routine operating expenses from irregular capital improvements, and keep source records for each assumption.
• Compare the calculator output with lender documents, local market evidence, professional inspections, and qualified legal and tax advice. Fannie Mae’s consumer education materials provide additional background on mortgage readiness and homeownership.

This calculator provides a general financial projection. It is not personalized investment, lending, legal, accounting, or tax advice, and it does not guarantee property performance or financing approval.