The Proforma Income Statement

Real estate investors like to evaluate the "future" performance of an investment property along with the first-year performance provided by reports such as the APOD.

This is where a Proforma Income Statement becomes useful.

A Proforma Income Statement virtually projects an investment property's income and expenses typically out ten years and gives the investor an idea of such things as future cash flow, tax benefit (or loss), and sales proceeds in the event of a future sale.

A caveat, however, should be understood with the Proforma.

Sample Proforma Income Statement
Sample Proforma Income Statement

Since it is a "projection" with speculated numbers, real estate analysts should use it cautiously. It's always best to include numbers that are more conservative then overly aggressive, and the investor should never make a buying or selling decision on the results of a Proforma alone. Moreover, given that a Proforma Income Statement is speculative, you might want to opt for a ten-year proforma rather then a fifteen or twenty-year income statement.

You can generally find a Proforma in most real estate investment software or real estate investor software solutions. But solutions might vary slightly. In fact, some solutions might even omit some features like tax shelter, sales proceeds after tax, or specific rates of return. A software solution, naturally, is your most prudent option, just be sure to examine each program carefully.

You can also create your own Proforma Income Statement. It does take some effort, but it can be done on a spreadsheet program like MS Excel.

If you choose this option, just bear in mind what you want to accomplish.

You want to analyze the cash flow and other performance measures resulting from changes to such variables as income, operating expenses, and property value over a future period. In other words, given the assumption that rents, expenses, and property value are going to increase over future years, you want to see the outcome to the property's financial performance.

To begin, you must create an income statement for the property.

In this case, include income, operating expenses, cash flow, and property value. Next, decide on the percent you want to annually increase the income, expenses, and property value and then make those calculations (i.e., inflate each value). If you are using a spreadsheet, place this calculated data in column one. Repeat the calculation (inflate each value in column one) and place it in column two, and so on, through column ten.

If you created your Proforma Income Statement correctly, it should be ready for you to evaluate the future cash flow performance of the rental property in question.

Sample (page 1)

Source: ProAPOD Real Estate Investment Software
Source: ProAPOD Real Estate Investment Software

Sample (page 2)

Source: ProAPOD Real Estate Investment Software
Source: ProAPOD Real Estate Investment Software

Sample (input form)

Source: ProAPOD Real Estate Investment Software
Source: ProAPOD Real Estate Investment Software

About the Author

James Kobzeff is a real estate professional and the owner/developer of ProAPOD - leading real estate investment software solutions since 2000. Create cash flow, rates of return, and profitability analysis on rental property at your fingertips in minutes! Learn more at www.proapod.com

ProAPOD also provides iCalculator - an online real estate calculator that enables you to learn dozens of real estate definitions and formulas as you calculate. You save 64%. Learn more at real estate calculator

More by this Author


Comments 1 comment

GoogleCashMoney profile image

GoogleCashMoney 8 years ago from Mumbai, India

Very Good Information.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working