Revenue and Calc
Edit hours, utilization, hourly rates and service allocations; Calc converts one billable-hour pool into monthly and annual revenue.

This editable Social Media Consulting Financial Model plans a remote U.S. advisory firm from 2026 to 2030. Consulting hours, utilization, service mix and hourly rates drive revenue, operating expenses and EBITDA.
The firm advises businesses on audits, strategy, analytics, content planning and training. Clients buy advertising and handle publishing, so the case excludes ad-spend billings, influencer commissions, studio production and resale inventory.
The workbook links consulting inputs to monthly forecasts and management reports.
Edit hours, utilization, hourly rates and service allocations; Calc converts one billable-hour pool into monthly and annual revenue.
Budget direct research costs, revenue-linked marketing, charges, collection losses and monthly overhead.
Plan founder, consultant and coordinator FTE and salaries; CAPEX records equipment separately from operating expenses.
Income Statement, Cash Flow, Balance Sheet and Summary support financial review; case outputs here extend only to EBITDA.
Dashboard, Scenarios, Returns, Valuation, Ratios and Checks support assumption testing, investment analysis and model review.
Revenue uses billable advisory hours assigned to five exclusive services and priced at their hourly rates.
Monthly capacity rises from 240 hours in 2026 to 560 in 2030, while utilization increases from 45% to 60%. Annual inputs drive monthly forecasts.
Strategy uses 30% of hours at $140 hourly; audits use 25% at $125. Analytics, content planning and training each use 15%, priced at $110, $120 and $145 per hour. Shares total 100%.
The Revenue Forecast shows consulting-hour capacity, billable utilization, service allocations, hourly rates and projected billings. Monthly calculations feed the annual revenue totals and service mix.
240 available hours/month × 45% utilization × $129.50 weighted hourly rate × 12 months = $167,832 in annual revenue.
The $129.50 blended price reflects the five service shares, not a sixth fee. Adjusting the mix changes revenue without changing billable hours; client advertising spend is excluded.
Operating costs combine direct research, variable expenses, fixed overhead and role-based payroll without duplicating salaries.
Research data equals 2% of revenue. Other variable costs total 6%: marketing 4%, payment charges 1.2%, and collection losses 0.8%.
The COGS and Operating Expenses report separates direct research, variable costs and fixed monthly overhead to calculate operating expenses.
Office software costs $350 monthly in 2026 and $700 in 2030, each for 12 months. Other fixed costs include workspace, insurance, bookkeeping, connectivity, travel and training.
The Payroll Forecast tracks FTE and base salaries by role. The plan retains one founder FTE while consultant capacity expands from 0.5 to 2.5 FTE.
The founder earns $85,000 annually, each consultant FTE $70,000, and coordinator FTE $45,000. Coordination rises from 0.15 to 0.5 FTE; payroll grows from $126,750 to $282,500 between 2026 and 2030.
Employer taxes, benefits and personal taxes are excluded from this example. Salaries appear only in Payroll, not again in COGS or overhead.
Opening funding covers assets, preopening costs, receivables and reserves; owner funding is not consulting revenue.
Startup assets include $7,000 for computers and secure networks plus $2,000 for desks and meeting equipment. They are separate from recurring overhead.
The Capital Expenditure Plan schedules equipment purchases and applicable depreciation. The illustration includes $9,000 of computers, networking and meeting equipment.
The estimate adds $5,000 in preopening costs, $6,897 in receivables and a $39,844 three-month reserve to $9,000 of assets, totaling about $60,741 in initial owner funding.
The Sources and Uses of Funds report summarizes how investment and operating cash needs are financed. The case assumes owner funding, with no committed external debt.
Receivables are modeled at 15 days; payable and inventory days are zero. Collection timing changes cash needs without changing EBITDA.
Dashboard debt controls allow hypothetical borrowing terms and repayment structures. The estimated $60,741 funding is not tested against peak cash requirements.
Higher billable capacity and utilization drive illustrated revenue and EBITDA growth between 2026 and 2030.
| Year | Revenue | Operating expenses | EBITDA |
|---|---|---|---|
| 2026 | $167,832 | $159,377 | $8,455 |
| 2027 | $248,640 | $208,941 | $39,699 |
| 2028 | $341,880 | $257,850 | $84,030 |
| 2029 | $447,552 | $310,004 | $137,548 |
| 2030 | $522,144 | $359,672 | $162,472 |
Forecast values are illustrative, not historical results. Operating expenses include direct, variable, fixed and base-pay payroll costs; display amounts are rounded to whole dollars.
Revenue grows from $167,832 in 2026 to $522,144 in 2030. EBITDA rises from approximately $8,455 to $162,472 as the illustrative EBITDA margin reaches about 31.1%.
Growth assumes rising productive hours, alongside increased payroll and overhead. These are input-driven projections, not observed company performance.
The Cash Flow Forecast tracks collections, expenses, CAPEX and financing by month. EBITDA cannot reveal cash receipt timing or liquidity sufficiency.
Income Statement, Balance Sheet and Summary reports provide broader analysis, but this documented numerical example supports only revenue, operating expenses and EBITDA—not net income or closing cash figures.
Returns distinguishes operating sales break-even, cash break-even, cumulative investment payback and annual return on invested capital.
Sales break-even tests whether revenue covers operating costs. Cash break-even tests cash needs; payback tracks cumulative project cash flow against investment, and annual ROIC measures return on invested capital.
The Returns analysis presents break-even, project payback and annual ROIC calculations. None of those figures, or a payback date, is established by this EBITDA-only illustration.
Dashboard Low, Base and High scenarios vary revenue and cost assumptions. Valuation applies discounted free cash flow and terminal assumptions, not EBITDA alone.
This model fits hourly advisory firms planning utilization, service mix and hiring in one financial forecast.
It suits a U.S. remote practice led by one principal with salaried consultants and part-time coordination, not an agency reselling advertising or producing content.
Test pricing and utilization in Revenue, hiring in Payroll and risk in Scenarios. Examine Cash Flow separately before relying on the opening funding estimate.
Answers about editable inputs, report functions and illustration limits.
Yes. Change annual hours, utilization, five service rates and their shares of billed hours.
No. Clients buy advertising and handle publishing, so ad spend is not included in consulting revenue.
Yes. Divide each billed hour among the five services once, without double-counting capacity.
Founder, consultant and coordinator base payroll is included; employer taxes, benefits and personal taxes are excluded.
The $60,741 estimate includes a three-month reserve but is not a tested peak-cash requirement. Review Cash Flow.
No. EBITDA excludes depreciation, interest, taxes, working-capital timing and investing or financing cash movements.
Yes. Dashboard controls and Debt, Cash Flow and Returns support analysis; the example establishes neither borrowing nor payback timing.
It covers 2026 through 2030, with January 2026 treated as a full launch month.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
This template saved me from building every tab by hand, and I had a working five-year model in a few hours instead of losing a full week. It let me move straight into client planning and sales conversations.
I could finally see break-even and margin pressure without digging through messy sheets. That made it much easier to explain profitability in one meeting and tighten my pricing assumptions.
The structure made it easier to trust the numbers because I wasn't worried one broken cell would throw off the whole model. I caught issues faster and sent a cleaner version to my team.