All
Members
Companies
Blog
Forums
Podcast
Webinars
    User Log in  /  Sign up
  • Forums
    Newest Posts Trending Discussions Followed Forums Real Estate News & Current Events General Landlording & Rental Properties Buying & Selling Real Estate Deal Analysis See All
  • Education

    Read

    BiggerPockets Blog BPInsights: Expert Analysis Coronavirus Content & Resources Guides Glossary Reviews Member Blogs

    Watch

    Webinars Video Library Financial Independence Blueprint Intro to Real Estate: Rentals

    Listen

    BiggerPockets Real Estate Podcast BiggerPockets Money Podcast BiggerPockets Business Podcast Real Estate Rookie Podcast Daily Podcast (Audio Blog)

    Topics

    Business Operations Finance Finding Deals Property Management Property Types Strategy
  • Network

    Recommended Vendors

    Real Estate Agents Mortgage Lenders Companies Hard Money Lenders Contractors Investment Companies

    Search

    Members Events Jobs
  • Tools

    Calculators

    Rental Property Fix and Flip BRRRR Rehab Estimator
    Wholesaling Mortgage Payment 70% Rule Airbnb

    Services

    BPInsights: Property Insights Tenant Screening Property Management Lease Agreement Packages

    New Feature

    BPInsights (beta)

    Quickly analyze a property address or ZIP Code to compare your rent in your neighborhood.

    Analyze a property
  • Find Deals
    Real Estate Listings Find Foreclosures External Link Ads, Jobs, and Other
  • Bookstore

    Real Estate Books

    Profit Like The Pros Bidding to Buy See all books

    Featured Book

    BiggerPockets Wealth Magazine book cover
    BiggerPockets Wealth Magazine

    Written by financial journalists and data scientists, get 60+ pages of newsworthy content, expert-driven advice, and data-backed research written in a clear way to help you navigate your tough investment decisions in an ever-changing financial climate! Subscribe today and get the Oct/Nov issue delivered to your door!

    Get the Magazine
  • Pricing
Log In Sign up
User
Quick search links
Podcast Hard Money Lenders Books Washington
BlogArrowReal Estate News & CommentaryArrowStarting a Development Pro Forma – Where to Begin
Real Estate News & Commentary

Starting a Development Pro Forma – Where to Begin

Kyle Zaylor
Expertise: Business Management, Real Estate Marketing, Real Estate Investing Basics
25 Articles Written
Development

I wrote about the three essential elements of any real estate development pro forma last week (assumptions, cash flow, and financial returns).  Development pro formas can often be messy, confusing, and increasingly complex with time. So this three-piece framework is one I use to keep the chaos from getting out of hand.

Want more articles like this?

Create an account today to get BiggerPocket's best blog articles delivered to your inbox

Sign up for free

Are pro forma financial models important in real estate development? Yes, yes, and yes! Many developers would argue that they are crucial to executing profitable projects and mitigating substantial financial risk. They are a necessary tool of the trade—one which is learned and sharpened over time.

If you’re looking to jump into development, yet have never built a pro forma, how the heck do you even start?! How do you treat a pro forma like a tool and not a chore?

Admittedly, building an investment-grade development pro forma is a major undertaking. It’s something that’s built in stages, torn apart, built again, torn apart again, and built again. Yet it doesn’t have to seem so daunting because of one MAJOR point:

Every pro forma starts somewhere—usually with a blank page.

With this in mind, here are a few strategies for starting and building a development pro forma.

1) Build from Scratch

This is the most time intensive way to start a pro forma. However, it’s also an excellent method for understanding the ins and outs of a potential project in intimate detail. Since you are building and controlling every input, projection, and return, you gain detailed knowledge much quicker than using someone else’s model, template, or formula.

This strategy takes the most time (and can be very frustrating), but it can also enhance one’s knowledge quickly relative to other strategies.

If you are trying to build a development model from scratch, don’t get overwhelmed by the need to get everything in place right away. Start with what you know, get that in place, and expand from there. The point is to just get something on your screen to start—the detail and complexity will build over time.

