What factors should be considered when projecting income, expense

When projecting income, expenses, capital expenditures, and debt services for a property, several factors should be considered. These include the current property income and expenses, historical operating data such as Property Rent Roll and Annual YTD Profit and Loss Statement, and potential future changes such as rent increases or changes in vacancy rates. It's also important to consider the property's potential for capital expenditures, such as renovations or improvements, and the cost of any debt services associated with the property.

Question was asked on:

Build curiosity – in this stage, ask yourself these questions: Why does the property have such a high vacancy rate? Why is the owner choosing now to sell? Does the property have the potential to raise rent in the near future? Analyze the deal using the seller's numbers – in your spreadsheet, run a property analysis based on the numbers you have given in the Offering Memorandum. Most likely, you will have access to two sets of numbers: the current property income plus expenses and the proforma income plus expenses. Analyze the deal using historical operating data (a.k.a Annual Property Operating Data) – these financials include Property Rent Roll and Annual YTD Profit and Loss Statement. Analyze from a proforma perspective – in this stage, you look at the property as if you were already the owner of it. Begin by adding 12 months' worth of categories to your spreadsheet for projected income, expenses, capital expenditures and debt services.

Asked on the following spreadsheet:

Multifamily Property Analyzer

Real estate can be a great addition to an investment portfolio. But as with any investment, it has to be the right buy. This spreadsheet helps analyze...

download

Download Free Version