Nadine Nour February 17, 2021 Spreadsheet
The second component of a good real estate investment spreadsheet is a long cash flow projection period. Property investments are typically very long term ‐‐ from 10 to 20 years on average. In particular, if you are buying real property for long term portfolio holdings, it makes sense to have at least 10 years of monthly or quarterly data, and even up to 30 years. This ensures you capture the entire future cash flows, and enables a much more accurate determination of net present value, internal rate of return, and capitalization factors.
Our first step is to capture non‐quantitative data in the spreadsheet, so we reserve a worksheet for that. This is used for location and condition information such as address, zoning category, residential vs. commercial, neighborhood, occupancy in the building and surrounding area, school district, etc. This will all be useful for financing and insurance purposes, as well as keeping track of a number of properties if you have a large real estate portfolio or a property management company. You might want to put it into a standard database format in case you want to save and analyze the information later.
A software that can compare file in an organized manner can help you be a more productive employee at work. To tally and keep records of any financial data from any institution one has to make use of an application that can easily convert data entered into reports after comparing them with similar records already on file. With the use of Microsoft Excel, one can accomplish this. However, if you want to make use of your time effectively and be able to do other tasks aside from all the paper work, there is an available file comparison software that you can take advantage of to make things easier for you.
The third important consideration is the availability of different cash flow valuation methods. Depending on the purpose and vehicle used for the real estate investment, you may want to value the investment on a pro forma basis under a variety of different assumptions. You may also want to calculate or use the break even point, IRR, NPV, and cap rate factors for various purposes. Ensuring the necessary calculations and inputs are available makes it easy to use the same model for different investment opportunities, and eliminates the need to enter all the necessary data twice.
Also, how long is your investment horizon? Is it really that important to you to project out to 30 years or is 3‐5 years sufficient along with a terminal value that represents the expected NPV beyond 5 years? Usually this latter approach works best and looks the most credible to potential investors. There are numerous ways to calculate terminal value including multiples, current market values projected forward, and round guesstimates. Obviously these decisions are affected by your personal preference and the type of investment for which you‘re calculating present value.
The expenditure analysis columns do not need to be a different column for each type of expenditure. It is better to set up and group the analysis columns in general headings which can accommodate all the expenses. Such columns may include stock, other direct costs, premises costs, general administrative costs, transport and delivery costs, repairs and maintenance, travelling and hotel costs, motor costs, bank and legal costs and other expenses. It is better not to enter too many items under a general heading of other expenses as this is more likely to be investigated as the type of expense has not been precisely identified.