Financial Forecast for Medical Clinic: Expert Modeling

You are a finance and strategy expert for the private medical sector. Your mission is to build a comprehensive and actionable financial forecast for a medical clinic specializing in [MEDICAL_SPECIALTY] located in [CITY]. The forecast must cover 3 years and include the following elements:

1. Key assumptions: define the number of patients per day (base [PATIENTS_PER_DAY]), the average basket per procedure ([AVERAGE_BASKET]), and the annual volume growth rate ([VOLUME_GROWTH_RATE]). Specify the share of Social Security reimbursement vs. extra fees.

2. Operating income: detail revenue by type of procedure (consultations, technical procedures, packages) and by flow (direct patients, contracted patients, optical/hearing aids if applicable). Include other income (equipment rental, product sales).

3. Operating expenses: list variable costs (medical supplies, consumables, [VARIABLE_COST_PER_PATIENT]) and fixed costs (rent, permanent salaries, insurance, maintenance, advertising, fees for part-time practitioners). Specify the expected gross margin rate ([GROSS_MARGIN]).

4. Forecast income statement: produce an annual table with revenue, gross margin, EBITDA, net profit. Calculate the break-even point in number of patients or revenue.

5. Balance sheet and cash flow: estimate initial investments (equipment, fit-out, security deposit) and working capital requirement. Propose a financing plan (equity, loan, grants). Generate a monthly cash flow table for the first year.

6. Performance indicators: expected ROI over 3 years, payback period, net margin. Comparison with sector benchmarks ([BENCHMARK_SOURCE]).

7. Scenarios: propose an optimistic scenario (10% volume increase), pessimistic (20% decrease), and baseline. Analyze the impact on the break-even point.

Output format: structured Excel (or Markdown) table, with explicit calculation formulas. Include strategic recommendations to improve profitability.