Section 8 Rental Property Analysis: The Excel Model That Tells You When Vouchers Actually Win

Most investors get Section 8 wrong in one of two directions. The first group avoids it because their uncle had a tenant who trashed a kitchen in 2009. The second group treats HUD vouchers like a money printer and buys anything in a "Section 8 area." Both groups skip the only part that matters: a real Section 8 rental property analysis that compares the voucher cash flow to the market-rate cash flow in the same ZIP, with honest numbers for vacancy, inspections, and repair burden.

The Housing Choice Voucher program moves roughly $30 billion a year through Public Housing Authorities (PHAs) to private landlords. In some ZIPs, Section 8 pays 110% of market rent. In others, it pays 78% and adds 45 days of lease-up delay. The difference between a winning deal and a money pit is not "Section 8 good" or "Section 8 bad." It is whether you modeled the right ZIP with the right Small Area Fair Market Rent (SAFMR), the right tenant portion, and the right HAP payment timeline. This article shows how to build that model in Excel and what cell values flag a deal as a pass.

The real cost of not modeling Section 8 properly

A landlord in Cleveland buys a duplex for $145,000. Market rent in that ZIP is $1,050 per unit. The local PHA's 2025 SAFMR for a 2-bed is $1,180. The investor sees the spread and assumes she's beating market by $130 per unit per month, or $3,120 per year across both units.

What she didn't model:

• The PHA pays 90% of SAFMR for this property class (payment standard set by PHA, not always 100% of SAFMR). Effective contract rent: $1,062.
• Initial inspection delay: 38 days average in her metro. Lost rent on first lease-up: $1,310 per unit.
• Annual reinspection failures: 22% in her county. Average repair cost to pass: $640.
• Voucher tenant turnover: similar to market, but re-lease takes 6 weeks vs 2 weeks because tenant must port the voucher and the unit must re-pass inspection.

True annual delta vs market: negative $480 per unit. She thought she was up $3,120 per year. She's actually down $960 per year across the duplex. Worse, she made the buy decision based on a number that didn't exist.

This is the central problem. Section 8 is a contract with specific cash mechanics. If you don't model the mechanics, you're guessing.

The variables a Section 8 model needs

A Section 8 rental property analysis has six inputs that a standard rental model does not have. Skip any one of them and the numbers lie.

The first two variables are public data. The other four come from making three phone calls to PHA staff and two landlords who already own there. Skip the calls, accept worse numbers.

Building the Excel model

Set up the worksheet with a clear input block at the top and a comparison block below. Here's the layout that works.

Input block (rows 3 to 18)

Section 8 effective rent

The contract rent is the lower of the payment standard and the unit's reasonable rent as determined by the PHA. Most PHAs cap at payment standard, so use:

=MIN(B5B6, B71.15)

That formula says: the PHA will pay no more than the payment standard, and no more than 115% of the comparable market rent (PHA "rent reasonableness" check). Put this in C5 as Effective Section 8 Contract Rent. With the example values: MIN(11800.90, 10501.15) = MIN(1062, 1207.50) = $1,062.

Annualized gross income with vacancy

For the Section 8 unit (cell C20):

=C512(1-B15) - (C5/30)*B8

This takes 12 months of contract rent, applies the lower Section 8 vacancy rate, then subtracts the lost rent during initial inspection delay (only relevant in year 1, but most landlords model it in for honest underwriting). Result: 106212(1-0.02) - (1062/30)*38 = 12489 - 1345 = $11,144.

For the market-rate scenario (cell C21):

=B712(1-B14)

Result: 105012(1-0.07) = $11,718.

Notice what happened. Even though Section 8 pays $12 per month more than market rent, the inspection delay in year 1 plus vacancy normalization makes market-rate the higher gross income in year 1. In stabilized year 2 onward, you would remove the initial inspection drag. Build a separate "stabilized" column to see both.

Section 8 specific expenses

HQS reinspection failures cost real money. Put the expected annual cost in C22:

=B9*B10

Result: 0.22 * 640 = $140.80. Small, but real, and it compounds over a 10-year hold.

Turnover cost with longer re-lease (C23):

=B13(B11/30)C5

This is the expected lost rent during voucher turnover. Result: 0.20(45/30)1062 = $318.60. Compare to market: =B13(B12/30)B7 = 0.20(14/30)1050 = $98. The voucher unit loses about $220 more per year to turnover friction.

Net operating income comparison

For Section 8 NOI (C25):

=C20 - B16 - (C512B17) - (C512B18) - C22 - C23

