Streamline your medical clinic budgeting with intuitive, color-coded inputs (light yellow cells only) that adapt to your business specifics:

Setup and General Assumptions

• Business details: Clinic name, nature of operations, forecast period (up to 5 years), currency (USD default), and projection start/end dates.
• Previous financials: Invested capital, revenue, expenses, assets, and net cash from prior periods.
• Capacity calculator: Clinic spaces/cabins, operating hours, and time per patient to estimate daily/monthly patient throughput.

Revenue Model Inputs

• Service-based streams: Pricing and volume assumptions for categories like general consultations, specialist visits, surgeries, dental procedures, emergency care, and bundled packages.
• Traffic projections: Patient acquisition growth rates, market capture percentages, and ARPU scaling.
• Credit terms: Average payment periods for receivables.

Costing and Expense Assumptions

• COGS (Cost of Goods Sold): Inventory levels, turnover rates, and supply costs tied to patient services (e.g., pharmacy supplies).
• OPEX (Operational Expenses): Detailed categories including rent, marketing, utilities, IT support, insurance, legal fees, and bank charges; input as fixed amounts or revenue percentages with growth factors.
• Headcount and Salaries: Employee numbers by role, wage structures, bonuses, benefits, and scaling with business growth.
• CAPEX (Capital Expenditures): One-time investments in clinic buildouts, medical equipment, surgical tools, IT systems, and marketing launches; useful life for depreciation.

Investment and Financing Inputs

• New funding: Pre-seed, Series A, Round 2, or Round 3 amounts, equity stakes, and timelines.
• Borrowings: Loan principals, interest rates, and repayment schedules across up to four facilities.
• Working capital: Initial buffers, safety margins, and short-term investment options for excess cash.
• Tax and dividend: Rates, payment lags, and payout policies.

These inputs support healthcare cost modeling and clinic revenue projections, ensuring alignment with real-world variables like seasonal patient flows or regulatory changes.