Real Estate Investment Analyzer

Analyse a rental: cap rate, cash-on-cash return, DSCR, yearly cash flow, loan paydown and appreciation, with each formula shown on its numbers.

The interactive tool loads here when JavaScript runs.

About this tool

What is the Real Estate Investment Analyzer?

The Real Estate Investment Analyzer runs the numbers on a buy-to-let property. Enter the price, rent, down payment, closing costs, mortgage rate and term, property taxes, insurance, maintenance, vacancy and management fee, and it returns the year-one cap rate, cash-on-cash return, debt service coverage ratio (DSCR) and total return on the cash you put in, plus a year-by-year table of rent, NOI, mortgage, cash flow, loan balance and value.

Click any metric card to see its formula filled in with your numbers. Rent and value both grow at the Annual Appreciation rate, starting from today's rent in year one, while taxes, insurance and maintenance stay flat at the amounts you enter.

The calculation runs in your browser, and Copy Results Link copies a URL with your inputs. The results are a model of the assumptions you type, useful for comparing deals, and not investment advice.

  • Cap rate, cash-on-cash, total ROI and DSCR with worked formulas
  • Vacancy and percentage-based management fee
  • Month-by-month mortgage amortisation, including 0% loans
  • Year-by-year cash flow, equity and value table
  • Shareable link with all inputs
Read the guide: Rental Property Returns: Cap Rate, Cash-on-Cash and DSCR

Updated

How to use the Real Estate Investment Analyzer

  1. On the Property tab, enter Purchase Price, Monthly Rent, Annual Appreciation and the Analysis Period. Property Type is a label only.
  2. On the Financing tab, set Down Payment (%), Closing Costs (%), Loan Term, Interest Rate, Tax Rate and Depreciation Rate.
  3. On the Operations tab, enter annual Property Taxes, Insurance and Maintenance, plus Vacancy Rate and Property Management as percentages.
  4. Read the Cap Rate, Cash-on-Cash, Total ROI and DSCR cards. Click one to see its formula with your figures.
  5. Check the Annual Cash Flow Analysis and Financial Breakdown, then use Copy Results Link to save or share the deal.

Worked examples

Default single-family rental

Input

300,000 price, 20% down, 3% closing, 6.5% for 30 years, 2,500 rent, 5% vacancy, 8% management, 3,600 tax, 1,200 insurance, 2,400 maintenance

Output

NOI 19,020; debt service 18,204; cash flow 816; cap rate 6.34%; cash-on-cash 1.18%; DSCR 1.04

Effective rent is 28,500 after vacancy, and operating costs are 9,480 including 2,280 of management. The mortgage takes almost all of the NOI, which is typical when rates are near or above cap rates.

Same house at 3,000 rent

Input

Monthly Rent 3,000, everything else unchanged

Output

NOI 24,264; cash flow 6,060; cap rate 8.09%; cash-on-cash 8.78%; DSCR 1.33

A 20% rent increase raises cash flow more than sevenfold because the mortgage is fixed. Rent assumptions are where most deal analysis goes wrong, so check local comparables.

Background and insight

Each metric answers a different question. Cap rate = NOI / purchase price, where NOI is rent after vacancy minus operating costs and before any mortgage; it compares properties as if bought with cash. Cash-on-cash = year-one pre-tax cash flow / cash invested (down payment plus closing costs); it shows what your actual money earns after debt. DSCR = NOI / annual debt service; Freddie Mac and Fannie Mae require at least 1.25 on their standard multifamily loans, and other lenders set their own minimums.

Leverage cuts both ways, and the defaults show it. A 300,000 house renting at 2,500 has a 6.34% cap rate, but a 6.5% mortgage costs more than that yield, so year-one cash flow is only 816 and cash-on-cash is 1.18% on 69,000 invested. Raise rent to 3,000 and NOI rises to 24,264: cap rate 8.09%, cash-on-cash 8.78%, DSCR 1.33. When the cap rate is below the mortgage rate, most of the return has to come from appreciation and loan paydown.

