📘
🏠 Rental Portfolio Workbook — End-User Instruction Manual
Instruction Manual · How to use this template
The Rental Portfolio Workbook is a premium Google Sheets template designed for landlords, real-estate investors, and property managers who want a single, always-current view of their entire rental portfolio. You enter basic property details — rent, vacancy, expenses, mortgage, and market value — and the workbook instantly computes over 20 professional metrics per property including NOI, cap rate, DSCR, cash-on-cash return, and breakeven occupancy. It flags vacancy risk, models five-year equity growth, and rolls everything up into a Portfolio Dashboard that groups performance by property type. Whether you own two duplexes or twenty mixed-use buildings, the workflow is the same: fill in the Property Ledger, then read the Dashboard.
⚡ Quick start
1Step 1 — Make a copy: Open the shared Google Sheets link, click File → Make a copy, and save it to your own Google Drive. Never edit the original.
2Step 2 — Read the Read Me sheet: It contains a color-key legend, quick-start tips, and notes on which columns are auto-computed (marked with ƒ). Skim it once so you know what the colors mean.
3Step 3 — Enter your first property on the 🏠 Property Ledger sheet: Fill in columns Property, Type, Units, Gross Rent, Vacancy, Expenses, Mortgage, and Value — one row per property. All ƒ columns will calculate instantly.
4Step 4 — Set vacancy targets on 📊 Portfolio Dashboard: After your properties appear, enter your desired Vac Target for each property so the dashboard can compute recoverable revenue.
5Step 5 — Review KPI cards and charts: Scroll to the top of each sheet to see the summary KPI cards, then browse the charts below to spot your strongest and weakest performers.
6Step 6 — Add more properties over time: Simply add a new row on the Property Ledger for each acquisition. The Dashboard updates automatically via lookups.
The Property Ledger is the heart of the workbook. Every property you own gets one row. You enter six core financial inputs and the sheet instantly computes over 20 performance metrics, ranks your properties, flags risk, and feeds all data downstream to the Portfolio Dashboard.
✍️ Step by step
11. In the Property column, type a short, unique name for each property (e.g., '742 Evergreen Duplex'). This name is used as the key in lookups, so keep it consistent and unique.
22. In the Type column, enter the property category — for example 'SFH', 'Duplex', 'Triplex', 'Quad', 'Apartment', 'Commercial', or 'Mixed-Use'. The Dashboard groups and averages by this value, so use consistent labels.
33. In the Units column, enter the total number of rentable units as a whole number (e.g., 1 for a single-family home, 4 for a quadplex). Per-unit metrics depend on this.
44. In Gross Rent, enter total monthly rental income before any vacancy adjustment, in dollars (e.g., 4800). This is what you would collect if every unit were occupied and paying full rent.
55. In Vacancy, enter the current vacancy rate as a percentage (e.g., 5 for 5%). This represents the portion of gross rent lost to unoccupied units or non-paying tenants.
66. In Expenses, enter total monthly operating expenses in dollars — include property tax, insurance, maintenance, management fees, HOA, utilities paid by owner, etc. Do NOT include mortgage payments here.
77. In Mortgage, enter the total monthly mortgage payment (principal + interest + escrow if applicable) in dollars. If the property is owned free-and-clear, enter 0.
88. In Value, enter the current estimated market value of the property in dollars (e.g., 380000). Use your latest appraisal, Zillow estimate, or purchase price — whichever reflects reality best. This drives cap rate, price-per-unit, and equity projections.
99. After filling a row, verify that all ƒ columns populate. Scroll right to check ƒStatus and ƒNOI Rank — these are your quick health indicators. Repeat for each property in your portfolio.
📋 Column-by-column
| Property | INPUT — Type the unique name or address of the property, e.g., '221B Baker St Duplex'. Keep it short but distinctive because this value appears in every chart label and is used as the lookup key on the Dashboard. No two rows should share the same name. |
| Type | INPUT — Enter the property classification such as 'SFH' (single-family home), 'Duplex', 'Triplex', 'Quad', 'Apartment', 'Commercial', or 'Mixed-Use'. Use the exact same spelling each time (e.g., always 'Duplex', not sometimes 'duplex') because the Portfolio Dashboard aggregates by this field using COUNTIF and AVERAGEIFS. |
| Units | INPUT — Enter the number of rentable units as a whole number. For a single-family home enter 1; for a fourplex enter 4. This drives all per-unit metrics (Rent/Unit, CF/Unit, Price/Unit, NOI/Unit). If you add an ADU, update this number. |
| Gross Rent | INPUT — Enter the total monthly rent you would collect at full occupancy, in dollars. Example: a duplex where each unit rents for $1,400 → enter 2800. Do not subtract vacancy here; the sheet handles that. Currency format, no dollar sign needed. |
| Vacancy | INPUT — Enter the vacancy rate as a percentage number (e.g., type 5 for 5%, not 0.05). This represents expected or actual lost rent due to vacant units, tenant turnover, or non-payment. The national average is roughly 5–8%; a self-managed single-family rental might be 3%, while a property in a soft market could be 10%+. |
| ƒNet Rent | AUTO-COMPUTED — Net Rent equals Gross Rent minus the Vacancy Loss. Formula in words: Net Rent = Gross Rent × (1 − Vacancy ÷ 100). It represents the realistic monthly income you actually expect to collect. A healthy Net Rent is as close to Gross Rent as possible; a large gap signals high vacancy exposure. |
| Expenses | INPUT — Enter total monthly operating expenses in dollars. Include property taxes, insurance, repairs and maintenance, property management fees, landscaping, HOA dues, and any utilities you pay as landlord. Do NOT include mortgage principal or interest — that goes in the Mortgage column. Example: $1,200 per month. |
| ƒNOI | AUTO-COMPUTED — Net Operating Income. NOI = Net Rent − Expenses (monthly). It measures the property's earning power before debt service. A positive NOI means the property covers its operating costs from rent alone. Typical small residential properties have monthly NOIs ranging from a few hundred to several thousand dollars. If NOI is negative, the property loses money operationally regardless of financing. |
| Mortgage | INPUT — Enter the total monthly mortgage payment in dollars, including principal, interest, and any escrowed taxes/insurance if your lender bundles them. If the property is owned free-and-clear (no loan), enter 0. Example: $1,650 per month. |
| ƒCash Flow | AUTO-COMPUTED — Cash Flow = NOI − Mortgage (monthly). This is the actual money left in your pocket each month after all operating costs and debt payments. Positive cash flow means the property pays you; negative means you're subsidizing it. For buy-and-hold investors, even a small positive cash flow ($100–300/unit/month) is considered acceptable when equity growth is strong. |
| Value | INPUT — Enter the current market value of the property in dollars. Use your most recent appraisal, a comparable-sales estimate, or a conservative Zillow/Redfin figure. Example: 380000. This drives cap rate, GRM, price-per-unit, net yield, and the five-year equity projection charts. |
| ƒCap Rate | AUTO-COMPUTED — Capitalization Rate. Cap Rate = (NOI × 12) ÷ Value × 100, expressed as a percentage. It measures return on the property as if you paid all cash. A higher cap rate means higher return relative to price. Typical ranges: 4–6% in hot urban markets, 7–10% in secondary markets, 10%+ in higher-risk areas. Below 4% may signal over-priced; above 12% may signal hidden risk. |
| ƒOpEx % | AUTO-COMPUTED — Operating Expense Ratio. OpEx % = Expenses ÷ Gross Rent × 100. It tells you what share of your gross rent is eaten by operating costs. A healthy OpEx % for residential rentals is typically 35–50%. Above 50% means more than half of every rent dollar goes to expenses, which compresses your NOI and cash flow. |
| ƒDSCR | AUTO-COMPUTED — Debt Service Coverage Ratio. DSCR = NOI ÷ Mortgage. It measures how comfortably rental income covers the mortgage. A DSCR of 1.0 means NOI exactly equals the mortgage — breakeven. Lenders typically require 1.20–1.25 minimum. Above 1.5 is strong; below 1.0 means the property cannot cover its debt from operations. If Mortgage is 0 (no debt), DSCR may display as N/A or a very high number. |
| ƒGRM | AUTO-COMPUTED — Gross Rent Multiplier. GRM = Value ÷ (Gross Rent × 12). It estimates how many years of gross rent it would take to equal the purchase price. Lower is generally better: a GRM of 8–12 is typical for residential rentals. Above 15 suggests the property is expensive relative to its income. GRM ignores expenses, so always cross-reference with cap rate. |
| ƒRent/Unit | AUTO-COMPUTED — Rent per Unit = Gross Rent ÷ Units. Shows the average monthly rent per unit. Useful for comparing efficiency across properties of different sizes. If one 4-unit building averages $900/unit while another averages $1,300/unit, the second extracts more revenue per door. |
| ƒStatus | AUTO-COMPUTED — A text-based health flag derived from key metrics (likely DSCR and cash flow). Expect labels such as 'Healthy', 'Watch', or 'At Risk'. Green/Healthy means strong cash flow and DSCR above lender minimums. Watch means marginal. At Risk means negative cash flow or DSCR below 1.0. Use this as a quick triage column — scan it to see which properties need attention. |
| ƒNOI Rank | AUTO-COMPUTED — Ranks each property from 1 (highest NOI) to N (lowest NOI) within your portfolio. Ties may share a rank. Use it to instantly spot your top earner and your weakest performer without scanning dollar amounts. |
| ƒBreakeven | AUTO-COMPUTED — Breakeven Occupancy = (Expenses + Mortgage) ÷ Gross Rent × 100, expressed as a percentage. It tells you the minimum occupancy rate needed for the property to cover all costs. A breakeven of 75% means you can afford 25% vacancy before losing money. Lower is safer. Above 90% means even a single vacancy could push you into negative territory. |
| ƒCF/Unit | AUTO-COMPUTED — Cash Flow per Unit = Cash Flow ÷ Units. Shows how much monthly cash flow each door generates. A common investor benchmark is $100–200/unit/month for a 'good' deal. Below $0/unit means the property is a net drag. This helps compare a cash-flowing duplex vs. a marginally profitable 10-unit building on an apples-to-apples basis. |
| ƒPrice/Unit | AUTO-COMPUTED — Price per Unit = Value ÷ Units. Indicates how much each door cost you. Useful for comparing acquisition efficiency: two buildings worth $400K each look identical until you see one is 4 units ($100K/unit) and the other is 8 units ($50K/unit). Lower price-per-unit generally means more scalable returns. |
| ƒNet Yield | AUTO-COMPUTED — Net Yield = (NOI × 12) ÷ Value × 100, expressed as a percentage. It is essentially the same concept as cap rate — the annual net operating return relative to property value. It provides a yield-oriented perspective for investors comparing real estate to bonds or dividend stocks. A good net yield mirrors a good cap rate: 5–10% for most residential portfolios. |
| ƒVac Cost | AUTO-COMPUTED — Vacancy Cost = Gross Rent × (Vacancy ÷ 100), in monthly dollar terms. It converts your vacancy percentage into an actual dollar figure so you can see exactly how much money vacancy is costing you each month. A $5,000 gross rent property at 8% vacancy is losing $400/month. Use this to prioritize lease-up efforts on your most expensive vacancies. |
| ƒRent Yield | AUTO-COMPUTED — Rent Yield = (Gross Rent × 12) ÷ Value × 100, expressed as a percentage. Unlike cap rate, this uses gross rent (before expenses), so it is always higher. It measures top-line income relative to asset value. A rent yield of 10–12% is typical for cash-flow markets; below 6% suggests the property's value is driven more by appreciation than income. |
| ƒNOI/Unit | AUTO-COMPUTED — NOI per Unit = NOI ÷ Units. Measures operating profitability on a per-door basis. Higher is better. If one 4-plex generates $250/unit NOI while another generates $600/unit, the second property is operationally stronger even if total NOIs differ. Helps you evaluate operating efficiency independent of building size. |
| ƒCF Margin | AUTO-COMPUTED — Cash Flow Margin = Cash Flow ÷ Net Rent × 100, expressed as a percentage. It shows what percentage of your collected rent survives as cash flow after all expenses and debt. A CF Margin of 20–30% is solid; below 10% means the property is barely profitable; negative means you're losing money. Think of it as your profit margin as a landlord. |
📊 Reading the numbers
• KPI Card — Gross Rent: Shows the total monthly gross rent across all properties. Compare month-over-month to confirm rent growth or catch data-entry errors.
• KPI Card — Portfolio NOI: Sum of all properties' monthly NOI. This is your portfolio's total operating profit before debt. Track this over time; it should grow as you add properties or raise rents.
• KPI Card — Vacancy Loss: The total dollar amount lost to vacancy across the portfolio each month. If this is a large share of Gross Rent, focus on lease-up strategies.
• KPI Card — Portfolio DSCR: A weighted measure of how well total portfolio NOI covers total mortgage payments. Above 1.25 is comfortable; below 1.0 means the portfolio as a whole cannot service its debt from rent alone.
• KPI Card — Units: Total rentable units in your portfolio — a quick size check.
• KPI Card — Vacancy: Portfolio-wide vacancy rate. Under 5% is excellent; over 10% warrants investigation.
• Chart — NOI by Property: Bar chart ranking each property by monthly NOI. The tallest bar is your best earner. Negative bars need immediate attention.
• Chart — Rent Distribution: Shows how gross rent is split across properties. Helps you see concentration risk — if one property accounts for 60% of rent, losing it would be devastating.
• Chart — DSCR by Property: Visualizes debt safety per property. Bars below the 1.0 line are under water on debt service; bars above 1.25 are comfortable.
• Chart — Expenses vs Mortgage: Side-by-side comparison showing whether operating expenses or debt payments are the bigger cost burden for each property.
• Chart — Cap Rate vs Net Yield: These two metrics should be very close in value. A large gap would indicate a data-entry issue. Use this chart to compare return profiles across properties.
• Chart — Vacancy Cost by Property: Dollar-value visualization of vacancy drag. Target your lease-up efforts at the tallest bars first for maximum revenue recovery.
• Chart — Net Rent vs Cash Flow: Shows the gap between collected rent and final cash flow — a wide gap means expenses and debt are consuming most of your income.
• Chart — Breakeven vs Vacancy: Plots each property's breakeven occupancy against its current vacancy rate. Properties where vacancy exceeds breakeven are losing money.
• Chart — CF Margin by Property: Your profit-margin view. Quickly see which properties convert the most rent into actual cash flow.
• Chart — GRM by Property: Lower bars mean the property is cheaper relative to its rent. Higher bars suggest the property's value is driven by appreciation rather than income.
• Chart — Per-Unit Economics: Compares Rent/Unit, CF/Unit, NOI/Unit, and Price/Unit across properties on a normalized basis.
• Chart — CoC Return by Property: Cash-on-Cash Return chart — shows annual cash flow as a percentage of actual capital invested. Higher is better; 8–12% is a common investor target.
• Chart — Capital Deployed: Shows how much equity/capital you have invested in each property, helping you see where your money is concentrated.
• Chart — 5yr Projected Equity: Models estimated equity growth over five years based on current values, debt paydown, and assumed appreciation. Use it for long-range planning, not precision forecasting.
• Chart — Equity CAGR by Property: Compound Annual Growth Rate of equity for each property. Higher CAGR means faster wealth building.
• Chart — CoC vs Total Return: Compares cash-on-cash return (income only) against total return (income + appreciation). Useful for seeing which properties are appreciation plays vs. cash-flow plays.
• Chart — Payback Period by Property: Estimates how many years until your cumulative cash flow equals your invested capital. Shorter is better; under 10 years is strong for residential.
• Chart — Adj CoC by Property: Adjusted Cash-on-Cash may factor in principal paydown or tax benefits, giving a more complete return picture than basic CoC.
• Chart — Leverage Ratio by Property: Shows mortgage balance as a fraction of property value. Higher leverage amplifies both gains and risk. Typical healthy range is 60–80% for newer acquisitions, declining over time.
• Chart — CoC Gap: Actual vs Target: Compares your actual cash-on-cash return against a target benchmark. Properties falling short of target may need rent increases, expense cuts, or refinancing.
⚠️ Avoid these mistakes
• Do not enter vacancy as a decimal (0.05); enter it as a whole-number percentage (5). The formulas expect the whole number.
• Do not include mortgage payments in the Expenses column — that would double-count debt and produce incorrect NOI, DSCR, and OpEx % figures.
• Do not leave the Value column blank or at zero; this will cause division-by-zero errors in Cap Rate, GRM, Net Yield, Price/Unit, and Rent Yield.
• Do not use duplicate property names — the Dashboard uses property names as lookup keys, so duplicates will cause incorrect or missing data on the Dashboard.
💡 Tips• Sort by ƒNOI Rank to quickly see your best and worst performers side by side.
• Use ƒStatus as a weekly triage tool: filter to show only 'At Risk' or 'Watch' properties to focus your management energy.
• When considering a new acquisition, add it as a temporary row with estimated numbers to see how it would affect portfolio-level KPIs before committing.
• Periodically update the Value column with fresh market estimates — stale values make cap rate and equity projections unreliable.
The Portfolio Dashboard aggregates your Property Ledger data by property type, giving you a bird's-eye view of portfolio composition, vacancy risk, and type-level performance. Use it to compare how your single-family homes perform against your multifamily buildings, spot concentration risk, and identify recoverable revenue from vacancy reduction.
✍️ Step by step
11. Most columns on this sheet are auto-computed — they pull data from the 🏠 Property Ledger using VLOOKUP, SUMIFS, AVERAGEIFS, and COUNTIF formulas. You do not need to enter property details here.
22. Verify that the Property column lists every property from your Ledger. If a property is missing, check that its name matches exactly between both sheets.
33. The one input you provide here is Vac Target — your desired or market-standard vacancy rate for each property. Enter it as a whole-number percentage (e.g., 3 for 3%).
44. Once Vac Target is set, the ƒRecoverable column calculates how much monthly rent you could recover if you reduced vacancy from its current level to your target.
55. Review the KPI cards at the top for portfolio-wide health: Net Cash Flow, Portfolio Cap Rate, Total NOI, Occupancy, Total Rent, and Average Vacancy.
66. Browse the charts grouped by property type to see which categories (SFH, Duplex, Apartment, etc.) are driving returns and which are dragging performance.
77. Use the Vacancy-specific charts (Vacancy Rate by Property, Annual Vacancy Cost, Recoverable Revenue, Loss vs Recoverable) to build a prioritized action plan for reducing vacancy and recapturing lost income.
88. Share this sheet (or export it as PDF) with partners, lenders, or property managers as a professional portfolio summary — it contains no raw input cells except Vac Target.
📋 Column-by-column
| Property | AUTO-POPULATED — Mirrors the property names from the 🏠 Property Ledger via lookup. Do not edit these directly; update the source on the Ledger instead. Each property appears once. |
| ƒGross Rent | AUTO-COMPUTED — Pulls each property's Gross Rent from the Ledger. Displayed here for reference so you can see income alongside vacancy metrics without switching sheets. |
| ƒVacancy % | AUTO-COMPUTED — Pulls each property's vacancy rate from the Ledger and displays it as a percentage. A quick way to scan which properties have the highest vacancy. Anything above 8–10% deserves investigation. |
| ƒMo. Loss | AUTO-COMPUTED — Monthly Loss = Gross Rent × (Vacancy % ÷ 100). The dollar amount you are losing each month to vacancy for this property. This is the same as ƒVac Cost on the Ledger, surfaced here for dashboard convenience. |
| ƒAnnual Loss | AUTO-COMPUTED — Annual Loss = Mo. Loss × 12. Annualizes the vacancy cost so you can see the yearly financial impact. A property losing $500/month is losing $6,000/year — framing it annually makes the urgency clearer. |
| ƒRisk | AUTO-COMPUTED — A text or color-coded risk flag based on the vacancy rate and possibly other factors. Expect labels such as 'Low', 'Medium', or 'High'. High-risk properties have elevated vacancy, low DSCR, or both. Use this column to quickly triage which properties need immediate leasing attention. |
| Vac Target | INPUT — Enter your target vacancy rate as a whole-number percentage (e.g., 3 for 3%). This is the vacancy level you believe is achievable through better marketing, tenant retention, or market improvement. The ƒRecoverable column uses this to calculate how much rent you could recapture. Set it to your market's natural vacancy rate or your own goal. |
| ƒRecoverable | AUTO-COMPUTED — Recoverable Revenue = Gross Rent × ((Vacancy % − Vac Target) ÷ 100), shown as a monthly dollar amount. It tells you exactly how much additional rent you would collect each month if you brought vacancy down from its current level to your target. If current vacancy already meets or beats the target, this shows $0. This is your opportunity dollar — prioritize action on properties with the highest Recoverable amounts. |
| ƒRent Share | AUTO-COMPUTED — Rent Share = Property's Gross Rent ÷ Total Portfolio Gross Rent × 100, expressed as a percentage. It reveals concentration risk: if one property represents 40%+ of your total rent, losing that property's income (major vacancy, natural disaster, problem tenant) would devastate portfolio cash flow. Diversification is healthier — aim for no single property exceeding 25–30% of total rent. |
📊 Reading the numbers
• KPI Card — Net Cash Flow: Total monthly cash flow after all expenses and mortgages across the portfolio. Positive means the portfolio pays you; negative means you're subsidizing it overall.
• KPI Card — Portfolio Cap: The portfolio-wide capitalization rate — total annual NOI divided by total property value. Gives you one number to benchmark your entire portfolio's unlevered return. A portfolio cap of 6–8% is solid for residential.
• KPI Card — Total NOI: Sum of monthly NOI across all properties. This is the portfolio's operating profit engine. Compare it against total mortgage payments to gauge debt safety.
• KPI Card — Occupancy: Portfolio-wide occupancy rate (100% minus average or weighted vacancy). Above 95% is excellent; below 90% signals a systemic issue across multiple properties.
• KPI Card — Total Rent: Sum of monthly gross rent across the portfolio. Your top-line revenue figure.
• KPI Card — Avg Vacancy: The average vacancy rate across all properties. Compare to the national average (roughly 5–7%) to see if your portfolio is outperforming or underperforming the market.
• Chart — Total NOI by Type: Bar chart showing total NOI grouped by property type (e.g., all Duplexes combined). Reveals which property categories generate the most operating income.
• Chart — Rent Share by Type: Pie or bar chart showing what percentage of total rent comes from each property type. Helps assess diversification.
• Chart — Avg Cap Rate by Type: Shows the average capitalization rate for each property category. Higher-cap categories deliver more income per dollar of value.
• Chart — NOI vs Cash Flow by Type: Compares pre-debt (NOI) and post-debt (Cash Flow) income by type. A big gap indicates heavy leverage in that category.
• Chart — Avg DSCR by Type: Displays average Debt Service Coverage Ratio per type. Types averaging below 1.25 may need refinancing or rent increases.
• Chart — Avg Vacancy by Type: Reveals which property types suffer the most vacancy. If apartments average 12% but SFH average 3%, you know where to focus tenant-retention efforts.
• Chart — CF Margin by Type: Average cash-flow margin by type. Shows which categories are most efficient at converting rent into profit.
• Chart — Net Yield by Type: Average net yield (annual NOI ÷ value) per type. Comparable to cap rate grouping; useful for type-level return comparison.
• Chart — Properties by Type: Simple count of how many properties you own in each category. Context for all the averages — an average based on one property is less reliable than one based on ten.
• Chart — NOI by Type: May overlap with Total NOI by Type; shows aggregate or individual NOI contributions broken down by category.
• Chart — Annual Vacancy Cost: Total annual dollar loss from vacancy across the portfolio, potentially broken down by property or type. Makes the financial case for investing in tenant retention.
• Chart — Vacancy Rate by Property: Bar chart of each property's vacancy rate, making it easy to spot outliers that are dragging down portfolio occupancy.
• Chart — Recoverable Revenue: Bar chart showing ƒRecoverable for each property. The tallest bars represent your biggest revenue-recovery opportunities — address them first.
• Chart — Loss vs Recoverable: Compares current vacancy loss against recoverable revenue. The gap between loss and recoverable represents the 'structural' vacancy you cannot realistically eliminate.
• Chart — Rent Exposure by Property: Shows each property's share of total portfolio rent, highlighting concentration risk. Even out exposure over time through diversified acquisitions.
⚠️ Avoid these mistakes
• Do not manually type property names in the Property column on this sheet — they are pulled from the Ledger. If a name doesn't appear, fix it on the Ledger.
• Do not forget to fill in Vac Target — without it, the Recoverable column will show $0 or an error, and you'll miss one of the dashboard's most actionable insights.
• Do not enter Vac Target as a decimal (0.03); enter it as a whole number (3) matching the format used for Vacancy on the Ledger.
• Avoid ignoring the Risk flags — they are designed to catch properties trending toward trouble before cash flow actually goes negative.
💡 Tips• Export this sheet as a PDF (File → Download → PDF) to share a polished portfolio overview with business partners, lenders, or CPA during tax season.
• Sort by ƒRecoverable descending to create a prioritized vacancy-reduction action list — tackle the highest-dollar opportunities first.
• Compare the Avg Vacancy by Type chart against the Avg DSCR by Type chart side by side: types with high vacancy AND low DSCR are your highest-priority categories for operational improvement.
• Revisit Vac Target quarterly and adjust based on local market conditions — a target that was realistic last year may be too aggressive or too conservative now.
📖Glossary — what every value means
| NOI (Net Operating Income) | Net Operating Income is the monthly income remaining after subtracting operating expenses from net rent, but before mortgage payments. Formula: NOI = Net Rent − Expenses. It measures a property's operational profitability regardless of financing. A positive and growing NOI is the foundation of a healthy rental investment. |
| Cap Rate (Capitalization Rate) | The capitalization rate is the annual NOI expressed as a percentage of the property's market value. Formula: Cap Rate = (NOI × 12) ÷ Value × 100. It measures the unlevered return on the asset — the return you'd earn if you bought the property with all cash. Typical healthy range: 5–10% for residential rentals. |
| DSCR (Debt Service Coverage Ratio) | DSCR measures how many times your net operating income can cover the mortgage payment. Formula: DSCR = NOI ÷ Mortgage. A DSCR of 1.0 means income exactly equals the mortgage (breakeven); lenders typically want 1.20–1.25 minimum. Above 1.5 is very comfortable; below 1.0 means the property loses money after debt. |
| GRM (Gross Rent Multiplier) | GRM estimates how many years of gross annual rent it would take to equal the property's value. Formula: GRM = Value ÷ (Gross Rent × 12). Lower is generally better (cheaper relative to income). Typical range: 8–15 for residential investment properties. GRM ignores expenses and debt, so always pair it with cap rate. |
| OpEx % (Operating Expense Ratio) | The share of gross rent consumed by operating expenses. Formula: OpEx % = Expenses ÷ Gross Rent × 100. Healthy residential rentals typically fall between 35–50%. Above 50% means more than half of every rent dollar goes to costs, compressing profits. Track it over time to spot rising maintenance or tax burdens. |
| Cash-on-Cash Return (CoC) | Cash-on-Cash Return measures annual cash flow as a percentage of the actual cash you invested (down payment, closing costs, rehab). It captures the return on your out-of-pocket capital, not the property's total value. A CoC of 8–12% is a common investor target. Unlike cap rate, CoC reflects the impact of leverage. |
| Breakeven Occupancy | The minimum occupancy rate needed for a property to cover all operating expenses and mortgage payments. Formula: Breakeven = (Expenses + Mortgage) ÷ Gross Rent × 100. Lower is safer — a breakeven of 70% means you can afford 30% vacancy before losing money. Above 90% is risky because even one vacant unit can push you negative. |
| Vacancy % | The percentage of gross rental income lost to unoccupied units, tenant turnover, or non-payment. Entered as a whole number (e.g., 5 for 5%). The national residential average is roughly 5–7%. Lower vacancy means more stable income; high vacancy (10%+) erodes cash flow quickly. |
| Net Rent | Gross rent adjusted downward for vacancy. Formula: Net Rent = Gross Rent × (1 − Vacancy ÷ 100). This is the realistic monthly income you expect to collect, and it is the starting point for NOI calculation. |
| Cash Flow | The money remaining after all operating expenses and mortgage payments. Formula: Cash Flow = NOI − Mortgage. Positive cash flow means the property pays you monthly; negative cash flow means you pay out of pocket. Even modest positive cash flow ($100–200/unit/month) is acceptable when equity growth is strong. |
| CF Margin (Cash Flow Margin) | The percentage of collected rent that survives as cash flow. Formula: CF Margin = Cash Flow ÷ Net Rent × 100. Think of it as your profit margin as a landlord. A 20–30% CF Margin is solid; below 10% is thin; negative means losses. |
| Rent/Unit | Average monthly gross rent per rentable unit. Formula: Rent/Unit = Gross Rent ÷ Units. Useful for comparing revenue efficiency across buildings of different sizes. |
| CF/Unit (Cash Flow per Unit) | Monthly cash flow divided by the number of units. Formula: CF/Unit = Cash Flow ÷ Units. A common benchmark is $100–200/unit/month for a viable deal. |
| Price/Unit | Property value divided by the number of units. Formula: Price/Unit = Value ÷ Units. Lower price-per-unit generally means more scalable returns and easier entry points for investors. |
| NOI/Unit | Monthly NOI divided by the number of units. Formula: NOI/Unit = NOI ÷ Units. Measures per-door operating profitability independent of building size. |
| Net Yield | Annual NOI as a percentage of property value — essentially the same as cap rate presented as a yield figure. Formula: Net Yield = (NOI × 12) ÷ Value × 100. Useful for investors comparing real estate income to bond yields or dividend stocks. |
| Rent Yield | Annual gross rent as a percentage of property value. Formula: Rent Yield = (Gross Rent × 12) ÷ Value × 100. Always higher than cap rate because it ignores expenses. A rent yield of 10–12% is typical in cash-flow-oriented markets. |
| Vac Cost (Vacancy Cost) | The monthly dollar amount lost to vacancy. Formula: Vac Cost = Gross Rent × (Vacancy ÷ 100). Converts the abstract vacancy percentage into a tangible dollar figure to help prioritize lease-up efforts. |
| NOI Rank | A numeric ranking of each property by NOI from highest (1) to lowest. Instantly identifies your top earner and weakest performer without scanning dollar amounts. |
| Breakeven vs Vacancy | A comparative view plotting each property's breakeven occupancy against its actual vacancy. Properties where vacancy exceeds breakeven are actively losing money and need urgent attention. |
| Occupancy | The inverse of vacancy: Occupancy = 100% − Vacancy %. Represents the proportion of units that are leased and generating rent. Above 95% is excellent for a residential portfolio. |
| Recoverable Revenue | The monthly rent that could be recaptured by bringing vacancy down from its current level to your target. Formula: Recoverable = Gross Rent × ((Vacancy % − Vac Target) ÷ 100). Represents your upside opportunity from better leasing or tenant retention. |
| Rent Share | Each property's gross rent as a percentage of the total portfolio gross rent. Reveals concentration risk — if one property dominates, its loss would disproportionately hurt the portfolio. |
| CAGR (Compound Annual Growth Rate) | The smoothed annual rate at which equity grows over a multi-year period. Used in the 5-year equity projection charts. A higher CAGR means faster wealth accumulation; typical residential real estate equity CAGR ranges from 5–15% depending on appreciation and debt paydown. |
| Leverage Ratio | The proportion of a property's value that is financed by debt. Formula: Leverage Ratio = Mortgage Balance ÷ Value. Higher leverage amplifies both gains and losses. Typical healthy range is 60–80% for newer acquisitions, declining over time as you pay down the mortgage. |
| Payback Period | The estimated number of years until cumulative cash flow equals the capital you invested in the property. Shorter is better; under 10 years is considered strong for residential buy-and-hold investments. |
| Adjusted CoC (Adjusted Cash-on-Cash) | A refined version of Cash-on-Cash return that may factor in principal paydown, tax benefits, or appreciation, providing a more complete return picture than basic CoC. Gives a fuller view of total wealth building, not just cash in your pocket. |
Every template ships with an AI side-panel. Type in plain language — it fills rows, explains any cell, and analyses your data for you.
How to use it
1The workbook includes a built-in AI assistant accessible via the ✨ side panel in Google Sheets. To open it, click the sparkle icon (✨) in the right-hand toolbar or go to Extensions and look for the AI assistant option. The side panel slides open and you can type natural-language questions or commands.
2Try prompts like: 'Fill in this row with sample data for a duplex in Austin, TX', 'Explain the formula in cell B7', 'Which property should I sell first based on these numbers?', 'What should I cut to improve cash flow on 742 Evergreen?', or 'Summarize my portfolio health in plain English.' The assistant reads your sheet data and responds contextually.
3The AI assistant can help you interpret metrics ('What does a DSCR of 0.9 mean for my property?'), suggest improvements ('How can I improve my cap rate?'), draft scenarios ('What happens if I raise rent 5% on all units?'), and explain any formula in the workbook. It is a conversational coach, not a data-entry bot — it works best with specific questions.
4The AI assistant cannot modify cells directly, access external data sources, or guarantee financial advice — treat its suggestions as analytical starting points, not professional counsel. Always verify critical decisions with your accountant or financial advisor.
5You start with a set of free AI requests included with your template purchase. After those are used, a subscription plan gives you a larger monthly allowance of additional requests — enough for regular portfolio reviews and scenario modeling. Requests reset monthly and unused requests do not roll over.
6For best results, be specific in your prompts: reference cell addresses, property names, or metric names rather than asking vague questions. The more context you give the assistant, the more targeted and useful its responses will be.