The Assessment Fire Alarm: Why Single-Point Averages Hide Multi-Million Dollar Roll Risks

For decades, traditional mass appraisal has relied on central tendency metrics—averages and medians—as statistical shields. But evaluating a tentative tax roll solely on a median is like checking the average depth of a river before jumping in: it tells you nothing about the ten-foot hole hiding in the middle.

In our newly released finale for Phase 1—Session 4C: The Champ-Challenger Showdown—we deploy Extended Percentile Analysis (10th to 90th Percentiles) across a 60,870-property tentative roll to unmask the hidden tail distortions that legacy CAMA models overlook.

What the Extended Percentile Curve Reveals:

· The Over-Assessment Vortex (10th Percentile): Working-class homestead owners at the bottom decile face a crushing 34.8% over-assessment penalty (JVR of 0.6517), directly driving the surge in appeal petitions and Value Adjustment Board challenges.

· The Uncollected Revenue Leak (90th Percentile): Luxury residential properties at the top decile drop to an under-assessed 1.5141 JVR ceiling, allowing vast baseline property assets to fly under the tax radar.

· The Equity Gap: While the Homestead class suffers an extreme 0.8624 spread between its floor and ceiling, Non-Homestead investors enjoy a tight, protected 0.3648 spread.

An Actionable Guardrail for Every Jurisdiction

You don't need a multi-million dollar software overhaul or statutory changes to start catching these distortions. Every assessment department can immediately implement two critical safeguards within their existing sales-based workflows:

1. Front-End Guardrail: Test sales samples across 10th-to-90th percentiles—rather than relying on medians alone—before calibrating models.

2. Back-End Guardrail: Stratify post-model ratios by key foundational variables (Town vs. Suburb, Homestead vs. Non-Homestead) across extended percentiles to identify spatial and class equity rifts.

Session 4C provides the practical "Fire Alarm" diagnostic that assessing staff can run today to mitigate litigation exposure, protect vulnerable taxpayers, and restore true constitutional uniformity.

Read the full Session 4C post now on Substack and Patreon.

Link to Patreon

Link to Substack

#PropertyTax #MassAppraisal #CAMA #DataAnalytics #PublicFinance #TaxPolicy #DEMA #AssessmentEquity

The Champ-Challenger Showdown Finale

This Wednesday at 8:00 AM EST, Phase 1 reaches its definitive climax.

For decades, legacy single-entry CAMA infrastructure—"The Champ"—has ruled property tax administration. But when pitted against the raw, unvarnished truth of a 60,870-property countywide tentative roll, the Champ gets knocked flat on the canvas.

In Session 4C, we skip the repetitive post-outlier breakdowns and go straight to the raw financial scene. By executing a baseline 2x2 matrix across both Location (Town vs. Suburbs) and Ownership Status (Homestead vs. Non-Homestead), we reveal the full scale of structural damage left behind by legacy single-entry modeling.

The raw population numbers speak for themselves:

· A Geographic Rift: An urban over-assessment litigation time bomb sitting alongside a multi-million-dollar suburban revenue leakage.

· A 30% Modal Over-Assessment Vortex: Proof that while high-value luxury estates enjoy suppressed assessments, working-class permanent homeowners carry the deficit.

· The Transfer of the Crown: Why the crowd is cheering for Double-Entry Mass Appraisal (DEMA™)—the agile Challenger that acts as both a Shield (neutralizing appeals) and a Sword (recapturing lost revenue without raising tax rates).

What’s dropping this Wednesday at 8 AM EST:

· Free Executive Summary: The complete dramatic breakdown of the Champ’s downfall and DEMA’s victory lap.

· Paid Subscriber Portal Release: Unedited textbook manuscript draft, interactive workbooks, and details on closed-door technical analysis.

Whether you are in local government looking to protect your tax base or a consultant advocating for property tax equity, you won't want to miss the crowning of the new standard in mass appraisal.

Mark your calendars for Wed 8:00 AM EST. The reign of single-entry CAMA is officially over.

