Financial Modelling & Corporate Restructuring crash course, Online BBA, Semester 6:
This subject covers building financial models in Excel, valuing companies using DCF and relative methods, corporate restructuring such as mergers, demergers…
- 13 video lessons
- 3h 43m
- Study notes
- 65 quiz questions
- Assignment
13 lessons in Financial Modelling & Corporate Restructuring
Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.
About this subject
This subject covers building financial models in Excel, valuing companies using DCF and relative methods, corporate restructuring such as mergers, demergers and buybacks under SEBI's takeover code, and basic financial analytics in Python. After it you will be able to build a three-statement model and DCF with sensitivity tables, calculate FCFF, FCFE and swap ratios, and analyse stock returns and volatility using Pandas.
- 1
Financial Model Structure and Best Practices
Module 1, Financial Modelling in Excel: Model structure
Financial Modeling Explained in 10 Minutes (Even a Beginner Can Do This)· Ishaan Arora· 11 min
Study notes 5 quiz questionsWatch lesson - 2
Building a Three-Statement Model in Excel
Module 1, Financial Modelling in Excel: Three-statement model
Build a Dynamic 3 Statement Financial Model From Scratch· Kenji Explains· 31 min
Study notes 5 quiz questionsWatch lesson - 3
Forecasting Revenue and Expenses in Excel
Module 1, Financial Modelling in Excel: Forecasting
Build a Monthly Budgeting & Forecasting Model in Excel· Kenji Explains· 19 min
Study notes 5 quiz questionsWatch lesson - 4
DCF Valuation: FCFF and FCFE
Module 2, Valuation: DCF valuation (FCFF, FCFE)
DCF Excel Modelling | Step by Step - Session 7 | Investment Banking· The Valuation School· 49 min
Study notes 5 quiz questionsWatch lesson - 5
Relative Valuation Using Multiples
Module 2, Valuation: Relative valuation
How to Calculate Relative Valuation of Business Model in Hindi - FinSchool by 5paisa· FinSchool By 5paisa· 13 min
Study notes 5 quiz questionsWatch lesson - 6
Sensitivity and Scenario Analysis in Excel
Module 2, Valuation: Sensitivity and scenario analysis
Excel Financial Modeling | Sensitivity & Scenario Analysis· Kenji Explains· 8 min
Study notes 5 quiz questionsWatch lesson - 7
Mergers and Acquisitions: Types and Motives
Module 3, Corporate Restructuring: Mergers and acquisitions: types and motives
What are Mergers and Acquisitions (M&A)? Types, Form of integration.· Educationleaves· 6 min
Study notes 5 quiz questionsWatch lesson - 8
Swap Ratio Calculation in Mergers
Module 3, Corporate Restructuring: Swap ratio
JCE_MBA_M, A & CR - Exchange Ratio - Lec 1· E Connect Jain College of Engineering· 14 min
Study notes 5 quiz questionsWatch lesson - 9
Demergers and Share Buybacks
Module 3, Corporate Restructuring: Demergers and buybacks
What is De-Merger? || Spin-off, Split-off & Equity Carve Out #demerger #netjrf· Crack with Indresh· 12 min
Study notes 5 quiz questionsWatch lesson - 10
SEBI Takeover Code Explained
Module 3, Corporate Restructuring: Takeover code
SEBI (Substantial Acquisiion of Shares & Takeovers) Regulations, 2011 |CA CS CMA | CA Arpita Tulsyan· Arpita Tulsyan· 35 min
Study notes 5 quiz questionsWatch lesson - 11
Pandas for Financial Data
Module 4, Financial Analytics with Python: Pandas for financial data
Quant Finance with Python and Pandas | 50 Concepts you NEED to Know in 9 Minutes | [Getting Started]· Daniel Boctor· 8 min
Study notes 5 quiz questionsWatch lesson - 12
Stock Returns and Volatility in Python
Module 4, Financial Analytics with Python: Return and volatility calculations
Quant Finance with Python and Pandas | 50 Concepts you NEED to Know in 9 Minutes | [Getting Started]· Daniel Boctor· 5 min
Study notes 5 quiz questionsWatch lesson - 13
Visualising Stock Data with Python
Module 4, Financial Analytics with Python: Visualising stock data
#8 Build Your Own Stock Market Analyzer in Python | Data visualization Project in Hindi· Pythonist Hindi· 12 min
Study notes 5 quiz questionsWatch lesson
Assignment
Model, Value and Restructure: An End-to-End Case on Two Listed Indian Firms
Less scrolling. More passing.
- Free
Hand-picked video lessons
13 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.
- Free login
Study notes
13 lessons come with a summary, key points, key terms and takeaways for quick revision.
- Free login
Quizzes
65 questions across the course, with the right answer and why, the moment you pick.
- Free login
Assignments
1 subject assignments with clear tasks, so you practise what each subject actually asks of you.
- Free login
Notebook
Write notes beside the video, stamped with the exact time, and jump back to that moment later.
- Free login
Progress that follows you
Completed lessons, quiz scores and where you stopped, saved to your account on every device.
- Live chat pass
Live chat
A members-only live chat beside every lesson: doubts, tips, stickers and GIFs with your batch. One ₹19 pass opens every live chat.
The Online BBA live chat. Study together, live.
A live chat right beside the video, shared by everyone studying Online BBA. Ask a Financial Modelling & Corporate Restructuring doubt mid-lesson, share a shortcut, celebrate a finished semester.
- Live chat beside every lesson
- One live chat for all of Online BBA
- Members-only stickers & GIFs
- One ₹19 pass opens every live chat
Online BBA live chat
Anyone else finding Financial Modelling & Corporate Restructuring tricky? 😅
Lesson 2 cleared it up for me. Watch it before the quiz
Doing it now, thanks!
Starting Customer Relationship Management tonight if anyone wants to go together
More from Online BBA Semester 6
All subjects- Sem 6
Customer Relationship Management
Building and retaining profitable customer relationships.
- 4 lessons
- 1h 18m
- Notes
- Quiz
- Sem 6
Digital Marketing
Online channels, branding and campaign management.
- 5 lessons
- 1h 29m
- Notes
- Quiz
- Sem 6
Final Project
Six-month specialisation project from synopsis to final report.
- 1 lesson
- 9 min
- Notes
- Quiz
- Sem 6General Mgmt
Technology Management
Managing technology for competitive advantage.
- 7 lessons
- 1h 20m
- Notes
- Quiz
- Sem 6General Mgmt
Management Development and Skills
Management process and core managerial skills.
- 7 lessons
- 2h 43m
- Notes
- Quiz
- Sem 6General Mgmt · Intl Business
Role of International Financial Management
Global finance, forex and international financial institutions.
- 11 lessons
- 4h 18m
- Notes
- Quiz
Financial Modelling & Corporate Restructuring: common questions
This subject covers building financial models in Excel, valuing companies using DCF and relative methods, corporate restructuring such as mergers, demergers and buybacks under SEBI's takeover code, and basic financial analytics in Python. After it you will be able to build a three-statement model and DCF with sensitivity tables, calculate FCFF, FCFE and swap ratios, and analyse stock returns and volatility using Pandas. It's the Financial Modelling & Corporate Restructuring subject of Online BBA, Semester 6, in 13 lessons: Financial Model Structure and Best Practices; Building a Three-Statement Model in Excel; Forecasting Revenue and Expenses in Excel; DCF Valuation: FCFF and FCFE; Relative Valuation Using Multiples; Sensitivity and Scenario Analysis in Excel; Mergers and Acquisitions: Types and Motives; Swap Ratio Calculation in Mergers; Demergers and Share Buybacks; SEBI Takeover Code Explained; Pandas for Financial Data; Stock Returns and Volatility in Python; Visualising Stock Data with Python.
Yes. Every video lesson is free to watch without an account. A free login unlocks study notes, quizzes, the assignment, a notebook and progress that syncs across devices.
About 3h 43m of video across 13 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.
Yes: “Model, Value and Restructure: An End-to-End Case on Two Listed Indian Firms”. It comes after the last lesson, with a brief, clear tasks and how the work is judged.
A members-only live chat beside the video, shared by everyone studying Online BBA, where learners ask doubts, share tips and react with stickers and GIFs. One ₹19 pass, paid once from your InsideEdge wallet, opens the live chat for every degree.
No. It's a crash course to help you understand and revise the subject quickly. Use it alongside your official study material and assignments.