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
#66: What The Notches Said – No. 06
Wednesday, January 15, 2025
Interview with 'Z', who's from my səxual past ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Katie Holmes’ Monochrome Outfit Debuts Winter’s New *It* Color
Wednesday, January 15, 2025
We're major fans. The Zoe Report Daily The Zoe Report 1.14.2025 Katie Holmes' Monochrome Outfit Debuts Winter's New *It* Color (Celebrity) Katie Holmes' Monochrome Outfit Debuts
The Best Thing: January 14, 2025
Wednesday, January 15, 2025
The Best Thing is our weekly discussion thread where we share the one thing that we read, listened to, watched, did, or otherwise enjoyed recent… ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
'Micro-Dosing' Your Concealer Is The Genius Hack For Flawless Skin
Wednesday, January 15, 2025
A celebrity makeup artist breaks it down. The Zoe Report Beauty The Zoe Report 1.14.2025 (Beauty) lisa eldridge pinpoint concealer micro correcting pencil (Makeup) 'Micro-Dosing' Your Concealer
How to Use TikTok in the US, Even When It's Banned
Tuesday, January 14, 2025
9 States Will Have Lower Income Taxes This Year. Even if TikTok is banned, there are ways to access it. Not displaying correctly? View this newsletter online. TODAY'S FEATURED STORY How to Use
Keke Palmer’s Greatest Role Is Herself
Tuesday, January 14, 2025
Today in style, self, culture, and power. The Cut January 14, 2025 CUT COVERS Keke Palmer's Greatest Role Is Herself How the former child star became a multimedia mogul and stopped trying to please
A Deleted 'SATC' Scene Explains Charlotte & Trey's Divorce Twist
Tuesday, January 14, 2025
Plus, Every time Anne Hathaway freed the nipple, your daily horoscope, and more. Jan. 14, 2025 Bustle Daily Y2K trends are back, but what happened to the optimism? BOOKS Y2K Trends Are Back, But What
Why I didn't save my kitchen during the LA fire evacuation
Tuesday, January 14, 2025
Are TikTokers putting beef tallow on their faces?
New from Tim — My First Book In 7+ Years (Plus “Tactics and Strategies for a 2025 Reboot”)
Tuesday, January 14, 2025
The latest from author and investor Tim Ferriss ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Demi Moore Continues To Reinvent Herself
Tuesday, January 14, 2025
Plus: Zendaya leans into the chaos of her characters. • Jan. 14, 2025 Up Next Your complete guide to industry-shaping entertainment news, exclusive interviews with A-list celebs, and what you should