Here are a few ways to get started from scratch:

  • Get what you already know down in the “assumptions” tab. This could include site size and constraints, land acquisition costs, zoning, previous tax payments, etc.
  • Estimate a rough development and construction schedule. This will simply be a reasonable estimate for the time needed to start, build, and complete the project. As you get more information about timing, this will get updated and refined.
  • Create a preliminary building scope. Will your ideal project be a duplex rental property, garden-style 50-unit apartment community, 200-unit apartment community, single-family home subdivision, etc?   Or does it make more sense as a 20,000 square foot retail strip center or a four-story medical office building? The scope doesn’t have to be detailed and exact at the start. But, based on the site’s context and existing land uses, a rough scope of work for the scale and building type should get things in motion.

Once the known project details and rough assumptions are in place, the next step is to jump back in and refine what you know while creating new assumptions and projections for unknown project details. This process repeats itself over and over as the project gets more physically and financially feasible.

2) Re-Use an Existing Pro Forma

Pro forma templates are typically built by another person or company and customized by you as you analyze a project. They are useful when you want to analyze a project, but want guidance on what inputs and projections to focus on. They can save time and money because the structure and framework is laid out before you even begin. In an ideal situation, you’d simply have to input project-specific variables and the model takes care of the rest.

There are a few drawbacks to using an existing template instead of building from scratch. First, someone else has created the model, so you lose much of the skill-building work that goes into creating a model from scratch. Second, you don’t have a completely customizable tool to use for your analysis. Every project is different, which often requires a unique pro forma.

This strategy can backfire when you have to spend more time fixing and patching the template than it would take to build one from scratch.

3) Hybrid

Pro forma templates usually have the most value when they teach you how to build your own model. To do this, use the pro forma template as a reference, but build one of your own from scratch.

They best way to implement this strategy is to find a quality, well-built pro forma, and leave it minimized in the background. When you hit a road block and need guidance, open the template to understand how and why certain inputs or formulas were used. Over time you start to recognize patterns, methods, tricks, and styles that you can then graft into your own model building tool kit.

The most important thing to understand with financial models is that they aren’t built over night. It can be intimidating to want to develop a project, but not know how to properly underwrite it. Since development is a high-risk venture, pro formas are essential to getting the process started and mitigating risk.  So if you’re stuck on getting your pro forma off the ground (no pun intended), give one of the strategies above a try and jump in!

Photo: @alviseni

By Kyle Zaylor
Kyle is the creator of realestate-java.com, a blog dedicated to commercial real estate development. Kyle is also a real estate development associate with Blu Homes, Inc. His company focuses on building sustainable homes throughout the country.
Read more
13 Replies
    Glenn Espinosa
    Replied almost 8 years ago
    Kyle, Thanks a lot for doing this three part blog. This is perfect timing for me as I’m starting to delve more into commercial properties, developments, etc. Your blog has been a staple for me in my education. Let’s chat soon and please keep it coming!! -Glenn
    Kyle Zaylor
    Replied almost 8 years ago
    Glad to hear, Glenn–happy to talk shop any time!

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Nathan Stevenson
    Replied over 7 years ago
    Kyle, This is a great article. I have substantial experience in finance but not specifically in real estate. I’m familiar with real estate concepts though. I’m looking to take a well-built proforma designed for real estate and adapt it for a commercial office development, single family housing, vacant lot development and other uses. Could you recommend a good proforma that I could start with? I’d be prepared to share other excel models I have developed myself in return. One of them is a project budgeting template that is now used by the Johannesburg Stock Exchange to approve all 100+ projects they evaluate annually. Best Regards, Nathan Stevenson
    Kyle Zaylor
    Replied over 7 years ago
    Thanks Nathan. I’d be happy to follow up and point you in the right direction. Send me a PM on BiggerPockets and let’s connect offline.

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    jeffrey gordon
    Replied almost 7 years ago
    thanks for the article. I have been trying out Rehab Valuator recently and am have been so thankful I could use it rather than dump hundreds of more hours into my excel model I have been building over the last 4 years. Thanks Danill! jeffrey

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Karen Margrave
    Replied almost 7 years ago
    Kyle, another great blog! I had no idea you were with Blu Homes. I have put links to Blu Homes on several threads on manufactured housing, etc. I love your product. I think in high end areas such as Orange County, etc. it can be a great benefit, especially on in fill lots with neighbors that hate construction traffic. What is it that you do with Blu Homes? You can message me, didn’t mean to steal the post! Sorry.

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Kyle Zaylor
    Replied almost 7 years ago
    Thanks Karen! Thanks too for the plugs to Blu on the forum! I’ll connect via PM. Cheers, Kyle Reply Report comment

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Kyle Zaylor
    Replied almost 7 years ago
    Thanks Karen! Thanks too for the plugs to Blu on the forum! I’ll connect via PM. Cheers, Kyle Reply Report comment

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Kyle Zaylor
    Replied almost 7 years ago
    Thanks Karen! Thanks too for the plugs to Blu on the forum! I’ll connect via PM. Cheers, Kyle

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Kyle Zaylor
    Replied almost 7 years ago
    Thanks Karen! Thanks too for the plugs to Blu on the forum! I’ll connect via PM. Cheers, Kyle

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Pete
    Replied almost 7 years ago
    Great motivational post. I always use existing sheet but make more sense to create my own to get better idea. Specially when I am just getting into RE investment.

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Pete
    Replied almost 7 years ago
    Great motivational post. I always use existing sheet but make more sense to create my own to get better idea. Specially when I am just getting into RE investment.

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
    Boris Godin Investor from Brooklyn, New York
    Replied about 5 years ago
    Please post any RE models you have created as a benchmark. I will upload mine shortly

    Report Abuse

    Why are you reporting this?

    Additional Comments (optional)

    Cancel
