See your real return before you buy.
Most deal sheets take out the loan, taxes and insurance and call the rest cash flow. This one takes out every bill the owner actually pays, unit by unit, and shows the number a lender sees next to the number you keep.
Your numbers on one branded page you can hand to a lender, a partner, or your own file. It downloads the second you hit the button.
One more, only so I can actually be useful. What do you have, and what do you need?
Pre-filled with a sample 6-unit deal. Change anything.
For MLS / listed deals where you cover the seller’s listing-agent commission. Leave at 0 for off-market.
All expenses are per year. Set management to 0 if you manage it yourself.
Drag the gap loan below and watch the two lines move apart.
How the structure changes everything, run live on the deal above, with no extra private money.
Cash flow, the equity you build, and what you would actually make if you sold: after selling costs and after getting your own cash back.
| Year | Cash flow | Cumulative | Value | Your equity |
|---|
It takes the rent from every unit, subtracts vacancy and every bill the owner pays (taxes, insurance, owner-paid utilities, lawn and trash, management, repairs and reserves), then the loan payment, and shows what is left each month. It also shows the cash it takes to buy, your cash-on-cash return, and a 5-year projection.
Lender DSCR is how most DSCR lenders size a loan: total rent divided by the loan payment, taxes and insurance. Real DSCR is income after every expense divided by the loan payment. A deal can show 1.46 to a lender and still lose money every month, because the lender version leaves out repairs, utilities, management and vacancy.
Vacancy, utilities the owner pays, repairs, management and reserves. Many sheets also count an empty unit as rented and use the seller's current property tax bill. Put every one of those in before you trust the cash flow.
On property that is not your homestead, Florida caps yearly assessment increases at 10%, and that cap resets when the property sells. The year after you buy, the county property appraiser re-values it at market, so the seller's old bill is not the bill you will pay. Check the estimate with your county property appraiser before you make an offer.
Usually not the residential kind. Most residential and DSCR loans cover one to four units. Five units and up is commercial lending, which often means a larger down payment and different terms. Ask your lender before you count on a rate.
The sample uses 5% for vacancy and about 5% of rent for reserves. Use more for older buildings, a well or septic system, or a unit that is empty today. Run the deal with one unit empty and see if it still works.
Spreadsheet versions: Long-Term Rental Calculator · Complete Investor Toolkit, $59 · All free calculators →
InvestorBuilt: Deal Analyzer puts all three calculators in your pocket. PDF exports, instant verdicts, and it works offline, even standing in a house with no signal.
Get it on the App Store