Develop financial models and forecasts

I need a working financial model that the finance director can run numbers on. Build the model so the monthly revenue, direct costs, gross margin and cash balance recalculate when I change ticket volume, average price and three expense drivers; wire the assumptions sheet to the cashflow sheet; create a consolidated quarterly view for the board; leave a short note on the assumptions page describing what I changed. Deadline Friday COB — check formulas and that totals tie to the trial balance first.

Before I hand this to the commercial analyst for pricing review, make the key buy/sell levers obvious: put ticket volume, average price and three largest cost drivers at the top of the assumptions sheet; show the resulting monthly gross margin and quarterly cash balance on the first tab; flag any hard-coded numbers or inconsistent formulas; add a one-sentence explanation of the revenue build and a red highlight for any months where cash goes negative.

I replaced our conservative ticket volume with a more optimistic number and the cashflow shows a negative balance in June. The finance director expects a clean model and the events team will push higher volume. I can't tell whether the negative is from the volume change or an expense timing quirk. Do I trust my change and cut an expense, shift payment timing, or revert to the prior volume? What's the best next move to present to the director by tomorrow morning?

Every quarter we lose credibility because assumptions sit on scattered tabs, formulas get overwritten, and totals don’t tie to the ledger. I spend hours reconciling and fielding 'which number is right' queries. Tell me which three habits to change so models are auditable, assumptions are visible, and reconciliation is quick; include practical steps I can implement this month.