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.
Monthly cash flow
Cash-on-cash return
Cap rate
| 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.
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
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.