Collect the inputs.
Rent rolls, leases, operating records, building details and financing terms. Label the source and date for each figure.
ANY PROPERTY · ANY MARKET
Before you invest,
check the numbers.
My custom-built Excel Deal Analyzer helps you make informed investment decisions on multifamily and commercial properties.
- Analyze rental income and operating expenses.
- Calculate mortgage payments, debt service, NOI and cash flow.
- Compare cap rate, cash-on-cash return and investment scenarios.
Free DEAL ANALYZER
Send it to my inbox.
Join my email list to receive my custom-built Excel calculator for multifamily and commercial properties, plus the PDF guide, in your welcome email. You can also download both after signup.
Download Excel calculator (.xlsx) ↓Download PDF guide ↓Download both files (ZIP) ↓
Open the .xlsx file in Microsoft Excel and edit the pale-gold input cells. The example is fictional.
A LOOK INSIDE THE FREE DEAL ANALYZER
Real tools.
A clearer picture.
See the Excel calculator and companion PDF before you sign up.
Start with the assumptions.
Income, expenses, NOI, financing and cash flow, with editable inputs.
EDITABLE EXCEL WORKBOOK + SIX-PAGE PDF
Make the assumptions visible.
Keep the evidence beside the arithmetic.
Follow the cash.
Enter rents, annual expenses and financing in Excel. Formulas calculate NOI, debt service, cash flow, cap rate and cash-on-cash return.
Ask what could change.
Compare loan terms, cash balloon payoffs and refinancing, then review the Year 0–10 forecast and property vs. market returns. The PDF explains the inputs through a fictional example.
THE COMPANION PDF
Keep the evidence
beside the arithmetic.
A framework for better questions.
Use the guide’s fictional example and property worksheet to organize the information behind your calculations.
USE IT WITH YOUR PROPERTY RECORDS
A starting point for better questions.
This guide is educational information, not an appraisal, investment recommendation, tax or legal advice, loan commitment, or guarantee of returns. Example figures are invented; they are not local market estimates or available financing.
Verify property-specific information and consult qualified professionals before making decisions.