Real estate deal analyzer workbook
The Alura deal analyzer is a free Excel workbook that runs a rental, a five-year pro forma with IRR, a BRRRR or flip, and a commercial loan size, all from your own numbers.
Free, no sign-up. Five tabs. Open it in Excel; the results fill in when the file opens. File dated September 28, 2026.
What each tab does
| Tab | What it does |
|---|---|
| Start here | How the cells work, a glossary of terms, and how to reach us. |
| Rental analyzer | One rental property, 1 to 4 units or a small multifamily building. Shows the loan, monthly PITIA, lender-style DSCR, NOI, cap rate, cash flow, cash-on-cash return, gross rent multiplier, the 1 percent rule, and break-even occupancy. |
| 5-year pro forma | Grows the Rental analyzer deal for five years, sells it at the end of year 5, and shows cash flow, loan balance, equity, IRR, and equity multiple. |
| BRRRR and flip | Buy and rehab, then refinance and hold, or sell. Shows the 70 percent rule max offer, all-in cost, cash back at the refinance, cash left in the deal, and flip profit and ROI. |
| Commercial loan sizing | Sizes a commercial loan by LTV, DSCR, and debt yield, names the test that limits the loan, and shows the equity you need at the purchase price. |
How the cells work
- Gold cells with blue text are inputs. Type over the example value with your own number.
- White cells are formulas. They update when an input changes, so leave them as they are.
- Type percents with the % sign, for example 7%.
- Every tab opens with a sample Tampa Bay deal, so the math runs right away. The examples are not a quote, a rate offer, or an appraisal.
- Printing: each calculator tab prints landscape and one page wide, with the disclosures at the bottom.
Rental analyzer
What you enter
- Purchase: purchase price, closing costs at purchase, rehab or repairs at purchase
- Loan: down payment (percent of price), interest rate, loan term in years, interest-only months (0 means amortizing)
- Income: gross monthly rent for all units, other monthly income (laundry, pet, storage), vacancy as a percent of gross potential income
- Expenses: property taxes per year, insurance per year, HOA dues per month, management (percent of collected rent), maintenance and capex reserve (percent of gross rent), owner-paid utilities per month, other expenses per month
What it shows
| Result | How the file figures it |
|---|---|
| Loan amount | Price times (1 minus down payment percent) |
| Monthly payment | Principal and interest, or interest only while interest-only months are above 0 |
| Monthly PITIA | Payment plus taxes, insurance, and HOA, per month |
| DSCR, lender style | Gross monthly rent divided by PITIA |
| Effective gross income | Gross potential income minus vacancy loss |
| Net operating income (NOI) | Effective gross income minus operating expenses, before debt service |
| Cap rate on price | NOI divided by purchase price |
| Annual and monthly cash flow | NOI minus annual debt service |
| Cash-on-cash return | Annual cash flow divided by total cash invested (down payment, closing costs, and rehab) |
| Gross rent multiplier | Price divided by annual gross rent. Lower is better. |
| 1 percent rule | Monthly rent divided by price. 1.00 percent or more passes this quick screen. |
| Break-even occupancy | Operating expenses plus debt service, divided by gross potential income |
The DSCR result comes with a plain-language check from the file: 1.25 or higher reads "strong for most DSCR loans", 1.00 to 1.24 reads "meets many DSCR loan programs", and below 1.00 reads "fewer programs, usually more down". Programs differ, and we confirm terms in writing.
DSCR calculator5-year pro forma
You set four growth assumptions: rent and other income growth per year, expense growth per year, property value growth per year, and selling costs at the year-5 sale. Year 1 comes from the Rental analyzer, so fill that tab in first.
For each of years 1 to 5 the tab shows NOI, debt service, cash flow before income taxes, year-end loan balance, property value, and equity. It handles interest-only months first, then amortizes over the rest of the term. At the end of year 5 it sells the property and shows the net sale proceeds, then the IRR, equity multiple, and total profit.
- IRR: the yearly return that accounts for when each dollar comes back, including the sale.
- Equity multiple: total cash back, cash flow plus sale proceeds, divided by the cash you put in.
This is the one part of the workbook with no online version on our site.
BRRRR and flip
What you enter
Purchase price, rehab budget, purchase closing costs (include lender points), holding months, monthly holding costs, loan-to-cost on price plus rehab, interest rate during the hold, after-repair value (ARV), refinance LTV as a percent of ARV, refinance closing costs, and selling costs as a percent of ARV for the flip case.
What it shows
- Offer check: the max offer by the 70 percent rule (ARV times 0.70, minus rehab), and whether your price is at or under it.
- Costs through the hold: the purchase loan, holding costs, financing costs (interest only on the full loan; rehab draws can lower it), all-in cost, and all-in cost as a percent of ARV.
- BRRRR: the refinance loan, cash back at the refinance, and cash left in the deal. A negative number means you pulled out more than you put in.
- Flip: gross profit, selling costs, net profit after selling, holding, and financing costs, and ROI on cash invested.
Example from the file: ARV is $370,000 and rehab is $60,000, so the 70 percent rule max offer is $370,000 times 0.70, minus $60,000, which is $199,000. The example's $205,000 price is above it. The 70 percent rule is a quick screen, not a lending rule.
Commercial loan sizing
You enter the NOI, the purchase price or appraised value, a market cap rate, which value to use (Price or Cap rate), and the lender's limits: maximum LTV, minimum DSCR, minimum debt yield, interest rate, and amortization. Every lender limit needs a value above zero.
The tab sizes the loan three ways, and the loan can be no larger than any of the three results, because lenders size the loan so it passes all three tests. It names the test that limits the loan, then shows the monthly payment, annual debt service, the resulting LTV, DSCR, and debt yield, and the equity required at the purchase price (the down payment before closing costs and reserves).
Example from the file: $168,000 of NOI on a $2,400,000 price. At the example's 70 percent LTV, the LTV test allows $1,680,000. At its 9 percent debt yield, the debt yield test allows about $1,866,667. At the example's rate and 25-year amortization, the DSCR test comes in lower than both, so the file reports "DSCR limits this loan." These are the file's sample limits, not our program terms.
Mistakes the file's own instructions help you avoid
- Typing percents without the % sign. The file asks for the % sign, for example 7.25%.
- Starting on the pro forma. Its year 1 comes from the Rental analyzer, so fill that tab in first.
- Typing over a white cell. White cells are formulas. Change the gold cells instead.
- Leaving a lender limit at zero on the commercial tab. Every limit needs a value above zero.
Prefer a quick check online?
Our seven calculators run in your browser, free, with no sign-up: DSCR, NOI and cap rate, cash-on-cash, cash-out refi, commercial sizing, 1031 clock, and flip and BRRRR. Open the investor tools.
Ready to send us the deal?
When the numbers work, send them to us. Tell us the deal and we will tell you which loan programs fit and what the terms look like today. A licensed loan officer calls you back the same business day.
The application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through.
For planning only. Not a loan offer or commitment to lend.
Related templates
Frequently asked questions
What is in the deal analyzer workbook?
Five tabs: Start here, Rental analyzer, 5-year pro forma, BRRRR and flip, and Commercial loan sizing. You type your numbers into the gold cells, and the white formula cells update on their own. Each tab opens with a sample Tampa Bay deal, so the math runs as soon as you open the file in Excel.
How does the workbook figure DSCR?
Two ways, and its glossary explains both. The rental tab uses lender-style DSCR: gross monthly rent divided by PITIA, the ratio many DSCR rental loans use to qualify a property. The commercial tab uses NOI divided by annual debt service. Each result in the workbook is labelled with the method it uses.
What does the 5-year pro forma add?
It grows the rental deal for five years using your rent, expense, and value growth assumptions, sells the property at the end of year five, and shows cash flow, loan balance, equity, IRR, and equity multiple. Year one comes from the Rental analyzer, so fill in that tab before you look at the pro forma.
Does the workbook give the same results as the online flip calculator?
Not always. Both screen an offer the same way: after-repair value times 0.70, minus the rehab budget. The workbook's BRRRR and flip tab also finances the purchase at a loan-to-cost, adds interest during the hold, and reports return on the cash you invest. The online calculator reports return on all-in cost.
Are the example numbers a quote?
No. The workbook says every tab opens with a sample Tampa Bay deal so the math runs, and that the examples are not a quote, a rate offer, or an appraisal. Replace them with your own numbers. If the deal works, send it to us and we will tell you which loan programs fit.
Can I use it for a commercial property?
Yes, for loan sizing. The Commercial loan sizing tab takes NOI, the price or appraised value, and a lender's limits for LTV, DSCR, and debt yield. It sizes the loan all three ways, keeps the loan within all three, names the test that limits it, and shows the equity you need at the price.
