Download and customize this and hundreds of business spreadsheet templates for free
A spreadsheet can be used to analyze a property deal by running a property analysis based on the numbers given in the Offering Memorandum. This includes the current property income plus expenses and the proforma income plus expenses. It can also be used to analyze the deal using historical operating data such as Property Rent Roll and Annual YTD Profit and Loss Statement. Furthermore, a spreadsheet can be used to analyze the property from a proforma perspective by adding 12 months' worth of categories for projected income, expenses, capital expenditures and debt services.
Asked on the following spreadsheet:
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...
Voila! You can now download this spreadsheet
DownloadQuestion 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.
Questions and answers