Financial planning and analysis (FP&A) is the finance function that prepares budgets, forecasts, and performance reports and turns them into insights for business decisions. FP&A teams analyse variances between plan and actuals, model different scenarios, and advise leadership on costs, pricing, and investments. Unlike accounting, which records what has already happened, FP&A is forward-looking and works closely with sales, operations, and strategy teams.

If you're working out how to learn financial planning and analysis, combine three things: core concepts (budgeting, forecasting, variance analysis, management reporting), tool skills (Excel, Power BI, and financial modeling), and real-world practice with business cases. A structured financial planning and analysis course or certification gives you the framework, while 1:1 sessions with an experienced FP&A mentor — such as Asif Masani, an FP&A Manager at Coursera with prior Citi and EY experience — help you apply those concepts to your own career.

An FP&A job description typically includes preparing annual budgets and rolling forecasts, month-end variance analysis, management reporting and dashboards, financial modeling, and partnering with business heads on targets and cost control. Analyst roles focus more on Excel models and reporting, while manager and director roles focus on insights, storytelling, and influencing decisions. Most postings also ask for strong Excel skills, commerce or accounting fundamentals, and clear communication.

FP&A experience means hands-on work in planning and analysis activities — building budgets and forecasts, analysing plan vs actual performance, preparing reports and models, and supporting business decisions — rather than pure bookkeeping or compliance. It can be built in dedicated FP&A roles or adjacent areas like management reporting, business finance, or controller teams. Professionals from audit, accounting, or consulting backgrounds can position forecasting and business-partnering project work as genuine FP&A experience.

The FP&A skills needed at the analyst level are advanced Excel, financial modeling, budgeting and forecasting fundamentals, variance analysis, data visualisation tools like Power BI or Tableau, and accounting basics. Soft skills matter just as much — explaining numbers simply, meeting deadlines during reporting cycles, and working with non-finance stakeholders. As you grow senior, business partnering and storytelling become more valuable than technical tricks.

The most valued FP&A Excel skills are XLOOKUP/VLOOKUP, SUMIFS and INDEX-MATCH, pivot tables, dynamic charts, scenario and sensitivity analysis, and building driver-based budget and forecast models. Power Query for cleaning data and Power BI for dashboards are strong add-ons, and AI-assisted Excel workflows are increasingly used to speed up monthly reporting. Master these fundamentals before picking up niche add-ins.

To present FP&A skills for resume shortlisting, lead with quantified achievements — for example, "built a driver-based forecast for a ₹200 crore business unit" or "cut monthly reporting time by 30%" — instead of listing routine duties. Mirror the exact terms from the job description (budgeting, forecasting, variance analysis, Power BI) so recruiters and applicant tracking systems can spot them instantly. Getting your resume reviewed by someone who works in FP&A can expose gaps you would miss on your own.

If you're unsure how to prepare for an FP&A interview, work on three fronts: concepts (budgeting vs forecasting, variance analysis, working capital, unit economics), hands-on Excel and modeling tests, and your own stories told with numbers and outcomes. Research the company's business model so you can discuss what its leadership would care about, and practise answering out loud — a mock interview with an FP&A mentor is one of the fastest ways to close gaps before the real round.

Most FP&A interview questions and answers revolve around a few themes: "What is the difference between budgeting and forecasting?", "Walk me through a variance analysis", "How would you build a revenue or cost forecast?", "Which financial model have you built?", and behavioural questions on stakeholder conflicts or tight reporting deadlines. Structure every answer as situation → action → measurable result, and keep it under two minutes.

FP&A interview questions for freshers usually test fundamentals rather than corporate experience: definitions of budget vs forecast, how the three financial statements link together, basic variance analysis, simple Excel exercises, and why you chose FP&A over accounting or audit. Interviewers mainly assess concept clarity, Excel comfort, and learning attitude, so revise the basics and prepare a clear story about why finance business partnering interests you.

FP&A interview questions for experienced professionals go deeper into judgement: driver-based vs top-down forecasting, a time your forecast was wrong and how you corrected it, automating recurring reports, influencing a business decision through analysis, and handling pushback from senior stakeholders. Prepare four or five detailed stories from your own work, each backed by quantified business impact.

FP&A interview questions in Accenture and other large organisations typically test budgeting vs forecasting concepts, variance analysis on a sample P&L, Excel modeling proficiency, and scenario questions such as managing a cost overrun or supporting a global business unit. Expect multiple rounds — technical, managerial, and HR — along with questions on collaborating with international stakeholders across time zones. Preparing structured answers for each round keeps you consistent.

Financial planning and analysis jobs in India are concentrated in Mumbai, Pune, Bengaluru, Hyderabad, and the NCR, across IT and GCCs, BFSI, pharma, FMCG, and startups. Most financial planning and analysis jobs for freshers open at the analyst level, often through Big 4, shared-services, or GCC entry roles, while experienced professionals usually transition from accounting, audit, or business finance by demonstrating modeling and forecasting ability. Build visible Excel and modeling proof, keep your LinkedIn profile sharp, and network with FP&A professionals — referrals drive a large share of hiring.

The financial planning and analysis salary in India depends on city, company type, and experience: entry-level analysts typically start around ₹4–8 LPA, mid-level professionals roughly ₹9–18 LPA, and FP&A managers often earn ₹18–35 LPA or more, with GCCs, BFSI, and product companies paying at the higher end, while director-level roles go well beyond that. These are indicative ranges, so benchmark against your specific city and industry before negotiating an offer.

Rather than hunting for a financial planning and analysis book PDF of uncertain quality, build a short reading list of well-regarded FP&A, forecasting, and data-storytelling books and read one core title properly — many publishers share free sample chapters or summaries on their official pages. Follow FP&A practitioners who share practical frameworks online, and if you prefer guided reading, a book-chat session with an FP&A author or mentor helps you extract actionable takeaways instead of reading passively.