{"id":54331,"date":"2014-02-19T13:30:25","date_gmt":"2014-02-19T20:30:25","guid":{"rendered":"https:\/\/www.biggerpockets.com\/renewsblog\/?p=54331"},"modified":"2021-03-16T10:16:17","modified_gmt":"2021-03-16T16:16:17","slug":"2014-02-19-building-pro-forma-skills","status":"publish","type":"post","link":"https:\/\/www.biggerpockets.com\/blog\/2014-02-19-building-pro-forma-skills","title":{"rendered":"Building a Pro Forma: an Essential Skill for Real Estate Investors"},"content":{"rendered":"<p>Pro formas are the business plans of the real estate development world.<\/p>\n<p>They give you a snap shot into the future given the data available and your sense of the current and future market.<\/p>\n<p>When evaluating a potential development opportunity, you can&#8217;t get anywhere without making a sound case for your development to potential lenders, partners, and internally.<\/p>\n<p>That sound case starts with and gets honed through building and understanding your pro forma.<\/p>\n<p>Like any skill set, becoming proficient at modeling a pro forma takes time, trial and error, and patience (and plenty of frustration too). The larger a deal gets, typically the more detailed the pro forma gets. However, many times the mechanics and foundation of your pro forma will stay the same regardless of the deal size (i.e. money goes into a project, that money creates\/improves something, money comes out).<\/p>\n<p>Building and using a pro forma is certainly a skill set that&#8217;s important in the real estate game. \u00a0Like any skill set, baby steps can grow into walking, walking can turn into running, running can turn into sprinting. \u00a0At the same time, skill sets can be softened, forgotten, or even lost.\u00a0So starting, maintaining, and\/or improving one&#8217;s modeling skill set is always encouraged in my book.<\/p>\n<p>There are many strategies and techniques one can adopt to quickly improve and\/or learn. \u00a0Here are a few I think are the most effective:<\/p>\n<h2><b>Build from Scratch on a Real Deal<\/b><\/h2>\n<p>I&#8217;m a huge fan of not reinventing any wheel you can. \u00a0Yet building a pro forma from scratch can be a valuable undertaking that could pay dividends in the future.<\/p>\n<p>Motivation tends to be lower for fictitious projects. So pick out a project that could turn into a real deal. Maybe it&#8217;s a vacant lot down the street that you&#8217;ve always wanted to develop. Maybe there&#8217;s an underperforming multifamily property close by that could use a facelift.<\/p>\n<p>Regardless of the property or deal, <strong>the point is to sit down and start<\/strong>.<\/p>\n<p>It is scary to sit down with a blank spreadsheet and have to plan out how to <a title=\"Starting a Development Pro Forma \u2013 Where to Begin\" href=\"\/renewsblog\/2013\/04\/06\/starting-a-development-pro-forma-where-to-begin\/\" target=\"_blank\">build a fully functioning pro forma<\/a>. \u00a0Like any epic saga one is about to embark on, a sense of nervousness always surrounds this stage because of the anticipation of changes, adjustments, and dead-ends likely to occur. \u00a0Yet for the time invested, I believe it&#8217;s worth it to try.<\/p>\n<h2><b>Bedtime Reading<\/b><\/h2>\n<p>There are plenty of <a title=\"The Top 12 Business and Real Estate Books as Recommended By BiggerPockets Podcast Guests\" href=\"\/renewsblog\/2013\/10\/14\/real-estate-books\/\" target=\"_blank\">great books<\/a> out there on structuring real estate deals. While not always as enthralling as a great novel, a little bedtime reading on the subject could go a long way to forming your approach to pro forma building.<\/p>\n<p>A close friend recently reintroduced me to audio books for daily commutes. I&#8217;ve been amazed at how much I can get through during a short car ride (repeated daily). \u00a0The same can be true for breaking off a large, dense book on structuring real estate deals.<\/p>\n<h2><b>Mirror an Existing Pro Forma<\/b><\/h2>\n<p>If you have access to a spare laptop or PC, this can be a useful technique for learning how to model a specific deal. \u00a0Try lining up an example pro forma you admire and build it over again in a new spreadsheet. \u00a0Keep the screens side by side so you can quickly review the formulas and inputs from the existing pro forma. \u00a0Then input them line by line into the fresh spreadsheet.<\/p>\n<p>It&#8217;s a slow process. However the work put in to picking up the structure and specific modeling techniques will likely stay with you as you take on new deals.<\/p>\n<p>There&#8217;s no silver bullet for picking up new pro forma skills. Patience and time are your best bets for growing or maintaining them. While the above strategies can be tedious, cumbersome, and time-intensive, I&#8217;m sure they&#8217;ll be worth the investment.<span style=\"font-size: 10px;\"><br \/>\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pro formas are the business plans of the real estate development world. They give you a snap shot into the future given the data available and your sense of the [&hellip;]<\/p>\n","protected":false},"author":803,"featured_media":54405,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5529],"tags":[],"class_list":["post-54331","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-real-estate-marketing"],"acf":[],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/posts\/54331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/users\/803"}],"replies":[{"embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/comments?post=54331"}],"version-history":[{"count":0,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/posts\/54331\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/media\/54405"}],"wp:attachment":[{"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/media?parent=54331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/categories?post=54331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biggerpockets.com\/blog\/wp-json\/wp\/v2\/tags?post=54331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}