#MassAppraisal #AVM #CAMA #DEMA #PropertyTax #TaxAssessment #ForensicValuation #DataAnalytics #CrossoverDreamers

The Final Call: Is Legacy CAMA Surviving the Audit?

For decades, the entrenched legacy mass appraisal system has been the undisputed Champ of property tax administration—heavy, rigid, and legally anchored. But a single-entry Champ cannot survive a double-entry world.

Today, we are dropping the final teaser for Session 4B, and the numbers leave the old guard with nowhere to hide. When you run raw, population-level data through a single regression model without a dual-pass accounting audit, the Single-Entry Mass Appraisal splits your jurisdiction right down the middle:

·  In-Town: Property values are systematically overestimated relative to our model. Homeowners inside the town are being over-assessed and over-taxed.

·  The Suburbs: Property values are systematically underestimated, granting an artificial valuation discount and leaking massive institutional revenue.

There is a new kid in town. The Challenger—the DEMA™ Protocol—has officially stepped into the ring.

Double-Entry Mass Appraisal (DEMA™) doesn’t illegally alter the official record. Instead, it acts as an agile, independent forensic audit that exposes exactly where the Champ's blind spots are, turning neighbors against each other and setting the stage for an econometric equalization of the tax roll.

The talk on the street is changing, and the old single-entry playbook is officially on notice. This is your last chance to unpack the structural distortions of Session 4B before we move to the final reconciliation.

Read the final Session 4B analysis and watch the Challenger land the ultimate econometric punch:

Link to the Substack Post

Link to the Patreon Post

If you work in assessing, serve on a VAB or Review Commission, or consult in this space, DEMA™ offers a practical path to stronger rolls and fewer appeals.

Tag colleagues who should see this series:

#DEMA #CAMA #DataScience #Econometrics #IAAO #MassAppraisal #RegressionModel #PropertyTax #ValuationModeling #HorizontalEquity #TaxLitigation

Introducing DEMA™ (Double-Entry Mass Appraisal)

What if the traditional one-step CAMA approach is the root cause of the appeals tsunami?

We’ve been building a better way.

In Sessions 4A and 4B, we demonstrated the complete Double-Entry Mass Appraisal (DEMA™) protocol:

· First Entry (Sales-Based Modeling): Builds the tentative roll with econometric soundness (BLUE status) and IAAO compliance.

· Second Entry (Population-Based Equalization): Cleans the roll by identifying and correcting population-level distortions before it is finalized.

This two-sided ledger approach — DEMA™ — is the true Nirvana of modern mass appraisal: proactive equity instead of reactive defense.

Session 4C, the grand finale of Phase 1, will deliver the final Champ-Challenger showdown between the Central Taxing District and the Town Taxing District. This direct comparison will identify the major faultlines when the jurisdiction roll is generated by two separate models (in-town vs. suburbs). 4C will complete our end-to-end DEMA™ solution next week.

To read Session 4B and run the DEMA™ Protocol on your own database:

Link to Substack

Link to Patreon

If you work in assessing, serve on a VAB or Review Commission, or consult in this space, DEMA™ offers a practical path to stronger rolls and fewer appeals.

Tag colleagues who should see this series:

#DEMA #CAMA #IAAO #MassAppraisal #PropertyAssessment #ValuationModeling #VAB 

Why Mass Appraisal Needs Double-Entry Valuation Modeling

Would you let a Fortune 500 company manage its financial ledger using single-entry bookkeeping?

Of course not. Tracking cash flowing in without a balancing entry, a trial balance, or a structural balance sheet is an immediate recipe for systemic failure.

Yet, every single year, multi-billion-dollar tax jurisdictions run their property rolls on the exact same single-entry mindset.

Legacy CAMA practices do this by default:

1.   They look at transaction data (sales).

2.   They run a baseline regression.

3.   They print the Tentative Roll (the first entry).

4.   They stop right there.

