Annual operating budget simulator

67% of companies drift more than 25% from their original budget. Most find out far too late.

  • Instant result
  • No sign-up
  • Visible assumptions
  • Deterministic calculation

In 30 seconds: Simulate your budget under optimistic, realistic, and pessimistic scenarios, and set up early variance alerts. Deterministic calculation with auditable formulas. The result is indicative — adjust the assumptions to reflect your real operation.

Building an annual operating budget isn't an academic exercise — it's the difference between catching a problem in March or in September when it's already a crisis. This calculator gives a 12-month baseline projection; adjust each lever to validate your plan.

Methodology

Variable Expenses = Revenue × (% Variable ÷ 100)

Monthly Net Flow = Revenue − Fixed Expenses − Variable Expenses

Accounts Receivable = Revenue × (Collection Days ÷ 30)

Balance[month 1] = Reserve + Net Flow − Accounts Receivable

Balance[month N] = Balance[month N-1] + Net Flow

Runway = Reserve ÷ (Fixed Expenses + Variable Expenses)

Variables

Revenue
Average monthly revenue of the business.
Fixed Expenses
Expenses that don't vary with sales (rent, payroll).
% Variable
Percentage of revenue spent on variable expenses.
Collection Days
Average number of days it takes customers to pay.
Reserve
Cash available at the start of the projection.

Practical example

Established SMB (IT outsourcing services, 18 staff) building a 12-month operating budget: base invoiced revenue $800,000/month, fixed costs $380,000 (payroll, rent, software, accounting), variable costs 32% (subcontractors, project cloud infrastructure), 35 collection days (mix of net-30 and net-45 clients), $400,000 reserve.

Monthly accounting profit: $800,000 − $380,000 − $256,000 = $164,000. Projected annual EBITDA: $164,000 × 12 = $1,968,000.

Cash reality with 35 collection days (k = 2 months of lag): month 1 balance = $400,000 − $636,000 = −$236,000. Month 2: −$872,000 (minimum). Month 3 first collection lands: −$708,000.

The operating budget must be planned with scenarios. Conservative (revenue −15% = $680,000/month): EBITDA drops to $1.05M, but cash suffers far more because of lag. Projected minimum balance in conservative scenario: −$1,150,000 at month 2. Optimistic (+10% = $880,000/month): EBITDA $2.4M, minimum balance −$808,000.

Recommended review trigger: if variance vs budget exceeds 5% for two consecutive months, adjust projection. If it exceeds 10%, freeze hiring and discretionary opex until you understand the cause. Companies that wait until 15%+ variance typically cut 60-90 days too late.

Operating recommendation: the budget is only useful if you review it monthly against actuals. Quarterly review is standard but lets a bad Q1 destroy the year. The practice that separates healthy SMBs from SMBs in crisis: monthly close by day 5 of the following month and budget-vs-actual comparison by day 7. If your accountant delivers close on day 20+, change the process (not the accountant) — latency is what kills you.

Interpretation

A positive monthly net flow doesn't guarantee liquidity. If your customers pay late, you can have cash problems even though you're profitable.

Runway tells you how many months your company survives without revenue. Less than 3 months is a risk zone; at least 6 is recommended.

If the projection line dips below zero, your business will need external financing at that point.

Review this projection monthly against actuals. The gap between projected and actual measures your cash management.

Assumptions and limitations

  • Assumes constant monthly revenue and expenses (no seasonality).
  • Accounts receivable impact only the first month of the projection.
  • Does not consider credit lines, financing or capital injections.
  • Does not include taxes, depreciation or financial expenses.
  • Runway assumes a complete revenue stop; in practice it would be partial.

When to use this calculator

  • When starting a new business. Before signing leases or hiring staff, project your cash flow to know how many months you can operate before revenue covers expenses. Many profitable businesses fail due to early-months illiquidity.

  • When your customers pay on credit. If you sell at 30, 60 or 90 days, invoicing doesn't reflect cash on hand. Cash flow shows when you actually receive the money and whether you can meet obligations while waiting.

  • To decide whether you can take on a major expense. Before buying equipment, hiring an employee or investing in inventory, simulate how it affects your cash balance over the next 6-12 months.

  • When negotiating payment terms with suppliers. If your flow is positive but tight in certain months, you can negotiate paying at 60 days instead of 30 to smooth expense peaks.

  • To determine how much working capital you need. Cash flow shows the lowest point of your balance — that's the minimum reserve you need to operate without surprises.

  • When a bank or investor asks for financial projections. The cash flow statement is one of the three basic financial statements they evaluate to grant credit or investment.

