FP&A и budget на собесе финансового аналитика
Зачем FP&A на собесе финаналитика
FP&A (Financial Planning & Analysis) — основная функция корпоративного финаналитика. Annual budget, quarterly forecasting, variance analysis, business partnering. На собесе финаналитика кейс типичный — «built budget на следующий год для X-направления».
Слабый ответ — «возьму прошлогодний + 10%». Сильный — про top-down / bottom-up, driver-based forecasting, variance analysis, rolling forecasts.
Что такое FP&A
Functions:
- Budget — annual plan на год вперёд
- Forecast — updates прогноза в течение года (quarterly / monthly)
- Variance analysis — план vs факт, root cause
- Business partnering — поддержка продуктовых / sales команд
Outputs:
- Annual budget document
- Quarterly forecasts
- Monthly P&L reviews
- Strategic plans (3-5 years)
Budget process
Stages типичного annual budget cycle:
Strategy alignment (Q3 prior year): business goals → financial targets.
Top-down targets (October): CFO / CEO set revenue + EBITDA targets.
Bottom-up build (October-November): команды строят свои части (sales forecast, headcount plan, opex).
Iteration (November-December): консолидация, gap к target → cuts / additions.
Approval (December): board / CEO approves.
Communication (January): budget rolled out, target setters.
Monthly review (year): variance analysis.
Top-down vs bottom-up
Top-down:
- Senior leadership sets targets
- Departments distribute
- Faster
- Risk: unrealistic
Bottom-up:
- Teams build assumptions
- Aggregates до company
- More accurate
- Slower, sandbagging risk
Best practice: hybrid. Top-down anchors → bottom-up details → reconcile.
Driver-based forecasting
Не считать строки P&L одну за другой. Built model on drivers.
Пример Карьерника:
- Driver: WAU (weekly active users)
- Revenue = WAU × paid_conversion × ARPPU
- Marketing spend = WAU growth × CAC
- COGS = LLM cost per active user × WAU
Изменение WAU прогноза → автоматически revenue / costs.
Преимущества:
- Transparent assumptions
- Sensitivity легко делать
- Better business conversations («что если WAU вырастет 2x?»)
Variance analysis
Plan vs actual каждый месяц.
Variance: actual - budget.
Variance %: (actual - budget) / budget × 100%.
Variance categories:
- Volume variance: разница из-за количества (orders, customers)
- Price variance: разница из-за цены / unit
- Mix variance: изменение product mix
- Timing variance: revenue / cost shifted между periods
Decomposition: total variance = volume + price + mix + timing.
Reporting: waterfall chart показывает contribution каждого driver.
Rolling forecast
Вместо «annual budget, set in stone» — rolling 12-month forecast.
Approach:
- Каждый месяц / квартал обновлять прогноз на следующие 12 месяцев
- Drop oldest, add newest period
- Continuous learning
Преимущества:
- Adapts к changing reality
- Less «budget season» pressure
- Better для volatile industries
Минусы:
- Continuous workload
- Coordination challenge с long-term plans
В современных растущих компаниях rolling forecast > traditional budget.
Forecasting techniques
Naive:
- Last period × growth %
- Simple, often biased
Trend extrapolation:
- Linear / exponential trend from history
- ARIMA / Prophet (если data достаточно)
Driver-based:
- Model relationships между drivers
- Forecast drivers → output
ML-based:
- Random Forest / Gradient Boosting для seasonal + factors
- Часто для revenue forecasting
Sensible mix: drivers + manual judgment overrides.
Reporting cadence
Monthly:
- Monthly P&L
- Variance vs budget
- Updated forecast
- Manager review meeting
Quarterly:
- Board reporting
- Forecast revision
- Strategic review
Annually:
- Budget cycle
- Long-range planning
Tools
Excel / Google Sheets: still dominant в budget.
SAP / Oracle / Anaplan: enterprise planning suites.
Workday Adaptive / Vena / Pigment: modern FP&A platforms.
В РФ: часто Excel + 1C интеграция. Modern startups → Sheets + Python / dbt.
Типичные вопросы
«Спланируй бюджет на следующий год для нового продукта»
- Drivers: users, ARPU, conversion, churn.
- Revenue forecast: bottom-up build.
- Costs: COGS, marketing, headcount.
- P&L assembly.
- Sensitivities + scenarios.
«Variance: actual revenue 20% below budget. Что делаешь?»
- Decompose: volume vs price vs mix.
- Drill: какие segments / channels / products.
- Investigate: что произошло (один-time vs structural).
- Update forecast.
- Action plan (recovery? cuts?).
«Rolling forecast vs annual budget?»
Modern: rolling 12-month. Old-school: annual + quarterly review. Best в стартапах — rolling из-за volatility.
«Driver-based vs line-item forecasting?»
Driver-based лучше: transparent, sensitivities easy, business conversations. Line-item — для small / stable companies.
Частые ошибки
- «Last year + 10%». Без drivers — no insights.
- Budget vs reality disconnect. Annual rigid budget breaks при rapid change.
- No variance analysis. Без — budget = wish list, не plan.
- Sandbagging. Teams underforecast чтобы overachieve. Hybrid approach mitigates.
- No business partnering. Finance в isolation от bizdev team.
FAQ
FP&A или corporate finance?
FP&A — operational planning. Corporate finance — M&A, treasury, IR. Career paths overlap.
Финансовый аналитик vs FP&A analyst?
В стартапах overlap. В крупных — FP&A specific, finanalitik broader.
Сколько занимает budget?
3-4 месяца для крупных, 1-2 месяца для startup.
Какие skills senior FP&A?
Driver-based modeling, business partnering, communication, strategic thinking.
Где научиться?
CFA для теории. Wall Street Prep / BIWS для practical models. На практике — практика лучше всего.