HarborSheet

Rental Property Cash Flow & Schedule E Estimator

Type in one rental's numbers and see its monthly and yearly cash flow, cash-on-cash return, and a Schedule E-style expense estimate with the 2026 IRS mileage rates. Free, no sign-up, and nothing you type leaves your browser.

Income
Mortgage payment

Not sure of the split? Your monthly mortgage statement lists interest and principal separately. Leave escrow out here and enter taxes and insurance below.

Expenses
Business miles (optional)
Change the mileage rates

2026 IRS business rates: 72.5¢ (Jan 1–Jun 30) and 76¢ (Jul 1–Dec 31), per IRS Announcement 2026-11. For another year, put that year's rate in both boxes.

Cash-on-cash (optional)

Your results

Monthly cash flow
–
Yearly cash flow
–
Cash-on-cash
–

Schedule E-style estimate (yearly)

LineItemAmount

Mortgage principal is left out because it isn't deductible. Line 18 depreciation isn't calculated here; it usually lowers your taxable result, so ask your tax preparer. Rent assumes your vacancy % for the whole year. HOA dues are shown on line 19 (Other). The mileage deduction lowers taxes but isn't counted in cash flow.

Track it all year in the full spreadsheet. The HarborSheet Rental Property Tracker logs every rent payment, expense and mile for up to 5 rentals and fills in your Schedule E summary automatically. Works in Excel and Google Sheets.

See the templates on Etsy (opens in a new tab)

Questions

Is mortgage principal deductible on Schedule E?

No. Only the interest part of your mortgage payment goes on Schedule E (line 12, mortgage interest paid to banks). The principal part is paying back the loan, so it lowers your cash flow but it is not a deductible expense. Your lender's Form 1098 shows the interest you paid for the year.

What is the IRS business mileage rate for 2026?

The IRS set 72.5¢ per mile for business miles driven January 1 to June 30, 2026, then raised it to 76¢ per mile for miles driven July 1 to December 31, 2026 (IRS Announcement 2026-11). Rental-related driving goes on Schedule E line 6, auto and travel. Check irs.gov for other years.

Why is my Schedule E profit different from my cash flow?

Cash flow counts every dollar that leaves your pocket, including mortgage principal. Schedule E leaves principal out, adds non-cash deductions like the mileage deduction, and usually includes depreciation. This estimator does not calculate depreciation, so your real Schedule E result will often be lower than the estimate shown here.

Debt snowball or debt avalanche: which pays off debt faster?

The avalanche method (highest interest rate first) usually costs the least interest and is often a little faster. The snowball method (smallest balance first) pays off individual debts sooner, which keeps many people motivated. The calculator shows both debt-free dates side by side so you can see the real difference for your numbers.

Is this calculator tax advice, and is my data saved?

It is not tax advice. It is an estimate to help you plan and to have cleaner numbers for your tax preparer. Everything runs in your browser: nothing you type is saved, sent, or tracked, and the page uses no cookies.