Common mistakes

  • Confusing profit with cash. You can have positive accounting profit and still run out of cash. If you sold $100,000 but your customers haven't paid yet, you don't have $100,000 in the bank. Cash flow measures real money, not payment promises.

  • Not accounting for seasonality. Most businesses have strong and weak months. A restaurant in a tourist area may bill twice as much in December as in September. Projecting constant revenue creates a false sense of security.

  • Underestimating average collection days. Customers rarely pay on agreed terms. If the contract says 30 days, the real average is usually 45-60 days. Use real collection data to project.

  • Forgetting irregular expenses. Year-end bonuses, annual insurance, license renewals, equipment maintenance and annual tax payments are expenses that don't appear every month but can empty your cash when they arrive.

  • Not maintaining an emergency reserve. The minimum rule is 3 months of fixed expenses in reserve. For businesses with corporate customers paying on credit, the recommendation rises to 6 months. Without reserves, any collection delay or unexpected expense creates a crisis.

  • Projecting growth without considering the cost of growth. If sales rise 50%, you probably need more inventory, more staff and more space. Growth consumes cash before generating it.

Industry use cases

Established SMB

Baseline budget plus 3 scenarios (conservative −15%, base, optimistic +10%). Monthly review against actuals, quarterly adjustment if variance exceeds 5%.

Corporate (>$50M USD)

Top-down budget paired with bottom-up by business unit. Focus on EBITDA and cash conversion, not just revenue.

Nonprofit organization

Model revenue by source (donations, contracts, fundraising) with probabilities. Minimum reserve: 6 months of operating expenses.

Family business

Separate business cash flow from personal cash flow. The most common mistake: using the company's cash as a personal account without formal dividends.

Methodology and assumptions

How results are calculated, what we assume when modeling, and where the method loses precision.

Formula

Ending balance = Opening balance + Inflows − Outflows · Runway = Balance ÷ |Monthly burn|

Assumptions

  • Inflows and outflows distributed evenly through the month.
  • Lines of credit or factoring not included unless entered as additional inflows.
  • Inflation treated as flat within the projection horizon.

Applicability limits

  • Runway becomes unreliable with less than 3 months of history.
  • Large one-off events (annual taxes, year-end bonuses) must be entered as point items.
  • Does not model depreciation: it works on cash, not accounting profit.

Sources

  • Brealey, Myers & Allen — Principles of Corporate Finance (13th ed., McGraw-Hill).
  • Internal editorial estimate based on industry best practices.

Need more depth? The advanced simulator models 3 scenarios from a free-text description of your business. Advanced Cash Flow Simulator

Embed on your site

This calculator is free and embeddable. Copy this snippet into your blog or website so your readers can run it directly from there.

Responsive width, fixed height. Adjust `height` to fit your layout.

Want to go beyond the quick calculation?

Sign up to access advanced simulators with multiple scenarios, data export, and detailed projections.

No spam. Just early access to the annual operating budget simulator.

Complete guide

What an operating budget is and what it is for

The operating budget is the financial plan that projects operating revenue and expenses of a company across the fiscal year — typically 12 months broken down monthly or quarterly. It does not cover capital investments (CapEx: machinery, capitalizable software, major remodeling); those live in a separate budget. The operating one covers what has to happen every month for the business to run: projected sales, cost of goods sold (COGS), payroll and social charges, rent, utilities, marketing, commissions, operating taxes, software subscriptions and professional services.

For an SMB, the operating budget simultaneously answers three questions: can I sustain the current structure with the sales I project?, where do I have room to grow without decapitalizing?, and what month of the year do I run out of air if sales drop 20%? Without those written answers, the company operates reactively month by month — and cuts always arrive late.

Operating budget vs capital budget (OpEx vs CapEx)

