When utilizing your real estate investment model, be it an Excel template or an out of the box software application, there are several points you should consider. These could be considered recommendations for estimating income in any home or multiple space property purchase.
At the start, you must have a clear and detailed plan for the property purchase, funding, rehab, leasing plan, sales, property taxes, legal and other income and costs. This means an examination of the property must have already been completed. You should know with a bit of precision what funding interest rate and terms you are likely to get from your lenders. You absolutely must know the expected taxes and insurance rates. Finally, if the property was used for rental recently try to obtain as much leasing background as possible, including data by unit, tenants, month, year, and percentage on time vs. past due payments. This provides a complete view of the investment from a money standpoint and prepares you to input solid data into your real estate investment model.
Next, you need to enter as much data possible into the spreadsheet. Every different real estate investment model requires varying data or formats. Usually it is monthly or quarterly data. After this is completed you will be able to identify gaps in your data, which you can fill in based on your preliminary presumptions or past experience, or return and get more historical data.
Then you should get a baseline scenario. This is often the property “as is” without any alterations to the renters, building condition, taxes, insurance coverage, rent rates, financing, and so forth. This provides you with a take on what sort of cash flows the property generates now, which you will be able to forecast into the future. At this point, you may take a preliminary go or no go choice on the investment.
Finally, if you have chosen to proceed ahead you can start modeling various scenarios in your real estate investment model. Let’s say I repaint and landscape? Let’s say I evict the current tenants and replace them with new higher paying tenants at higher rents? What if we get a town improvement grant? What are my financing rates and how does the break even level vary as rates vary? What if I get a 2nd loan? How large does the down payment need to be? Suppose we advertise? How much does that cost, how fast will it bring new tenants, at what rental rates, and how can this alter the cash results.
There are many more details consider, nevertheless the above process is a high level best practices for utilizing your real estate investment model.
To find out more about the real estate investment model process and see a complete screenshot walk-through go to http://www.financial-edu.com/residential-real-estate-excel-model.php
|
|