By . Tracking Spreadsheet. At Thursday, April 29th 2021, 20:41:45 PM.
You do not have to do it all in one shot. You just have to take action every day to move in the right direction. It does not matter how small the action may be, what does matter is that you took action at all. Momentum builds on itself and soon you will find yourself cruising towards your goals. Reward yourself for small medium and large successes The final key to creating your goals spreadsheet is to make sure you are rewarding yourself every step along the way. If you have a small goal of getting to $4001 in a month, then you better give yourself a reward the moment you make that 4001st dollar. You have to get into a habit of giving yourself rewards no matter how big or small the accomplishments. By celebrating the small goals you are preparing yourself for receiving the large goals. The rewards do not have to be huge, go buy that ice cream cone you want for getting that small goal. Treat yourself to dinner when you hit those medium goals. Treat yourself to a nice vacation when you hit the large goals. Always reward and always celebrate.
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.
Microsoft Excel and other spreadsheet programs have become indispensable business tools. Not only are spreadsheets useful for keeping track of data and making calculations, they contain a number of business intelligence features and data visualizations. However, as vital as spreadsheets have become, they are relatively complicated to understand and use. While you can connect to external sources, the more data and sources you have, the more cumbersome spreadsheets become. Plus, theres a new kid on the block: business intelligence platforms. What is a business intelligence platform? Though business intelligence isnt necessarily new, the technologies used to deliver it to business professionals are relative newcomers. The term business intelligence, or BI as its commonly called today, dates back to the late 1950s when IBMs Hans Peter Luhn first used the term to describe the ability to understand the interrelationships of data "in such a way as to guide action towards a desired goal." A BI platform is a set of integrated tools that work together to deliver information for analysis.