MFA-216 Financial Modelling Notes for GGSIPU MBA (FA) Sem 4 - cover image
Notes MFA 216

MFA-216 Financial Modelling Notes for GGSIPU MBA (FA) Sem 4

Programme
Master of Business Administration

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.

MFA-216 snapshot from the official MBA (FA) scheme and syllabus
Code and titleMFA-216 Financial Modelling
Course and semesterMBA (Financial Analysis), Semester 4
Category and creditsDiscipline Specific Elective · L 3 · 3 credits
Marks100: 50 internal + 50 end-term
Internal 50Two class tests (15 + 15) + assignments, presentation or viva 20
Applies toScheme and syllabus 2021-22 onwards
End-term pattern50-mark written exam; question pattern not printed in the official PDF
Units4 units: 11 + 10 + 10 + 11 = 42 teaching hours
Paired labNone; the Semester 4 lab is MFA-206 Finance Lab-II (NUES, P 4, 2 credits)
View complete table: MFA-216 snapshot from the official MBA (FA) scheme and syllabus

This view preserves the original alignment. Scroll within it if needed to read the complete content.

MFA-216 snapshot from the official MBA (FA) scheme and syllabus
Code and titleMFA-216 Financial Modelling
Course and semesterMBA (Financial Analysis), Semester 4
Category and creditsDiscipline Specific Elective · L 3 · 3 credits
Marks100: 50 internal + 50 end-term
Internal 50Two class tests (15 + 15) + assignments, presentation or viva 20
Applies toScheme and syllabus 2021-22 onwards
End-term pattern50-mark written exam; question pattern not printed in the official PDF
Units4 units: 11 + 10 + 10 + 11 = 42 teaching hours
Paired labNone; 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)

Quick look: what-if tools (from page 16)
ToolWhat it does
Goal SeekOne input, one target, no constraints
SolverMany inputs, an objective, constraints
Data TableOutput for a range of one or two inputs
Scenario ManagerSwitches 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)

Quick look: ABC Ltd cases, ₹ crore (from page 28)
DriverWorstBaseBest
Revenue growth5%12%18%
COGS % of revenue63%60%58%
FY28 PAT62.998.4132.5
Probability0.250.500.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)

Quick look: multiples (from page 40)
MultipleBuilt asBest for
P/EEquity value ÷ PATStable, profitable firms
P/BEquity value ÷ book equityBanks, NBFCs, insurers
EV/EBITDAEV ÷ EBITDACapital-intensive firms
EV/SalesEV ÷ revenueLoss-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)

Quick look: FY26 revenue, ₹ crore (from page 44)
MethodFY26Excel
3-year moving average466.7=AVERAGE()
Linear trend537.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_V
View preformatted content

This view preserves the original alignment. Scroll within it if needed to read the complete content.

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_V

Keeping 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.

MFA-216 official units mapped to the notes
Official unitOfficial topicsIn the notesStatus
I: Excel as a tool in Financial ModellingExcel commands; maths, logical, look up, date, text, financial functions; charts, conditional formatting, sort, filter; formulas, macros; what if analysis, pivot, scenario, goal seek, solverSections 1-7, pp 4-17Covered
II: Financial Modelling Basic ConceptsAdvanced functions; components, template, historical data, drivers; schedules and statements; valuation approaches; ratios; cases, sensitivity, probabilistic analysisSections 1-7, pp 19-30Covered
III: Cash Ratios and Non-Cash ValuationsCash ratio; menu model and accounting statement; key ratios; international cash flow; accounting methods, DDM, EPS and multiples, EV/EBITDA, EV/Sales, peer groupsSections 1-7, pp 32-41Covered
IV: Forecasting Methods and Initial ValuationsForecasting; strategy, key drivers; linkages; free cash flow; bonds, APT, CAPM, betas, derivation; terminal value; equity valuation vs share priceSections 1-6, pp 43-53Covered

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%
View preformatted content

This view preserves the original alignment. Scroll within it if needed to read the complete content.

=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.

MFA-216 exam questions and worked illustrations per unit
UnitShort (2–5 Marks)Long (10–15 Marks)Illustrations
Unit 11078
Unit 21064 + worked model
Unit 31067
Unit 41077

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.

What the full MFA-216 notes book contains, by unit
UnitPagesIllustrationsFiguresQuestions
Unit 14-18 (15)8517
Unit 219-31 (13)4 + model716
Unit 332-42 (11)7416
Unit 443-54 (12)7617

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.