Ophelie Axelle June 7, 2021 Spreadsheet
Most planners are good at multi-tasking and have no problems designing a simple spreadsheet to handle a basic budget or designing a form to handle registration. So, you spend your time designing and stressing out. You end up with a variety of forms that each handle a specific need like registration, exhibits, food expenses and budget. The forms are not connected and do not work together. Hence, you end up having to do additional work merging the information from the various forms into your budget. Why do this when there is a Budget Spreadsheet for Meetings on the market that will tie your history, individual forms and budget together? It is so easy that all you have to do is enter the information. The spreadsheet does the rest.
So why does data that inevitably finds its way into a Microsoft Excel spreadsheet often suffer from the problems outlined above. The reasons are many. If the data is imported, it may have been sourced from a combination of other spreadsheets, databases, systems, reports, word documents, emails or web pages. If the data has been entered manually it may have been poorly done so by an inexperienced computer users such as administrative or junior staff with a lack of understanding for data structures. Excel is easy to use and widely accessible, so an inexperienced colleague can quite easily update your spreadsheet with a false sense of confidence and inadvertently enter new data incorrectly. And finally, unlike a fully functional software system, data entry in Excel generally has no automatic validating rules, unless carefully setup by the spreadsheet‘s creator.
You have now created a dynamic link between your Excel spreadsheet and the Word document. That is to say, any changes which you make to the spreadsheet will be reflected within your Word document. Simply right-click the embedded object in Word after editing the spreadsheet and choose ‘update link‘ to see the changes. You will also be given the option to update each time you open the Word invoice.
This will show your Angel Investor that you indeed are a rational thinker and concerned about the money as well as the truth. If the Angel Investor cannot trust you your chances of being funded are nil. An angel investor is betting on the jockey not only the horse. As an entrepreneur you must be honest with yourself as well as your financial partner. They want to make sure you believe in what you are doing and that you also have risked your own capital, time and energies into the new business. Angel investors want you to succeed and often they also like to give their input and if you end up taking their money for your startup, the need to realize that their input needs to be taken seriously.
When presenting your business plan to an angel investor you must understand that they will be very interested in your spreadsheets and proformas, but you must also realize that it is typically an entrepreneurial optimistic approach, which causes problems with proformas. Therefore, you should have dueling spreadsheets; that is to say the spreadsheets, which take your best guess and double the time, double the expenses to compete with your optimistic approach. You should be able to present both of these to your Angel Investor; who chances are is a retired business person with a little bit of financial savvy.
Here‘s a very simple budget set up. Keep a simple income spreadsheet. List all the sources by name in column A. List how much each brings in in column B. And then, any notes you have for the income (like if it is temporary) in column C. You don‘t need to get very detailed with the income, because it only needs to be accounted for so that we can budget for it‘s use. And, the incomes use is in our expenses spreadsheet. This spreadsheet will be much more complex than the income one. You‘ll need a field for income that you carry over from the income sheet. You‘ll also need a field for a total expenses budgeted for. A third field will give us the budget surplus. We get that by subtracting the budgeted amounts from the income amount. A final field will subtract the actual amount spent from the income, and will serve to tell us where we stand in our budget. If you like, you can add another field that subtracts the actual amount spent from the amount budgeted.
Tag Cloudblank spreadsheet template