Rotate Log in or sign up to comment

Related Blog Posts

Real Estate News & Commentary Jan 20, 2021

Consider Your Neighborhood Grocer When Buying a Home—Here’s Why

By BiggerPockets

A recent study explored how grocery stores seem to affect local housing markets in terms of home appreciation, seller profits, equity, and more.

Read more →

Real Estate News & Commentary Jan 17, 2021

Floods, Wildfires Hinder Appreciation of Real Estate in Several Areas—and It’s Getting Worse

By BiggerPockets

In recent years, homes in high-risk flood and wildfire zones have had slower price appreciation than homes in similar areas with less risk.

Read more →

Real Estate News & Commentary Jan 14, 2021

Breaking News: Real Estate Fund Manager Charged With Misappropriating Funds, Misleading Investors

By Adam Gower

The Securities and Exchange Commission announced Tuesday that real estate fund manager Eric C. Malley of MG Capital has been charged with defrauding investors and misappropriating funds.

Read more →

Real Estate News & Commentary Jan 13, 2021

14 Markets Where Home Flippers Are Doubling Their Money

By BiggerPockets

Fix and flip profits shot up in late 2020 amid low inventory, heavy buyer competition, and record-low interest rates, recent data revealed.

Read more →
Log in Sign up

Log in

Forgot password?

If you signed up for BiggerPockets via Facebook, you can log in with just one click!

Log in with Facebook

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Let's get started

We just need a few details to get you set up and ready to go!

Use your real name

Use at least 8 characters. Using a phrase of random words (like: paper Dog team blue) is secure and easy to remember.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Why create an account?

Receive a free digital download of The Ultimate Beginner's Guide to Real Estate Investing.

Connect with 1,000,000+ real estate investors!

Find local real estate meetups and events in your area.

Start analyzing real estate properties, we do the math for you.

It's free!

Explore

  • Membership
  • Community
  • Education
  • Marketplace
  • Tools
  • FilePlace
  • REI Resources
  • Perks
  • Glossary
  • Reviews
  • iOS App
  • Android App

Company

  • About Us
  • Press
  • Advertising
  • Careers
  • Stats
  • Contact Us

Important

  • Editorial Guidelines
  • Terms of Use
  • Rules
  • Privacy
  • FAQ

Social

  • Facebook
  • Twitter
  • YouTube
  • Instagram
© 2004-2021 BiggerPockets, LLC. All Rights Reserved.