📘
Rental Rate Optimizer Workbook — Complete Instruction Manual
Instruction Manual · How to use this template
The Rental Rate Optimizer Workbook is a premium Google Sheets template designed for landlords, property managers, and real-estate investors who want to close the gap between what they currently charge and what the market will bear. It combines a full rental portfolio register, a rent-increase tracker, a comparable-rent research log, and automatic scenario modeling so you can quantify exactly how much revenue you are leaving on the table — unit by unit. The typical workflow is: (1) enter your properties and current rents, (2) log market comps, (3) review the auto-scored priority list and dashboard, (4) propose increases for the highest-opportunity units, and (5) track each increase through approval to a signed lease. Every formula-driven column updates instantly, so you always have a live picture of your portfolio's revenue potential.
⚡ Quick start
1Step 1 — Open the workbook and read the 'Read Me' sheet for a quick orientation, color-key legend, and any version notes.
2Step 2 — Go to 🏠 Rental Portfolio and fill in one row per unit: Property name, Unit label, number of Beds, current Rent, and the Market rent you believe that unit could command. Set each row's Status (e.g. Under-Rented, At Market, Over Market) and enter the Lease End date.
3Step 3 — Switch to 🏷️ Market Comps and log at least 3–5 comparable listings per bedroom count so the workbook can benchmark your rents against real asking prices.
4Step 4 — Return to 🏠 Rental Portfolio's right-side rent-increase tracker: for any unit you want to raise, enter the Proposed rent, the Effective date of the new lease, and mark Approved once the tenant agrees.
5Step 5 — Open 📈 Market Dashboard and 💰 Revenue Scenarios to review your portfolio-wide KPIs, gap analysis charts, and annual upside projections — no data entry needed on these sheets.
6Step 6 — Use the ✨ AI side-panel (see the last section of this guide) to ask questions, auto-fill rows, or generate a full data report at any time.
This is the core data-entry sheet and the engine of the entire workbook. The left side holds your unit register — every property, its current rent, and its market rent — so the workbook can score and rank each unit by how under-rented it is. The right side is a rent-increase tracker where you log proposed raises, approval status, and effective dates so you can monitor every increase from proposal to signed lease. Nearly every other sheet in the workbook pulls from this one.
✍️ Step by step
11. In the left section, start a new row for each rentable unit: type the Property name (e.g. '412 Oak St'), the Unit identifier (e.g. 'Unit 2A'), and the number of Beds (whole number like 1, 2, 3).
22. Enter the current monthly Rent you are collecting (e.g. 1350) and the Market rent — your best estimate of what the unit could fetch today (e.g. 1550). The formula columns ƒGap $, ƒGap %, ƒYr Upside, ƒRent/Bed, ƒMkt/Bed, ƒPriority, ƒRank, ƒLease Drag, ƒGap Share, and ƒCAGR Req will all populate automatically.
33. Set the Status dropdown for each unit (e.g. Under-Rented, At Market, Over Market) to categorize it; this feeds the Market Dashboard breakdowns.
44. Enter the Lease End date (e.g. 2026-09-30) so the workbook can calculate ƒDays Left and ƒPriority — units whose leases expire sooner score higher priority.
55. On the right side of the sheet, for any unit you plan to increase, enter the same Property and Unit identifiers, the Current rent, and your Proposed new rent.
66. Enter the Effective date — the date the new rent would begin — so ƒDays Out and ƒDelay Cost can calculate how much revenue you lose by waiting.
77. Once a tenant agrees, set Approved to Yes (or the date approved); this updates ƒClose Rate across the portfolio.
88. Review the auto-populated KPI cards at the top (Monthly Rev, Capture Rate, Ann. Upside, Beds, Rent, Market) for a snapshot of portfolio health.
99. Use the six charts (Rent vs Market Rate, Upside Share by Unit, Priority Score by Unit, Proposed Increase by Unit, Annual Revenue Gain, Current vs Proposed Rent) to visually compare units and decide where to act first.
📋 Column-by-column
| Property | INPUT — Type the name or address of the property this unit belongs to. Use a consistent name across all sheets (e.g. '412 Oak St' every time, not '412 Oak' in one row and 'Oak Street' in another). This is the key that links data to the Market Dashboard and Revenue Scenarios sheets. |
| Unit | INPUT — A unique label for the specific unit within the property, such as 'Unit 1A', 'Apt 3', or 'House' if it is a single-family rental. Combined with Property, it must be unique across the entire sheet. |
| Beds | INPUT — The number of bedrooms in the unit as a whole number (e.g. 1, 2, 3). Studio apartments should be entered as 0 or 1 depending on your preference. This value is used to calculate ƒRent/Bed and ƒMkt/Bed and to match against comps in 🏷️ Market Comps. |
| Rent | INPUT — The current monthly rent you are actually collecting for this unit, in dollars, without the dollar sign (e.g. 1350). Do not include utilities or fees — just base rent. This is the baseline for every gap and upside calculation. |
| Market | INPUT — Your best estimate of the market rent this unit could command today, in dollars (e.g. 1550). Base this on comparable listings, your research, or the average from 🏷️ Market Comps. The accuracy of every gap metric depends on this number. |
| ƒGap $ | Gap Dollars — the absolute dollar difference between Market rent and current Rent. Formula in words: Market − Rent. A positive value (e.g. $200) means you are under-renting by that amount per month. Zero means you are at market. A negative value means you are charging above market. Larger positive gaps signal the biggest immediate opportunities. |
| ƒGap % | Gap Percentage — the rent gap expressed as a percentage of current Rent. Formula: (Market − Rent) ÷ Rent × 100. For example, if Rent is $1,300 and Market is $1,500, the Gap % is about 15.4%. Values above 10 % generally indicate a unit that is meaningfully under-rented; values above 20 % suggest urgent action. |
| Status | INPUT — A dropdown or typed label that categorizes the unit's rent position. Typical values: 'Under-Rented', 'At Market', 'Over Market'. This feeds the 📈 Market Dashboard status breakdowns and charts. Be consistent with spelling so COUNTIF formulas count correctly. |
| ƒCapture | Capture Rate — the percentage of the market rent you are currently collecting. Formula: Rent ÷ Market × 100. A Capture of 100% means you are at market; 87% means you are collecting 87 cents of every market dollar. Healthy portfolios target 95%+ overall; anything below 85% on an individual unit is a strong candidate for a raise. |
| Lease End | INPUT — The date the current lease expires, formatted as a date (e.g. 2026-09-30 or 09/30/2026). This drives ƒDays Left and factors into ƒPriority — units expiring sooner get a higher priority score because you can act on them first. |
| ƒDays Left | Days Left until Lease End — the number of calendar days between today and the Lease End date. Formula: Lease End − TODAY(). A value of 0 or negative means the lease has already expired or is month-to-month. Units with fewer days left are more actionable. Typically, you want to start the renewal conversation 60–90 days before expiry. |
| ƒYr Upside | Yearly Upside — the total additional annual revenue you would gain if this unit were moved to market rent. Formula: ƒGap $ × 12. For example, a $200 monthly gap equals $2,400 per year in lost revenue. Sum this column to see portfolio-wide annual upside. Larger values should draw your attention first. |
| ƒRent/Bed | Rent per Bed — the current rent divided by the number of bedrooms. Formula: Rent ÷ Beds. This normalizes rent across different unit sizes so you can compare a 1-bed at $1,200 to a 3-bed at $3,300 on an apples-to-apples basis. If a unit's Rent/Bed is noticeably lower than peers, it may be under-rented. |
| ƒMkt/Bed | Market Rent per Bed — the market rent divided by the number of bedrooms. Formula: Market ÷ Beds. Compare this to ƒRent/Bed to see the per-bedroom gap. In most urban markets, expect $600–$1,200 per bedroom depending on location and quality. |
| ƒPriority | Priority Score — a composite score that ranks how urgently you should raise rent on this unit. It typically combines the gap size (ƒGap %), days until lease expiry (ƒDays Left), and possibly other factors into a single number. Higher scores mean 'act on this unit first.' A score in the top quartile of your portfolio is a strong candidate for an immediate rent-increase proposal. |
| ƒRank | Rank — the ordinal ranking of each unit by ƒPriority score, where 1 = highest priority. Formula: RANK(ƒPriority, all ƒPriority values). Use this to quickly identify your top-5 or top-10 units to focus on this quarter. |
| ƒLease Drag | Lease Drag — the revenue cost of being locked into a below-market lease for the remaining lease term. Formula: ƒGap $ × (ƒDays Left ÷ 30), approximately the total dollars you will 'lose' between now and lease expiry if rent stays the same. A high Lease Drag on a unit with many months remaining signals that an early renegotiation or buyout might be worth exploring. |
| ƒGap Share | Gap Share — this unit's share of the portfolio's total monthly rent gap, expressed as a percentage. Formula: this unit's ƒGap $ ÷ SUM of all ƒGap $ × 100. If one unit shows 40% Gap Share, it alone accounts for 40% of your portfolio's total under-renting. Focusing on the highest Gap Share units gives you the most revenue lift per effort. |
| ƒCAGR Req | Compound Annual Growth Rate Required — the annual rent growth rate you would need to close the gap over a set horizon (often 2–3 years) through gradual increases rather than a single jump. A high CAGR Req (e.g. 12%+) means the gap is large relative to time and you may want to take a bigger first step. A low CAGR Req (e.g. 3%) means modest annual bumps will close the gap naturally. |
| Property (Increase Tracker) | INPUT — The property name, matching exactly what you used in the left-side register. This links the increase proposal back to the correct unit's portfolio data. |
| Unit (Increase Tracker) | INPUT — The unit identifier, matching the left-side register. Together with Property, it uniquely identifies which unit this rent increase applies to. |
| Current | INPUT — The current monthly rent for this unit at the time you are proposing the increase (should match the Rent column on the left side). Enter as a plain number (e.g. 1350). |
| Proposed | INPUT — The new monthly rent you are proposing for this unit (e.g. 1500). This is the target rent you will offer the tenant at renewal. The difference between Proposed and Current drives all raise and gain calculations on the right side. |
| ƒRaise $ | Raise Dollars — the dollar amount of the proposed increase. Formula: Proposed − Current. For example, if Current is $1,350 and Proposed is $1,500, ƒRaise $ is $150. This is the per-month revenue gain if the tenant accepts. |
| ƒRaise % | Raise Percentage — the proposed increase expressed as a percentage of Current rent. Formula: (Proposed − Current) ÷ Current × 100. Most markets consider 3–5% a standard annual increase; 8–12% may be justifiable for significantly under-rented units but could trigger more tenant pushback. |
| Effective | INPUT — The date the new rent would take effect (e.g. 2026-10-01). This is typically the first day of the new lease term. Enter as a proper date so ƒDays Out and ƒDelay Cost calculate correctly. |
| ƒDays Out | Days Out — the number of days from today until the proposed Effective date. Formula: Effective − TODAY(). This tells you how long you must wait before the increase begins generating revenue. Shorter is better; if Days Out is large, consider whether you can negotiate an earlier start. |
| Approved | INPUT — Whether the tenant has agreed to the new rent. Enter 'Yes', 'No', 'Pending', or the date approved. This column feeds ƒClose Rate and helps you track pipeline status at a glance. |
| ƒUrgency | Urgency — a calculated score reflecting how time-sensitive this rent increase proposal is. It typically factors in ƒDays Out, the size of the raise, and possibly the lease expiry. Higher urgency means you should finalize this proposal sooner to avoid leaving money on the table. Review units with the highest Urgency weekly. |
| ƒYr Gain | Yearly Gain — the additional annual revenue this proposed increase would generate if accepted. Formula: ƒRaise $ × 12. For example, a $150 monthly raise yields $1,800 per year. Sum this column to see the total annual revenue gain from all proposed increases. |
| ƒ% of Mkt | Percent of Market — what percentage of the market rent the Proposed rent represents. Formula: Proposed ÷ Market × 100 (where Market comes from the left-side register). A value of 100% means your proposal exactly matches market; below 100% means you are still leaving some gap even after the raise, which may be a strategic choice to retain tenants. |
| ƒDelay Cost | Delay Cost — the revenue you lose by waiting until the Effective date instead of raising rent immediately. Formula: ƒRaise $ × (ƒDays Out ÷ 30), approximately. For example, a $150 raise that doesn't start for 90 days costs you roughly $450 in foregone revenue. Use this to justify expediting negotiations. |
| ƒGap Left | Gap Left — the remaining monthly gap between the Proposed rent and full market rent. Formula: Market − Proposed. If Gap Left is zero, your proposal fully closes the gap. If it is positive, you are intentionally leaving some room — perhaps to stay competitive or retain a good tenant. Track this so you know how much further you can go in future renewals. |
| ƒRaises Left | Raises Left — an estimate of how many more annual raises (at your typical raise percentage) it would take to close the remaining gap after this proposal. Formula: roughly ƒGap Left ÷ typical annual raise amount. A value of 0 means this single raise closes the gap entirely; a value of 2–3 means you have a multi-year path to market rent. |
| ƒNotice By | Notice By — the latest date you should send the tenant a rent-increase notice, based on the Effective date and any required notice period (often 30–60 days). Formula: Effective − notice period in days. If this date is in the past or very soon, act immediately. Mark your calendar for this date. |
| ƒClose Rate | Close Rate — the percentage of proposed increases that have been approved. Formula: COUNT of Approved='Yes' ÷ total proposals × 100. A healthy Close Rate is 70–90%; below 50% may mean your proposed increases are too aggressive or your negotiation approach needs adjustment. |
| ƒYr 1 Rev | Year 1 Revenue — the total projected rent revenue from this unit in the first year under the new Proposed rent. Formula: Proposed × 12 (or a prorated calculation if the Effective date is mid-year). This gives you the absolute revenue figure to use in budgeting and forecasting. |
📊 Reading the numbers
• Monthly Rev KPI shows the total current monthly rent across all units — compare this to the Market KPI to see your total monthly gap at a glance.
• Capture Rate KPI is the portfolio-wide percentage of market rent you are collecting; aim for 95%+ to indicate a well-optimized portfolio.
• Ann. Upside KPI is the total annual revenue you are leaving on the table across all units; this is the prize you are chasing.
• The 'Rent vs Market Rate' chart visually compares each unit's current rent to its market rent — look for the widest bars to find your biggest opportunities.
• 'Upside Share by Unit' chart shows which units contribute the most to your total gap; concentrate your efforts on the tallest bars.
• 'Priority Score by Unit' chart ranks units by their composite priority — higher-scoring units should be at the top of your action list.
• On the increase-tracker side, 'Current vs Proposed Rent' shows the before-and-after for each proposal, while 'Annual Revenue Gain' quantifies the dollar impact of each raise.
⚠️ Avoid these mistakes
• Using inconsistent property names (e.g. '412 Oak St' vs '412 Oak') — this breaks lookups to other sheets. Copy-paste to stay consistent.
• Leaving Market rent blank or at zero — this causes division errors in ƒGap %, ƒCapture, and downstream sheets.
• Forgetting to update Lease End dates when a tenant renews — stale dates skew ƒDays Left and ƒPriority.
• Setting Proposed rent below Current rent by accident — double-check that Proposed is higher unless you are intentionally lowering rent.
💡 Tips• Sort by ƒRank ascending to see your highest-priority units at the top and work through them in order.
• Use conditional formatting or the Status column to visually flag units where ƒCapture is below 85%.
• When a tenant signs a new lease, update both the left-side Rent column and the right-side Approved column so all metrics refresh.
• Review ƒDelay Cost regularly — it quantifies procrastination in dollar terms and can motivate faster action.
This sheet is a fully automatic, read-only dashboard that summarizes your entire portfolio's health by status, property, and key metrics. It pulls data from 🏠 Rental Portfolio (and optionally 🏷️ Market Comps) using COUNTIF, AVERAGEIF, SUMIFS, and COUNTIFS formulas. Use it for executive-level reviews, owner meetings, or a quick weekly check on progress.
✍️ Step by step
11. You do not enter any data on this sheet — it is entirely auto-populated from 🏠 Rental Portfolio and 🏷️ Market Comps.
22. Review the Status breakdown table: each row corresponds to a Status value (Under-Rented, At Market, Over Market) and shows the count of units, their share of the portfolio, average rent, and yearly upside for that segment.
33. Check the KPI cards at the top: Total Units, Drag %, Comp Adj %, Gap/Mo, Yr Upside, and Avg Priority give you a portfolio-level snapshot.
44. Use the 'Rent Status Mix' chart to see the proportion of your units in each status category — ideally most should be 'At Market.'
55. 'Monthly Gap by Property' shows which properties have the largest total monthly gap — focus increases there first.
66. 'Upside vs Drag by Property' compares unrealized upside to the cost of remaining locked into below-market leases, property by property.
77. Revisit this dashboard after every batch of data updates in 🏠 Rental Portfolio to see how your aggregate metrics have shifted.
📋 Column-by-column
| Status | AUTO — The distinct status values pulled from 🏠 Rental Portfolio (e.g. Under-Rented, At Market, Over Market). Each unique status gets its own summary row. |
| ƒCount | Count — the number of units in 🏠 Rental Portfolio that have this status. Formula: COUNTIF across the Status column in the portfolio. If Count is high for 'Under-Rented', you have many units to address. |
| ƒShare | Share — the percentage of total units that fall into this status category. Formula: ƒCount for this status ÷ total units × 100. A portfolio with 60%+ of units at 'At Market' is performing well; if 'Under-Rented' dominates, there is significant work ahead. |
| ƒRent/Mo | Rent per Month — the average (or total) monthly rent for units in this status category, pulled via AVERAGEIF or SUMIFS from the portfolio. Use this to see whether your under-rented units cluster at a particular rent level. |
| ƒYr Upside | Yearly Upside — the total annual upside for all units in this status group. Formula: SUMIFS of ƒYr Upside from the portfolio where Status matches. This tells you how much of the annual prize sits in each status bucket. |
📊 Reading the numbers
• Total Units KPI confirms the number of units the workbook is tracking — verify it matches your actual portfolio count.
• Drag % is the percentage of potential revenue lost due to below-market leases still in force; lower is better, and under 5% is excellent.
• Comp Adj % reflects how your portfolio rent compares after adjusting for comp data from 🏷️ Market Comps — watch for large deviations.
• Gap/Mo is the total monthly dollars you are leaving on the table across all units; multiply by 12 for the annual figure.
• 'Capture Rate by Property' chart lets you compare how well each property is optimized — properties with low capture rates need the most attention.
• 'Upside by Status' chart shows the dollar opportunity in each status segment, making it clear whether most upside is in a few deeply under-rented units or spread broadly.
⚠️ Avoid these mistakes
• Trying to type data into this sheet — it will overwrite formulas and break the dashboard. All inputs go in 🏠 Rental Portfolio.
• Having inconsistent Status labels in the portfolio (e.g. 'under-rented' vs 'Under-Rented') which splits counts across multiple rows.
• Ignoring this sheet entirely — it is the fastest way to spot portfolio-wide trends and should be reviewed at least weekly.
💡 Tips• Screenshot this dashboard and share it with property owners or partners as a one-page portfolio health report.
• If Drag % is rising over time, it means leases are locking you into below-market rates for longer — consider shorter lease terms.
• Use Avg Priority to set a threshold: any unit above the average is worth acting on this cycle.
• Compare Gap/Mo before and after a round of rent increases to quantify your progress.
This sheet is your comparable-rent research log. Every time you find a listing, survey result, or broker quote for a similar unit in your area, log it here. The workbook uses this data to benchmark your portfolio against real market evidence, adjust for quality differences, and feed adjusted market rents into 🏠 Rental Portfolio and 📈 Market Dashboard via AVERAGEIF, COUNTIFS, and COUNTIF formulas.
✍️ Step by step
11. For each comparable listing you find, create a new row and enter the Address (street address or complex name of the comp).
22. Log the Source — where you found the listing (e.g. Zillow, Apartments.com, broker email, MLS) — and the Found date so you can track freshness.
33. Enter the number of Beds, the asking Rent, and the Sq Ft (square footage) if available. The sheet auto-calculates ƒ$/Sq Ft and ƒRent/Bed.
44. Set the Quality dropdown or score (e.g. Superior, Similar, Inferior) to indicate how the comp's condition and amenities compare to your units. This drives the ƒAdj. Rent adjustment.
55. Add any Notes (e.g. 'includes parking', 'recently renovated', 'no dishwasher') that explain why the comp might rent higher or lower.
66. The ƒAdj. Rent column adjusts the comp's asking rent based on your Quality rating, giving you a fairer apples-to-apples number.
77. ƒvs Yours compares each comp's rent to your portfolio average for the same bedroom count, so you can see if the market is above or below your current rents.
88. ƒAge (days) tracks how old the listing is — stale comps (90+ days) may no longer reflect current market conditions.
99. Enter the Lease Type (e.g. 12-month, month-to-month, furnished) if known, as this can affect rent levels and comparability.
📋 Column-by-column
| Address | INPUT — The street address or property name of the comparable listing (e.g. '500 Maple Ave Apt 4B'). Be specific enough to identify the comp later if you need to revisit or verify it. |
| Source | INPUT — Where you found this comp (e.g. 'Zillow', 'Apartments.com', 'Craigslist', 'broker email'). Tracking sources helps you assess reliability and diversify your research. |
| Found | INPUT — The date you found or recorded this comparable listing (e.g. 2026-06-15). Enter as a proper date so ƒAge (days) can calculate freshness automatically. |
| Beds | INPUT — The number of bedrooms in the comp unit (e.g. 2). This must match the bedroom counts you use in 🏠 Rental Portfolio so that cross-sheet lookups (AVERAGEIF by Beds) work correctly. |
| Rent | INPUT — The asking monthly rent for the comp unit, in dollars (e.g. 1600). Do not include utilities or one-time fees — just the base monthly rent. |
| Sq Ft | INPUT — The square footage of the comp unit, if available (e.g. 950). Leave blank if unknown. When filled in, it enables the ƒ$/Sq Ft metric for fine-grained comparison. |
| ƒ$/Sq Ft | Dollars per Square Foot — the comp's monthly rent divided by its square footage. Formula: Rent ÷ Sq Ft. This normalizes rent by size so you can compare a 700 sq ft unit to a 1,100 sq ft unit fairly. In most suburban markets $1.00–$2.00/sq ft is typical; urban areas may reach $2.50–$4.00+. |
| ƒRent/Bed | Rent per Bed — the comp's asking rent divided by its bedroom count. Formula: Rent ÷ Beds. Compare this to the ƒRent/Bed and ƒMkt/Bed columns in 🏠 Rental Portfolio to see if this comp suggests your units are priced high, low, or about right. |
| ƒvs Yours | Versus Yours — the percentage difference between this comp's rent and your portfolio's average rent for the same bedroom count. Formula: (Comp Rent − Your Avg Rent for same Beds) ÷ Your Avg Rent × 100. A positive value means the comp is asking more than you charge; a negative value means the comp is cheaper. Consistently positive values suggest you are under-renting. |
| Quality | INPUT — A rating of how the comp's condition, amenities, and location compare to your units. Use a consistent scale such as 'Superior', 'Similar', or 'Inferior', or a numeric scale (1–5). This rating feeds the ƒAdj. Rent adjustment: superior comps are adjusted down and inferior comps are adjusted up to create an apples-to-apples benchmark. |
| Notes | INPUT — Free-text field for anything notable about the comp (e.g. 'includes in-unit washer/dryer', 'ground floor, no view', 'newly renovated kitchen'). Good notes help you interpret why a comp's rent is higher or lower and whether the quality adjustment is reasonable. |
| ƒAdj. Rent | Adjusted Rent — the comp's asking rent after applying a quality adjustment factor. Formula: Rent × quality adjustment multiplier (e.g. Superior comps are discounted, Inferior comps are boosted). This adjusted figure is a better benchmark for your units because it accounts for differences in condition and amenities. Use the average of ƒAdj. Rent for a given bedroom count as your Market rent estimate in 🏠 Rental Portfolio. |
| ƒAge (days) | Age in Days — how many days ago this comp was found. Formula: TODAY() − Found. Comps under 30 days old are fresh and reliable; 30–60 days are acceptable; over 90 days are stale and should be replaced with newer data. Stale comps can distort your market rent estimates. |
| Lease Type | INPUT — The lease term of the comp if known (e.g. '12-month', 'month-to-month', 'furnished short-term'). Month-to-month and furnished units typically command higher rents, so knowing this helps you adjust your expectations when comparing. |
📊 Reading the numbers
• The KPI cards summarize your comp data: Beds shows the average bedroom count of your comps, Rent the average asking rent, Sq Ft the average size, $/Sq Ft the average rent per square foot, Rent/Bed the average rent per bedroom, and vs Yours the average gap between comps and your portfolio.
• 'Asking Rent by Comp' chart plots each comp's rent so you can spot outliers — very high or very low comps that may skew averages.
• 'Raw vs Adj. Rent' compares each comp's original asking rent to its quality-adjusted rent; large differences flag comps where the quality adjustment matters most.
• 'Gap vs Your Portfolio' visually shows how each comp stacks up against your current rents — bars extending to the right mean the comp is more expensive than your average.
• 'Rent per Sq Ft' chart helps you spot whether your units are under-priced on a per-square-foot basis relative to the local market.
⚠️ Avoid these mistakes
• Logging comps with incorrect or missing bedroom counts — this breaks the AVERAGEIF lookups that match comps to your portfolio units by bedroom.
• Only logging comps that are more expensive than your rents (confirmation bias) — include cheaper comps too for an honest market picture.
• Never refreshing your comps — market data older than 90 days becomes unreliable. Periodically add fresh listings and delete or archive old ones.
• Forgetting to set the Quality rating, leaving ƒAdj. Rent unadjusted — this means superior comps will inflate your market benchmark and inferior comps will deflate it.
💡 Tips• Aim for at least 3–5 comps per bedroom count to get a reliable average. More is better.
• Use the ƒAge (days) column to filter out stale comps before making rent decisions.
• After a round of comp research, update the Market column in 🏠 Rental Portfolio with the average ƒAdj. Rent for each bedroom count — this keeps your gap analysis grounded in real data.
• Log the Source so you can revisit listings and verify details if a tenant challenges your proposed increase.
This read-only sheet models the financial impact of bringing your entire portfolio to market rent, broken down by property. It pulls unit counts and rent data from 🏠 Rental Portfolio using COUNTIF and SUMIFS formulas and presents current annual revenue, market-rate annual revenue, the total prize (the difference), and per-unit metrics. Use this sheet to build a business case for rent optimization or to set annual revenue targets.
✍️ Step by step
11. No data entry is needed — every cell auto-populates from 🏠 Rental Portfolio.
22. Review each row: one row per Property, showing the number of Units, Current annual revenue (ƒCurr/Yr), Market annual revenue (ƒMkt/Yr), and the Prize (ƒPrize/Yr) — the gap between the two.
33. Check ƒCapture for each property to see which properties are closest to market and which have the most room to grow.
44. Compare ƒRev/Unit and ƒMkt/Unit across properties to identify which assets generate the least revenue per unit relative to their potential.
55. Use the KPI cards (Curr Rev/Yr, Mkt Rev/Yr, Capture %, Total Prize, Curr/Yr, Mkt/Yr) for portfolio-wide totals.
66. Review the charts to visualize upside by property and build a prioritized action plan.
77. Revisit this sheet each quarter after implementing rent increases to see how Capture % and Prize change over time.
📋 Column-by-column
| Property | AUTO — The property name, pulled from 🏠 Rental Portfolio. Each unique property gets one summary row. |
| ƒUnits | Units — the number of rentable units at this property. Formula: COUNTIF of the Property name in the portfolio. Verify this matches your actual unit count to ensure no rows are missing. |
| ƒCurr/Yr | Current Revenue per Year — the total annual rent revenue this property generates at current rents. Formula: SUMIFS of Rent for this property × 12. This is your baseline — the money actually coming in. |
| ƒMkt/Yr | Market Revenue per Year — the total annual rent revenue this property would generate if every unit were at market rent. Formula: SUMIFS of Market for this property × 12. This is your target ceiling. |
| ƒPrize/Yr | Prize per Year — the total annual revenue difference between market and current for this property. Formula: ƒMkt/Yr − ƒCurr/Yr. This is the 'prize' — the additional annual income available if you close every gap. Larger prizes warrant more effort. |
| ƒCapture | Capture Rate — the percentage of market-rate revenue this property is currently achieving. Formula: ƒCurr/Yr ÷ ƒMkt/Yr × 100. A Capture of 92% means you are realizing 92% of the property's potential. Properties below 90% should be prioritized for rent increases. |
| ƒRev/Unit | Revenue per Unit — the average annual rent revenue per unit at current rents. Formula: ƒCurr/Yr ÷ ƒUnits. Compare across properties to see which ones are dragging down your portfolio average. |
| ƒMkt/Unit | Market Revenue per Unit — the average annual rent revenue per unit at market rates. Formula: ƒMkt/Yr ÷ ƒUnits. The gap between ƒRev/Unit and ƒMkt/Unit shows the per-unit opportunity at each property. |
📊 Reading the numbers
• Curr Rev/Yr and Mkt Rev/Yr KPIs show the portfolio-wide annual totals — the difference is your Total Prize.
• Capture % KPI is the single most important number: it tells you what fraction of the market's revenue potential you are actually collecting. Aim for 95%+.
• 'Current Rev vs Upside' chart stacks current revenue against the uncaptured upside for each property — the upside portion is the revenue you could gain.
• 'Annual Prize by Property' chart ranks properties by dollar opportunity; the tallest bar is where you should focus first.
• 'Revenue Share' chart shows each property's contribution to total portfolio revenue, helping you see concentration risk.
• 'Rev/Unit: Current vs Market' compares per-unit revenue to per-unit potential — properties where the two bars diverge most have the largest per-unit opportunity.
⚠️ Avoid these mistakes
• Treating the Prize as guaranteed income — it represents the theoretical maximum if every unit reaches market rent, which may not be realistic in a single cycle.
• Ignoring properties with small Prize amounts — even a modest gain compounds over years and across multiple units.
• Not updating 🏠 Rental Portfolio after implementing increases — if the source data is stale, Revenue Scenarios will overstate the remaining opportunity.
💡 Tips• Use this sheet to set quarterly goals: for example, 'close 50% of the Prize at 412 Oak St by Q4.'
• Export or screenshot the 'Annual Prize by Property' chart for owner presentations — it instantly communicates where the money is.
• Track Capture % month over month to measure the impact of your rent optimization efforts.
• If a property shows 100% Capture, shift your attention and resources to properties with lower capture rates.
📖Glossary — what every value means
| Gap $ | Gap Dollars — the per-unit monthly difference between market rent and current rent (Market − Rent). A positive value means you are charging less than market. Measured in dollars per month. |
| Gap % | Gap Percentage — the rent gap expressed as a percentage of current rent: (Market − Rent) ÷ Rent × 100. Values above 10% generally indicate meaningful under-renting. |
| Capture Rate | The percentage of market rent you are actually collecting. Calculated as Current Rent ÷ Market Rent × 100 (at the unit level) or Current Revenue ÷ Market Revenue × 100 (at the property/portfolio level). A healthy portfolio targets 95%+; below 85% signals significant unrealized revenue. |
| Yr Upside | Yearly Upside — the total additional annual revenue available if a unit (or the portfolio) were brought to market rent. Calculated as Gap $ × 12. This is the 'prize' in annual terms. |
| Rent/Bed | Rent per Bedroom — monthly rent divided by the number of bedrooms. This normalizes rents across different unit sizes so a 1-bed and 3-bed can be compared fairly. |
| Mkt/Bed | Market Rent per Bedroom — the market-rate rent divided by the number of bedrooms, providing a normalized market benchmark. |
| Priority Score | A composite ranking metric that combines the size of the rent gap and the proximity of lease expiry (and possibly other factors) into a single number. Higher scores indicate units that should be addressed sooner. |
| Lease Drag | The total dollar cost of remaining locked into a below-market lease for the remainder of its term. Calculated approximately as Gap $ × months remaining. High Lease Drag on a long lease signals an expensive lock-in. |
| Gap Share | A unit's share of the portfolio's total monthly rent gap, expressed as a percentage. It answers: 'What fraction of my total under-renting does this one unit account for?' |
| CAGR Req | Compound Annual Growth Rate Required — the annual rent increase rate needed to close the gap between current rent and market rent over a defined horizon (typically 2–3 years). A high CAGR Req (above 10%) means the gap is large and aggressive increases or a multi-year plan are needed. |
| Raise $ | Raise Dollars — the per-month dollar amount of a proposed rent increase (Proposed − Current). Multiply by 12 for the annual impact. |
| Raise % | Raise Percentage — the proposed rent increase as a percentage of current rent: (Proposed − Current) ÷ Current × 100. Standard annual increases are 3–5%; anything above 8–10% may require strong market evidence. |
| Days Out | The number of calendar days from today until a proposed rent increase takes effect. Shorter is better, as each day of delay costs you the daily equivalent of the raise amount. |
| Delay Cost | The cumulative revenue foregone by waiting until the Effective date to implement a rent increase. Calculated approximately as Raise $ × (Days Out ÷ 30). This quantifies the cost of procrastination. |
| Close Rate | The percentage of proposed rent increases that tenants have approved. Calculated as approved proposals ÷ total proposals × 100. A healthy Close Rate is 70–90%. |
| Yr 1 Rev | Year 1 Revenue — the projected total annual rent from a unit under the proposed new rent (Proposed × 12, or prorated if the increase takes effect mid-year). |
| Drag % | Drag Percentage — the share of potential portfolio revenue that is being lost ('dragged down') due to below-market leases currently in force. Lower is better; under 5% is excellent. |
| Comp Adj % | Comp Adjustment Percentage — a measure of how your portfolio's actual rents compare to the quality-adjusted comparable rents from 🏷️ Market Comps. It reflects whether your rents are above or below the adjusted market benchmark. |
| $/Sq Ft | Dollars per Square Foot — a comp's monthly rent divided by its square footage (Rent ÷ Sq Ft). This normalizes rent by unit size. Typical ranges vary by market: suburban $1.00–$2.00, urban $2.00–$4.00+. |
| Adj. Rent | Adjusted Rent — a comparable listing's asking rent after applying a quality adjustment (Superior comps are adjusted down, Inferior comps are adjusted up) to make it a fairer benchmark against your own units. |
| vs Yours | Versus Yours — the percentage difference between a comp's asking rent and your portfolio's average rent for the same bedroom count. Positive means the comp is pricier; negative means it is cheaper than what you charge. |
| Prize | The total annual revenue difference between what you currently earn and what you would earn at full market rent. Calculated as Market Revenue − Current Revenue, annualized. This is the total dollar opportunity across a property or the entire portfolio. |
| Rev/Unit | Revenue per Unit — the average annual rent revenue generated per unit at current rents (Total Revenue ÷ Number of Units). Compare to Mkt/Unit to see per-unit opportunity. |
| Mkt/Unit | Market Revenue per Unit — the average annual rent revenue per unit if rents were at market rates (Market Revenue ÷ Number of Units). |
| Urgency | A computed score reflecting how time-sensitive a proposed rent increase is, typically combining the size of the raise with how soon the effective date arrives. Higher urgency means finalize the proposal sooner to avoid revenue loss. |
| Gap Left | The remaining monthly rent gap after a proposed increase: Market − Proposed. Zero means the proposal fully closes the gap; a positive value means intentional room was left for future increases. |
| Raises Left | An estimate of how many additional annual rent increases are needed to close the remaining gap after the current proposal, based on typical annual raise amounts. |
| Notice By | The latest date by which you must send a rent-increase notice to the tenant, calculated by subtracting the required notice period (often 30–60 days) from the Effective date. |
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
1To open the built-in ✨ AI assistant, click the sparkle icon or the AI side-panel button in the right margin of your Google Sheet. The assistant appears as a chat panel where you type questions or commands in plain English.
2You can ask it to explain any cell — for example, type 'explain B7' or 'what does the Priority Score formula do?' and it will break down the formula and its inputs in plain language. You can also ask it to perform actions that read your data and act on it, such as 'sum column C', 'fill the next row with data for Unit 3B', or 'color row 1 gold'. These commands work directly on your sheet without breaking any existing formulas.
3The assistant can scan your entire workbook for issues, inconsistencies, or opportunities. You can also attach a screenshot or image (e.g., a photo of a competitor's listing flyer) and the AI will read and interpret it for you.
4One-click presets tailored to this template are available in the assistant panel — these are pre-built prompts designed specifically for rental rate optimization tasks, so you can get insights with a single click instead of typing a custom question each time.
5Under the Tools tab, you will find 'Analyze All My Data', which generates a comprehensive written report and places it on a new sheet, plus an Auto-Fit option to resize columns for readability. You can also use the Translate feature to convert every label in the workbook to another language, build a visual Infographic summarizing your portfolio, and adjust the assistant's Tone (Friendly, Professional, or Concise) or apply Smart Styling to improve the sheet's appearance.
6The AI assistant comes with free trial requests so you can explore its capabilities immediately. After the trial, a subscription unlocks a bigger monthly allowance of requests along with Pro features including native Charts, Forecasts, and a full multi-page Report. The assistant never modifies your formulas unless you explicitly ask it to — your data and calculations stay safe.