event-budget-template

 

Besides listing the expenses, this Event Budget Template allows us to track the  event’s sources of income (attendees, merchandise sales, registration fees, sponsors, etc.). By using this worksheet you’ll be able to quickly see where you can make adjustments to reach our event budget goal.

Event Budget

for Excel

Event Budget Templete

 

Template Details:

License: TGV Club Use Only (not for distribution or resale)

Note: All numbers in these sample event budgets are completely made up.

Description

This Event Budget worksheet can be used for a variety of event types. The template includes three budget examples: a group party, a seminar, and a golf outing.

As you are filling out the template, the top section of the worksheet provides a quick reference of the event’s expenses, income and final balance.

In addition to seeing where your expenses are going there is a bullet chart for visualizing how your expenses and income compare, as well as showing your goal for estimated income.

The following steps provide an example of how you might create the budget for something like a group party:

  1. Figure out how many people are attending from each group. You can use the Income/Funding section to keep track of this (entering the number of people in each group in the “estimated quantity” column), but keep the unit cost zero for now.
  2. Use the “Expenses” section to list expenses, some of which may depend on the total number of people attending. You may want to create a formula to link to the Income/Funding section if that is convenient.
  3. If you have an initial source of funding available (such as an existing party budget), enter that in the first line of the Income/Funding section.
  4. Look at the Balance listed at the top of the worksheet and divide that number by the number of people attending to determine the cost per person.
  5. Use the Income/Funding section to list the expected fees to be collected from each group based on the cost per person that you calculated.

Related Content