Pod Insights The Real Estate Espresso Podcast Quick Math Versus Detailed Math About this episode On today’s show we are talking about how to model a project. I often hear people advocating for a simple spreadsheet to perform quick calculations. There was a time when I used these simple tools to make fast decisions. There is a trade-off in any project where speed is a component of a quality outcome. However, as time has progressed, I’m less inclined to rely on quick math for anything. The reason is that when bank leverage is involved, which it often is, the analysis becomes increasingly sensitive to small changes. A small change can cause a project to flip from attractive to upside down. --------------**Real Estate Espresso Podcast:** Spotify: [The Real Estate Espresso Podcast](https://open.spotify.com/show/3GvtwRmTq4r3es8cbw8jW0?si=c75ea506a6694ef1) iTunes: [The Real Estate Espresso Podcast](https://podcasts.apple.com/ca/podcast/the-real-estate-espresso-podcast/id1340482613) Website: [www.victorjm.com](http://www.victorjm.com) LinkedIn: [Victor Menasce](http://www.linkedin.com/in/vmenasce) YouTube: [The Real Estate Espresso Podcast](http://www.youtube.com/@victorjmenasce6734) Facebook: [www.facebook.com/realestateespresso](http://www.facebook.com/realestateespresso) Email: [[email protected] ](mailto:[email protected] ) **Y Street Capital:** Website: [www.ystreetcapital.com](http://www.ystreetcapital.com) Facebook: [www.facebook.com/YStreetCapital](https://www.facebook.com/YStreetCapital) Instagram: [@ystreetcapital](http://www.instagram.com/ystreetcapital)
Transcript 0:01 Speaker 00 Welcome to the Real Estate Espresso Podcast, your morning shot of what's new in the world of real estate investing. I'm your host Victor Manash. On today's show, we're talking about how to model a project. I often hear people advocating for a simple spreadsheet to perform quick calculations. There was a point in time when I used these simpler tools as well to make fast decisions. There's a trade-off in any project where speed is absolutely a component of a quality outcome. But as time has progressed, I'm less inclined to rely on quick math for anything. The reason is that when bank leverage is involved, which it often is, the analysis becomes increasingly sensitive to small changes. And a small change can cause a project to flip from attractive to upside down in a heartbeat. So I want to be working with a financial model
0:46 Speaker 00 that takes into account all of the required elements. You can't neglect to take interest reserves or lender fees and legal fees into account simply to save yourself time in the analysis. An inaccurate model is just that. It's inaccurate and it's of no value. We have experienced with projects where the cost for some line items had been estimated. In some cases, the line items were even based on hard quotes. Either way, it didn't matter whether the estimate was wrong or the quote was wrong. If the error is large, the subcontractor will merely walk away and refuse to complete the work until a new scope is agreed to. We experienced a massive cost overrun, for example, on the site work at 100-unit apartment complex that's currently in construction. We had a geotechnical survey completed with 24 test locations across
1:30 Speaker 00 the entire site. We thought we had done a good job on the geotech. But in between those test locations, we found organic material in the soil that was not suitable for building apartment buildings. That material needed to be removed, exported from the site, and replaced with more suitable material, which was then compacted in 12-inch lifts to ensure a stable stub straight under the building. We're talking over 700 truckloads of import and export. Majority of the contingency fund for the project was consumed in just that one line item. There are certain metrics that become extremely sensitive to changes. Construction cost is one of them. Capital cost is another. We often experience changes in market conditions which can affect the capital structure.
2:10 Speaker 00 Might change their lending policy and all of a sudden the borrower is required to bring additional equity or just additional reserves to the project just to satisfy the lender requirements. If your financial model doesn't take these factors into account and merely relies on the so-called rules of thumb, then chances are you're going to be way off in your project assumptions. You can get an Excel spreadsheet to tell you anything you want. It all comes down to the accuracy of your assumptions. There's no real substitute for getting the right numbers embedded at a detail level. Now, that doesn't mean you need to have a detailed construction quote or completed permit-ready design before you can even underwrite the project. But it does mean you need to have a good data set as the starting point. Those numbers can be in some reform. You definitely need a solid market study and a strong set of rental comps.
2:55 Speaker 00 You want to have the tools that are capable of performing sensitivity analysis. One of the biggest mistakes I see underwriters make is to assume that rents will continue to increase in a uniform manner year after year. In some markets that are rent-controlled, that can happen. In those situations, there's very little new supply coming into the market and very low vacancy means landlords are able to increase rents each year up to the maximum allowed by the rent control guidelines. But in markets that experience larger changes between supply and demand, we can and do see periods of time when rent increases can fall below the consumer price index averages. And when that happens, expenses increase, but income doesn't and profit margins get squeezed.
3:37 Speaker 00 If your project can't tolerate that situation, you're at high risk of having your project upside down. That type of sensitivity analysis will show you the vulnerability in your financial model. An experienced underwriter who's accustomed to working with institutional-quality investors will zero in very quickly on those types of rookie mistakes. The best way to get really good at seeing these types of problems is by looking at projects that are currently for sale on the market in a distressed situation. There's many examples to choose from. You need to remember that each one of those deals would have been presented to investors a few years ago with a rosy picture, an investment rate of return forecast that simply didn't pan out. So where were the mistakes? Was the sponsor too optimistic? About the trajectory of interest rates.
4:22 Speaker 00 Were they too aggressive in their assumptions about rents? Or the degree of leverage that lenders would accept? Were they too optimistic on the assumptions on maintenance costs? Were they too optimistic on assumptions on insurance and property taxes? There's many ways that projects can fail. And when I look at projects that are struggling in the marketplace, they usually fail on multiple of these metrics simultaneously, not just one. I find a lot of underwriting software tends to assume a very simplistic structure. For example, if your project has multiple layers of financing, maybe starting with bridge financing, followed by a mini perm, followed by permanent financing. Most tools cannot handle that type of debt structure. And it's a perfectly legitimate debt structure. Many projects will experience it.
5:05 Speaker 00 And if your tools can't handle those real world situations, then the analysis is simply too academic and therefore, again, not useful. This was the number one reason that we developed our own underwriting software in-house. We were not looking for a software development project. It was born out of necessity. It also happens to be one of the reasons why many of our consulting clients approach us to work with us because of the depth and accuracy of our underwriting process. As you think about that, quick is great, but detailed is better. Have an awesome rest of your day. Go make some great things happen. We'll talk to you again tomorrow.
Previous Is The Ship Sinking? Next Blazing A Trail Or Fast Follower Page updated November 15, 2026 · transcript and summary are machine-generated