La bibliothèque
55 calculateurs conçus pour les équipes finance
Carnets de travail validés par les relecteurs pour les projets d'investissement, plus une bibliothèque complète couvrant l'évaluation, la comptabilité fiscale, le FP&A et l'unit economics. Inscrivez-vous pour sauvegarder vos scénarios et exporter en PDF.
21 calculateurs
Classeur de projet
Calculatrices validées par le relecteur et extensions spécifiques au projet
R&D Amortization
Multi-year §174 amortization with roll-forward. Solves per-unit amortization that balances NPV at SOP.
Business Case P&L
Go / no-go P&L for a capital project. Multi-year volumes, costs, lifetime KPIs.
Sales P&L Analyzer
Baseline → Sensitivity → Top-Down. Full P&L waterfall with cost-composition pies and EBIT bridge.
Quick Performance Indicator
Side-by-side Current vs Reference with plant-level cost lookup, target-ROS reverse calc, and normality testing.
Project FX Decomposition
Per-line currency mix with annual devaluation rates over the project horizon.
FX Devaluation Risk
Country-level devaluation, inflation differential vs. baseline, and country risk premium.
P&L with FX Adjustment
Re-runs the project P&L through the currency-mix and devaluation overlay to show FX-adjusted EBIT.
FX Sensitivity
Stress test the project P&L across alternative FX scenarios; compare against the baseline.
P&L FX Stress
Project P&L under a single adverse FX scenario - quick "what if a key currency moves 10%" check.
Project Cash Flow & Assets
EBIT → Cash Flow bridge with depreciation add-back, GPA invest, working capital, residual book value.
Project IRR / NPV / Payback
Project go/no-go economics: NPV at hurdle, IRR after tax, profitability index, discounted payback.
Multi-Asset Depreciation
Roll-up of new equipment, existing equipment, and internal tooling. GPA tracking and residual book value.
Productivity Ramp
Year-over-year price erosion + manufacturing cost reduction trajectory. Standard 3% lean assumption.
P&L per Product
Per-SKU P&L for multi-product projects. Aggregates volume-weighted into the project total.
Outbound Logistics Costs
Per-product OBL: packaging, warehouse (LDC + MDC), transport, customs, ICO tax. Sub-P&L roll-up.
Project Specific Effects
FX clause selection, customer-funded start-up, commodity passthrough, labor/machine inefficiency tags.
Investment Sensitivity
Vary investment, volume, or hurdle rate; see IRR / NPV / Payback move across the range.
Project Summary
High-level KPI dashboard: IRR, RoS, Payback, Investment, Receivables, Lifetime EBIT - quote-approval review.
Project Key Data
Approval-ready key-data block: BU, Plant, SOP, FX clause, Volume, NPV, IRR, RoS, Payback, FX Sensitivity.
Project Cover Sheet
Auto-filled cover document for sales approval: project ID, customer, premises, comments, sign-off.
Project Data Lookup
Reference data: plants, customers, equipment depreciation classes, exchange-rate history.
4 calculateurs
Planification du capital
Plans d'amortissement et de financement
Loan Amortization
Principal & interest schedules for commercial and residential loans. Monthly/bi-weekly/annual, extra-payment modeling.
Capital Budgeting
NPV, IRR, profitability index, discounted payback for a single project.
Lease vs Buy
Present-value comparison of financed ownership vs. leasing. After-tax cashflows, depreciation tax shield, salvage.
Debt Schedule
Multi-tranche term loan + revolver + mezzanine. Balance, interest, and coverage ratios over 10 years.
6 calculateurs
Ventes et marge
P&P, contribution, économie unitaire
Break-even / CVP
Break-even units + revenue, contribution margin, margin of safety, target-profit unit count.
Unit Economics
LTV, LTV/CAC, payback months, 24-month cohort retention curve + contribution.
Cohort Revenue
Retention-driven ARR: new bookings layer, retention curve, expansion.
Sensitivity Analysis
One-way sweep or two-way matrix - how does the result respond to input changes.
Goal Seek
Back-solve for the input that produces a target output via bisection.
Monte Carlo
Sample inputs from distributions, N runs, percentile + probability of success.
8 calculateurs
Valorisation
DCF, WACC, analyse de rendement
DCF Valuation
Terminal value (Gordon Growth / exit multiple), WACC inputs, FCF roll-forward.
WACC
Cost of equity (CAPM) blended with after-tax cost of debt at market weights.
Beta unlevering
Hamada equation for a comparable set. Unlever, take median, relever at target capital structure.
Dilution modeling
Pre/post-money, option pool top-up, founder dilution, price-per-share.
Bond Pricing
Clean price ↔ YTM, Macaulay & modified duration, convexity.
FX Hedging
Forward vs option hedge on a foreign-currency exposure. Scenario P&L vs unhedged.
Cap Table Waterfall
Preferred classes + common + option pool. Exit distribution by liquidation preference + participation.
EPS Bridge
Year-over-year EPS walk by driver: organic, FX, M&A, buybacks, tax.
9 calculateurs
Fiscalité et comptabilité
§174, amortissement, impôts différés
Depreciation Schedule
Straight-line, declining balance, and MACRS (GDS half-year). Tax-shield calc per period.
R&D Tax Credit (§41)
Regular Research Credit (20%) or Alternative Simplified Credit (14%). QRE computation with contract-research haircut.
Deferred Tax
Book-vs-tax timing differences, DTA/DTL movement, effective tax rate reconciliation.
Stock-based Comp
Black-Scholes fair value + graded vesting + forfeiture-adjusted expense schedule.
Goodwill Impairment
ASC 350 Step 1 test: reporting-unit fair value vs carrying amount; loss capped at goodwill.
ASC 842 Lease
Operating vs finance classification, ROU asset + liability schedule.
ASC 606 Revenue
Performance-obligation allocation + monthly recognition + deferred revenue.
BEPS Pillar 2
15% global minimum tax: per-jurisdiction ETR test, SBIE carve-out, top-up tax.
Transfer Pricing
Arm's-length interquartile range + adjustment check.
7 calculateurs
FP&A
Budget, prévision, effectifs
Budget vs Actual
Line-item variance with revenue/cost-aware favorable/unfavorable flagging and rollup summary.
Headcount Planner
Roles x quarters, fully-loaded cost (base + benefits + equity), department rollup, peak headcount.
Forecast Rollup
Departments x quarters with FX translation + intercompany eliminations.
13-Week Cash Flow
Direct-method rolling cash forecast: inflows, outflows, ending balance, LoC need.
Working Capital
DSO / DPO / DIO + Cash Conversion Cycle trend by period.
Month-end Close
Task list with owners, business-day timing, and status tracking.
KPI Dashboard
KPI tiles with targets and traffic-light status for leadership reviews.
Remplacez votre feuille de calcul
Sauvegardez vos scénarios, partagez-les avec votre équipe, exportez des PDFs soignés. 14 jours gratuits, sans carte.