Business Budget Calculator
Build a monthly P&L budget and track variance between planned and actual figures for any small business.
💼 What is a Business Budget Calculator?
A business budget calculator is a financial planning tool that helps you build a profit and loss (P&L) projection for your business. You enter your expected revenue and cost categories, and the calculator instantly shows gross profit, operating income, net profit, and key margin percentages. The result is a one-page financial picture of your business for any given month, along with an annual projection.
Businesses use budget calculators across many stages and purposes. A startup founder might use it to project whether the business will be cash-flow positive at a given revenue level. A restaurant owner might enter current revenue and cost of goods to see if the kitchen margin is healthy enough to cover rent and payroll. A freelance consultant might use it to plan how much they need to bill each month to hit a target annual income. The Variance Analysis mode is particularly useful for monthly management reviews: enter what you budgeted versus what actually happened, and the tool flags each line item as favorable or unfavorable.
The P&L structure used in this calculator follows the standard income statement format: Revenue minus COGS gives Gross Profit. Gross Profit minus Operating Expenses gives Operating Income (also called EBIT: Earnings Before Interest and Taxes). Operating Income minus Tax gives Net Profit. This is the same structure used by public company financial statements, private business reviews, and loan applications. Knowing gross margin separately from net margin helps you identify where profitability problems originate: a low gross margin signals pricing or supplier cost issues, while a healthy gross margin but low net margin points to overhead spending.
This calculator is designed for small business owners, entrepreneurs, freelancers, and finance students who need a fast, accessible budget tool without the complexity of spreadsheet software. Default values reflect a realistic small business scenario ($50,000 monthly revenue, 40% COGS, $21,500 operating expenses), so the pre-calculated result on page load gives you an immediate reference point to adjust from.
📐 Formula
Net Profit = (Revenue − COGS − OpEx) × (1 − Tax Rate)
COGS = Revenue × COGS Rate % ÷ 100
Gross Profit = Revenue − COGS
Gross Margin = Gross Profit ÷ Revenue × 100%
Operating Income = Gross Profit − Total Operating Expenses
Tax = max(Operating Income, 0) × Tax Rate ÷ 100
Net Profit = Operating Income − Tax
Net Margin = Net Profit ÷ Revenue × 100%
Budget Variance = Actual − Budget (positive = favorable for revenue; negative = favorable for expenses)
Example: Revenue $50,000; COGS 40% = $20,000; Gross Profit $30,000 (60%); OpEx $21,500; Operating Income $8,500; Tax 25% = $2,125; Net Profit $6,375 (12.75%)
📖 How to Use This Calculator
Steps
1
Enter your monthly revenue - Type your expected or actual monthly revenue in the Revenue field. This is the total amount billed or received before any deductions.
2
Set COGS rate and operating expenses - Drag the COGS slider to set your cost of goods sold as a percentage of revenue. Then enter your fixed monthly operating expenses: salaries, rent, marketing, and other costs.
3
Adjust the tax rate and review results - Use the Tax Rate slider to match your effective business tax rate. The calculator instantly shows gross profit, operating income, net profit, margins, and annual projections.
4
Switch to Variance Analysis for monthly review - Click the Variance Analysis tab, enter your budgeted and actual figures for each category, and click Calculate to see which lines came in favorable or unfavorable.
💡 Example Calculations
Example 1 - Small Retail Business
Monthly revenue $50,000, COGS 40%, $21,500 operating expenses, 25% tax
1
COGS = $50,000 x 40% = $20,000. Gross Profit = $50,000 - $20,000 = $30,000 (60% gross margin).
2
Total OpEx = $15,000 (salaries) + $3,000 (rent) + $2,000 (marketing) + $1,500 (other) = $21,500. Operating Income = $30,000 - $21,500 = $8,500.
3
Tax = $8,500 x 25% = $2,125. Net Profit = $8,500 - $2,125 = $6,375 (12.75% net margin). Annual Net Profit = $6,375 x 12 = $76,500.
Monthly Net Profit = $6,375
Try this example →Example 2 - Consulting Firm (Higher Revenue, Higher Margins)
Monthly revenue $75,000, COGS 20%, $28,000 operating expenses, 28% tax
1
COGS = $75,000 x 20% = $15,000. Gross Profit = $75,000 - $15,000 = $60,000 (80% gross margin). Services businesses have lower COGS than product businesses.
2
Total OpEx = $20,000 (salaries) + $3,000 (office) + $3,000 (marketing) + $2,000 (other) = $28,000. Operating Income = $60,000 - $28,000 = $32,000.
3
Tax = $32,000 x 28% = $8,960. Net Profit = $32,000 - $8,960 = $23,040 (30.72% net margin). Annual Net Profit = $23,040 x 12 = $276,480.
Monthly Net Profit = $23,040
Try this example →Example 3 - Variance Analysis (Month-End Review)
Revenue came in above budget; COGS over budget; OpEx under budget
1
Revenue: Budget $50,000, Actual $52,000. Variance = +$2,000 (Favorable). Higher actual revenue means more was earned than planned.
2
COGS: Budget $20,000, Actual $21,000. Variance = +$1,000 (Unfavorable). Higher actual COGS means more was spent on goods than planned.
3
OpEx: Budget $21,500, Actual $20,500. Variance = -$1,000 (Favorable). Lower actual operating expenses means overhead was controlled. Net Profit variance: Budget $6,375, Actual $8,375 = +$2,000 (Favorable).
Net Profit Variance = +$2,000 (Favorable)
Try this example →❓ Frequently Asked Questions
How do I calculate net profit in a business budget?
Net profit = Revenue minus COGS minus Operating Expenses minus Tax. The step-by-step path is: (1) subtract COGS from revenue to get gross profit; (2) subtract all operating expenses from gross profit to get operating income; (3) multiply operating income by your tax rate to find the tax bill; (4) subtract tax from operating income to get net profit. Net margin (net profit divided by revenue) tells you what fraction of each dollar of revenue you keep as profit.
What is a good net profit margin for a small business?
Net profit margins vary widely by industry. Grocery stores often run 1-3%, restaurants 3-9%, retail 2-6%, professional services 15-25%, and software businesses 10-30%. As a general benchmark, a net margin above 10% is considered good for most small businesses. Early-stage businesses frequently have negative or very low margins as they invest in growth. Benchmark against direct competitors rather than cross-industry averages for the most useful comparison.
What is the difference between gross profit and operating income?
Gross profit is revenue minus COGS only. It measures the profitability of your product or service before overhead costs. Operating income (EBIT) is gross profit minus all operating expenses (salaries, rent, marketing, administrative costs). Operating income shows whether the business as a whole is profitable from its core activities, ignoring financing costs and taxes. A business can have a healthy gross margin but negative operating income if overhead is too high.
How do I set the right COGS rate for my business?
COGS rate = Total COGS divided by Revenue, expressed as a percentage. Review your last 3-6 months of financial statements to find your average COGS rate. For product businesses, COGS includes materials, direct labor, and freight. For service businesses, it includes direct project costs and subcontractor fees. Once you know your current rate, use the slider to model what happens to profit if you negotiate better supplier pricing (lower COGS) or raise prices (same COGS but higher revenue, reducing the rate).
What is budget variance analysis and how do I use it?
Budget variance analysis compares what you planned (budget) to what actually happened (actual). For revenue lines, favorable means actual exceeded budget. For expense lines, favorable means actual was below budget. Monthly variance analysis helps identify recurring patterns: a consistently unfavorable COGS variance might mean supplier costs are rising faster than pricing; a favorable OpEx variance might mean under-investment in marketing. Use the Variance Analysis mode in this calculator at the end of each month to track these patterns.
What percentage of revenue should salaries be in a small business?
For most small businesses, total payroll (salaries plus any direct labor in COGS) runs 30-50% of revenue. Service businesses tend to be at the higher end since people are the main cost of delivery. Product businesses split payroll between COGS (production labor) and operating expenses (admin, sales staff). If payroll in operating expenses alone exceeds 40% of revenue, it is worth reviewing whether all hires are generating sufficient revenue per head. Use the salaries slider to model the impact of adding or removing staff.
How do I calculate my effective tax rate for the budget?
Effective tax rate = Total tax paid divided by net income (or operating income) for the year, from your prior year tax return. For US businesses: sole proprietors and partners pay self-employment tax (15.3%) plus income tax, totaling 25-40% effective rates. S-corps may reduce self-employment tax on distributions. C-corps pay a flat 21% federal corporate rate plus state taxes. For budgeting purposes, a rate of 20-30% is a reasonable starting estimate for most US small businesses, adjusted down if you have significant deductions.
Why does the calculator show annual revenue and net profit?
Annual revenue and net profit equal monthly values times 12, assuming consistent performance throughout the year. Annual figures matter for: bank loan applications (lenders use annual revenue and EBITDA); business valuations (small businesses are often valued at 2-4x annual net profit or EBITDA); tax planning (year-end tax liability is based on annual income); and goal setting (annual targets are more meaningful for long-range planning). For seasonal businesses, enter average monthly figures rather than peak-month figures for a realistic annual projection.
What is operating income vs EBIT?
Operating income and EBIT (Earnings Before Interest and Taxes) are the same thing for most small businesses: gross profit minus operating expenses. The distinction only matters when there are significant non-operating items. EBITDA (adding back Depreciation and Amortization) is another common metric used in business valuations and lending decisions. For simplicity, this calculator treats operating income and EBIT as equivalent and does not add back depreciation, which is fine for most small business budget planning purposes.
How can I improve my net profit margin?
Three main levers: (1) Increase revenue at the same cost structure. Drag the revenue input up to see how additional sales fall through to net profit at your current margins. (2) Lower COGS rate: renegotiate supplier prices, reduce waste, or raise prices without increasing costs. (3) Cut operating expenses: analyze each expense category for reduction opportunities. Use the sliders and inputs to model each scenario. A 5-point improvement in gross margin (e.g., from 60% to 65%) often has more impact on net profit than cutting a similar dollar amount from operating expenses.
How do I use this calculator for a service business with no physical product?
For service businesses, COGS typically represents direct delivery costs: subcontractor or freelancer fees, direct labor hours billed to clients, software or tools used exclusively for client projects. Set the COGS rate to match your blended direct cost ratio (for many service businesses this is 10-30%). Put all overhead costs (office rent, admin staff, marketing, software subscriptions, professional fees) into the operating expense fields. The result will show your service profitability in the same P&L structure that accountants and lenders use.