• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

PropertyMetrics

  • Home
  • Blog
  • Products
    • Proforma Software
    • Publisher Software
    • Courses
  • Sign In
    • Software Login
    • Courses Login
  • Contact Us
  • Build a Proforma

Last Updated on July 17, 2015 By Robert Schmidt 11 Comments

The Real Estate Proforma

The first task in any investment real estate decision is to build a real estate proforma, which is just a word that means cash flow projection. In this post we will look at a numerical example of a real estate proforma, and then explain each individual component common to all real estate proformas.

Real Estate Proforma Example

The following is a numerical example of a real estate proforma.  This shows a ten year cash flow projection similar to what would be used on a regular basis by investors, developers, brokers, lenders, and appraisers.

real_estate_proforma

Potential Gross Income (PGI)

The top line item in the proforma consists of the cash that could be generated if the property were 100% leased. Forecasting Potential Gross Income is a function of both contractual lease terms, as well as market rents. First, for all of the contractual leases in place on the rent roll, the cash flow for each lease is calculated for each year in the holding period. This takes into account the lease terms specific to each tenant.

Second, if there is any period of time in the holding period not covered by a contractual lease, market rent is forecasted to determine cash flow that could be generated given the then prevailing market conditions. Projecting out potential rental income will often involves accounting for renewal assumptions after a lease expires. This includes forecasting market leasing commissions, tenant improvements, abatement, reimbursements, etc.

Vacancy Allowance

Because it’s not realistic to assume a property will be 100% leased forever, the vacancy allowance line item on a real estate proforma accounts for expected vacancy of the property.  Vacancy can be calculated in several different ways, including taking a simple percentage of the potential rental income, or using a total dollar amount for each year in the holding period.  Other, more advanced ways of accounting for vacancy include calculating downtime between leases, and taking into account prevailing market conditions.

Other Income

Other income items typically show up on the real estate proforma after vacancy allowance. Other income items usually aren’t a part of contractual leases, but still provide additional revenue for the property.  Examples of other income items include billboard, laundry, parking, or antenna income.

Effective Gross Income (EGI)

Subtracting the vacancy allowance from potential rental income for a property, and then adding in any other income items, results in what’s known as the Effective Rental Income.

Operating Expenses

The next major category on the real estate proforma is operating expenses. Common expense line items include property taxes, property insurance, property management fees, and utilities. Often Class A tenants will have so-called net leases, where the tenant pays all or most of the operating expenses.  Other times, landlords will negotiate reimbursements where the tenant is required to pay a portion of the operating expenses each year.

Net Operating Income (NOI)

The Net Operating Income is derived by subtracting all operating expenses from the Effective Gross Income for a property.  The NOI is perhaps the most widely used indicator of cash flow for commercial real estate. However, it is important to note that the NOI ignores irregular expenditures like leasing commissions, tenant improvement allowances, and some capital improvement expenditures.  Accounting for these items in the Before Tax Cash Flow indicator results in more accuracy.

Other Expenditures

Other expense items associated with a property that are specific to the investor, or that don’t occur on a regular basis are included here.  Examples include debt service, leasing commissions, tenant improvement allowances, reserves for replacement, and some capital expenditure items.

Before Tax Cash Flow (BTCF)

Netting out any other expenditures items from the Net Operating Income results in a Before Tax Cash Flow for the property. This gives a clear picture of free cash flow available to the owners of a property, before taxes.

Reversion Cash Flows

In addition to forecasting the operating cash flows using the above proforma line items, the reversion cash flow, or net sales proceeds, must also be taken into account on a real estate proforma.  The reversion value can be estimated in a number of different ways, including taking a terminal cap rate and applying it to that year’s NOI, or applying a percentage of growth method to appreciate the property over the holding period. After a sales price is forecasted, any outstanding debt is netted out, as well as selling costs and taxes, to arrive at a net sales proceeds figure.

Need help building a real estate proforma? Give our web-based real estate analysis software a try with a free trial!

Filed Under: Articles

Reader Interactions

