Revenue and Calc
Build monthly professional-service hours by utilization, allocate one capacity pool across five services, and apply the realized hourly receipts for each revenue stream.

This Excel financial model builds a five-year forecast for a solo, self-pay nutrition counseling practice. It links professional hours, utilization, service allocations, realized receipts, expenses, and owner compensation to monthly financial reports.
The illustrated 2026–2030 case is one qualified owner in a leased suburban Atlanta counseling room, offering assessments, follow-ups, meal planning, grocery education, and corporate education without insurance reimbursement or product resale.
The workbook links nutrition-practice assumptions to monthly operating calculations, financial statements, funding plans, and decision reports.
Build monthly professional-service hours by utilization, allocate one capacity pool across five services, and apply the realized hourly receipts for each revenue stream.
Separate revenue-linked digital resources, processing and travel, fixed practice overhead, and the owner nutritionist’s base salary to avoid double-counting operating costs.
Enter startup purchases, equity contributions, and optional debt assumptions; review investment timing and opening funding.
The revenue forecast multiplies one shared pool of utilized professional hours by a mutually exclusive service mix and realized receipts per hour.
One provider has 120 available professional-service hours each month. Utilization is 50% in 2026, 60% in 2027, 70% in 2028, 75% in 2029, and 80% in 2030, with every forecast month active from the January 2026 launch.
Those utilized hours are assigned once: 20% to initial assessments, 45% to follow-up counseling, 15% to standalone meal plans, 10% to grocery education, and 10% to corporate education. The allocations add to 100% without multiplying the capacity pool five times.
The Revenue Forecast shows the service-hour capacity, annual utilization assumptions, individual service allocations, and realized hourly receipts. Its inputs feed the Calc sheet, which converts professional hours into monthly and annual revenue for the five service categories.
Realized receipts are $180 per assessment hour, $140 per follow-up, $100 per meal plan, $120 per grocery-tour, and $200 per corporate-education hour. Each includes attributable preparation, documentation, and travel time.
120 available hours/month × 50% utilized × $146 weighted receipts per used hour × 12 months = $105,120.
The model distinguishes percentage-based direct and variable expenses from monthly practice overhead and the owner’s annual base pay.
Client digital-resource licenses are modeled as COGS at 0.5% of revenue. Variable operating costs total 7.25% of revenue: payment processing at 3.25%, incremental client acquisition at 3%, and client travel and parking at 1%.
Fixed practice costs total $20,040 annually for occupancy, software, insurance, communications, marketing, professional services, renewals, cleaning, repairs, and supplies. Room occupancy assumes $700 per month.
The COGS and Operating Expenses report separates the 0.5% direct-cost rate, revenue-sensitive variable costs, and fixed monthly overhead. It helps distinguish expenses that grow automatically with billed service hours from costs paid even when utilization is lower.
The owner nutritionist has one annual-average FTE and $70,000 base pay. Payroll stays separate from COGS and fixed overhead.
The Payroll Forecast by Staff Role models owner staffing and salary across the forecast. Monthly personnel expenses feed earnings reports, with hiring dates and compensation inputs available for alternative plans.
The opening plan separately identifies durable assets, one-time cash expenditures, and a reserve financed by an estimated owner contribution.
Startup assets total $4,500: a $1,800 secure computer and video equipment, $2,200 counseling furniture and storage, and $500 assessment and teaching equipment. These purchases are distinct from the practice’s recurring expense categories.
The Capital Expenditure Plan records asset purchases, spending dates, and depreciable status. It shows how the practice’s opening equipment and furniture budget can enter investment cash flows and subsequent depreciation schedules without treating the purchase itself as EBITDA expense.
Separate opening cash costs of $4,400 cover refundable room and utility deposits, entity and privacy setup, website launch and the opening campaign, and preopening administration. Accounts receivable, payable, and inventory day assumptions are all zero in this example.
Owner funding is estimated at $33,447, including $4,500 of assets, $4,400 of one-time cash costs, and approximately $24,547 reserved for three months of first-year recurring outflows. No committed external borrowing is assumed.
The Sources and Uses of Funds report reconciles equity funding, customer receipts, investing, and operating payments. It helps assess reserve allocation but does not prove that opening cash is sufficient.
In the supplied base illustration, higher utilized service hours increase revenue and EBITDA while provider capacity and fixed base pay remain unchanged.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $105,120 | $98,187 | $6,933 |
| 2027 | $126,144 | $99,816 | $26,328 |
| 2028 | $147,168 | $101,446 | $45,722 |
| 2029 | $157,680 | $102,260 | $55,420 |
| 2030 | $168,192 | $103,075 | $65,117 |
Illustrative forecast, not observed industry results; whole-dollar display rounding can cause minor differences.
The cost forecast includes the owner’s $70,000 annual base pay. EBITDA increases from approximately $6,933 in 2026 to $65,117 in 2030 because more receipts contribute toward largely unchanged fixed overhead and salary.
The Cash Flow Forecast tracks monthly operating receipts and payments together with investing and financing flows. Its cash reconciliation helps examine the timing of opening owner funding, expenditures, and liquidity, which cannot be determined from EBITDA alone.
The Income Statement, Balance Sheet, and combined Summary are available for broader financial reporting, including profit measures and financial position. The specific annual case numbers above end at EBITDA and do not establish net profit, debt balances, or tested cash sufficiency.
The Returns and scenario tools help test economic sustainability without equating EBITDA with recovered startup investment or positive cash.
Sales break-even, cash break-even, investment payback, and annual ROIC answer different questions, using different income and cash schedules.
The Returns report compares operating break-even requirements, cash break-even timing, project cash flow and investment payback, and annual ROIC. These are separate assessments: a positive EBITDA forecast does not, by itself, confirm cash payback or a particular return percentage.
Dashboard scenario controls provide Low, Base, and High multipliers for revenue, direct costs, operating expenses, and payroll. The Scenarios report compares projected margins and EBITDA; no alternative scenario result is claimed here.
Debt Controls let users enter financing terms, while Valuation offers discounted cash flow sensitivity. No loan, valuation, IRR, or payback result is established here.
The case is built for a solo credentialed nutrition professional who wants to assess service-hour capacity, self-pay pricing, and startup economics.
It fits a small counseling-room practice that sells one-on-one nutrition services, planning work, grocery education, and corporate education from one provider’s professional-time budget. Adjust the utilization curve, hour allocations, realized receipts, expense rates, or owner compensation to build a different plan.
These answers describe the assumptions and reporting capabilities of the documented nutritionist practice case.
Yes. Five exclusive revenue shares allocate one utilized provider-hour pool, so one professional hour cannot generate five simultaneous service receipts.
Yes. Adjust available service hours, annual utilization, individual service allocations, and realized receipts per hour to revise the monthly and annual revenue forecast.
No. The illustrated practice is entirely self-pay and excludes insurance reimbursement, supplement or food resale, and laboratory pass-through revenue.
No. Owner equity funds opening assets, other startup cash, and reserves; EBITDA measures operating earnings before depreciation, interest, and taxes.
Yes. The workbook includes debt-facility controls and equity contribution schedules, although the supplied illustration assumes only owner funding at opening.
No. The Returns sheet can calculate cash break-even, investment payback, and ROIC, but no verified timing or return result is supplied for this case.
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 cut the manual build time way down, so I wasn’t piecing together formulas for days. I had a full 5-year model ready in one afternoon.
It made runway and shortfalls much easier to see, with cash flow laid out in a way I could actually follow. We booked a lender meeting with clearer assumptions and no guessing.
Starting from scratch felt like too much, but this gave me a clean place to begin. I went from a blank sheet to a working nutritionist model without stalling out.