Mattie Charlize February 12, 2021 Spreadsheet
A budget spreadsheet is just like the typical spreadsheet that we see when we use various computer programs such as Microsoft Excel. However, this specific type is particularly designed to be used for financial budgeting. Most people can make their very own spreadsheet, especially if they don‘t really need further features. All they would need is a computer program, such as the Excel, that could help them. But for most households and families that are planning to get optimum financial planning, then they should download for their spreadsheet software.
You can create an account and upload your spreadsheet in about five minutes. If your first line in the spreadsheet contains your field names, you are just about done. You can easily sort any column quickly by clicking on the arrow icons. You can quickly locate duplicate records, create a mail merge template and forms for your Web site, all with just a couple of clicks of the mouse. Custom reports are simple, and what‘s more, they can be distributed via email to your collaborators on a set schedule. Adding different collaborators with various discrete permissions is very straightforward, and in about 30 minutes you can have a project setup and working with your team.
There are other ways to import data into your database, including using Web forms or setting up a special email inbox that will post the information automatically. These tasks will take some skill and some HTML knowledge, however. Other tools require more programming skill to do what Trackvia does with a few mouse clicks, or are more cumbersome to manipulate, or don‘t have the automatic defaults that make setup as easy as Trackvia. Did I mention the cost? $10 per month per user. This includes an unlimited number of databases and up to a GB of attachment storage (meaning that you aren‘t charged for the actual records themselves that are stored). If you sign up before October 1 for an account, the company will give you several additional features free.
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.
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.
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.