Summary
Written by a model from the transcript; not yet reviewed.
This weekend edition of the podcast features a recording of a talk by guest Victor Manash at a land development mastermind hosted by Brandon Cobb. Manash outlines ten common land development pitfalls, including moving goalposts, capacity allocations for utilities, community opposition, navigating local politics, legal team quality, and flawed underwriting models. Using concrete examples like a warehouse project requiring an expensive water main extension or a Canadian development blocked by a dysfunctional city council, the discussion explains how seemingly minor assumptions can derail a project. The conversation also covers market cycles where land demand is binary, and demonstrates advanced Excel modeling techniques with conditional formatting and goal-seeking macros.
- Check water and fire hydrant capacity requirements directly with the current fire marshal rather than relying on existing infrastructure. 8:17
- Inspect underwriting models for hardcoded values and math errors by applying conditional formatting to isolate manual entries. 18:24
- Model the entire project lifecycle across multiple financing stages rather than relying on a single generic loan model. 14:45
- Understand that land demand is binary and can vanish completely when development timelines get pushed out. 4:39
Chapters
- 0:02Podcast Intro and Host Greeting
Victor Manash welcomes listeners and explains the episode’s format as a live talk on land development pitfalls.
- 1:41Market Cycles and Land Demand Dynamics
Victor explains how land demand swings dramatically with market changes, using residential and commercial examples.
- 6:14Understanding Capacity and Utility Allocation
Victor illustrates how assumptions about utilities can lead to costly surprises, such as unexpected water main extensions.
- 12:01Community Opposition and Political Risk
Victor shares real-world cases where community pushback and political maneuvers derailed development plans.
- 13:02Legal and Permitting Complexities
Victor discusses the challenges of navigating building code changes, amendments, and the importance of a strong legal team.
- 14:16Underwriting Fundamentals and Model Critique
Victor critiques common underwriting tools, emphasizing the need to model full project lifecycles and avoid hardcoded errors.
- 15:52AI‑Assisted Underwriting and Spreadsheet Techniques
Victor demonstrates how selective AI and Excel features like conditional formatting and goal‑seek improve model accuracy and speed.
- 21:03Sensitivity Analysis and Scenario Planning
Victor explains how to build efficient sensitivity matrices to evaluate key variables without generating endless spreadsheet versions.
- 22:18Wrap‑Up and Closing Remarks
Victor concludes the session, thanks listeners, and signs off with a weekend well‑wish.
Highlights
- 4:39
Why Land Markets Are Binaryinsight
The speaker explains that land demand is binary, going from in demand to out of demand completely when project timelines shift.
- 6:30
Unforeseen Fire Safety Costsstory
An existing warehouse project hit a roadblock when the fire marshal demanded a new 1700-foot water main extension for a hydrant.
- 9:00
Special Election Overturns Annexationstory
A massive 1783-acre master plan community in Colorado Springs was forced back into the county after competitors funded a special election.
- 9:47
Political Opposition Blocks Projectstory
A 26-acre historic property development in Ottawa was stalled because a city councillor wanted to acquire the land for a dollar.
- 17:25
Conditional Formatting For Underwritingstrategy
The speaker uses conditional formatting in Excel to instantly flag hardcoded numbers in spreadsheet formulas and catch bugs.
- 19:33
Goal Seek For Circular Referencesstrategy
A macro using goal seek automatically iterates through circular financing and equity calculations until the balance error reaches zero.
- 21:10
Automated Sensitivity Analysis Matrixstrategy
A custom two-by-two matrix module runs automated sensitivity calculations over 10 to 15 minutes to evaluate key financial variables.
Quotes
“These numbers are not scientific, but market cycles occur. We know that.”
Unnamed speaker · 4:16 “I can be on the phone. I can be driving and I'm talking with my lead underwriter.”
Unnamed speaker · 20:47 “You can tell all the areas that you can adjust versus the ones, don't do that because that's part of the formula.”
Unnamed speaker · 18:09
About this episode
On today's show I'm sharing a segment of the Land Development Mastermind hosted by Brandon Cobb. We're touching on a subset of the top 10 land development pitfalls. ----------- **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/](http://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) http://www.facebook.com/realestateespresso%5D(http://www.facebook.com/realestateespresso) Email: [[email protected] mailto:[email protected]](mailto:[email protected] mailto:[email protected]) **Y Street Capital:** Website: [www.ystreetcapital.com http://www.ystreetcapital.com/](http://www.ystreetcapital.com http://www.ystreetcapital.com/) Facebook: [www.facebook.com/YStreetCapital](https://www.facebook.com/YStreetCapital) http://www.facebook.com/YStreetCapital%5D(https://www.facebook.com/YStreetCapital) Instagram: [@ystreetcapital](http://www.instagram.com/ystreetcapital)
Transcript
4,161 words · 2 speakers
Topics
- Conditional formatting
- Excel
- Lennar
- D R Horton
- Richmond
- Shreve Air Force Base
- US Space Command
- Colorado Springs
- National Capital Commission
- Ottawa
Page updated · transcript and summary are machine-generated