Stopping at the first entry means you are flying completely blind. You have no balancing ledger to check if those values are mathematically stable or legally uniform across the remaining 95% of the unsold population. You only find out the ledger is broken when an appeals tsunami hits the Value Adjustment Board (VAB) or the Review Commission.

In Session 4B, we introduce modern Double-Entry Valuation Modeling. We show you how to take that initial generative sales engine and systematically reconcile it against a full population dataset of 60,870 properties.

If you want to move past single-entry mass appraisal and learn how to build an unassailable, balanced valuation ledger that stops litigation before it starts, the Session 4B blueprint is officially live.

The Executive Summary remains free for everyone (use either link below):

Link to Patreon

Link to Substack

How Resilient is Your Tax Roll when subjected to a Rigorous Population-Based Audit?

 Session 4B is Now Live!

Many mass appraisal systems look brilliant on paper. They boast high R^2 values, strong global F-statistics, and highly "significant" variables. But beneath the surface of these global metrics often lie structural anomalies, negative coefficient traps, and systemic equity distortions that leave jurisdictions incredibly vulnerable to appeals and litigation.

In Session 4B of our Equalization Valuation Modeling series, we move from sales-based modeling (Session 4A) to a comprehensive population dataset of 60,870 Single-Family Residences.

Using a population-based approach, this session provides a step-by-step blueprint for assessment staff, independent consultants, Review Commissioners, and Value Adjustment Board (VAB) members to conduct a forensic audit of a tentative roll, diagnose legacy computer-assisted mass appraisal (CAMA) failures, and protect the integrity of the jurisdiction.

In this session, we dive deep into:

The Continuous Variable Riddle: Why legacy linear models produce economic absurdities (like negative land values) and how to fix them using our proprietary, objective, stratification method. 

Quantifying Systemic Exposure: How a seemingly simple binary variable can unmask massive, multi-billion dollar horizontal and vertical equity risks across a population. 

The 2-Pass JVR Protocol: How executing a strict two-pass regression with Just Value Ratio (JVR) analysis mathematically purges cross-jurisdictional noise and stabilizes the roll.

This session also sets the stage for our upcoming grand finale: The Session 4C Champ-Challenger Showdown.

If you are an assessor, independent analyst, or oversight commissioner looking for unassailable, platform-agnostic modeling frameworks to navigate today's complex valuation landscape, this playbook is for you.

Read the Executive Summary for Free and unlock the full Premium Deep Dive here:

Substack Link

Patreon Link

Equalization Valuation Modeling (EVM) for Smaller and Mid-Sized Jurisdictions: Foundations & Model Development

 

Equalization Valuation Modeling (EVM) for Smaller and Mid-Sized Jurisdictions: Foundations & Model Development: (Building Practical, Transparent Models Using Your Own Just Values)

In this book, we introduce Equalization Valuation Modeling (EVM) — a practical, transparent approach designed specifically for smaller and mid-sized jurisdictions. Unlike traditional Automated Valuation Models (AVM) or Mass Appraisal Models (CAMA) that predict sale prices, Equalization Valuation Models use your jurisdiction’s own Just Values as the dependent variable to improve uniformity and defensibility across the roll.
Using a real non-coastal county dataset (hybrid taxing system with 7 towns), we demonstrate:

• Proper data construction for equalization modeling
• The 2-Pass Outlier Protocol (Z-score based)
• Dramatic model improvement from Pass 1 to Pass 2
• Just Value Ratio (JVR) analysis showing major gains in uniformity

Key Result: After removing ~5% outliers, R² rose to 93.78%, Standard Error dropped to $35,963, and JVR dispersion tightened significantly. This book lays the forensic foundation for building lightweight, internally manageable models using only Excel.

This concise book establishes the core of Equalization Valuation Modeling — a transparent, platform-agnostic approach that serves as both a preventative shield for assessing offices and an independent verification standard for Review Commissions, Value Adjustment Boards, and consultants.

Only $2.99 -- Kindle version (for a limited time).

Link to the book's Amazon Kindle version

