Market Tracker Template: The 12 Metrics Investors Should Refresh Every Month

Introduction

Most investors track markets the way they track the weather — they notice conditions after the conditions have already changed. A market tracker fixes the ordering problem. It forces you to look at the same small set of indicators on the same cadence, so that when a market turns you see it in the data rather than in your vacancy report six months later.

TL;DR: Track twelve metrics across four groups — demand, supply, pricing, and capital. Refresh eight of them monthly and four quarterly. The value is not in any single number; it is in seeing two or more groups deteriorate at once, which is the pattern that precedes almost every underwriting miss.

This is a template, not a product. Everything below can be built in a spreadsheet in an afternoon and pulled from free public sources. What makes it work is discipline about the refresh cadence, not sophistication in the model.

Why a tracker beats ad-hoc market research

Ad-hoc research has a structural bias: you go looking when something prompts you, and what prompts you is usually a deal you already want to do. By then you are researching to confirm, not to decide.

A standing tracker inverts that. The metrics are chosen before you have a position, refreshed whether or not you are buying, and compared against their own history rather than against your expectations. Three practical consequences:

• You get a baseline. A 6% vacancy rate means nothing on its own. A 6% vacancy rate in a market that ran 3.5% for three years means a great deal.
• You catch direction, not just level. Most underwriting errors are direction errors — assuming a trend continues past its inflection.
• You can compare markets on identical inputs. Ad-hoc research produces incomparable notes; a tracker produces a table.

For a worked example of how these signals get applied at the point of decision, see 10 market signals to check before bidding.

The four groups

A useful tracker is organized by what the metric tells you, not by where you got it. Four groups cover the ground:

Group	Question it answers	Refresh
Demand	Are more people able and willing to rent or buy here?	Monthly
Supply	What is competing with me now, and in 24 months?	Monthly
Pricing	What are rents and values actually doing?	Monthly
Capital	What does it cost to finance and exit?	Monthly / Quarterly

The point of the grouping is the cross-check. Any one group can move for benign reasons. When two move against you at once, the market is telling you something.

Demand metrics

1. Non-farm payroll employment (metro level)

The single best proxy for whether a rental market has a floor under it. Track the 12-month change, not the monthly print — monthly employment data is noisy and gets revised.

Source: Bureau of Labor Statistics, State and Metro Area Employment. Free, monthly.

What to watch for: Any 12-month change that turns negative, and any metro where growth is concentrated in a single employer or sector.

2. Population and household formation

Households, not people, rent units. A metro can add population and add fewer households than you expect if household size is rising — which is exactly what happens when affordability tightens.

Source: Census Bureau population estimates (annual), American Community Survey.

What to watch for: Divergence between population growth and household growth.

3. Median household income vs. median rent

The affordability ceiling. When rent-to-income passes roughly 30% at the median, further rent growth starts coming out of occupancy and collections rather than out of the tenant's budget.

Source: ACS for income, your own comps or a rent index for rent.

What to watch for: Rent growth outrunning income growth for more than four consecutive quarters.

Supply metrics

4. Building permits (units authorized)

The best available 18-to-24-month leading indicator of competitive supply. Permits are not starts and starts are not deliveries, but permits turn first.

Source: Census Building Permits Survey, monthly, by metro.

What to watch for: Permit volume above the metro's 10-year average while absorption is flat.

5. Units under construction

Permits tell you about intent; units under construction tell you what is actually arriving. This is the number that determines your lease-up assumptions two years out.

What to watch for: Construction pipeline as a share of existing inventory above ~4% in a metro whose employment growth is under 1%.

6. Months of for-sale inventory

A cross-check on the for-sale market, which competes with rentals at the margin and sets your exit conditions.

What to watch for: Inventory rising while days-on-market also rises — two signals of the same softening.

Pricing metrics

7. Asking rent, by unit type

Track asking rent for the specific unit types you own or want to own. Metro-wide averages blend product classes that do not compete with each other.

8. Concessions

The most under-tracked metric on this list, and often the first to move. Effective rent falls through concessions long before asking rent falls. One month free on a 12-month lease is an 8.3% effective rent cut that never shows up in an asking-rent index.

Source: Direct observation. Call three competing properties as a prospective renter, once a month.

9. Sale price per unit / per square foot

Your basis check and your exit check. Track the trailing 6-month median for comparable product, not the single most recent trade.

Capital metrics

10. Prevailing debt cost for your product

Not the 30-year fixed headline rate — the rate you would actually be quoted on the loan type you use. If you finance with DSCR loans, track DSCR quotes; the spread over the index moves independently of the index.

See DSCR loan rates in 2026 for what those quotes have been doing.

11. Cap rate for comparable trades

Refresh quarterly. Cap rates are derived from a small number of transactions, so a monthly refresh mostly measures sampling noise.

What to watch for: Any widening between your going-in cap and the trailing cap on recent trades — that gap is exit risk.

12. Property tax reassessment exposure

Quarterly. Reassessment timing varies by jurisdiction, and in reassessment-on-sale states your tax line can step up the year after purchase in a way the trailing operating statement completely hides.

The detail on this is in the property tax reassessment risk scorecard.

Building the sheet

One tab per market, one row per month, one column per metric. Three columns beyond the raw values do most of the work:

1. 12-month change, so you are reading direction rather than level.
2. Percentile against that market's own history, so you know whether the current value is unusual.
3. A flag column that turns on when the metric crosses a threshold you set in advance.

Set the thresholds before you have a position. Thresholds set while you are underwriting a deal you like are not thresholds.

Reading the tracker

The tracker earns its keep through combinations, not individual readings:

• Permits high + employment flat → supply arriving into demand that is not growing. Lease-up risk in 18–24 months.
• Concessions rising + asking rent flat → effective rents are already falling. Your rent growth assumption is wrong now, not later.
• Cap rates widening + debt cost flat → the market is repricing risk rather than reacting to rates. Exit cap assumptions need to move.
• Rent-to-income above 30% + rent growth strong → the rent growth is borrowed from future occupancy.

A single flag is a prompt to look closer. Two flags in different groups is a reason to change an assumption. Three is a reason to stop underwriting the market until you understand why.

FAQ

How many markets can one person realistically track?

Three to five, refreshed monthly, done properly. Beyond that the refresh slips and a stale tracker is worse than none — it produces confident decisions from old data.

Is paid data necessary?

No, for this list. Everything here is available free from BLS, the Census Bureau, and direct observation. Paid data buys you speed and granularity, which matter at scale but are not the constraint for most investors.

How far back should the history go?

Ten years if you can get it, five as a minimum. You need enough history to include at least one period of stress, or your percentiles will describe only good conditions.

What is the most common mistake?

Tracking level instead of change, and metro averages instead of submarket and product-type detail. Both produce numbers that are technically correct and decision-useless.

Should the thresholds be the same in every market?

No. A 4% construction pipeline is routine in a fast-growing Sunbelt metro and alarming in a flat Midwest one. Set thresholds against each market's own history.

Conclusion

The value of a market tracker is not predictive precision. It is that it makes you look at the same things on a schedule, compare them to their own history, and notice when several of them move together. That is enough to catch most of the errors that actually damage returns — assuming a trend continues, missing supply that was visible in permit data two years earlier, and underwriting rent growth that concessions had already reversed.

Build it once, refresh it monthly, and set the thresholds before you have a position.

Sources

• U.S. Bureau of Labor Statistics, State and Metro Area Employment, Hours, and Earnings.
• U.S. Census Bureau, Building Permits Survey.
• U.S. Census Bureau, American Community Survey.