Use a Cash Flow Proforma to Evaluate A Rental Property's Future Cash Flow Performance

A cash flow proforma is a useful way for real estate investors to evaluate an investment property's future cash flow performance. Unlike an APOD, which merely gives a snap shot of the property's first year cash flow, proforma income statements look at revenue and expense projections typically up to ten years, enabling the investor to evaluate the investment real estate's cash flow, tax benefit (or loss), sales proceeds, and other financial projections.

The cash flow proforma income statements is generated by looking at the financial performance of the rental property the year before and then using a variable to make projections into the future.

For example, if:

    Last year's income was $30,000, 
    The operating expenses $12,000, and 
    The net operating income was $18,000 ($30,000 - 12,000),

And you would like to determine next year's net operating income in the event revenue increases 5% and operating expenses increases 4%, you would compute as follows:

Revenue (next year) less Expenses (next year) = Net Operating Income (next year)

Revenue (next year) = $30,000 + (30,000 x .05) = $31,500

Expense (next year) = $12,000 + (12,000 x .04) = $12,480

Net Operating Income (next year) = $31,500 - 12,480 = $19,020

In other words, now you know what net operating income (NOI) you can expect the property to generate in the event that next year, the property's rental income increases (inflates) 5% and its operating expenses increases (inflates) 4%.

This is the essentially the pattern for each year in the proforma, starting with the end of year one and extending out through the end of year ten (i.e., EOY1, EOY2, EOY3, and so on up through EOY10). This year's data is inflated by some variable to compute next year's data.

Moreover, its exactly the same way the computations are made each year for the other returns such as cash flow before tax (CFBT), cash flow after tax (CFAT), sale proceeds after tax (generally requires an inflation rate for property value), cap rate, return on equity, and other returns provided by your specific cash flow proforma. Returns are recalculated annually based on changes made to income, expenses, and property value.

How do I create a proforma income statement?

Software You can invest in a real estate investment software that will automatically create a cash flow proforma income state for you. Bear in mind, however, that software solutions tend to vary and whereas one might include computations for tax shelter, another might not.

Manually You can use an Excel spreadsheet to create a Proforma Income Statement. In this case, it helps to have some knowledge of Excel, and you should allow yourself several hours to create a good proforma.

Whatever method you choose, though, real estate investment software or a spreadsheet, here are a few important considerations to keep in mind about your statement.

Consider what you are seeking to accomplish with the proforma. 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 future years.

The pro forma is just an estimate (a guess). Do not rely solely upon a proforma income statement to make your investment decision.

Though a proforma can be constructed to project any number of future years, because a it's speculative, you might not want to go out further then ten years (I wouldn't).

Be sure to use realistic numbers. Start with the current income and expenses and inflate them annually by a reasonable amount. Don't inflate income 10%, for instance, when 2-3% has been normal for your market over the past several years.

As stated earlier, a proforma is a good way for a real estate investor or analysts to evaluate the future financial performance of investment real estate. Moreover, it makes a good presentation to other investors and lenders because it does peek into the future.

You can see a sample Proforma on my website at http://www.proapod.com. Follow Software Reports --> Proforma Income Statement.

About the Author

James Kobzeff developed ProAPOD Real Estate Investment Software to help you succeed with rental property analysis. Want to learn more about how to create cash flow and rates of returns in minutes? See it at => http://www.proapod.com

Article Source: http://EzineArticles.com/?expert=James_Kobzeff
http://EzineArticles.com/?How-a-Proforma-Can-Evaluate-a-Rental-Propertys-Future-Cash-Flow-Performance&id=936230

Return From Property's Cash Flow Proforma To Real Estate Investment Selection Methods Or go to Freedom Steps With Property Investing

Click here for an example of a cash flow proforma

Steps to Freedom

Tuesday, December 1, 2009