52-year spreadsheet

The Spreadsheet That Debunks Housing Market Myths Most financial commentators operate on feelings, but Michael Zuber operates on a 52-year data set. His comprehensive analysis, which tracks 34 different metrics back to 1970, reveals a stark reality: the housing market does not behave the way most experts claim. The prevailing wisdom suggests that for every 1% increase in interest rates, home prices should fall by 10%. Zuber’s data shows this is a fallacy. During the period from 1978 to 1982, interest rates surged by 700 basis points, yet home prices did not collapse. Instead, they remained resilient while transaction volume was the variable that truly crashed. This historical context is vital for understanding the 2026 landscape. We are currently witnessing a massive disconnect between affordability and price action. While 72% of people believe it is a bad time to buy, prices aren't plummeting because there is no wave of motivated sellers. Most homeowners are sitting on 30-year fixed mortgages below 4%, essentially fixing their second-largest life expense at an artificially low rate. They are effectively "locked in," creating a supply vacuum that prevents the price correction many are waiting for. Why Transactions Matter More Than Prices Real estate accounts for roughly 12% to 13% of the US economy. When transaction volume drops by 50%—as it did between 1978 and 1982—it pulls a massive lever on national productivity. The "recovery" people expect often takes much longer than they realize. After the late-70s peak, it took until 1996 for transaction volumes to return to their previous highs. This suggests that while prices may remain stable, the economic engine tied to housing will remain in low gear for over a decade. For the individual investor or homebuyer, this means 2026 is a year of gridlock. Buyers cannot afford the monthly payments at current rates, and sellers refuse to trade their 3% mortgage for a 7% one. This stalemate is why Zuber predicts national median home prices will remain flat—plus or minus 1%—until 2030. It takes years for wage growth to catch up to the step-function change in mortgage costs. Until the ratio of wages to monthly payments normalizes, the market will remain stagnant. The 18-Year Cycle Mirage Many investors cling to the theory of an 18-year real estate cycle, but the 52-year spreadsheet fails to find evidence for it. Outside of the Global Financial Crisis (GFC), where prices fell because of toxic adjustable-rate mortgages, the historical record shows only one year in the 1980s where prices dipped by less than 1%. The idea of a predictable, rhythmic crash is a story people tell to find order in chaos. In reality, the market is driven by inventory, debt structure, and the presence—or absence—of forced sellers. The Anatomy of a Successful 2026 Investor If the market is flat and transactions are low, how does one build wealth? The answer lies in the inefficiency of real estate compared to the S&P 500 or Bitcoin. In a liquid market, you know the value of an asset to the penny every second. Real estate is different. Success requires a "buy box"—a hyper-specific set of criteria that an investor tracks daily for years. By focusing on one zip code and one property type, such as three-bedroom single-family homes in Fresno, you develop the ability to spot a 15% discount the moment it hits the market. Investors who win in this environment are those who write "disrespectful" offers and seek out the one-in-a-hundred motivated seller. You make your money when you buy, not when you sell. This requires extreme discipline and the willingness to look at the market for 20 minutes every single day. Most people lack this fortitude, which is why they default to the stock market. But for those willing to do the work, the inefficiency of the current market provides a path to instant equity that liquid assets cannot match. Creative Financing as a Survival Tool As traditional lending becomes cost-prohibitive, creative financing has moved from the fringes to the mainstream. This isn't "magic beans"; it is a professional tool that requires rigorous paperwork and legal oversight. The most effective strategy currently involves targeting owners with high equity—specifically those who own more than 50% of their property. By offering a higher purchase price in exchange for the seller carrying a second mortgage, investors can bridge the gap created by high bank rates. However, many novices fail here because they treat paperwork as an afterthought. A professional deal must include clear penalties for mispayments and the ability to foreclose. Without these protections for both the buyer and the seller, creative financing becomes a liability rather than an asset. In a flat market, these structures are often the only way to make the numbers "pencil out" for cash flow. The Wealth Transfer in Commercial and Multifamily While residential real estate remains stuck, multifamily is approaching a reckoning similar to the 2008 residential crash. The issue is debt. Many commercial operators used short-term, floating-rate debt that is now resetting at double the interest cost. This is creating a genuine wave of forced sellers. We are on the cusp of a significant transfer of wealth where well-capitalized investors will acquire apartment buildings at 60% to 70% of their previous debt values. This is the K-shaped recovery in action. On one side, you have the "locked-in" residential owner who is protected by a 30-year fixed rate. On the other, you have the commercial operator whose business model is blowing up due to interest rate sensitivity. For the serious wealth manager, the opportunity of the next five years is not in flipping houses, but in identifying distressed commercial debt and being ready to provide the liquidity the market desperately needs. Redefining Financial Independence and Contentment Building wealth is a three-step process that has remained unchanged for a century: live below your means to create discretionary income, become elite at one asset class, and allow time—at least a decade—for compounding to work. The psychological hurdle is often harder than the financial one. Zuber recounts a "crying-in-the-car" moment 12 years into his journey, where he felt he was failing because his subordinates lived in better houses and drove newer cars. It was only by looking at his cash flow spreadsheet that he realized the sacrifice was working. True financial independence isn't about being a billionaire; it's about knowing your "burn rate" and having assets that cover it. By living on $12,000 a month while generating $52,000 in cash flow, an individual gains the ultimate luxury: the ability to stop moving the goalposts. Most high-earners, particularly in Silicon Valley, remain on a treadmill of consumption that keeps them paycheck-to-paycheck despite 300k+ salaries. Breaking that cycle requires a ruthless "need vs. want" audit and the discipline to value experiences over stuff. A Strategy for a Resilient Future Looking toward 2030, the outlook for real estate is one of stagnant prices but immense opportunity for the disciplined. The combination of AI-driven deflation and shifting demographics will eventually reshape the housing landscape, potentially making entry-level homes easier to produce. However, those shifts are a decade away. For now, the path forward is prudence. Avoid high-priced, speculative markets like Austin or Seattle where you are merely betting on appreciation. Focus on cash-flowing assets in tertiary markets and prioritize 30-year fixed debt above all else. In a world of fluctuating rates and economic uncertainty, the fixed-rate mortgage remains the single greatest gift to the American investor.