Adrianne Serena January 19, 2021 Spreadsheet
Finally, when applying discount factors, where do you intend to get your discount numbers? For a company with existing debt and equity capital you can calculate WACC and use that. For a startup company you need to figure out a risk‐adjusted cost of capital that makes sense. Usually this is not just a risk‐free rate which only the largest companies in the world have access to. It‘s probably something higher.
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.
Examples of third party evidence would be sales invoices, purchases invoices and bank statements. Financial transactions where no receipt exists can still be entered in the business books although all transactions not carrying third party evidence could subsequently be disallowed for tax purposes and certainly would be if the amounts entered indicated unusual income or expenditure.
A budget spreadsheet is one of the necessary tools you should have.It is equally as important as your calculator,in order for your budget planning to be successful. We all know that starting to budget your finances is a little difficult, especially if you are very much used to spending quite recklessly in the past. So for you to be sure that your plan of finally having complete control over all your finances to be effective and successful, then you should take the necessary steps of making a spreadsheet for your budget.
Next, how much detail do you need in your cash flow template Excel spreadsheet at the individual line item level? Is cash from financing sufficient or do you need equity financing, debt financing, interest earned, etc. Also how do you intend to handle depreciation and amortization, since these are non‐cash items that are typically added back to the income statement entries when determining the cash effect.
Since this is a residential rental apartment building it makes sense to include rental income in your real estate spreadsheet. That‘s obvious. What isn‘t so obvious are things like interest on tenant deposits, subsidies, tax refunds, etc. When you‘re building the spreadsheet you need to estimate when those revenues will arrive, and that relates to the number of tenants, the rental rates you charge, how long the lease term is for each tenant, etc. You also need to assume some late payments, evictions, and vacant units. If you haven‘t invested in the area before this can be a challenge. You can gather data on that by speaking with local real estate agents, lenders, and tax agencies, or subscribe to an industry database that covers the local area.