The operating budget records recurring period expenses (OpEx: payroll, rent, utilities, marketing, minor maintenance). The capital budget records long-lived investments that are capitalized and depreciated over several years (CapEx: productive machinery, major IT equipment, vehicles, structural remodeling, ERP software). The Mexican tax authority (SAT) allows OpEx to be deducted in the fiscal year; CapEx is deducted via depreciation at LISR rates (fixed assets). Mixing the two in the same budget obscures real operating profitability and breaks comparability with industry benchmarks.

Components of the operating budget

Every serious operating budget breaks down, by cost center, four blocks:

  • Projected revenue. Units × price by product or service line, with seasonality if applicable. Anchor data: sales are not one figure, they are 12 monthly figures.
  • Variable cost (COGS). What you consume per unit sold: raw materials, packaging, sales commissions, payment gateway, variable fees. Rises and falls with revenue.
  • Fixed costs. Base payroll (with IMSS + withheld ISR + Infonavit in Mexico: ~30%-40% payroll tax on gross wage), rent, basic utilities, insurance, SaaS subscriptions, accounting services.
  • Discretionary expenses. Marketing, travel, training, consulting. The first ones you cut in a pessimistic scenario.

The operating result formula (EBIT before financing) is:

Operating result = Revenue − COGS − Fixed operating expenses − Discretionary

If that number is negative for more than two consecutive months in the realistic scenario, the structure is oversized for demand.

How to build an operating budget in 6 steps

  1. Project revenue by product or service line. Do not use a single annual figure: project units × price month by month. Adjust for historical seasonality if you have at least 18 months of sales.
  2. List variable costs (COGS). Assign unit cost by each revenue line. Multiply by projected units. Gross margin (revenue − COGS) should stay stable; if it falls month over month, pricing or suppliers are bleeding.
  3. List fixed expenses by cost center. Payroll (includes IMSS/Infonavit/withheld ISR payroll taxes ~30%-40% on gross wage in Mexico), rent, utilities, insurance, software. These are the expenses that happen even if you sell nothing.
  4. List discretionary expenses. Marketing, travel, training, consulting. Reserve 5%-15% as a contingency margin over operating total.
  5. Compute the monthly operating result. Revenue − COGS − Fixed − Discretionary. Project 12 months rolling the year-to-date.
  6. Run three scenarios. Optimistic (sales +10%, unchanged COGS), realistic (baseline), pessimistic (sales −20%, collection delays, additional delinquency provision). In the pessimistic, accumulated operating result by June is the metric to watch: if it is already negative, cuts do not wait for Q4.

Zero-Based Budgeting vs Rolling Forecast vs Traditional Budget

Three methodologies dominate modern financial planning:

  • Traditional (incremental) budget. You take last year, apply a growth or cut percentage, close. Fast but it perpetuates inefficiencies: if in 2023 you spent 280,000 on travel with no measured ROI, the traditional method leaves you 294,000 in 2024.
  • Zero-Based Budgeting (ZBB). Each cost center justifies its budget from zero every cycle, as if the business started today. High preparation time (4-8 extra weeks) but reveals 10%-25% of recoverable discretionary spend per APQC studies. Used by turnaround companies (Kraft Heinz post-3G Capital) and by SMBs changing models.
  • Rolling Forecast (12-month rolling). Instead of a fixed annual budget, each month you close the prior one with real data, add a month at the end and re-project the next 12 months. Higher operational load but the budget never ages more than 30 days. Recommended by AFP (Association for Financial Professionals) for companies with more than 40% of volatile revenue.

The LatAm SMB reality: 60%-70% operate with a traditional annual budget that breaks in March and is abandoned in July. ZBB is time-expensive; rolling forecast is the most profitable transition — a web tool with monthly scenarios automates 80% of the work.

Variance analysis (budget vs actual)

Absolute variance = Actual − Budget Percentage variance = (Actual − Budget) / Budget

Variance is analyzed by cost center and by category. A favorable variance (costs below, revenue above) is not always good: revenue above plan with COGS above plan can mean you are discounting to sell, not growing.

Healthy thresholds for LatAm SMB per CFO practice:

  • Total variance ≤ 5% → strict execution, review the accuracy of the original forecast.
  • Variance 5%-15% → normal zone, adjust and keep going.
  • Variance > 15% → re-project the rest of the year, the budget is no longer the reference.
  • Variance > 25% sustained two months → rethink the operating model.

OpEx as % of revenue: benchmark by vertical

