Musetta Lahna November 13, 2020 Spreadsheet
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.
The third important consideration is the availability of different cash flow valuation methods. Depending on the purpose and vehicle used for the real estate investment, you may want to value the investment on a pro forma basis under a variety of different assumptions. You may also want to calculate or use the break even point, IRR, NPV, and cap rate factors for various purposes. Ensuring the necessary calculations and inputs are available makes it easy to use the same model for different investment opportunities, and eliminates the need to enter all the necessary data twice.
Is your job dealing with more and more paper work all the time? If you are an office clerk or reports assistant or even if you are a manager you will have to send reports on a monthly basis and more often they will have to do with comparing old and new files as well as updating them. To compare spreadsheet reports, you will have to understand the values being given and consolidate it with any changes made for a certain period of time. If you will be dealing with several files here to compare, you may find this a very daunting task. However, knowing that there is a tool you can use to make this task easier for you is a great relief.
Producing an income and expenditure statement using single entry bookkeeping is little more than making two lists of financial transactions. Those lists being one of sales income received from sales invoices or receipts issued to customers and the other of purchase expenditure being from purchase invoices received from suppliers. To record sales income it would not normally be sufficient to simply add up the total of the invoices as such a summation does not leave an audit trail of the items which have been included. A written list of sales invoices does provide an audit trail.
On the expenditure side of the business the bookkeeping can also be a simple list of the purchase invoices and receipts showing the amount spent. The list should also produce an audit trail by showing the date of the purchase invoice, name of the supplier, purchase invoice for identification purposes and the total amount spent. Usually tax returns are the main purpose of producing small business accounts and invariably some analysis is required to show what the expenses have been spent on. That is not difficult to achieve and as with the sales accounting the owner manager can add additional standard columns to the bookkeeping spreadsheet.
Finding your way around and identifying the various elements of your spreadsheet document will help you navigate around it more easily and use it more effectively. Most elements are the same for all spreadsheet programs but they look quite complicated. But once you understand how they work and how to find your way around them, they are easy to use. To understand from the start you have to know it is a grid of cells. The columns are like the columns in a ledger. You can use them to make lists of figures and perform calculations. Each column is identified by a letter of the alphabet and each row by a number.