Annual Budget Formula
Revenue (month) = Annual revenue x Month weight % Variable cost (month) = Revenue (month) x (Food % + Labour % + Other %) EBITDA (month) = Revenue (month) - Variable cost (month) - Monthly fixed costs
Caricamento...
Finance & Business Plan
Build a 12-month budget from a revenue target and your seasonality: revenue, variable costs and EBITDA month by month, with the best and worst months and the cumulative result highlighted.
Revenue (month) = Annual revenue x Month weight % Variable cost (month) = Revenue (month) x (Food % + Labour % + Other %) EBITDA (month) = Revenue (month) - Variable cost (month) - Monthly fixed costs
Instead of dividing annual revenue by twelve, a seasonality budget spreads the yearly target across the months using a weight for each month that reflects how busy it is. A tourist venue might put 15% of the year in its peak month and only 3% in its quietest. The calculator then applies your variable cost percentage and monthly fixed costs to each month, producing a realistic EBITDA profile rather than a flat average.
Variable costs move with sales: food cost, labour and other variable items, expressed as a percentage of each month's revenue. Fixed costs (rent, insurance, base salaries) stay roughly the same every month regardless of takings. EBITDA for a month is that month's revenue minus its variable costs minus its fixed costs, which is why low-season months can post a negative EBITDA even when the year as a whole is profitable.
Because fixed costs do not shrink when sales fall. In a very quiet month, revenue may not even cover variable costs plus fixed costs, so EBITDA goes negative. That is normal for seasonal hospitality and is exactly why budgeting month by month matters: it tells you which months will need cash support and how much surplus the strong months must build to cover them.
Use your historical sales mix if you have it: take each month's share of last year's revenue. If you are new, estimate the pattern from comparable venues and local seasonality. The weights should add up to 100% across the twelve months. The calculator handles the rest, ribboning your annual target across the year and computing each month's costs and EBITDA.