The OpEx / Revenue ratio measures operational efficiency. Healthy ranges per APQC Open Standards Benchmarking and CFO.com surveys:

  • Professional services (agencies, firms): 65%-75%. Payroll-dominated.
  • Physical retail: 25%-35% OpEx excluding COGS. Profitability depends on turnover.
  • Restaurants: 30%-40% OpEx (payroll + rent + utilities), 30%-35% COGS. Typical operating margins 8%-12%.
  • Small B2B SaaS: 60%-75% OpEx (engineering + sales + G&A). Profitability at scale.
  • Light manufacturing MX: 20%-30% OpEx excluding COGS. Bulk is raw materials.

If your OpEx/Revenue ratio is 10+ points above the vertical benchmark, the budget has slack to cut without touching sales.

Mexican tax context: annual ISR, RESICO, fiscal filing

The operating budget must separate tax flow because taxes are not operating expenses in the accounting sense but consume cash on fixed dates:

  • Monthly provisional ISR (PM general regime): computed on profit coefficient and paid by the 17th of the following month. It is not optional and does not prorate.
  • Annual ISR (March-April filing): the adjustment between provisional and definitive can represent 15%-25% of projected accounting profit. Specific budget reserve.
  • IVA charged − creditable: if you sell more than you buy in the month, you pay a balance to SAT by the 17th. If you buy more, you accumulate a favorable balance.
  • RESICO PM (revenue up to USD 2.06M): reduced effective rate vs general regime, but with deduction restrictions.

The common mistake: not budgeting the annual ISR adjustment in the first quarter of the following year. It shows up in March and upends cash at many profitable SMBs.

Interactive tool vs Excel template

The SERP is saturated with downloadable Excel templates — useful for the first calculation, useless for operations. They do not model three scenarios side by side, do not alert when the cumulative operating result crosses a critical threshold, and no one updates them after the second month. A web calculator with rolling forecast, automatic variance analysis and multi-scenario projection is the difference between a living budget and a file nobody opens.

Illustrative case

Composite case for instructional purposes: combines sector dynamics with realistic figures. Names are fictional and do not represent a specific company.

ManufacTextil del Bajío is an industrial-uniform manufacturer located in Querétaro. 80 employees, annual revenue of USD 4M, 9.4% accounting operating margin, PM general tax regime. Customer base: 60% Tier-2 automotive industry, 25% state government, 15% independent distributors.

In 2024 they had spent three years operating with an incremental budget — every December the accountant added 8% to each line of the prior year and the CFO signed off. By June 2024 the accumulated deviation was 28%: textile raw-material cost rose 14% (not 8%), payroll grew 11% from minimum-wage adjustments and IMSS payroll tax, and the government client delayed payments 90 days, stalling the work flow.

The owner, Renata Villalobos, hired an external controller who proposed an eight-week Zero-Based Budgeting (ZBB) exercise on the plant's 11 cost centers. When the data was loaded into Simúlalo with optimistic, realistic and pessimistic 12-month scenarios, three findings emerged:

  1. The "Inbound logistics" cost center had USD 42,000 of annual discretionary spend without an authorization process — double freight with two vendors that nobody had renegotiated in four years.
  2. The "Marketing and sales" line projected USD 180,000 with ROI measured at less than 15% of campaigns; ZBB cut it to USD 90,000, redirecting spend to direct sales.
  3. The annual ISR reserve (March 2025 tax filing) had not been budgeted: USD 95,000 were missing that were about to trigger a Q1 crisis.

Combined result: 12% operating savings annually (~USD 336,000 on OpEx of USD 2.8M), operating margin rose from 9.4% to 13.1% without touching revenue. Renata stopped signing budgets "on trust" and today runs a monthly rolling forecast: each month she closes the prior with real data and re-projects the next 12 months. The budget stopped being a forgotten file; it is the operations tool.

From theory to calculation

The calculator on this page runs with your numbers — no forms, no login. Scroll up and try it.

Try the calculator

Sector reference ranges

Indicative ranges based on public sector literature and operational observation. Your business may differ — use the numbers as a starting point, not as a target.

