MFA-216 Financial Modelling Notes cover all 4 units of the GGSIPU MBA (Financial Analysis) Semester 4 elective in 55 pages: Excel functions and what-if tools, a three-statement model, cash ratios and non-cash valuations, and DCF valuation. They include 26 worked illustrations, 22 figures and 66 exam questions, mapped to the syllabus applicable from 2021-22 onwards.
Written by Prateek Talwar, Founder, Unnati Educations (ACS, ICSI) · Reviewed by Sheetal Kirola, Academic Head, M.Ed. (academic review) · Checked against MBA (FA) Scheme and Syllabus 2021-22 onwards · Updated 30 October 2026 · Editorial policy
Scheme: MBA (FA) 2021-22 onwards | Applies to: session 2021-22 onwards | Verified against: official PDF, 30 Oct 2026
MFA-216 Financial Modelling at a glance: GGSIPU MBA (FA) Sem 4 credits, units and exam pattern
MFA-216 is one of twelve Semester 4 Financial Analytics electives, of which each student picks four; its objective is applying MS-Excel to financial modelling. Most students looking for MFA-216 Financial Modelling IPU notes first ask if it is compulsory. It is not.
| Code and title | MFA-216 Financial Modelling |
|---|---|
| Course and semester | MBA (Financial Analysis), Semester 4 |
| Category and credits | Discipline Specific Elective · L 3 · 3 credits |
| Marks | 100: 50 internal + 50 end-term |
| Internal 50 | Two class tests (15 + 15) + assignments, presentation or viva 20 |
| Applies to | Scheme and syllabus 2021-22 onwards |
| End-term pattern | 50-mark written exam; question pattern not printed in the official PDF |
| Units | 4 units: 11 + 10 + 10 + 11 = 42 teaching hours |
| Paired lab | None; the Semester 4 lab is MFA-206 Finance Lab-II (NUES, P 4, 2 credits) |
Compare it with the other GGSIPU MBA (FA) Semester 4 papers. Pass and re-appear rules follow Ordinance 11 on examinations.
MFA-216 Financial Modelling Notes unit-wise: 26 worked illustrations and 66 exam questions across 4 units
These GGSIPU MBA (FA) Sem 4 Financial Modelling notes carry one company, ABC Ltd, from the Unit 2 forecast to the Unit 4 DCF. Other papers are under GGSIPU MBA (FA) notes.
MFA-216 Unit 1: Excel as a tool in Financial Modelling
Pages 4 to 18 build the Excel toolkit: references, the six function families, charts, conditional formatting, Advanced Filter, macros, what-if tools, Solver and pivot tables. Seven sections, 8 illustrations (EMI, NPV, IRR, break-even, product mix), 5 figures, 10 short and 7 long questions.
Quick look: what-if tools (from page 16)
| Tool | What it does |
|---|---|
| Goal Seek | One input, one target, no constraints |
| Solver | Many inputs, an objective, constraints |
| Data Table | Output for a range of one or two inputs |
| Scenario Manager | Switches between named input sets |
Quick look: what-if tools (from page 16)
- Tool
- Goal Seek
- What it does
- One input, one target, no constraints
- Tool
- Solver
- What it does
- Many inputs, an objective, constraints
- Tool
- Data Table
- What it does
- Output for a range of one or two inputs
- Tool
- Scenario Manager
- What it does
- Switches between named input sets
MFA-216 Unit 2: Financial Modelling Basic Concepts
Pages 19 to 31 turn tools into a model: CHOOSE and XNPV, components, template rules, drivers, schedules and a balancing three-year ABC Ltd model (pages 24 and 25), then ratios, DuPont, cases and Monte Carlo. 4 more illustrations, 7 figures, 10 short and 6 long questions.
Quick look: ABC Ltd's three cases (from page 28)
| Driver | Worst | Base | Best |
|---|---|---|---|
| Revenue growth | 5% | 12% | 18% |
| COGS % of revenue | 63% | 60% | 58% |
| FY28 PAT | 62.9 | 98.4 | 132.5 |
| Probability | 0.25 | 0.50 | 0.25 |
Quick look: ABC Ltd cases, ₹ crore (from page 28)
- Driver
- Revenue growth
- Worst
- 5%
- Base
- 12%
- Best
- 18%
- Driver
- COGS % of revenue
- Worst
- 63%
- Base
- 60%
- Best
- 58%
- Driver
- FY28 PAT
- Worst
- 62.9
- Base
- 98.4
- Best
- 132.5
- Driver
- Probability
- Worst
- 0.25
- Base
- 0.50
- Best
- 0.25
MFA-216 Unit 3: Cash Ratios and Non-Cash Valuations
Pages 32 to 42 cover cash and cash-flow ratios, a menu-driven model, and a US subsidiary's derived cash flow under IAS 7, Ind AS 7 and US GAAP. Target Ltd is valued by adjusted NAV, DDM, P/E and four peers. 7 illustrations, 4 figures, 10 short and 6 long questions.
Quick look: matching multiples (from page 40)
| Multiple | Built as | Best for |
|---|---|---|
| P/E | Equity value ÷ PAT | Stable, profitable firms |
| P/B | Equity value ÷ book equity | Banks, NBFCs, insurers |
| EV/EBITDA | EV ÷ EBITDA | Capital-intensive firms |
| EV/Sales | EV ÷ revenue | Loss-making or early-stage firms |
Quick look: multiples (from page 40)
- Multiple
- P/E
- Built as
- Equity value ÷ PAT
- Best for
- Stable, profitable firms
- Multiple
- P/B
- Built as
- Equity value ÷ book equity
- Best for
- Banks, NBFCs, insurers
- Multiple
- EV/EBITDA
- Built as
- EV ÷ EBITDA
- Best for
- Capital-intensive firms
- Multiple
- EV/Sales
- Built as
- EV ÷ revenue
- Best for
- Loss-making or early-stage firms
MFA-216 Unit 4: Forecasting Methods and Initial Valuations
Pages 43 to 54 review forecasting, the sustainable growth rate, Rappaport's value drivers and linkage problems. FCFF, APT, CAPM (derived in five steps) and terminal value give ₹37.5 per share against a ₹34 market price. 7 illustrations, 6 figures, 10 short and 7 long questions.
Quick look: FY26 revenue forecasts (from page 44)
| Method | FY26 | Excel |
|---|---|---|
| 3-year moving average | 466.7 | =AVERAGE() |
| Linear trend | 537.5 | =FORECAST.LINEAR() |
| CAGR 8.56% | 542.8 | =RRI(4,360,500) |
| Driver-based, 12% | 560.0 | =F2*(1+Growth) |
Quick look: FY26 revenue, ₹ crore (from page 44)
- Method
- 3-year moving average
- FY26
- 466.7
- Excel
=AVERAGE()
- Method
- Linear trend
- FY26
- 537.5
- Excel
=FORECAST.LINEAR()
- Method
- CAGR 8.56%
- FY26
- 542.8
- Excel
=RRI(4,360,500)
- Method
- Driver-based, 12%
- FY26
- 560.0
- Excel
=F2*(1+Growth)
Unlevering and re-levering beta in financial modelling: excerpt from page 50 of the MFA-216 notes
Excerpt from page 50
Asset beta and equity beta
A firm's equity beta, also called the levered beta, carries two kinds of risk: the business risk of what the firm does and the financial risk that comes from its debt. The asset beta, or unlevered beta, carries business risk only. It is the beta the same firm would have if it had no debt at all.
This matters because an unlisted company or a division has no share price, so it has no market beta to regress. Analysts solve this in three moves. They take the equity betas of listed peers, unlever each one at that peer's own debt-equity ratio, and average the resulting asset betas. The average is then re-levered at the target's own capital structure. The notes use the Hamada or Modigliani-Miller relation and assume a debt beta of zero.
The two formulas
Unlever: βa = βe ÷ [1 + (1 − t) D/E]. Re-lever: βe = βa × [1 + (1 − t) D/E]. Here t is the tax rate and D/E is the debt-equity ratio of the company whose beta is being converted.
Illustration: from peer beta to ABC Ltd's WACC
Peer equity betas, unlevered at their own D/E with tax at 25%, average to an asset beta of 0.80. ABC Ltd targets a D/E of 0.25, so its equity beta is 0.80 × [1 + 0.75 × 0.25] = 0.80 × 1.1875 = 0.95.
With a risk-free rate of 7% and a market risk premium of 6%, CAPM gives Ke = 7% + 0.95 × 6% = 12.7%. The pre-tax cost of debt is 10%, or 7.5% after tax. A D/E of 0.25 means debt is 0.25 ÷ 1.25 = 20% of value and equity is 80%.
WACC = 0.80 × 12.7% + 0.20 × 7.5% = 10.16% + 1.50% = 11.66%, which the model rounds to 11.7%.
Cost of capital in Excel
Equity beta =SLOPE(Stock_Returns, Nifty_Returns)
Asset beta =Beta_e/(1+(1-Tax)*D_E)
Re-levered beta =Beta_a*(1+(1-Tax)*Target_D_E)
Ke =Rf+Beta_e*MRP
WACC =Ke*E_V+Kd*(1-Tax)*D_VKeeping each step on its own row, with named inputs, lets a reviewer trace the WACC back to the peer betas without opening a single nested formula.
Do the MFA-216 notes cover the full GGSIPU syllabus?
Yes. Every official topic in all four MFA-216 units has a matching section, including the CAPM derivation.
| Official unit | Official topics | In the notes | Status |
|---|---|---|---|
| I: Excel as a tool in Financial Modelling | Excel commands; maths, logical, look up, date, text, financial functions; charts, conditional formatting, sort, filter; formulas, macros; what if analysis, pivot, scenario, goal seek, solver | Sections 1-7, pp 4-17 | Covered |
| II: Financial Modelling Basic Concepts | Advanced functions; components, template, historical data, drivers; schedules and statements; valuation approaches; ratios; cases, sensitivity, probabilistic analysis | Sections 1-7, pp 19-30 | Covered |
| III: Cash Ratios and Non-Cash Valuations | Cash ratio; menu model and accounting statement; key ratios; international cash flow; accounting methods, DDM, EPS and multiples, EV/EBITDA, EV/Sales, peer groups | Sections 1-7, pp 32-41 | Covered |
| IV: Forecasting Methods and Initial Valuations | Forecasting; strategy, key drivers; linkages; free cash flow; bonds, APT, CAPM, betas, derivation; terminal value; equity valuation vs share price | Sections 1-6, pp 43-53 | Covered |
MFA-216 official units mapped to the notes
- Official unit
- I: Excel as a tool in Financial Modelling
- Official topics
- Excel commands; maths, logical, look up, date, text, financial functions; charts, conditional formatting, sort, filter; formulas, macros; what if analysis, pivot, scenario, goal seek, solver
- In the notes
- Sections 1-7, pp 4-17
- Status
- Covered
- Official unit
- II: Financial Modelling Basic Concepts
- Official topics
- Advanced functions; components, template, historical data, drivers; schedules and statements; valuation approaches; ratios; cases, sensitivity, probabilistic analysis
- In the notes
- Sections 1-7, pp 19-30
- Status
- Covered
- Official unit
- III: Cash Ratios and Non-Cash Valuations
- Official topics
- Cash ratio; menu model and accounting statement; key ratios; international cash flow; accounting methods, DDM, EPS and multiples, EV/EBITDA, EV/Sales, peer groups
- In the notes
- Sections 1-7, pp 32-41
- Status
- Covered
- Official unit
- IV: Forecasting Methods and Initial Valuations
- Official topics
- Forecasting; strategy, key drivers; linkages; free cash flow; bonds, APT, CAPM, betas, derivation; terminal value; equity valuation vs share price
- In the notes
- Sections 1-6, pp 43-53
- Status
- Covered
Official source: MBA (Financial Analysis) scheme and syllabus, 2021-22 onwards. MFA-216 is on page 74 of the PDF; marks and credits are on pages 4 and 8.
The PDF gives no unit-wise marks, so we never guess a weightage. Every course in GGSIPU notes is mapped to its official PDF this way.
How to write MFA-216 answers: Excel syntax lines, worked valuations and long theory answers
MFA-216 is a written paper, yet most marks reward Excel thinking: you write formulas on paper exactly as you would type them into a worksheet cell. The notes' exam tips point to three habits.
1. Write the syntax, then one line on why. Give the full syntax, such as =PMT(rate, nper, pv, [fv], [type]), then what it returns. The page 9 tip adds two lines examiners look for: Excel treats cash going out as negative, and NPV treats its first value as end of period 1, so the initial outlay is added outside the function.
2. Show every working step in a valuation. State the formula, put in the numbers, give the answer with its unit (₹ crore, %, times), then one line of interpretation. The page 51 tip adds a cross-check: compare the Gordon terminal value with an exit multiple and comment if the implied growth looks too high.
3. Structure long theory answers. For ratio questions, group the ratios, give each formula with a one-line reading, and end with limitations such as historical data and accounting policies (page 35). For model design, the page 22 tip suggests "garbage in, garbage out" and blue, sourced inputs on one sheet. For a case-based question, end with a recommendation, as the notes do on page 52 when the DCF value of ₹37.5 is compared with the ₹34 market price.
Worked example (page 10): a project costs ₹1,00,000 and returns ₹30,000, ₹40,000, ₹50,000 and ₹20,000 over four years at a 10% cost of capital.
=NPV(10%, B2:B5) + B1 → 1,11,557 − 1,00,000 = ₹11,557
=IRR(B1:B5) → 15.32%Always close with the decision: NPV is positive and the IRR is above the 10% cost of capital, so the project is accepted. Practise this format on the GGSIPU MBA (FA) important questions.
MFA-216 exam corner: 40 short-answer and 26 long-answer exam questions by unit
Each unit ends with practice questions labelled 2–5 Marks and 10–15 Marks; answers are built from the unit text.
| Unit | Short (2–5 Marks) | Long (10–15 Marks) | Illustrations |
|---|---|---|---|
| Unit 1 | 10 | 7 | 8 |
| Unit 2 | 10 | 6 | 4 + worked model |
| Unit 3 | 10 | 6 | 7 |
| Unit 4 | 10 | 7 | 7 |
MFA-216 exam questions and worked illustrations per unit
- Unit
- Unit 1
- Short (2–5 Marks)
- 10
- Long (10–15 Marks)
- 7
- Illustrations
- 8
- Unit
- Unit 2
- Short (2–5 Marks)
- 10
- Long (10–15 Marks)
- 6
- Illustrations
- 4 + worked model
- Unit
- Unit 3
- Short (2–5 Marks)
- 10
- Long (10–15 Marks)
- 6
- Illustrations
- 7
- Unit
- Unit 4
- Short (2–5 Marks)
- 10
- Long (10–15 Marks)
- 7
- Illustrations
- 7
The MFA-216 notes list 40 short-answer and 26 long-answer exam questions across 4 units, plus 26 worked illustrations.
Unit 1: Why is the initial outlay added outside NPV?
Pointer: NPV discounts its first value as year 1, so the year 0 outlay is added separately (page 9).
Unit 2: Find receivables if revenue is ₹730 crore and debtor days are 40.
Pointer: revenue × days ÷ 365 (page 22) = 730 × 40 ÷ 365 = ₹80 crore.
Unit 3: D0 = ₹4, g = 6%, ke = 14%. Value it by Gordon's model.
Pointer: always find D1 first. D1 = ₹4.24; P0 = 4.24 ÷ 0.08 = ₹53 (formula on page 38).
Unit 4: Distinguish between FCFF and FCFE.
Pointer: FCFF is discounted at WACC to enterprise value; FCFE, after interest and net borrowing, at Ke to equity value (page 47).
More practice sits in the MFA-216 important questions.
Who writes and checks the MFA-216 modelling notes?
- Prateek Talwar, author: Founder, Unnati Educations; Associate Company Secretary (ACS), ICSI, membership no. 58704 since 15 May 2019; B.Com, University of Delhi (School of Open Learning), 2012. Author profile
- Sheetal Kirola, reviewer: Academic Head, Unnati Educations; M.Ed.; 7 years of experience. Her role here is academic review: language, clarity and unit layout. Reviewer profile
The 2026-27 edition is mapped to the 2021-22 onwards scheme and its four unit titles. Updated 30 October 2026 under our editorial policy.
The same team prepares GGSIPU important questions for each course it covers.
MFA-216 and the GGSIPU MBA (FA) Sem 4 papers it connects to
MFA-216 has no paired lab; for all papers, see the GGSIPU MBA (FA) syllabus.
The closest link is MFA-206 Finance Lab-II, an internally evaluated NUES lab. Its outline names XNPV, PMT and INDEX MATCH (Unit 1, pages 7 to 9) and DDM, CAPM and APT valuation (pages 38 to 50).
Units 3 and 4 lead into MFA-210 Equity Valuation; Unit 2's Monte Carlo work supports MFA-214 Risk Management; the page 53 case touches MFA-212 Merger, Acquisition & Corporate Restructuring.
Other Semester 4 papers: MFA-202 Project Dissertation, MFA-204 Corporate Social Responsibility Human Values & Ethics, MFA-208 Technical Analysis, MFA-218 FinTech, MFA-220 Financial Derivatives, MFA-222 Strategic Financial Management, MFA-224 International Accounting & Reporting, MFA-226 Sustainable Finance, MFA-228 Investment Banking and MFA-230 Forensic Finance.
MFA-216 modelling notes FAQs
How do I get the full MFA-216 notes?
Message Unnati Educations on WhatsApp at 9899436384 and mention the paper code MFA-216. The full notes are sold only as a printed book, not as a PDF, so they are posted to your address. Delivery takes a maximum of 5 to 7 days, depending on your location. Check the watermarked sample PDF at the top of this page first.
Is MFA-216 Financial Modelling compulsory in MBA (FA) Semester 4?
No. MFA-216 is one of twelve Discipline Specific Electives in the Semester 4 Financial Analytics list, and the scheme asks each student to select any four. Confirm with your college or institute which electives it actually runs this year. If you choose it as an elective, MFA-216 carries 3 credits with three lecture hours a week.
How is MFA-216 marked, and what is the passing mark?
MFA-216 is marked out of 100: 50 internal and 50 end-term. The internal 50 comes from two class tests of 15 marks each and 20 marks for assignments, presentations, viva or class participation. The MBA (FA) scheme PDF does not print a pass percentage, so check GGSIPU Ordinance 11 on ipu.ac.in for end-term minimums and re-appear rules.
Do the MFA-216 notes teach Excel step by step?
Yes, for the tasks the syllabus names. Seven "Excel steps" boxes cover Advanced Filter, recording a macro, a two-variable Data Table, a model template, Monte Carlo simulation, a menu-driven ratio model and key drivers. Formula boxes give ready lines for scenario switches, revolver draws, ratio sheets, DDM and cost of capital, so you can rebuild each model.
Which MFA-216 unit has the most numericals?
Unit 1 has the most worked illustrations, 8 in total, mainly on Excel financial functions such as EMI, NPV, IRR and Goal Seek break-even. Units 3 and 4 have 7 each. Unit 2 has 4 illustrations plus the full ABC Ltd three-statement model on pages 24 and 25, which Unit 4 reuses for its DCF.
How is MFA-216 different from MFA-206 Finance Lab-II?
MFA-216 is a theory elective with a 50-mark written end-term exam and 3 credits. MFA-206 Finance Lab-II is a compulsory Semester 4 NUES lab of 2 credits, evaluated internally by the institute through hands-on Excel work. They overlap in tools: the lab asks you to build, in Excel, the functions and valuation models MFA-216 teaches.
Get the full MFA-216 Financial Modelling Notes on WhatsApp
The full notes are a 55-page printed book in English, not a PDF.
| Unit | Pages | Illustrations | Figures | Questions |
|---|---|---|---|---|
| Unit 1 | 4-18 (15) | 8 | 5 | 17 |
| Unit 2 | 19-31 (13) | 4 + model | 7 | 16 |
| Unit 3 | 32-42 (11) | 7 | 4 | 16 |
| Unit 4 | 43-54 (12) | 7 | 6 | 17 |
What the full MFA-216 notes book contains, by unit
- Unit
- Unit 1
- Pages
- 4-18 (15)
- Illustrations
- 8
- Figures
- 5
- Questions
- 17
- Unit
- Unit 2
- Pages
- 19-31 (13)
- Illustrations
- 4 + model
- Figures
- 7
- Questions
- 16
- Unit
- Unit 3
- Pages
- 32-42 (11)
- Illustrations
- 7
- Figures
- 4
- Questions
- 16
- Unit
- Unit 4
- Pages
- 43-54 (12)
- Illustrations
- 7
- Figures
- 6
- Questions
- 17
If you revise on paper, these Financial Modelling notes in English suit you: delivery takes a maximum of 5 to 7 days, depending on your location.
Order the MFA-216 Financial Modelling Notes book on WhatsApp (4 units, 55 pages)
Unnati Educations is an independent education provider based in Vikaspuri, Delhi. We are not affiliated with, authorised by, or endorsed by Guru Gobind Singh Indraprastha University (GGSIPU). 'GGSIPU' and 'IPU' are used only to describe the syllabus our notes follow. For official information, visit ipu.ac.in.
Ready for the full notes?
Discuss coverage and delivery with our team.