NOW LIVE | Beyond the Median: How to Unmask the Multi-Million-Dollar Appeals Tsunami in Modern Mass Appraisal

Beyond the Median is officially published!

I’m pleased to announce that my new book is available:

Beyond the Median: How to Unmask the Multi-Million Dollar Appeals Tsunami in Modern Mass Appraisal

Today marks a critical shift in how we evaluate, audit, and defend property tax assessment rolls.

For decades, assessing offices and valuation professionals have taken shelter behind a single statistical shield: aggregate central tendency. As long as median ratios hover near 1.00 and overall Coefficients of Dispersion (COD) meet basic benchmarks, assessment rolls are certified as compliant.

The uncomfortable truth? A healthy median is often a dangerous illusion.

Beneath smooth aggregate averages, traditional single-entry CAMA models (a sales-based approach that generates Just Values across the entire Tentative Roll with limited population-level checks and balances) routinely embed a silent, structural "double whammy":

1.   Severe over-assessment concentrated on entry-level and lower-value homes—triggering an uncontrollable tsunami of tax appeals and Value Adjustment Board petitions.

2.   Massive under-assessment on luxury and high-end assets—allowing billions in baseline property tax wealth to vanish untaxed.

What You Will Learn in Beyond the Median

This book moves past surface-level metrics to deliver an immediately usable, mathematically defensible, non-black-box solution that requires zero changes to existing CAMA software:

· The Double-Entry Mass Appraisal (DEMA™) Framework: A practical two-step population calibration model to audit and equalize values outside legacy software.

· The Ten Commandments of Valuation Modeling: A complete specification protocol enforcing strict data sanity, dual variable governance, simultaneous time parameterization, and formal OLS assumption testing for true BLUE status.

· Extended Percentile Audits & Champ-Challenger Diagnostics: How to use 10th-to-90th percentile audits to identify hidden tail skewness and pit legacy CAMA models ("the Champ") against population-calibrated econometric engines ("the Challenger").

Get Your Copy Today

Payhip (PDF Edition):

https://payhip.com/b/PcIyf

Amazon (Kindle, Paperback, and Hardcover):

https://www.amazon.com/dp/B0HCJY2X2K

Thank you to everyone in the mass appraisal, AVM, and property tax communities for your ongoing support, feedback, and dedication to constitutional valuation equity.

Let’s move beyond the median together.

#MassAppraisal #AVM #CAMA #PropertyTax #Econometrics #RealEstateValuation #AssessmentEquity #PublicFinance #BeyondTheMedian #BookLaunch #SaveTheChildren #DataAnalytics

TOMORROW: The wait is over.

For years, the mass appraisal and property tax industry has relied on a dangerous assumption: If the median ratio looks good, the assessment roll is fair.

Tomorrow, we shatter that illusion.

Beyond the Median: How to Unmask the Multi-Million Dollar Appeals Tsunami in Modern Mass Appraisal officially goes live tomorrow, Sunday, August 2nd!

In this book, we step beyond aggregate central tendency to expose the silent "double whammy" hidden inside traditional single-entry CAMA models—where lower-value homes face systemic over-assessment while luxury assets carry massive untaxed cushions.

More importantly, this volume delivers an immediately actionable, non-black-box solution:

·   The Double-Entry Mass Appraisal (DEMA™) Framework

·   The Ten Commandments of Valuation Modeling

·   Extended Percentile Ratio Auditing & Champ-Challenger Diagnostics

Whether you are a chief appraiser, assessment analyst, appeal attorney, mass appeal consultant, or public finance official, this playbook gives you the tools to unmask roll distortions, restore constitutional equity, and stop tax appeal waves before they start.

Keep an eye on this feed tomorrow morning for the official release link and launch announcement!

#MassAppraisal #AVM #CAMA #PropertyTax #Econometrics #RealEstateValuation #AssessmentEquity #PublicFinance #BeyondTheMedian #BookLaunch

COMING SOON | Beyond the Median: How to Unmask the Multi-Million Dollar Appeals Tsunami in Modern Mass Appraisal

For decades, assessing offices and valuation professionals have taken shelter behind a single statistical shield: aggregate central tendency.

Chief appraisers and oversight boards point to neat median ratios near 1.00 and low CODs to certify tentative rolls, declaring statistical compliance accomplished. But in today’s volatile property tax environment, a healthy median is a dangerous illusion.

Beneath smooth central averages, traditional one-step CAMA models (sales-based models generating the Tentative Rolls) routinely embed a silent "double whammy":

1.   Severe over-assessment concentrated on lower-value and working-class properties—triggering an uncontrollable tsunami of tax appeals and Review Commission / Value Adjustment Board petitions.

2.   Massive under-assessment on high-end luxury and commercial assets—allowing billions in baseline property tax wealth to vanish untaxed.

It’s time to look beyond the median.

My upcoming book drops this Sunday, August 2nd!

In this book, I introduce the practical, two-step Double-Entry Mass Appraisal (DEMA™) framework and The Ten Commandments of Valuation Modeling. We show how assessing staff can use extended percentile audits and the Champ-Challenger approach to unmask hidden roll distortions—offering an immediately usable stop-gap solution that requires zero changes to existing CAMA workflows.

#MassAppraisal #AVM #CAMA #PropertyTax #Econometrics #RealEstateValuation #AssessmentEquity #PublicFinance 

Coming Soon | Beyond the Median: How to Unmask the Multi-Million Dollar Appeals Tsunami in Modern Mass Appraisal

Beyond the Median: How to Unmask the Multi-Million Dollar Appeals Tsunami in Modern Mass Appraisal

Most assessing offices still rely on the traditional one-step CAMA model. The sales-based approach generates Just Values across the entire Tentative Roll with limited population-level checks and balances.

The result? Hidden distortions that quietly build into multi-million (and sometimes multi-billion) dollar appeals and ratio challenges.

This book introduces a practical path forward:

·        The Ten Commandments of Valuation Modeling

·        Extended percentile analysis that reveals what the median hides

·        A clear two-step framework that strengthens the Tentative Roll before it becomes final

Whether you work in assessment, serve on a VAB or Review Commission, or consult in this space, this book is written for you.

Coming Sunday, August 2.

Stay tuned.

#AVM #CAMA #DEMA #IAAO #USPAP #MassAppraisal #PropertyTax #RegressionModeling #ValuationModeling

The Ten Commandments of Valuation Modeling (AVM and CAMA)

Most assessing offices still follow the traditional one-step CAMA process. We believe the industry needs a clearer, more disciplined standard.

Today I am sharing a condensed version of The Ten Commandments of Valuation Modeling on Substack and Patreon. These ten non-negotiable principles cover everything from percentile-based sampling and holdout testing to time as an independent variable, systematic outlier removal, and the validation of OLS assumptions required for true BLUE status.

The full 14-page chapter — with detailed explanations and practical guidance — will appear as Chapter 1 in my upcoming book:

Beyond the Median: How to Unmask the Multi-Million Dollar Appeals Tsunami in Modern Mass Appraisal

If you work in assessment, serve on a VAB or Review Commission, or consult in this space, these Commandments offer a practical code of practice you can apply immediately.

Read the condensed version here: 

Link to Article on Patreon

Link to Article on Substack

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