Evony Cataleya June 10, 2021 Spreadsheet
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.
Lester‘s temporary office at the Factory was glassed on all sides, and surrounded by the sights, sounds, searing temperatures, and smells of the smelting and pouring areas. Originally, the cubbyhole had been used for storing coal and coke until the plant converted to gas-fired furnaces in the mid-‘50s. Over the next three decades a succession of plant superintendents used the room to boink their secretaries, which necessitated its windows being painted a squalid olive drab. During 10 years of performing this chore every six months, Lester had scraped two panes clear, so now he could gaze into the murky, smoky, smelly pit outside as he waited for the grinding computer and clackety printer to spit out a stream of spreadsheets.
Microsoft Excel is a phenomenally powerful calculator. You can create spreadsheets with 10,000 lines of data and calculate subtotals instantly. Indeed, if you change your data, any totals will get automatically updated. Arguably that‘s not too impressive. If we have quarterly revenues of $1m, and we secure another $20k, we can update our subtotal without summing revenues from scratch. So it‘s more impressive that Excel can do the same thing with statistical functions. If you‘ve ever plotted a chart on Excel, you may be aware that you can add a best fit line. These best fit lines are calculated using a method known as regression. Basically, you have to calculate the distance of every single point from the line, and minimise the sum. The maths is a little more sophisticated but the key point is that, every time you change the data, you need to perform the analysis all over again.
Second – Planning your Budget – is this easy or are you going to start over from scratch? If you kept good records and have accurate figures, then you have a great start for you next meeting. It is easy to modify last year‘s information and make changes for this year. That will be necessary for a variety of reasons. You will need it to tell your hotel contact what you want and you will also need it to prepare this year‘s budget. Third – Budgeting Spreadsheet for Meetings – take the easy way out. Use a spreadsheet that will make your job easy. There are excel spreadsheets that can do it for you. Do not waste your time trying to design something that already exists and is proven to save you effort and stress.
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.
First – History/Budget – what kind of a history do you have from your last convention? Did you fill out forms that showed all the results of your meeting? You started with a contract that specified sleeping rooms and scheduled functions, but did you update those numbers at the conclusion of your convention? This is important! You really do need to know what happened last year including your exact sleeping room pick-up, registration numbers with total income generated, specific meeting expenses and the number of attendees that attended each function. Without these numbers you are just guessing.