Total ROI adds cumulative cash flow, appreciation and principal repaid, then divides by cash invested. It ignores selling costs and taxes, so treat it as an upper bound. Depreciation is shown as a tax benefit row: US residential rental buildings are depreciated over 27.5 years (3.636% a year) and commercial over 39 years, but only the building is depreciable, not the land, so applying the rate to the full price overstates the deduction.

Common use cases

  • Screening listings

    Discard properties whose cap rate is far below the mortgage rate before booking a viewing.

  • Setting a maximum offer

    Lower the purchase price until cash-on-cash and DSCR reach your targets.

  • Lender conversations

    Check DSCR against the lender's minimum before applying for an investment loan.

  • Self-managing vs hiring a manager

    Set Property Management to 0% and 10% to see what a manager costs in yearly cash flow.

Tips and limitations

  • Year one uses today's rent; rent and value start growing in year two at the appreciation rate.
  • Operating costs do not grow with inflation in this model, which flatters later years. Raise them yourself for long horizons.
  • Budget capital expenditures (roof, HVAC, appliances) inside Maintenance; many investors set aside 5% to 10% of rent.
  • DSCR shows 0 for an all-cash purchase because there is no debt to cover.
  • Selling costs, income tax on cash flow and depreciation recapture on sale are not included in Total ROI.

Sources and further reading

  1. Conventional Small: fixed-rate loans, Freddie Mac Multifamily. Term sheet with a 1.25x minimum amortizing debt coverage ratio
  2. Conventional Properties Term Sheet, Fannie Mae Multifamily. Minimum DSCR of 1.25x for conventional multifamily loans
  3. Publication 527, Residential Rental Property, Internal Revenue Service. Rental income, expenses and the 27.5-year depreciation of residential buildings
  4. Publication 946, How To Depreciate Property, Internal Revenue Service. Recovery periods, including 39 years for nonresidential real property, and why land is not depreciable
  5. Tips on rental real estate income, deductions and recordkeeping, Internal Revenue Service

Frequently asked questions

How do you calculate cap rate on a rental property?

Divide net operating income by the purchase price. NOI is a year of rent after vacancy minus operating costs such as taxes, insurance, maintenance and management, but not mortgage payments. A 300,000 property with NOI of 19,020 has a cap rate of 6.34%.

What is the difference between cap rate and cash-on-cash return?

Cap rate ignores financing and compares a property's income with its price. Cash-on-cash return subtracts mortgage payments and divides by the cash you actually invested. With a 6.5% mortgage, a 6.34% cap rate can turn into a cash-on-cash return of just over 1%.

What is a good DSCR for a rental property loan?

Freddie Mac and Fannie Mae require a DSCR of at least 1.25 on their standard multifamily loans, meaning NOI covers the mortgage with 25% to spare. Other lenders set their own minimums, so ask yours. A DSCR below 1.0 means rent does not cover the loan payment and you are topping it up from your own pocket.

Does the real estate analyzer include vacancy and property management?

Yes. Vacancy Rate is taken off gross rent first, and Property Management is a percentage of the rent you actually collect. At 2,500 a month with 5% vacancy and 8% management, effective rent is 28,500 a year and the manager costs 2,280.

How is total ROI calculated for a rental property here?

Total ROI adds cumulative cash flow, the rise in property value and principal repaid over the analysis period, then divides by down payment plus closing costs. It leaves out selling costs and taxes, so the money you would actually walk away with is lower.

Why is my rental cash flow negative even though the cap rate looks fine?

Because the mortgage costs more than the property yields. When the interest rate on the loan is above the cap rate, each borrowed dollar earns less than it costs, and leverage reduces cash flow. A larger down payment, lower price or higher rent are the levers.

Is there an in-depth guide to the Real Estate Investment Analyzer?

Yes. “Rental Property Returns: Cap Rate, Cash-on-Cash and DSCR” covers the background, how it works, common pitfalls and worked examples. Read the full guide.