# The Event Planning Business Owner: companion files

Julian R. Sterling

## What is here

- EPBO_1_Bookings_and_Deposits.xlsx (Chapters 3 and 10; Bookings and Deposits workbook of Appendix A): sheets Inputs, Wedding deposits, Backlog, Retainer, then Checks. The Velloway-Brannick payments held as client deposits until the wedding ($9,500), what is still to collect on the backlog ($183,445 then $171,290 at the two year ends), and the retainer and payment schedule of each contract under both price lists.
- EPBO_2_Pricing_and_Hours.xlsx (Chapters 5, 6 and 11; Pricing and Hours workbook): sheets Inputs, Per planned hour, Per hour worked, Percentage fee, then Checks. Fee per planned hour by contract under both price lists ($105.00 for full planning in FY2026), the Velloway-Brannick wedding as planned and as worked ($95.00 then $75.40), the destination wedding, and the Quillorne fee at a percentage of the budget ($36,000).
- EPBO_3_Leads_and_Marketing.xlsx (Chapter 4; Leads and Marketing workbook): sheets Inputs, Per inquiry, Per contract, Signing rate, then Checks. Marketing per inquiry ($90.48 then $93.62) and per contract signed ($612.90 then $758.62), and the signing rate on consultations (38.8 percent then 33.1 percent).
- EPBO_4_People_and_Coordinators.xlsx (Chapters 7 and 8; People and Coordinators workbook): sheets Inputs, Capacity, Coordinators, Hire test, then Checks. Use of capacity (98.0 percent then 111.0 percent), what the day-of coordinators cost ($40,600 then $49,400) and the cost of a salaried coordinator ($51,920).
- EPBO_5_Cash_and_Seasonality.xlsx (Chapter 12; Cash and Seasonality workbook): sheets Inputs, Free cash, Reserve, Distribution, then Checks. Free cash at each year end ($22,285 then $135,865), the reserve of three months of fixed costs ($100,605) and the room for a distribution ($35,260).
- EPBO_6_Margins_and_Value.xlsx (Chapters 13 and 15; Margins and Value workbook): sheets Inputs, Income statement, SDE, Indication, then Checks. Both income statements ($84,730 then $182,830 of net income), seller's discretionary earnings ($179,770 then $284,950), and the buyer's indication ($455,920 to $626,890) with what the low end leaves at closing ($167,830).
- EPBO_Event_Planning_Checklists.docx: the 8 checklists of Appendix B, editable (First consultation and proposal; Contract and payment schedule; Vendor contracts in the client's name; The final week and the day of; Closing an event and the event review; Monthly deposit report and free cash; The coordinator file; Annual price list and commission review).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In EPBO_2_Pricing_and_Hours.xlsx, on Inputs, type the hours your own full-planning weddings really take: the Per planned hour sheet shows at once what the fee earns for each hour.
2. In EPBO_5_Cash_and_Seasonality.xlsx, on Inputs, type your own cash and client deposits on the same month-end date: the Free cash and Distribution sheets show what is really yours to spend.

To use a workbook on your own company, fill the yellow column from your booking system, the deposit ledger, the bank statements, the time records, the coordinator invoices and the income statement, in the order Appendix A gives, and keep a copy with the case column for comparison. Set your conventions with your outside CPA first: when a fee becomes revenue, and how money received before an event is shown. The workbooks are separate files with no link between them.

## A word of caution

Corvenhall Events, LLC, the town of Corvenhall, its founder, staff, coordinators and clients, and the regional event company that gave an indication are fictional. Fees, prices, salaries, hours, counts, budgets, shift rates, deposits and multiples are teaching assumptions, not market norms or recommendations. Whether a coordinator is an employee or an independent contractor, whether a planning fee carries sales tax, and how a contract term holds in your state are questions for your outside CPA, counsel and your state's agencies. No real company, venue, platform, software or vendor is described or recommended. Nothing here is legal, tax, insurance or accounting advice.