The Classic One-Step Sales Sample-Based CAMA Approach and the Three Golden Guardrails™ are live on Patreon and Substack.

 Session 4A is Now Live!

We just published our one-step compliant baseline model—built on real-world residential data from a Southern resort town (Spoiler Alert: Not Orlando, Miami, or Tampa). The quality control ledger is undeniable:

· COD = 8.54%

· PRD = 1.010

· R^2 = 0.8441

· SE = $55,333

· Status: Stage 1 BLUE. IAAO 3.3.5 Compliant.

On paper, it’s an assessor’s dream. In the field, it’s still blind to 95,000 taxpayers.

This is the exact structural trap that triggers the modern property tax appeals tsunami. Traditional workflows hit an elite, compliant ratio on a small sales sample and call it a day, completely masking the localized boundary rot that slaughters your roll in court. Achieving Stage 1 BLUE status does not guarantee Stage 2 population equity.

Inside the Paid Subscriber Session 4A Manual:

· The 2-Pass Protocol: The exact forensic roadmap to transition from raw, chaotic sales data to a certified, unassailable baseline model.

· The Three Golden Guardrails™: Hard-coding non-negotiable rules for Percentile-Based Sampling, strict Holdout Testing, and an absolute ban on on-the-fly GIS variables.

· The Shock Sample: A targeted, 24-sale micro-audit proving how a mathematically “perfect” model can still catastrophically fail your broader jurisdiction.

· The Doctrine: A masterclass on why global IAAO compliance is a necessary operational milestone, but an entirely insufficient condition for absolute tax equity.

· Predicting Distortions: How to use front-end sample variance to accurately forecast exactly where your Tentative Roll will rupture before it goes public.

One-step is clean. Two-step is constitutional.

Session 4A is the model. Session 4B is the roll. This ends the era of “good enough” COD.

NOT A PAID SUBSCRIBER YET?

The complete Phase 1 Executive Summary is 100% FREE for everyone. Read the structural breakdown of the guardrails and the limits of sample-based calibration before you touch a line of code.

Access Session 4A here:

https://www.patreon.com/SidSom/posts/session-4a-one-163206609

https://sidsom.substack.com/p/session-4a-the-classic-one-step-sales

Please tag colleagues who should see this series.

#CAMA #IAAO #MassAppraisal #PropertyTax #ForensicValuation #ValuationModeling #DataScience #Econometrics

Session 1: Platform-Agnostic Equalization Valuation Modeling is Now Live (and 100% Free!!)

 We’re Live — Session 1 is Now Available (100% Free)

Platform-Agnostic Equalization Valuation Modeling: Tools for Assessing Staff, VABs, Review Commissions & Independent Consultants

Today marks the official launch of our new 8-session series.

If you work for a small or mid-sized assessing jurisdiction and are trying to understand how the CAMA system produces values, serve on a Review Commission, are part of a Value Adjustment Board, or work as an independent consultant, this series was built for you.

Session 1 is completely free and unlocked for everyone.

In this foundational session, we demonstrate a practical, transparent, Excel-based (and platform-agnostic) approach to building Equalization Valuation Models using your jurisdiction’s own Just Values.

In Session 1, you will learn:

· How to construct a proper equalization dataset

· The complete 2-Pass Forensic Outlier Protocol

· A striking real-world “Wake-Up Call” sample showing current misalignments

· How the model improves dramatically after cleaning (R² to 93.78%, much tighter uniformity)

· Just Value Ratio (JVR) diagnostics with clear interpretation

·        Step-by-step Excel instructions (Data Analysis ToolPak)

This is your independent, defensible toolset — no vendor lock-in required. Works in Excel for smaller offices and scales to SPSS/SAS for larger jurisdictions.

Download Session 1 for Free Now (Patreon or Substack) →

https://www.patreon.com/SidSom/posts/platform-tools-161198809

https://sidsom.substack.com/p/platform-agnostic-equalization-valuation-ea3?r=7xq68s

Fellow coffee lovers: You can also support this ongoing work (and share a virtual coffee with me) via Buy Me a Coffee. Every bit helps keep this mission — helping dreamers achieve their goals — moving forward.

