Good Columns
Shop all

Free tools / Rental Property Cash Flow Calculator

Rental Property Cash Flow Calculator

Enter the price, loan and rent for a property and see the monthly mortgage payment, cash flow, cash-on-cash return, cap rate and gross rent multiplier as you type. Every result comes with the formula and the figures behind it.

The purchase

Cash paid at purchase on top of the down payment.

Income

Share of the year the unit sits empty.

Running costs

Of rent collected.

Of rent collected. Use 0 if you self-manage.

Example figures are filled in. Replace them with yours.

Monthly cash flow

Cash-on-cash return

Cap rate

The numbers
Monthly mortgage payment
Rent collected a month
Running costs a month
Net operating income a month
Monthly cash flow
Annual cash flow
Cash invested
Net operating income a year
Gross rent multiplier

The working

    Rental Property Deal Analyzer
    US$9.99 launch price. Up to 10 rentals side by side: cash flow and returns.

    Buy on Gumroad, US$9.99

    How it works

    Mortgage payment

    Loan = price - down payment. Monthly payment = L x r / (1 - (1 + r)^-n), where L is the loan, r is the yearly rate divided by 12 and n is the number of monthly payments. At a 0% rate it is the loan divided by n.

    Cash flow

    Rent collected = rent x (1 - vacancy). Maintenance and management are percentages of rent collected. Monthly cash flow = rent collected - property tax / 12 - insurance / 12 - HOA - maintenance - management - other costs - mortgage payment.

    Cash-on-cash return

    Yearly cash flow divided by the cash you put in: down payment plus closing costs.

    Cap rate and gross rent multiplier

    Cap rate = yearly net operating income / purchase price, where net operating income is rent collected less running costs and leaves out the mortgage. Gross rent multiplier = purchase price / yearly scheduled rent.

    Compare up to 10 rentals side by side

    The Rental Property Deal Analyzer is a spreadsheet that puts up to 10 deals next to each other. The Landlord Bundle adds the Schedule E Rent Ledger and the Inspection Kit.

    Questions

    How do you calculate cash flow on a rental property?

    Take the rent you collect after vacancy, subtract running costs (property tax, insurance, HOA, maintenance, management and anything else), then subtract the mortgage payment. What is left each month is cash flow. This calculator shows each line.

    What is cash-on-cash return?

    It is yearly cash flow divided by the cash you invested, meaning the down payment plus closing costs. It looks at the cash you put in, not the purchase price.

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

    Cap rate uses net operating income and the purchase price, so it ignores how the property is financed. Cash-on-cash return uses cash flow after the mortgage and the cash you invested, so it changes with the loan.

    How is the monthly mortgage payment worked out?

    With the standard amortization formula, payment = L x r / (1 - (1 + r)^-n). For a US$300,000 loan at 7% over 30 years the payment is US$1,995.91 a month. The payment covers principal and interest only; tax and insurance are entered separately.

    What is a gross rent multiplier?

    It is the purchase price divided by a year of scheduled rent. A lower number means you pay less per dollar of rent, before any costs. It is a quick way to compare two properties on rent alone.

    Embed this calculator

    Copy this code into your own page or blog post. It is free to use, and the credit link below the calculator stays in.

    Preview of the credit line: Calculator by Good Columns

    One email when a new file is out

    The free Rent Payment Tracker is ready to download now. Leave your email and we send one message when a new file or free tool is out, and nothing else unless you ask.

    The small print

    This calculator does arithmetic on the figures you enter. It is not tax, legal, accounting, investment or financial advice, is not endorsed by the IRS or any government body, and makes no buy or sell call on any property. You are responsible for the figures you enter.

    Good Columns, Melbourne, Australia. hello@goodcolumns.com

    Nothing you type is sent anywhere. The calculation runs in your browser, and the page sets no cookies and stores nothing.