Excel workbook
Rental Property Deal Analyzer: Cash Flow, Cap Rate, Cash-on-Cash and DSCR in Excel
Enter the price, financing, rent and expenses and see cash flow, cap rate, cash-on-cash return and coverage, with best, expected and worst cases side by side.
$29 one time · 14-day full refund · example and blank copies · download link by email
🌙 The desk is asleep. The store never is.
Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning.
Browse the storeWho it is for
Small landlords, first-time investors and bookkeepers who want to compare a rental purchase on the same set of numbers every time.
Not the right fit if
You want a prediction of returns or a lending decision: results depend entirely on the estimates you enter.
Why it is different
- Every assumption sits in one visible cell, so you can change rent growth, vacancy or the rate and see the result at once.
- It shows break-even occupancy and coverage, so you see how much room the deal has before it loses money.
- A filled example for an invented duplex and a blank copy with working formulas.
What is inside
- Start Here. Purpose, which cells to fill in and what the workbook cannot predict.
- Deal. Price, closing costs, loan terms, rent, vacancy and every operating expense.
- Results. Payment, net operating income, cap rate, cash-on-cash return, debt service coverage and break-even occupancy.
- Scenarios. Best, expected and worst cases on rent, vacancy and expenses.
- 5-Year Hold. Year by year cash flow, loan balance, equity and total return under the growth rates you choose.
- Checks. Missing inputs and numbers that look out of range.
A look inside
Example data, real formulas
Get it
Rental Property Deal Analyzer
Or pay with PayPal
Uses the email and terms box above. You get the same download link by email.
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Get every update for a year, $29: the Yearly Updates Pass gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal.
Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal advice. The results are only as good as the numbers you enter, and rents, vacancy, repairs and values are estimates. It does not predict returns. Not investment, tax, legal or lending advice. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Ways to get it
Just this kit, or more
Membership
$29 a month
Every kit and document pack in the store, including new ones. Cancel any time.
See the membershipQuestions
Common questions
What do I get and how is it delivered?
The Rental Property Deal Analyzer as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment.
Will it open on a Mac, Google Sheets or my phone?
Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund.
Is this legal or tax advice?
No, it is not investment, tax, legal or lending advice.
Is it the right fit for me?
It is made for small landlords, first-time investors and bookkeepers who want to compare a rental purchase on the same set of numbers every time. Skip it if you want a prediction of returns or a lending decision: results depend entirely on the estimates you enter.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others
Bundle
Landlord Bundle
This product plus 2 more, in one download.
$69 instead of $82 separately
Bundle
Short-Term Rental Host Bundle
This product plus 3 more, in one download.
$75 instead of $101 separately
Month-End Close Workbook
A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock.
$19