Accounting & FinanceView Domain Hub →

Financial Analysis, Budgeting & FP&A

Financial Planning & Analysis (FP&A) drives strategic corporate decisions. Master 3-statement financial modeling (P&L, Balance Sheet, Cash Flow), rolling annual budgets, revenue/expense variance analysis, Discounted Cash Flow (DCF) valuation, unit economics (CAC, LTV, payback), and Power BI executive CFO dashboards.

Curated 2026 Curriculum GuideProject-Based Track

Advanced Excel ModelingPower BIAnaplan / Adaptive InsightsTableauThink-Cell

🇮🇳 Indian Market Benchmark

Expected CTC Range₹6.5L – ₹24.0L LPA

Estimated Timeline8 – 12 Weeks

Demand Scope20,000+ Openings across Startups, MNCs & GCCs

Experience LevelIntermediate

Top Hubs:Bengaluru, Mumbai, Delhi NCR, Hyderabad, Pune, Chennai, Remote

Explore Career Compass Match

Core Track Highlights

High-prestige, high-impact corporate finance track sitting at the right hand of the CFO and CEO

High demand across funded startups, tech SaaS firms, FMCG giants, and Fortune 500 GCCs

Direct stepping stone to VP of Finance, Head of Strategic Finance, and CFO

Technical Architecture & Concept Breakdown

Corporate FP&A & Strategic Financial Forecasting Model

Historical data ingestion, dynamic 3-statement forecast, budget vs actual variance, and DCF scenario valuation.

Financial Analysis, Budgeting & FP&A Core Architecture Diagram — Figure: Structural Systems & Execution Lifecycle for Financial Analysis, Budgeting & FP&A

3-Statement Financial Modeling

Dynamically linking Income Statement, Balance Sheet, and Cash Flow with debt schedules and working capital.

Budgeting & Rolling Forecasts

Zero-Based Budgeting (ZBB), quarterly rolling forecasts, and departmental OPEX/CAPEX.

Variance Analysis & Root Causes

Decomposing price, volume, and mix variances against annual operating plans (AOP).

Valuation & Strategic Scenario Analysis

Discounted Cash Flow (DCF), WACC estimation, sensitivity tables, and Monte Carlo models.

Structured Phase-by-Phase Syllabus

Focus on build-by-doing milestones rather than passive video consumption.

Weeks 1 - 4

Phase 1: Dynamic 3-Statement Financial Modeling in Excel

Building integrated 3-statement models: Revenue drivers, COGS, OPEX schedules, and depreciation waterfall
Working capital schedule (DSO, DPO, DIO) and circular debt interest waterfall calculations
Excel best practices: Dynamic named ranges, INDEX-MATCH, XLOOKUP, Data Tables, and error checking

🎯 Milestone Proof Project: Construct a fully dynamic, 5-year 3-Statement Financial Model for an Indian SaaS or D2C company.

Weeks 5 - 8

Phase 2: Budgeting, Variance Analysis & Unit Economics

Annual Operating Plan (AOP) creation, Zero-Based Budgeting (ZBB), and quarterly rolling forecast updates
Budget vs Actual variance decomposition: Price variance, Volume variance, and Mix variance
SaaS and startup unit economics: CAC, LTV, Burn Multiple, Net Revenue Retention (NRR), and Magic Number

🎯 Milestone Proof Project: Create a Monthly Budget vs Actual Executive Variance Dashboard with automated waterfall charts.

Weeks 9 - 12

Phase 3: Valuation (DCF, Multiples) & Executive Dashboarding

Discounted Cash Flow (DCF) valuation: Unlevered Free Cash Flow (FCFF), Terminal Value, and WACC computation
Comparable Company Analysis (Trading Comps) and Precedent Transactions (EV/EBITDA, P/E, EV/ARR)
Building interactive CFO Executive Dashboards in Power BI with drill-through capability

🎯 Milestone Proof Project: Perform an end-to-end DCF Valuation & Sensitivity Matrix for a publicly traded Indian tech enterprise.

Technical Interview Questions & Answers

Q1: Walk me through how a ₹100 increase in Depreciation impacts all three financial statements (assuming a 25% tax rate).

(1) Income Statement: Operating Income (EBIT) decreases by ₹100. Taxes decrease by ₹25 (at 25% tax rate). Net Income decreases by ₹75. (2) Cash Flow Statement: Net Income starts ₹75 lower, but since Depreciation is a non-cash expense, we add back ₹100 under Operating Activities. Cash Flow from Operations increases by ₹25. (3) Balance Sheet: Cash increases by ₹25, PP&E decreases by ₹100 (net Assets down by ₹75). Retained Earnings on the Liabilities & Equity side decreases by ₹75 (from Net Income), so the Balance Sheet remains perfectly in balance.

Frequently Asked Questions

What is the difference between Accounting and FP&A?

Accounting records historical financial transactions accurately following statutory standards (backward-looking); FP&A uses financial data to forecast future performance, optimize budgets, and guide strategic capital allocation (forward-looking).