MetricValueSource
Typical savings from applying zero-based budgeting vs incremental budget10-25%APQC Open Standards Benchmarking, 2024
Mid-size companies exceeding 25% annual budget variance40-50%AFP FP&A Benchmarking Survey, 2024
Mexican SMBs without a formal written annual budgetmore than 60%CONDUSEF, Educación Financiera PyME 2024
OpEx-to-revenue ratio — professional services (agencies, consulting)65-75%APQC Open Standards Benchmarking, 2024
Total employer payroll burden on gross salary — Mexico (IMSS + Infonavit + withheld ISR)~30-40%IMSS + LISR, tabulaciones 2024
Mexican SMBs filing annual accounts on time54%INEGI ENAFIN, 2024
Recommended contingency margin — annual operating budget, SMB5-15%AFP Guide to Budgeting & Forecasting, 2024
Typical annual budget preparation cycle — mid-size company8-12 weeksAPQC Benchmarking, 2024

Frequently asked questions

1What is an operating budget and what is it for?
It is the financial plan that projects recurring operating revenue and expenses (OpEx) during the fiscal year, typically 12 months broken down monthly. It is used to size the structure, anticipate financially stressful months and decide where there is room to grow or cut. It does not include capital investments (CapEx), which go in a separate budget.
2What are the components of an operating budget?
Four blocks: projected revenue (units × price by line), variable cost or COGS (what you consume per unit sold), fixed expenses (payroll with payroll tax, rent, utilities, insurance, software) and discretionary expenses (marketing, travel, training). Operating result = Revenue − COGS − Fixed − Discretionary.
3What is the difference between operating budget and capital budget?
The operating covers recurring fiscal-year expenses (OpEx: payroll, rent, utilities, marketing). The capital covers long-lived investments that are capitalized and depreciated (CapEx: machinery, major equipment, ERP software). Tax-wise, OpEx is deducted in the year; CapEx via depreciation at LISR rates.
4How do you calculate an operating budget step by step?
Six steps: 1) project revenue by line with monthly seasonality; 2) list variable COGS per unit; 3) list fixed expenses including ~30%-40% IMSS payroll tax; 4) list discretionary expenses with 5%-15% contingency; 5) compute monthly operating result; 6) run three scenarios (optimistic, realistic, pessimistic) over 12 months.
5What is zero-based budgeting (ZBB)?
Methodology where each cost center justifies its budget from zero every cycle, as if the business started today, instead of starting from last year plus a percentage. It requires 4-8 additional weeks of preparation but reveals 10%-25% of discretionary savings per APQC. Useful in turnaround or model changes.
6What is a rolling forecast and how does it work?
Instead of a fixed annual budget, each month you close the prior one with real data, add a month at the end and re-project the next 12 months. The horizon is always rolling 12 months. Recommended by AFP for companies with more than 40% of volatile revenue; it keeps the budget fresh and avoids the "June death" of the traditional budget.
7What is budget variance and how is it analyzed?
Absolute variance = Actual − Budget; percentage variance = (Actual − Budget) / Budget. Analyzed by cost center. Thresholds: ≤5% strict execution, 5%-15% normal zone, >15% re-project the year, >25% sustained rethink the model. A favorable variance with above-plan COGS can indicate aggressive discounting, not healthy growth.
8How often should I review my operating budget?
Monthly compare actual vs budget by cost center. Quarterly run a full re-projection of remaining months. If you run rolling forecast, review is continuous: each month you close with real data and update the next 12 months. A budget reviewed once a year breaks in March and is abandoned in July.
9What does an SMB operating expense budget include?
Payroll with payroll tax (IMSS + Infonavit + withheld ISR ~30%-40% in Mexico), rent, basic utilities, insurance, SaaS subscriptions, accounting and legal services, minor maintenance, marketing, travel, training, banking and payment-gateway fees, and operating taxes (IVA, provisional ISR, employer social charges).
10How do you present an operating budget to a bank?
Include three scenarios (optimistic, realistic, pessimistic) with documented assumptions, 12-month monthly breakdown, projected EBITDA, debt service coverage ratio (DSCR) and sensitivity analysis to a 20% revenue drop. The bank does not expect optimism: it expects to see you know the risks and have a plan B. Attach the last two years of audited financials and the annual ISR filing.

Tools from the same topical cluster. Use them together to close the loop on your analysis.

Last updated: April 30, 2026 · Reviewed by the Simúlalo editorial team. Figures and benchmarks are indicative; verify with your own data before deciding.

View methodology