Joslyn Lylia March 21, 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.
First, databases are still tricky for some people to understand. While relational databases can be thought of as tables that have several indexes, this is more than many people want to deal with. Second, the collaboration tools are tough to learn and use. Look at how many people still use Lotus Notes for email and not much else. And since most of us are comfortable with email, using it as the transportation system isn‘t all that taxing. Until the day comes when three people are working on the same spreadsheet and make conflicting changes.
We want to look at costs, so we reserve a tab in the real estate spreadsheet for that. Here, you have a decision. You can either make a large list of standard rehabilitation and operating costs or a smaller list of costs specific to this property. The first option allows you to use the Excel spreadsheet for other properties which are probably not the same. The second option keeps things small and tidy and might work if this is a once‐off investment. Either way, you will want to include all of the costs in a timeline schedule by week or month. This would include the re‐roofing, paint, plumbing, electrics, landscaping, electricity if you are responsible for it, insurance, etc. The financing costs are likely to be the most complex because you need to estimate not only the interest rates of the loan or loans you get, but the principle amortization, mortgage insurance, etc. This can be complex from a calculations standpoint. How granular you get with costs is up to you.
One of the first things to consider is what kind of data you have to work with in your cash flow template Excel spreadsheet. Ideally, you‘re looking for accurate monthly data including income statement items like revenue and operating expenses and balance sheet items like equipment purchases and cash from financing activities. If you have a longer time frame you can go with quarterly periods, but annual tends to be too long. After all, how can you predict what is going to happen beyond 5 years with any accuracy unless you‘re valuing an annuity?
Most investment real estate financial modeling is done in spreadsheets. These can be built for the purpose or, better yet, purchased from a reputable software vendor or consulting firm that specializes in real estate. When building or buying a good real estate investment spreadsheet, there are several critical components you should consider.
Like I said previously, starting out a budget plan for your family will be quite challenging at first. For one, you will to start changing your shopping habits, as there will already be limitations to your allowance. Also, you will have the responsibility to take note of every single penny that you use, for your budget plan will be accurate. However, if you have the tools to help you, it won‘t be that hard. Plus, you‘ll eventually reap the benefits of budgeting in the long run. So while it‘s not yet too late, acquire your family a budget spreadsheet and kick off your budget planning.