Model Behavior: How a Spreadsheet Saved me $165K
Welcome back to Home Economics, a data-driven newsletter about the American housing market. If You Want Something Done Right…Few personal financial decisions are more important—and more complex—than whether to buy or rent a home. The answer depends on countless factors, and reasoning alone won’t get you there. You need to model it. When I was considering buying a home in 2017, I scoured the internet for a good, user-friendly ‘buy vs. rent’ model. I was disappointed. Even the best tools—like the New York Times calculator—rely on sweeping simplifications. They often overlook critical factors such as mortgage structure or refinancing options, which can produce misleading results. So I built my own model (an Excel spreadsheet) and shared it with subscribers last year. An updated version—featuring the ability to model interest-only mortgages—is now available. It’s here for paying subscribers: It was this model that gave me the confidence to take the leap and buy a home seven years ago. And now, in retrospect, I can use the same model to evaluate whether that decision paid off. I Saved $165,000 by Buying Instead of RentingCalculating the past economics of buying versus renting is easier than projecting forward because all the inputs—the sale price, stock market performance, rent increases, etc.—are known. For me, buying turned out to be a very good decision. The chart above shows the total costs (including opportunity costs, such as not investing the down payment in the stock market) of buying versus renting, broken down by holding period.
Why Was Owning Better?If you know the Brooklyn property market well, this might surprise you. Home prices didn’t rise much during this period. In fact, I sold my home for only about $150,000 more than I paid for it—peanuts for a $1.2 million property over seven years. So why did I still come out ahead buying rather than renting?
Stress-Testing the TransactionThe chart below shows how I would have fared under different scenarios. What if interest rates had been higher? What if home prices had declined instead of rising (even modestly)? Each cell represents the money saved (or lost) by buying instead of renting. My actual transaction is in the first row, where I broke even by year 4 (indicated by the hashed box). Below that, I tested stress scenarios by adjusting key variables—home prices, interest rates, and mortgage type—up and down by one standard deviation (based on the last 20 years of data). Here’s what I found:
Of course, this assumes the stock market would have continued to outperform housing indefinitely—a strong assumption. Subscribers can explore alternative scenarios using the downloadable model (again, here): Final ThoughtsThe decision to buy versus rent is nuanced and highly dependent on individual circumstances, market conditions, and financing strategies. While my experience turned out favorably, it was far from guaranteed. The key lesson: the devil is in the details. If you—or someone you’re advising—is facing this decision, I recommend building or buying a rigorous model to guide you. Home Economics is a reader-supported publication. Please consider upgrading to a paid subscription to support our work. Paying clients receive access to the full archive, forecasts, data sets, and exclusive in-depth analysis. This edition is free—you can forward it to colleagues who appreciate concise, data-driven housing analysis. |
Older messages
The Forces Keeping Home Prices High
Wednesday, December 11, 2024
Cameron Murray on housing market equilibria ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Why Housing Watchers Should Learn Python Programming
Tuesday, December 3, 2024
A showcase with housing and migration data ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Five Innovations that Could Upend the Housing Market
Wednesday, November 20, 2024
Don't overlook technology's role in shaping housing demand–and supply. Here are five technologies that will make a difference. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Happy News
Tuesday, November 5, 2024
Paternity leave and guest authors ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
The Week in Review
Sunday, October 20, 2024
Week of Oct 7 — Buyers brighten, inflation eases ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
You Might Also Like
Weekend: Introducing the Butt Mullet Dress 👀
Sunday, March 9, 2025
— Check out what we Skimm'd for you today March 9, 2025 Subscribe Read in browser Header Image But first: Join the waitlist for a new premium Skimm experience Update location or View forecast
Starting Thursday: Rediscover Inspiration Through Wordsworth
Sunday, March 9, 2025
Last chance to register for our next literary seminar starting March 13. March Literary Seminar: Timothy Donnelly on William Wordsworth Rediscover one of the most influential poets of all time with
5 little treats for these strange and uncertain times
Sunday, March 9, 2025
Little treat culture? In this economy?
RI#266 - Down the rabbit hole/ What is "feels-like" temp/ Realtime voice tutor
Sunday, March 9, 2025
Hello again! My name is Alex and every week I share with you the 5 most useful links for self-improvement and productivity that I have found on the web. ---------------------------------------- You are
Chaos Theory: How Trump is Destroying the Economy
Sunday, March 9, 2025
Trump's erratic, chaotic governing style is dragging down the economy ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Chicken Shed Chronicles.
Sunday, March 9, 2025
Inspiration For You. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
“Hymn of Nature” by Felicia Dorothea Hemans
Sunday, March 9, 2025
O! Blest art thou whose steps may rove ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Claim Your Special Men's Health Offer Today!
Sunday, March 9, 2025
Subscribe to Men's Health today! Men's Health logo Get stronger, smarter, better 1 year of print mag + digital mag access Men's Health Magazine is the essential read for active, successful,
The 2025 Color Trends You *Should* Be Wearing Right Now
Sunday, March 9, 2025
They pack a playful punch. The Zoe Report Daily The Zoe Report 3.8.2025 The 2025 Color Trends You *Should* Be Wearing Right Now (Trends) The 2025 Color Trends You *Should* Be Wearing Right Now They
6 Most Common Tax Myths, Debunked
Saturday, March 8, 2025
How to Finally Stick With a Fitness Habit. Avoid costly mistakes in the days and weeks leading up to April 15. Not displaying correctly? View this newsletter online. TODAY'S FEATURED STORY Six of