https://buymeacoffee.com/sidsom/platform-agnostic-equalization-valuation-modeling-tools-assessing-staff-vabs-review-commissions-independent-consultants

A portion of the proceeds from the full series will support charitable causes.

The full 8-session series will continue weekly, taking you from model development to powerful applications: Regression Comps (bottom-up) and Ratio Challenges (top-down).

This is structural empowerment in the back end of mass appraisal.

If you care about fair, transparent, and defensible property valuation, join us.

Session 1 is available right now. Let’s get started.

Tag colleagues who should read this post.

The Multi-Million-Dollar CAMA Vendor Trap is Over for Smaller and Mid-Sized Jurisdictions

If you’re an analyst, assessor, or independent consultant working in a jurisdiction with 50K to 200K residential parcels, you’ve been told a lie: that you need expensive, opaque black-box software to achieve real valuation equity.

You don’t.

You just need a standard copy of Microsoft Excel and a highly disciplined econometric protocol.

Next Tuesday, June 16th, I’m launching an 8-session series on Patreon: Equalization Valuation Modeling for Smaller and Mid-Sized Jurisdictions.

To prove it, Session 1 is 100% free and unlocked for everyone.

In this opening session, I’ll hand you the complete step-by-step 2-Pass Forensic Framework to:

1. Strip out valuation noise and legacy data defects

2. Drive your model toward true BLUE status (Best Linear Unbiased Estimator)

3. Produce a powerful Just Value Ratio (JVR) equity diagnostic that reveals where your roll stands

This is the ultimate resume builder and job-security tool for technical professionals who often serve as the sole modeling and appraisal team in their office.

No vendor contracts. No black boxes. Just a transparent, defensible methodology you can own and control.

Session 1 drops Tuesday morning — complete with dataset examples, Excel execution steps, and the full forensic protocol.

Keep an eye on this feed.

We’re bringing structural liberation to mass appraisal — one disciplined model at a time.

Book: Challenging Your Property Assessment: The Art of the Rebuttal: (A Comprehensive Guide to Winning Property Tax Appeals)

Link to the Kindle version

Book Summary

Your property tax bill arrives — and it’s higher than it should be. The assessor’s valuation feels wrong, but the system seems stacked against you. Most homeowners shrug, pay, and move on. You don’t have to. Sid, a former valuation expert who has written authoritative books on comparable sales, automated models, and mass appraisal, switched sides. After successfully appealing his own assessment using the very tools assessors rely on, he now arms everyday homeowners — and the consultants who represent them — with the same powerful strategies. This is not just a book about crunching numbers. It is a tactical guide to the art of the rebuttal — how to build an unassailable case, anticipate the assessor’s arguments, and win at the Value Adjustment Board (or equivalent hearing boards).
Inside you’ll discover:

• How to anchor your appeal with proximity and recency — the geographic and temporal comps that boards can’t ignore
• Step-by-step valuation grids that turn raw sales data into a clear, defensible fair market value
• Specialized techniques for low-rise, mid-rise, and high-rise condos, PUDs, and MPUDs — where standard rules break and intra-complex comparisons rule
• How to use simple regression modeling to derive objective, market-derived adjustments — no more “I think this is worth $40,000.”
• The Art of the Rebuttal — how to counter the assessor’s most common objections, present your evidence persuasively, and shift the burden back where it belongs
• The Ratio Challenge — discover how this innovative "Top-Down" approach audits the entire assessment roll using Just Value Ratios to pinpoint and challenge geographic or economic over-assessment clusters
• Each chapter contains ready-to-use presentation scripts, rebuttal responses, and comprehensive checklists to prepare you for the hearing.

Whether you’re fighting a single over-assessment or a consultant helping an entire neighborhood, this book transforms you into an advocate. You’ll learn not just how to calculate value — but how to prove it, defend it, and win it. The assessor has the data. Now you have the strategy. Master the art of the rebuttal — and take back what’s yours.