Comments

  1. Chris Adkins says

    July 30, 2014 at 10:17 am

    Robert,
    Thanks for the post. I thought the chart example was very easy to understand. I now have a better understanding of real-estate performa’s and will use this example to practice some of my own.
    Cheers!
    Chris

    Reply
  2. jarrod says

    February 10, 2015 at 5:51 pm

    Excellent article and outline. Thank you for your contribution

    Reply
  3. Darrett Stevenson says

    July 17, 2015 at 3:02 am

    Thanks for the article Robert.

    On the (BTCF) section you stated – “This gives a clear picture of free cash flow available to the owners of a property, before debt service and taxes.”. But doesn’t the BTCF include debt-service?

    Reply
    • Rob says

      July 17, 2015 at 2:57 pm

      Good catch, this has been updated.

      Reply
  4. David Jones says

    November 21, 2015 at 9:39 pm

    Good article. You gave an effective definition of pro forma, stating that it just means cash flow projections. A good definition for people to “get it”, Pro forma is a Latin term that originally meant “for the sake of form”. Usage was updated somewhere along the way to “for the sake of reduction to writing”. In today’s world, it is mostly thought of just as you described it. Good job. This is just the anal part of me yakking.

    Reply
  5. Ryan says

    November 23, 2015 at 3:17 am

    So when we are doing DCF Analysis on a property, do we use the NOI as our cash flow or the BTCF as our cash flow?

    Reply
    • Robby says

      December 27, 2015 at 3:34 pm

      Depends on what perspective you want to do for the analysis. NOI would be used at the property level (used for market value). BTCF or ATCF would be used at the owner/investor level (used for investment value) since it deducts owner specific expenses (mortgage, tax, etc.).

      Reply
  6. Keith Bascom says

    May 14, 2016 at 4:06 pm

    Interesting writing . Incidentally , if your company is interested a IL Power of Attorney for Property , my family discovered a sample version here http://goo.gl/z0Cgrb

    Reply
  7. David Horesh says

    January 4, 2017 at 11:13 pm

    I understand each of the cross-references in the article and the sample sheet except for the BB&T. It’s a fairly large amount, and with BB&T being a financial institution of some size, I am thinking that this item is debt service. Can you confirm that for me please.

    Reply
    • Robert says

      January 4, 2017 at 11:23 pm

      Yes, the BB&T line item is the bank loan.

      Reply

Trackbacks

  1. the CRE proforma | myCREsearch says:
    August 23, 2013 at 4:40 pm

    […] The crux of any CRE deal is the real estate proforma.  This is just a fancy way of saying a cash flow projection for a property.  Ultimately there are a few key components to building a proforma, based on my experience most CRE folks end up building their own in Excel or using Argus as the industry standard.  We found that the company/website http://www.propertymetrics.com has done a great job breaking down the basics as well as providing some examples and templates for those who don’t have one already built or who may prefer to have a template to start with.  Check out: http://www.propertymetrics.com/blog/real-estate-proforma/ […]

    Reply

Leave a Reply Cancel reply

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

Primary Sidebar

What is PropertyMetrics?

PropertyMetrics provides web-based software for commercial real estate analysis and presentation.

Recent Posts

  • How the Development Spread Works
  • Understanding the Texas Ratio
  • Understanding the Construction Draw Schedule
  • How The Double Net Lease Works
  • How to Calculate an Interest Reserve for a Construction Loan

WHAT OTHERS ARE SAYING

"I'm a 30+ year seasoned veteran in shopping center development. PropertyMetrics is an excellent source of information with professional grade software for analysis and presentation. I highly recommend it."
- Frank C. Guess | Barnhart Guess Properties, LLC


"PropertyMetrics is very helpful in my understanding of commercial real estate. The presentation and information provided is astute and always to the point with great clarity. PropertyMetrics is truly appreciated."
-Sheriar Khorsandian, CCIM | Osceola Partners, LLC


"I am very impressed with your product. I have to also compliment your company on clearly explaining valuation concepts to me. To put this into context, I asked my professor in my investment class last week if he knew of a way to value an income property using discounted cash flow analysis. Long story short...you guys are smarter than my professor. THANKS PropertyMetrics! "
-Jonathan Torres | College Student


"I want to compliment PropertyMetrics for providing clear and concise tools for analyzing commercial real estate. As the head of a local Taxpayers Association with a considerable amount of municipal real estate, your data provides me with the information needed to show how much current lease terms cost the town in lost revenue, making my task much easier. Thank you!"
-Jerome Scott | Taxpayers Association of Jamestown


I am a professor at NYU's real estate program and I always tell my students that PropertyMetrics has the best and most easily understood explanations of real estate concepts. Great job!!!"
-J. Weinberg, Adjunct Professor | New York University


"I want you to know how much I appreciate PropertyMetrics. As a 30 year real estate attorney focusing primarily on commercial leasing and purchase and sale of commercial properties, it is extremely helpful to see the principles I have learned and used for so many years explained so clearly."
-Jon K. Ladd | Business and Real Estate Law Group


"I am commercial real estate lender for a large regional bank and I recommend PropertyMetrics to everyone."
-Andrew Levin | Commercial Lender


"Frankly, since I have been getting your emails we have one of the best educated offices in our market!"
-William C. Colucci | Associate Real Estate Broker


"PropertyMetrics is awesome. I actually just went ranting and raving about it to a few other analysts at my company and everyone has been thanking me for referring them!"
-Richard Cadena Jr. | Analyst


"PropertyMetrics is great. Invaluable."
-Peter Knobloch | President/CEO

Footer

My Account

Software Login

Courses Login

Contact Us

Do you have questions, comments, or feedback? Drop us a line and let us know. Get in touch.

Get Our Best Content First

Solutions | Blog | Resources | Contact | Terms | Privacy

Copyright © 2021 PropertyMetrics.com

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OK