Markdown Editor
Mở trình soạn thảo

Bộ mẫu chuyên viên FP&A

Ngân sách năm, dự báo cuốn chiếu, phân tích chênh lệch, báo cáo quản trị tháng, unit economics và đặc tả mô hình tài chính.

Bước 1

Lập kế hoạch

  1. Annual Budget Template (FP&A Operating Plan)

    Đầy đủ

    Annual budget pack: targets, calendar, assumptions, revenue drivers, headcount, opex, capex, three statements, sensitivities, phasing, sign-off

    FP&A practice; FAST Standard 02c (by reference)

  2. Rolling Forecast Template (Driver-Based, Forecast Accuracy)

    Đầy đủ

    Driver-based rolling forecast: horizon, driver owners, bridges, revenue, cost, headcount and cash outlook, scenarios, MAPE and bias, decisions

    FP&A practice; Beyond Budgeting principles (names); FAST Standard 02c (by reference)

  3. 13-Week Cash Flow Forecast Template (Direct Method)

    Đầy đủ

    Direct-method weekly cash forecast: opening cash and facilities, receipts and disbursements by category, weekly roll, headroom vs minimum, variance and bridge, levers

    Corporate treasury practice (direct method); IAS 7 (name only)

  4. Investment Appraisal Template (NPV, IRR, MIRR, Payback)

    Đầy đủ

    Options, incremental cash flows, assumptions, WACC and hurdle, NPV, IRR, MIRR, payback, PI (KaTeX), sensitivity, switching values, scenarios

    Green Book 2026 (UK public sector); OMB Circular A-94 (1992, reinstated 2025)
Bước 2

Giám sát

  1. Budget Variance Analysis Template (Price, Volume, Mix)

    Đầy đủ

    Budget versus actual: thresholds, price, volume, mix and FX variances, margin, opex, headcount, capex and cash bridges, root causes, actions

    Management accounting practice (price, volume, mix variance)

  2. Monthly Management Report Template (CFO Pack, KPIs, Covenants)

    Đầy đủ

    Headlines, KPI dashboard, P&L vs budget and prior year, balance sheet, cash and net debt, covenant headroom, segments, forecast, MPM/APM reconciliations

    ESMA APM Guidelines (ESMA/2015/1415); SEC Regulation G and Reg S-K Item 10(e); IFRS 18 (name)
Bước 3

Đánh giá và an toàn

  1. Unit Economics Analysis Template (CAC, LTV, Payback, Cohorts)

    Đầy đủ

    Unit definition, revenue and contribution per unit, CAC by channel, cohort retention, discounted LTV (KaTeX), payback, sensitivities, reconciliation to ledger

    SEC Release 33-10751 (KPI disclosure); SEC Regulation G; ESMA APM Guidelines
Bước 4

Xây dựng

  1. Financial Model Specification Template (FAST Standard)

    Đầy đủ

    Model purpose, timeline, sheet map, inputs register, calculation blocks, outputs, FAST conventions, scenarios, checks, version control, tests, limitations

    FAST Standard 02c (CC BY 4.0); ICAEW Financial Modelling Code (name)