Previsionnel Financier

The problem

French entrepreneurs often struggle with French banking standards for financial forecasting. Manual Excel files frequently contain broken formulas, incorrect VAT calculations, or inconsistent social charge rates for TNS (Travailleurs Non-Salariés).

What it does

• Generates a professional 3-year financial forecast in .xlsx format compatible with French bank loan applications.
• Calculates French-specific social charges, corporate tax (IS), and VAT based on the chosen legal structure (SAS, SARL, EURL, etc.).
• Builds dynamic worksheets including a standardized income statement, financing plan, 12-month cash flow, and break-even analysis.
• Ensures formula-driven transparency, allowing bankers to audit every assumption without hard-coded values.
• Includes automated checks for the debt-service coverage ratio and financing balance.

Frameworks & tools

Python openpyxl, LibreOffice (optional for verification).

Why this beats prompting it yourself

Basic LLM prompts generate static tables with math errors. This skill enforces rigorous French accounting rules, handles complex VAT staggering in cash flow projections, and produces a live Excel file with inter-connected formulas designed to survive a banker's scrutiny.

Benchmarked results

Tested on realistic scenarios (SASU food truck with a bank loan, EURL consulting business with ramp-up, SARL business acquisition with employees): the skill passed 100% of banking-quality criteria vs. 81.5% for unassisted prompting. The main gap: without the skill, 2 out of 3 workbooks came out as static hard-coded values — impossible to adjust and not auditable. With the skill, every file contains 55-66% live formula cells, a balanced financing plan, and zero calculation errors.

Use cases

• Preparing a loan application file for a French bank or BPIfrance.
• Evaluating the feasibility of switching from Micro-entrepreneur to a legal company (SAS/SARL).
• Calculating the exact break-even point for a new physical shop or TPE.
• Simulating "what-if" scenarios by changing a single margin percentage in the master Assumptions tab.

Known limitations

This tool provides a structural foundation and calculation logic; it does not replace the mandated sign-off of a chartered accountant (Expert-comptable) for official filings.

Documentation et livrables en français — conçu pour les créateurs d'entreprise, dossiers de prêt bancaire et ARCE.