Property

Rental property cash-on-cash calculator

One property, one set of assumptions: cash invested, principal and interest, operating expenses, yearly cash flow, cash-on-cash return, and cap rate. It is a screen, not an appraisal.

How to use it

Enter the purchase price and the cash due around closing: down payment, closing costs, and upfront repairs. The loan is price minus down payment. For an all-cash purchase, set the down payment equal to the price. Type 6.5 for a 6.5% yearly rate, not 0.065.

Maintenance and management are percents of gross scheduled rent, which is monthly rent times 12. They are not percents of cash flow. Put property tax and insurance in their own fields so they are not hidden inside the mortgage payment. A partial first month of rent is a different question: Prorated rent calculator. A flip, rather than a hold, belongs on House flip profit calculator.

Formula

Loan = price − down payment. The payment is the standard fully amortizing payment, principal and interest only. If the rate is zero, payment = loan ÷ (years × 12). Vacancy loss = (yearly rent + other yearly income) × vacancy ÷ 100. NOI = effective income − operating expenses. Cash flow = NOI − yearly principal and interest. Cash invested = down payment + closing costs + upfront repairs. Cash-on-cash = cash flow ÷ cash invested. Cap rate = NOI ÷ purchase price.

Worked example

The sample buys at $240,000.00 with $48,000.00 down and $5,000.00 in closing costs. Rent is $2,000.00 a month, vacancy is 5%, and the loan is 6% for 30 years. The payment is $1,151.14 a month. NOI is $16,080.00 a year, cash flow is $2,266.36 a year, and cash-on-cash on $53,000.00 invested is 4.28%. Cap rate on the purchase price is 6.7%.

Questions

How is cash-on-cash different from cap rate?

Cash-on-cash uses the cash you put in and the money left after the mortgage. Cap rate ignores the loan and divides NOI by the purchase price. A property can have a workable cap rate and a weak cash-on-cash return when the payment is heavy. This sample’s cash flow can be negative. That is a result, not a recommendation.

What does NOI leave out?

NOI here is yearly income after vacancy, minus tax, insurance, HOA or society dues, the maintenance percent, the management percent, and other monthly costs. It is before principal and interest, before income tax, and before depreciation. Capital repairs beyond the maintenance percent are not in it.

Which mortgage does the payment assume?

A fixed rate that amortizes fully over the term you enter. It is not interest-only, not an adjustable rate, and not a balloon. Taxes and insurance stay in the expense fields so you do not count them twice.

What is the debt-service figure?

It is NOI divided by the yearly principal and interest. Above 1 means NOI covers that payment under these assumptions. It says nothing about income tax or a vacant month you forgot to type.