By . Tracking Spreadsheet. At Wednesday, April 28th 2021, 16:30:23 PM.
Do you like to save time? Do you like to have your phone ringing with customers calling? Of course, who doesnt want these things? Just as you have to spend money in order to make money. You need to spend time to learn to save time. Spend a little time to learn how to use Excel and you will save time and have more customers. Excel can be an unpaid personal assistant. Some of the things that I use the Excel Spreadsheet for are to calculate square footages, lineal footages and total them instantly without errors. Even if the list is 25 items long, it will calculate the totals, without error in seconds. I use it for calculating square footages from the length and width of the room. I can take a list of rooms and add their dimensions, hit enter and the calculations are done for ceiling square footage, wall square footages, moldings, including baseboards, crown and chair railing. I can even make an additional factor for high time difficulty, or any other factor that can influence the job.
These tables are quite efficient because they are automated with the same tabs that reflect a gain or a loss in normal ledger accounts. If at the end of the calculation the total is shown to tilt towards more expenditure, it appears automatically in scarlet numerals whereas if the total figure leans towards gains, then it is highlighted in a dark shade. This is often the lead that gives the user the assurance to go ahead planning using the same convenient table. Budget spreadsheets also aid in tracking expenditure due to the fact that they can be compatible with a number of similar technologies. They can be used in creating lists in emails as well as for being copied by browsers on a page to be viewed on another program. They can also be used to fill in data that has been scraped from any template because of their high compatibility.
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. 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.