La biblioteca
55 calculadoras hechas para equipos de finanzas
Libros de trabajo validados por revisores para proyectos de capital, además de una biblioteca completa que cubre valoración, contabilidad fiscal, FP&A y unit economics. Regístrate para guardar escenarios y exportar a PDF.
21 calculadoras
Cuaderno del proyecto
Calculadoras validadas por el revisor y extensiones específicas del proyecto
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 calculadoras
Planificación de capital
Programas de amortización y financiación
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 calculadoras
Ventas y margen
P&G, contribución, economía unitaria
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 calculadoras
Valoración
DCF, WACC, análisis de rentabilidad
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 calculadoras
Fiscalidad y contabilidad
§174, depreciación, impuesto diferido
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 calculadoras
FP&A
Presupuesto, previsión, plantilla
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.
Reemplaza tu hoja de cálculo
Guarda escenarios, compártelos con tu equipo, exporta PDFs pulidos. Gratis 14 días, sin tarjeta.