You will find several opinions regarding a proforma financial report for an investment property. Some descriptions used may be “working magic,” “pie in the sky” and “using a bit of pixie dust,” to coin a few terms.
With accurate research, a proforma statement can be a valuable tool an investor can use in determining the viability of an investment.
What is proforma?
Proforma is a method applied to a financial analysis that can draw focus to a specific figure of current or future projections. A “method” is a loosely used term, as some would consider this manipulation.
You will find a proforma analysis widely used when analyzing investment real estate. There are several types of metrics used over a five- or 10-year period. For example, internal rate of return (IRR), net present value, and many more.
One could consider the five- or 10-year projection of an investment property’s income and expenses to be a proforma analysis.
a proforma be used?
Speaking from experience, I use a proforma analysis to fill in the “holes” of an underperforming investment. The property may not be doing as well as expected for several reasons.
We commonly call these types of investments “opportunistic,” meaning the property may need rehabilitation and a new tenant or have high vacancies and high expenses.
The proforma report shows what the financial picture could be in the future with certain improvements, new tenants secured, and costs brought under control.
I am representing a mixed-use property in Vallejo for sale at $800,000. It contains two small retail storefronts, three apartments and a 3,800-square-feet warehouse.
Our example has only two studio apartments rented, and the storefront units need approximately $100,000 in improvements.
The income an investment property creates is used to determine its value; however, there is value in the land and improvements.
The best way to value the investment is with a proforma evaluation. Using a conservative and comparable market rent for all the vacancies, as well as an assumption of expenses at market value, can be derived.
Next, the cost to improve and repair the property to bring it up to standards is factored in to come to a market price.
Several other metrics can be used to confirm the price against other similar investments such as the capitalization (CAP) rate, price per square foot, internal rate of return (IRR) and different ratios.
After analyzing the data, the investment came back with a gross operating income of $78,785 and operating expenses of $26,597 a year.
The difference represents the net operation income and equates to a CAP rate of 6.5 percent and an IRR of 11.7 percent.
The good part is that I underestimated the rent income and over-estimated the expenses, so actual returns could be better.
There may be some instances where a proforma financial analysis you find is only magical pixie dust, but the well-informed investor that has a relationship with an experienced commercial broker can see right through the magic.