Free course · Foundation · 6 lessons · about 90 minutes
FP&A essentials: budgeting, forecasting and MIS
A practical, self-paced course for finance managers and analysts in Indian companies who plan, forecast and report to management. You will set up a planning calendar, build a driver-based budget, choose forecasting methods, explain variances with correct arithmetic, design MIS that leads to action, and support decisions on pricing, sourcing and investment.
What you will be able to do
- Describe the role of FP&A and set up an annual planning, forecasting and MIS calendar
- Build a driver-based budget covering revenue, headcount, opex and capex
- Choose between run-rate, driver-based, rolling and scenario forecasts and track their accuracy
- Calculate price, volume and mix variances and use a flexible budget to explain profit
- Design MIS packs with KPIs, unit economics and project profitability that drive action
- Support pricing, make-or-buy and investment decisions and present them clearly to a board
Lesson 1: The role of FP&A and the planning calendar
Accounting tells management what happened. FP&A (financial planning and analysis) tells them what is likely to happen next and what they can do about it. The work runs on a calendar, and a good calendar is half the job.
What FP&A actually does
- Plan: turn the business strategy into an annual budget with clear targets for each team.
- Forecast: update the expected outcome for the year as conditions change, so nobody is steering by an out-of-date budget.
- Report: produce monthly MIS (management information) that compares actuals with budget and forecast, and explains the gaps.
- Advise: work with sales, operations and leadership on decisions such as pricing, hiring, sourcing and capital spending.
The accounts team owns the numbers that have been booked. FP&A owns the view of the future and the explanation of performance. The two must reconcile: MIS actuals should tie to the trial balance, or the first meeting gets spent arguing about whose number is right.
Three cycles, one calendar
| Cycle | Frequency | Purpose | Typical output |
|---|---|---|---|
| Annual budget | Once a year, ahead of 1 April for most Indian companies | Set targets, allocate resources and agree accountability | Board-approved P&L, capex plan, headcount plan and cash flow, phased by month |
| Rolling forecast | Monthly or quarterly | Show the current best estimate of where the business will land | Updated full-year outlook, or the next 12 months on a rolling basis |
| Monthly MIS | Every month after close | Explain performance and trigger corrective action | KPI dashboard, P&L versus budget and forecast, commentary |
A sample budget calendar for an April–March year
| When | Step |
|---|---|
| Early December | Leadership agrees top-down targets and key assumptions: growth, pricing, inflation, exchange rates |
| Mid-December | FP&A issues the budget template, the assumption sheet and the timetable |
| January | Business heads submit bottom-up volumes, headcount, opex and capex requests |
| Early February | FP&A consolidates, compares bottom-up with the top-down target and runs review meetings |
| Late February | Revised version, phasing by month, cash flow and funding check |
| March | Board or management committee approval; budget loaded into the reporting system |
The dates are an illustration. What matters is that every step has an owner and a deadline, and that the budget is approved before the year starts, so April MIS can be compared against it.
Top-down versus bottom-up
A purely top-down budget is quick but has little ownership: managers treat the targets as someone else’s numbers. A purely bottom-up budget has ownership but tends to be padded, with sales targets set low and cost budgets set high. Most companies combine them: leadership sets the ambition, teams build the detail, and FP&A closes the gap through conversation, not by quietly changing cells.
The monthly rhythm
A workable rhythm is: books closed by working day 5, MIS pack and commentary by working day 8, review meeting by working day 10, and the forecast refreshed at the same time. If the close is slow, the MIS will always be late, so fix the close first. The Close the Books exercise is a useful warm-up.
Lesson check
Four questions. Get 3 right to complete the lesson. Your progress is saved in this browser.
Lesson 2: Building a driver-based budget
A driver-based budget links every major line to a business quantity people understand: units, price, headcount, square feet. When a driver changes, the budget updates itself, and conversations move from “why is this number ₹40 lakh?” to “do we really expect to sell 12,000 units?”.
Pick the drivers that move the numbers
| Line | Typical drivers |
|---|---|
| Revenue | Units × price; customers × revenue per customer; order book × execution rate |
| Material cost | Units × bill-of-materials cost, or a percentage of revenue |
| People cost | Headcount by grade × cost to company (CTC), timed by joining month and increment date |
| Opex | Fixed contracts (rent, AMC), activity-based items (freight per unit), discretionary items (marketing) |
| Capex | Project list with cost, timing and useful life, which drives depreciation |
Keep the list short. Ten good drivers explain most of a P&L; two hundred make the model fragile and nobody reviews them.
Worked example: Kaveri Pumps Pvt Ltd
Assumptions for the coming year (all figures exclude GST):
- Product sales: 12,000 pumps at ₹8,500 each.
- Service: 3,000 installed pumps on annual maintenance contracts at ₹4,000 each.
- Material: 50% of product revenue.
- People: 40 existing staff at an average CTC of ₹9,00,000 (after this year’s increment), plus 3 engineers joining on 1 October at ₹12,00,000 CTC each.
- Opex: rent ₹4,00,000 a month; freight 3% of product revenue; marketing ₹40 lakh; other admin ₹32 lakh.
- Capex: a machine costing ₹1.2 crore, in use from 1 October, depreciated straight-line over 10 years.
| Line | Working | ₹ lakh |
|---|---|---|
| Product revenue | 12,000 × ₹8,500 = ₹10,20,00,000 | 1,020.0 |
| Service revenue | 3,000 × ₹4,000 = ₹1,20,00,000 | 120.0 |
| Total revenue | 1,020 + 120 | 1,140.0 |
| Material | 50% × 1,020 | (510.0) |
| People | 40 × ₹9,00,000 = ₹3,60,00,000; plus 3 × ₹12,00,000 × 6/12 = ₹18,00,000 | (378.0) |
| Rent | ₹4,00,000 × 12 | (48.0) |
| Freight | 3% × 1,020 | (30.6) |
| Marketing and admin | 40 + 32 | (72.0) |
| EBITDA | 1,140 − 510 − 378 − 48 − 30.6 − 72 | 101.4 |
| Depreciation on new machine | ₹1.2 crore ÷ 10 × 6/12 | (6.0) |
EBITDA margin is 101.4 ÷ 1,140 = 8.9%. Notice the capex: the machine costs ₹120 lakh of cash this year but only ₹6 lakh hits the P&L. That is why every budget needs a cash flow and a capex plan alongside the P&L, not just a profit target. The depreciation calculator helps with the schedule. Useful lives in the books follow your accounting policy and the Companies Act, while tax depreciation follows separate rules under the income-tax law. confirm the current tax depreciation rates and section under the Income-tax Act, 2025 with your CA or the official portal.
Phasing by month
An annual number is not enough. Spread revenue across months using last year’s seasonality or the order book, place people cost by joining month, and put capex in the month cash goes out. Without phasing, the April MIS will show a “variance” that is only timing.
Habits that make the budget usable
- One assumption sheet: every driver lives in one place, with its owner and source.
- Sense-check against history: revenue per employee, material percentage and opex growth should be explainable against last year.
- Separate fixed and variable: it makes the flexible budget in lesson 4 possible.
Lesson check
Four questions. Get 3 right to complete the lesson. Your progress is saved in this browser.
Lesson 3: Forecasting methods and accuracy
A forecast is useful only if management trusts it. Trust comes from using a method that fits the business, explaining what changed, and measuring how close past forecasts came.
Four methods and when to use them
| Method | How it works | Best for | Watch out for |
|---|---|---|---|
| Run-rate | Extend year-to-date actuals for the remaining months | Stable, non-seasonal lines such as rent or salaries | Ignores seasonality, one-offs and known changes |
| Driver-based | Update the budget drivers (volume, price, headcount) with the latest view | Revenue, material and people cost | Needs disciplined input from business owners |
| Rolling 12-month | Every month or quarter, drop the period just finished and add a new one at the end | Businesses where the year-end is an artificial horizon | More effort; must be kept light to be sustainable |
| Scenario | Build base, downside and upside cases with different assumptions | Uncertain periods, funding decisions, large contracts | Too many scenarios confuse rather than inform |
Worked example: why simple run-rate misleads
Godavari Electricals reports revenue of ₹540 lakh for April to September. A simple run-rate doubles it: 540 × 2 = ₹1,080 lakh for the year. But last year the first half produced only 45% of annual revenue, because the second half has the festive and year-end peaks. A seasonality-adjusted forecast is 540 ÷ 0.45 = ₹1,200 lakh. The ₹120 lakh gap is the difference between telling the board “we will miss the budget” and “we are on track”. Always ask whether the period you are extending is typical.
Scenarios that help decisions
Keep to three cases and change only the assumptions that matter. For Godavari: base ₹1,200 lakh (last year’s seasonality holds); downside ₹1,050 lakh (a large dealer delays orders); upside ₹1,300 lakh (a pending tender is won). Then show what management would do in each case, such as holding hiring in the downside, and the trigger that tells you which case is unfolding.
Measuring forecast accuracy
Track every forecast against the actual that followed. Two measures are enough for most teams.
| Month | Forecast (₹ lakh) | Actual (₹ lakh) | Forecast − actual | Absolute error ÷ actual |
|---|---|---|---|---|
| Month 1 | 100 | 90 | +10 | 10 ÷ 90 = 11.1% |
| Month 2 | 95 | 100 | −5 | 5 ÷ 100 = 5.0% |
| Month 3 | 110 | 104 | +6 | 6 ÷ 104 = 5.8% |
| Total | 305 | 294 | +11 |
- Mean absolute percentage error (MAPE): (11.1% + 5.0% + 5.8%) ÷ 3 = 7.3%. It shows how far off you are on average, regardless of direction.
- Bias: total forecast minus total actual, 305 − 294 = +11, or 11 ÷ 294 = 3.7% over-forecast. Positive bias month after month means optimism is built into the process.
Errors in both directions can cancel out in a total, which is why you need both measures. Low MAPE with persistent bias usually points to a person or a team, such as sales always forecasting the deal that is “about to close”.
Lesson check
Four questions. Get 3 right to complete the lesson. Your progress is saved in this browser.
Lesson 4: Variance analysis and flexible budgets
“Revenue is ₹45,000 above budget” tells management almost nothing. Splitting the variance into price, volume and mix tells them whether they sold more, charged more, or sold a different combination, and each answer leads to a different action.
Worked example: Narmada Tiles, two products
| Budget units | Budget price | Budget revenue | Actual units | Actual price | Actual revenue | |
|---|---|---|---|---|---|---|
| Premium (A) | 1,000 | ₹500 | ₹5,00,000 | 900 | ₹520 | ₹4,68,000 |
| Standard (B) | 1,000 | ₹300 | ₹3,00,000 | 1,300 | ₹290 | ₹3,77,000 |
| Total | 2,000 | ₹400 avg | ₹8,00,000 | 2,200 | ₹8,45,000 |
Total revenue variance: ₹8,45,000 − ₹8,00,000 = ₹45,000 favourable. Now split it.
Price variance
(Actual price − budget price) × actual units.
A: (520 − 500) × 900 = +₹18,000. B: (290 − 300) × 1,300 = −₹13,000. Net ₹5,000 favourable.
Volume variance
(Total actual units − total budget units) × budget average price.
(2,200 − 2,000) × ₹400 = ₹80,000 favourable.
Mix variance
The budget mix was 50:50, so 2,200 units at budget mix would be 1,100 of each. Mix variance = (actual units − actual total at budget mix) × budget price.
A: (900 − 1,100) × 500 = −₹1,00,000. B: (1,300 − 1,100) × 300 = +₹60,000. Net ₹40,000 adverse.
Check and interpret
₹5,000 + ₹80,000 − ₹40,000 = ₹45,000, which agrees with the total. The story: the team sold 10% more tiles, but the shift towards the cheaper standard range gave back half of the volume gain. Price was broadly neutral. The action is about product mix and sales incentives, not price.
In practice, run the same analysis on contribution per unit rather than price, because a mix shift towards a low-margin product hurts profit more than revenue shows.
Flexible budgets
Comparing actual costs with a budget set for a different volume is misleading: of course costs are higher if you made more. A flexible budget restates the budget at the actual volume, using budget prices and costs.
| ₹ | Static budget (10,000 units) | Flexible budget (12,000 units) | Actual (12,000 units) |
|---|---|---|---|
| Revenue | 50,00,000 (@ ₹500) | 60,00,000 (@ ₹500) | 58,80,000 (@ ₹490) |
| Variable cost | (30,00,000) (@ ₹300) | (36,00,000) (@ ₹300) | (37,20,000) (@ ₹310) |
| Fixed cost | (12,00,000) | (12,00,000) | (12,50,000) |
| Profit | 8,00,000 | 12,00,000 | 9,10,000 |
- Total variance: 9,10,000 − 8,00,000 = ₹1,10,000 favourable. It looks like a good month.
- Volume variance: flexible minus static = ₹4,00,000 favourable (2,000 extra units × ₹200 budget contribution).
- Flexible-budget variances: actual minus flexible = ₹2,90,000 adverse, made up of selling price −₹1,20,000 (₹10 × 12,000), variable cost −₹1,20,000 (₹10 × 12,000) and fixed cost −₹50,000.
₹4,00,000 − ₹2,90,000 = ₹1,10,000. The flexible budget reveals the real message: volume was strong, but discounting and cost overruns gave away most of the benefit.
Lesson check
Four questions. Get 3 right to complete the lesson. Your progress is saved in this browser.
Lesson 5: MIS and KPI reporting that drives action
An MIS pack succeeds when a busy CEO can read it in ten minutes and know what to do next. That needs fewer numbers, the right numbers, and commentary that says “so what”.
What a monthly pack should contain
- One-page summary: five to eight KPIs with month, year-to-date, budget and latest forecast, plus three key messages.
- P&L versus budget and forecast: at the level management controls, not the full chart of accounts.
- Cash and working capital: cash balance, debtor and creditor days, inventory days, overdue receivables. Profit without cash is a warning sign.
- Business-specific views: unit economics, project profitability or segment results, depending on the business.
- Actions and owners: what was agreed last month, and whether it happened.
Unit economics
For businesses that sell many small orders, the most useful KPI is contribution per order or per customer. Example for Tapti Home Store, an online retailer:
| Per order | ₹ |
|---|---|
| Average order value (excluding GST) | 1,200 |
| Product cost | (540) |
| Delivery | (90) |
| Payment gateway at 2% | (24) |
| Returns allowance | (36) |
| Contribution per order | 510 (42.5%) |
If a customer places 3 orders a year, contribution per customer is ₹1,530. With a customer acquisition cost of ₹1,500, the business recovers its marketing spend in roughly a year. If delivery cost rises by ₹50 an order, contribution per customer falls by ₹150, which changes the marketing budget conversation.
Project and contract profitability in EPC businesses
In engineering, procurement and construction (EPC) businesses, the company-level P&L hides what matters: whether each contract will make its expected margin. Report every major project on one line.
| Project Indus Substation (₹ crore) | Original budget | Current estimate |
|---|---|---|
| Contract value | 50.0 | 50.0 |
| Cost incurred to date | 21.0 | |
| Estimated cost to complete | 24.0 | |
| Estimated total cost | 42.0 | 45.0 |
| Margin | 8.0 (16%) | 5.0 (10%) |
The margin has faded by 6 percentage points. Measured by cost, the project is 21 ÷ 45 = 46.7% complete, so revenue earned to date on a cost-based input method is 46.7% × 50 = ₹23.3 crore, and margin to date is ₹2.3 crore. If ₹26 crore has been billed, billing is about ₹2.7 crore ahead of revenue earned; if only ₹22 crore has been collected, ₹4 crore is sitting in receivables. Each of these numbers prompts a different question for the project manager. Where the estimate shows a loss on the whole contract, the accounting rules generally require the expected loss to be recognised straight away, so agree the treatment with your auditors early.
Commentary that drives action
Weak commentary repeats the table: “Revenue is ₹12 lakh below budget.” Strong commentary follows four steps: what happened, why, so what for the year, and now what, with an owner and a date.
Lesson check
Four questions. Get 3 right to complete the lesson. Your progress is saved in this browser.
Lesson 6: Business partnering and decision support
The most valued FP&A people are the ones the business calls before a decision, not after. That happens when you bring the right numbers to the question being asked, and present them in a way that leads to a decision.
Pricing: what volume does a discount need?
Yamuna Appliances sells a product at ₹1,000 with a variable cost of ₹600, so contribution is ₹400 a unit. At 10,000 units, total contribution is ₹40,00,000. Sales wants a 10% price cut to ₹900.
- New contribution: ₹900 − ₹600 = ₹300 a unit.
- Volume needed to stand still: ₹40,00,000 ÷ ₹300 = 13,333 units, a 33.3% increase.
A 10% price cut needs a one-third rise in volume just to keep the same contribution. That one calculation usually changes the discussion. Prices here exclude GST, which does not affect contribution.
Make or buy: only relevant costs count
A supplier offers a component at ₹250 a unit for 20,000 units a year. The in-house costing shows ₹270: material ₹120, labour ₹60, variable overhead ₹20 and allocated fixed overhead ₹70. It looks cheaper to buy, but the allocated fixed overhead (factory rent, management salaries) will not go away if you stop making the part.
| Per year | Make | Buy |
|---|---|---|
| Relevant cost per unit | ₹200 (120 + 60 + 20) | ₹250 |
| Cost for 20,000 units | ₹40,00,000 | ₹50,00,000 |
| Extra supervisor needed only if you make | ₹6,00,000 | – |
| Total relevant cost | ₹46,00,000 | ₹50,00,000 |
Making saves ₹4,00,000 a year. Before deciding, check the things the table cannot show: whether the capacity could earn more on another product (an opportunity cost), supplier quality and reliability, and whether labour is truly variable or would be paid anyway.
Investment requests
A good capital expenditure request answers the same questions every time:
- Why: the business problem or opportunity, and the option of doing nothing.
- Cash flows: incremental cash in and out over the asset’s life, including working capital and maintenance capex.
- Returns: NPV at the company’s hurdle rate, IRR and payback, worked the same way for every request.
- Sensitivity: what happens if volume is 20% lower or the project runs six months late.
- Follow-up: a post-investment review after a year, comparing results with the case that was approved.
The post-investment review is the step most companies skip, and it is the one that makes future requests honest.
Presenting to the board
- Answer first: open with the recommendation and the decision needed, then the support.
- One page per idea: a clear headline that states the message, not “Revenue analysis”.
- Round sensibly: ₹11.4 crore, not ₹11,40,23,516. Precision beyond what the decision needs is noise.
- Show the risks: boards trust a plan that names its weaknesses and the trigger points.
- Pre-wire: walk the CEO and key directors through the paper before the meeting so there are no surprises.
Lesson check
Four questions. Get 3 right to complete the lesson. Your progress is saved in this browser.
Final test and certificate
15 questions drawn from a bank, marked on the server. Score 11 or more (70%) for a certificate of completion with a public verification link and an “Add to LinkedIn” button.
Go to the final test- FEMA for importers
- Export compliance
- TDS and GST essentials
- Ind AS foundations
- Close and consolidation
- Internal controls and fraud
- Corporate finance essentials
- Treasury and cash management
- Cost and management accounting
- Import procurement & SCF
- EPC projects and tenders
- Companies Act compliance
- Payroll compliance
- IFRS, US GAAP and Ind AS
- Excel for finance teams
- AI for finance teams
General information for learning, not professional advice. Laws, rates and standards change: confirm with the official source or your adviser before acting. Last reviewed 15 November 2026.