Daily insights for city builders, delivered every morning at 6 AM ET. I’m Brandon Donnelly — a Toronto-based real estate developer and founder of Globizen. I’ve been writing here since 2013.

How to think about a development pro forma

One common mistake that people make when it comes to development pro forma is assuming that feasibility is easily attainable. It’s not. In fact, it’s best to think of a pro forma as a fragile object that is liable to break if not handled properly. So to that end, here’s a non-exhaustive list of things you may want to keep in mind when trying to both forecast and create the future as a developer:

  • As a starting point, you’re safer assuming that your pro forma isn’t going to work. If the numbers look too good to be true or even just really promising — especially at the outset — then there’s a good chance they’re wrong. You’ve likely missed things. Be weary if it feels too easy, especially in our current market, where very little works.
  • Cheap land isn’t enough. Just because your land cost feels cheap, it doesn’t mean that your development project will end up being feasible. There are instances and entire markets where even free land isn’t enough. You might actually need a negative land value. Meaning, a subsidy is required to reach feasibility. This is the case with affordable housing.
  • Drill down into as many line items as possible. Back-of-the-envelope math — where you just plug in a few cost per square foot assumptions — is fine for an initial screening. But if you’re really serious, you need to get deep into the weeds. Run through the entire process in your mind and think about what might happen, and go wrong. Even with this, you will still miss things.
  • Stress test your assumptions. What happens if the city asks you to do X? What happens if the local councillor comes at you with Y? Can your fragile object support them, or will it shatter to pieces? The sensitivity of your fragile object to various stimuli will help you decide whether you want to do the project or whether there’s simply too much risk.
  • Ultimately, real estate development is a creative act. You’ll need to come up with creative solutions, and then you’ll need to will your project to life. This is one way to tell that you’re on the right path. It needs to feel really hard. So if your pro forma also feels this way, then there’s a higher probability that you’re narrowing in on something close to reality.

One response to “How to think about a development pro forma”

  1. scottonthespot Avatar

    When I was doing the initial one page cost of construction spreadsheet, I didn’t even try to factor in the cost of the foundation. Two structural engineers from the major Building & Engineering firm that saw what we wanted to do said we’d have to go 175′-200′ into the shoreline ground just to support the building on its twin sites (it was to be an arched over-the-East River building). Everything else on the spreadsheet checked out, roughly, and was even conservative, according to several experienced developers and contractors I showed it to, before hiring a newly minted real estate student to help develop a full pro forma. I didn’t even try to model tax savings since I knew our local tax subsidy was going to change substantially – it expired without being replaced for years.

    But the foundation, with its geothermal pipes for heating/cooling spread over 19.5 acres, connecting to an existing subway tunnel for a new station 200′ away, parking garages, support beams, etc., was just too unique to estimate at that time. We would have gotten subsidies from the city Office of Remediation for what they determined were twin brownfields, but would it have been enough or would it eat into the projected 30% profit on the $21.6b cost?

    We’ll never know because we couldn’t get the land in the end, but that brings up another cost – the cost of doing work that will never be used. Search for The RiverArch on Youtube if you’re interested in what might have been the world’s largest multi-use building, in downtown New York City.

Leave a Reply

Your email address will not be published. Required fields are marked *