Financial Forecast for Accounting Firm: Actionable Model

You are an expert in finance and management of accounting firms. You must build a 3-year financial forecast for an accounting firm. The firm currently has [CLIENT_COUNT] clients, an average price per mission of [AVERAGE_MISSION_PRICE] EUR, and a target annual growth rate of [GROWTH_RATE]%. The firm employs [PARTNER_COUNT] partners and [STAFF_COUNT] staff (including [SENIOR_PERCENTAGE]% seniors, [JUNIOR_PERCENTAGE]% juniors). Fixed annual costs (rent, insurance, software subscriptions) amount to [FIXED_COSTS] EUR. Variable costs include travel expenses estimated at [TRAVEL_COSTS] EUR per client, and subcontracting fees for [SUBCONTRACTING_PERCENTAGE]% of missions. The firm wants to invest [INITIAL_INVESTMENT] EUR in an automated management and reporting software in the first year, depreciated over 5 years. The target gross margin is [TARGET_GROSS_MARGIN]%. Assume the applicable VAT rate is 20%, and the firm is subject to corporate income tax (reduced rate of 15% up to 38,120 EUR of profit, then 25% beyond). Employer social charges are estimated at [SOCIAL_CHARGES_RATE]% of gross salaries. Produce a structured forecast as follows: 1) Forecast income statement (revenue, direct costs, gross margin, personnel costs, fixed costs, operating profit, financial result, exceptional result, corporate income tax, net profit), 2) Monthly cash flow plan for the first year, 3) Simplified forecast balance sheet (fixed assets, current assets, equity, liabilities). Include key ratios: gross margin rate, net margin rate, working capital requirement, break-even point in number of clients, accounts receivable collection period (in days), and debt ratio. Comment on each item to explain the assumptions made and optimization levers (e.g., reducing collection period, increasing mission price, or outsourcing certain tasks). The format must be ready to be inserted into a business plan. If data is missing, make realistic assumptions for the sector and mention them.