For market NOI (C26):

=C21 - B16 - (B712B17) - (B712B18) - (B13(B12/30)B7)

Subtract management, maintenance reserve, property tax and insurance, and turnover friction. The delta between C25 and C26 is your honest answer about whether Section 8 wins in this specific ZIP for this specific property.

Decision rule cell

In C28, put a flag:

=IF(C25>C261.05, "GO Section 8", IF(C25<C260.95, "GO Market", "Either, run more analysis"))

The 5% buffer matters. If the two scenarios are within 5% of each other, the deal is not being made or broken by the Section 8 decision. It is being made or broken by something else (purchase price, financing, neighborhood trajectory). Do not let the voucher question dominate a marginal call.

The ZIP-level rule most investors ignore

Before SAFMRs were introduced in 2018, HUD set one FMR per metro area. This meant that a 2-bedroom in a low-rent ZIP got the same voucher amount as one in a high-rent ZIP within the same metro. Landlords in low-rent areas loved this because they could rent at 130% of market through Section 8. Tenants got stuck in concentrated poverty because their vouchers did not go far in better neighborhoods.

HUD now publishes SAFMRs by ZIP for 24 metros (and growing). In SAFMR metros, the voucher amount in a "good" ZIP is 20% to 40% higher than the voucher amount in a "rough" ZIP. This flipped the investor math. Today, the deals that work for Section 8 are often in higher-quality ZIPs where the SAFMR is generous, not in low-rent ZIPs where Section 8 used to print money.

Practical rule: pull the SAFMR for every ZIP within 20 minutes of your target market. Sort them. The top quartile by SAFMR-to-purchase-price ratio is where the Section 8 deals actually pencil. The bottom quartile is where everyone thinks Section 8 works but actually does not anymore.

Red flags that kill the deal regardless of rent

Run the model. If it says GO Section 8, you still have to check four things before you sign anything.

1. PHA payment timing. Some PHAs pay HAP on the 1st. Some on the 5th. Some on "approximately the 10th." If your mortgage is due on the 1st and HAP arrives on the 12th, you need 30 days of float reserves. Ask the PHA when they actually deposit.
2. Voucher utilization rate. If the PHA is using 95%+ of available vouchers, demand is high and re-lease is fast. If they are at 78%, you will sit empty between tenants. HUD publishes this in the Voucher Management System reports.
3. Local landlord rejection rate. Cities like Houston have legal protections requiring landlords to accept vouchers. Cities like Indianapolis do not. In source-of-income discrimination jurisdictions, voucher tenant pools are deeper. In non-protected jurisdictions, you have less competition for tenants but the tenant pool is narrower.
4. HQS vs your current property condition. Walk the unit with the HQS checklist. If your hot water heater is 14 years old, your GFCI outlets are not installed in the bathroom, and your handrail is loose, you are looking at $1,800 to pass initial inspection. Bake it into the deal as a closing-cost line item, not a "we will fix it later" promise.

What to do with the model output

When the GO Section 8 flag fires and the four red flags clear, lock in the deal mechanics:

• Request the PHA's payment standard schedule in writing. Payment standards reset annually, usually on October 1st. Plan rent escalation around that date.
• Get on the PHA's preferred landlord list. In many PHAs, this puts your unit in front of vouchered families before it hits the public listing.
• Set up direct deposit for HAP payments. Paper checks are still common and add 5 days of float.
• Use a lease addendum that mirrors the HAP contract language exactly. Discrepancies between your lease and the HAP contract create enforcement gaps later.

The deals that work are the ones where the landlord treated Section 8 as a contract management exercise, not a moral position. Run the model, make the calls, walk the property with the HQS checklist, and decide based on the numbers in front of you.

Stop guessing on voucher deals

Section 8 analysis is not harder than market-rate analysis. It just has six more variables that most spreadsheets do not include. If you are underwriting voucher properties using a model that does not separate contract rent from market rent, does not account for inspection delay, and does not price HQS repair burden, you are going to misprice deals in both directions.

The SheetCraft Rental Property Analyzer includes a dedicated Section 8 tab with all six variables wired into the cash flow model, plus a side-by-side comparison view that flags whether the voucher scenario or the market scenario wins for that specific unit. SAFMR lookup is built in for the metros HUD publishes, and the payment standard, HQS reinspection, and re-lease friction variables are pre-formulated. If you are looking at a property today and trying to decide whether to chase the voucher, drop the numbers into the template and have a defensible answer in 10 minutes.