How to Create Revenue Projections to Determine Rental Property Profitability

When a real estate investor or analyst wants toshows cash flow after taxes, sale proceeds, cap
determine whether a rental property is profitablerate, return on equity and so on, you will need to
and might offer a good investment opportunity orinclude tax information such as depreciation,
should be dismissed, they commonly evaluate themortgage interest, amortized loan points and the
property's projected future revenues.investor's marginal tax rate, a projected selling
The idea is to estimate the cash flows and ratesprice for each of the years, and a round of
of return a rental property may produce foradditional computations for the rates of return.
future years by projecting its income, operatingStart with year one and then add each of the
expenses, and loan payment out for maybe tenfigures to the following years. You can inflate a
years based upon some assumptions.sales price in exactly the same manner you did
The concept is straightforward. Increase thefor income and expenses or select another way
income and operating expenses annually by someto project a sales price such as with a cap rate,
estimated percentage rate to arrive at a netgross rent multiplier, or set dollar amount. The
operating income (income less expenses), thendepreciation rate depends on whether the rental
deduct the mortgage balance owed for thatproperty is residential (a home rental or
particular year to compute the property's cashapartments), or non-residential (commercial use).
flow and subsequent rates of return. TheThe loan will also have to be amortized so you
proforma income statement (or proforma) iscan determine the amount of interest paid during
generally the report used to project theseeach year.
revenues, and in this article, we'll discuss someYou can find information regarding the
simple basics to give you the idea. Please feel freedepreciation schedules online if you're planning to
to visit my website if you would like to see aconstruct your own proforma, otherwise a good
sample proforma.real estate investment software solution will have
How to Create a Proforma You can choose oneit built in to the program and you will just have to
of two methods. You can use a spreadsheet orfill in the forms.
you can invest in a real estate investmentWhether you choose to use real estate
software solution that provides the forms and willinvestment software or a spreadsheet, here's
create a proforma income statement for you.what you want to keep in mind about your
In any case, the important thing is to start thestatement.
proforma with numbers that accurately reflect1) You are essentially looking to analyze the cash
the property's current financial position, i.e.,flow and other performance measures resulting
income, operating expenses, and loan payment.from changes to such variables as income,
This will represent year one.operating expenses, and property value over
Next, make an estimate as to how much yousome number of future years.
think income and expenses will increase annually2) Because it consists of projected estimates,
(use separate percentage rates for each if youdon't rely solely upon a proforma income
wish) and multiply your starting numbers by thesestatement to make your investment decision.
rates to calculate for year two, year two's3) Also, because it is speculative, you might not
numbers again for year three, and so on out aswant to construct your proforma out further
many years as you deem necessary (ten yearsthen ten years.
is typical). Be sure to include the loan repayment4) Always use income and operating expenses
for each of those years.that are realistic to begin with and then use a
Finally, for each year, subtract the operatingreasonable percentage rate to inflate them
expenses from the income to determine theannually. The same would be true with the
rental property's net operating income thenprojected selling price of the property.
subtract the loan payment to arrive at the cashTo get a better idea about creating revenue
flow (or more specifically, cash flow beforeprojections for rental properties, you can see a
taxes).completed sample proforma on my website.
For a more elaborate income statement thatHere's to your real estate investing success.