Last Day Left! Apply before 21st May 2025 to enroll in the final batch. Call now: 9112-2072-07
PGDM Executive In Finance Management
Financial Modelling and Valuation Certificate by EY- 40 Hrs
Elevate your expertise in Financial Management with a specialized module on Financial Modelling and Valuation delivered by EY, one of the world’s leading professional services firms. Gain cutting-edge skills in financial modelling, valuation, and Excel techniques through this program, designed by senior professionals from EY and industry experts. The module provides candidates an exposure to create efficient, robust and flexible financial models to perform independent business valuations.
- Understanding of Excel screen, copy & paste, Navigation Shortcuts
- Page Setup, Calculation modes
- Cell formatting, Sorting & filter data
- Mathematical functions
- Statistical functions
- Financial functions
- Logical functions
- Lookups and Reference functions
- Text functions
- Data and information functions
- Difference between financial models and spreadsheets
- Financial model structure - flow of the model, deciding on the order in which sheets should be prepared and presented
- Creating a template for the financial model
- Timelines, flags, and counters
- Developing P&L, Balance Sheet & Cash flows - line items and drivers
- Understanding contra accounts
- Constructing Revenue items
- Expenses - fixed costs (rent, insurance, electricity & utilities, etc)
- Expenses - variable costs (employee costs, power and fuel, advertising and marketing, etc)
- Revenue and expenses for sectors that are covered by regulatory authorities (power, telecom, roads, etc)
- Tangible fixed assets account - break-up, capital expenditures, asset lives, impact of foreign exchange translation
- Treatment of intangible fixed assets
- Depreciation and amortization - straight-line method, written-down value method, units of production method, and other methods
- Depreciation for books vs. depreciation for tax
- Capital structure and introduction to debt modelling - types of structures, types of debt, types of equity, treatment of grant, reviewing terms of debt
- Setting up inputs, flags, and counters for debt calculations (considering repayment pattern, moratorium, etc)
- Setting up priority of payments and arriving at repayment profile for debt when there are multiple debts in the project (senior debt, sub-debt, etc)
- Understanding sculpted repayments
- Modelling to check for debt covenants
- Understanding the debt service reserve account (DSRA) and setting it up
- Construction cost, timeline, and delays in infrastructure projects
- Introduction to VBA - creating a simple macro
- Treatment of interest during construction (circularity and how to break it) and Equity Schedule
- Understanding Working Capital
- Modelling of Working Capital
- Tax calculations (Income tax and Minimum alternate tax)
- Understanding and calculating deferred tax
- Integrating the financial statements - preparing Profit & Loss Account, Balance Sheet, and Cash Flow Statement and setting up dividend calculations
- Handling aggregation, consolidation, and switches when there are multiple assets and/or entities
- Understanding adjusted EBITDA and Pro Forma EBITDA
- Building flexibility to evaluate sensitivities on various parameters
- Calculation of key ratios and margins
- Goal Seek, Setting up checks in the model
- Incorporating overrides for various assumptions
- Introduction to charts - simple and advanced charts
- Creating dashboards that present the key assumptions and outputs of the model in a meaningful and decision-oriented manner
- Introduction to valuation concepts - PV, NPV, IRR, FCFF, FCFE, etc
- Introduction to valuation methods - Discounted cash flow method, difference between NPV and XNPV, IRR and XIRR formulas
- Introduction to valuation methods - comparable companies methods (trading multiples and transaction multiples)
- Introduction to valuation methods - book value method (net asset value - NAV - and adjustments to NAV)
- Detailed understanding of discounted cash flow method, calculation of WACC
1. Module 1 will be eLearning and Modules 2-10 will be Virtual Instructor Led Training.
2. To access all the live sessions, the learner will have to access the link from the MITSDE LMS. However, all learning materials and reading materials of the EY Financial Modelling and Valuation Certification Program will be available on the EY LMS.
3. All learning materials and reading materials of the PGDM Exe COURSE will be available on the MITSDE LMS.
Tool Used
About The Course
In a rapidly evolving business world, financial expertise is essential for informed decision-making, risk management, and sustainable growth. The PGDM Executive in Finance Management is a specialized program designed for working professionals who want to strengthen their financial acumen and move into leadership roles in corporate finance, banking, investment, or financial consulting.
Spanning 15 months, this program blends core management principles with advanced financial concepts. It starts with foundational subjects like Business Management, Strategic Management, and Legal Aspects of Business to help learners understand the broader business environment. The specialization then dives into key financial topics such as Financial Management, International Finance, Security Analysis, Portfolio Management, and Mergers and Acquisitions.
The course is structured to provide practical insights into financial markets, corporate finance, and investment strategies. It equips learners to analyze financial statements, interpret market trends, and make data-driven decisions. Tools like Business Analytics and Management Information Systems are included to ensure participants are proficient in modern financial technologies and techniques.
Case studies, real-world projects, and interactive assignments help students apply theory to practice, improving their ability to assess investment opportunities, manage risks, and optimize capital allocation. The program also emphasizes ethical financial practices and strategic thinking—qualities that are highly valued in senior finance roles.
Delivered entirely online, the PGDM Executive format allows professionals to upskill without interrupting their careers. With flexible learning options and support from experienced faculty, learners can integrate new skills directly into their current roles.
Graduates of this program can pursue roles such as Financial Analyst, Finance Manager, Risk Manager, Investment Advisor, and M&A Consultant. Whether in the private sector, government, or entrepreneurial ventures, the program prepares professionals to handle complex financial challenges with confidence.
Get in touch +91 9112-2072-07
Unique Pedagogy
MITSDE's distance learning programs are meticulously designed to bridge the skills gap for working professionals. Our curriculum is constantly updated to reflect the latest trends in management, industry requirements, dynamic business environments, and burgeoning technological advancements. The PG programs are co-created with industry experts and subject matter authorities, ensuring content aligns with real-world applications. You have access to interactive tools, e-books, multimedia content, and comprehensive reference materials.
Academic Partnerships
Launch your global career with MITSDE. Partner with us to gain industry-leading expertise from renowned institutions. Our curriculum integrates global best practices, equipping you with the skills and connections to thrive on the international stage. Graduate with a competitive edge and unlock a world of career possibilities.
Expert Faculty
The MITSDE faculty consists of several academic luminaries and seasoned industry experts, ensuring you receive a well-rounded education grounded in real-world application. These experts actively engage with students through interactive webinars and doubt-solving sessions. This direct interaction bridges the gap between theory and practice, giving you the opportunity to ask questions, clarify concepts, and gain valuable insights directly from professionals at the forefront of your chosen field.
Learning
Outcomes
By the end of this program, learners will be able to:
Course Syllabus
| S.No | Code | Subject | Credits |
|---|---|---|---|
| 1 | S1F01 | Foundations of Business Management | 4 |
| 2 | S1LA1 | Legal Aspects of Business | 4 |
| 3 | S2C10 | Strategic Management | 4 |
| 4 | S2C07 | Management Information System | 4 |
| 5 | S2C11 | Business Analytics | 4 |
| 6 | S3C13 | Project Management | 4 |
| S.No | Code | Subject | Credits |
|---|---|---|---|
| 1 | S2C09 | Research Methodology and Management Decision | 4 |
| 2 | S2C16 | Financial Management | 4 |
| 3 | S3SF01 | Financial Markets and services | 4 |
| 4 | S4SF2 | International Finance | 4 |
| 5 | S4EB3 | Security Analysis and Portfolio Management | 4 |
| 6 | S4SF1 | Mergers and Acquisitions | 4 |
Project Term - 3 Months
- The above course curriculum is subject to revision as per AICTE guidelines from time to time and as per industry updates.
- Exams would be conducted during the January and July exam cycles.
- All the Exams at MITSDE (Internal & External) are in the form of Multiple Choice Questions.
- Student will have to attempt all the components in the Learning Management System and submit TWO Quizzes (30 marks each) for each subject.
- Internal Examinations carry 60% marks (2 Quizzes of 30 Marks each) and External Proctored Exam carry 40% weightage (passing criteria for both internal & external exam is 50%).
| S.No | Code | Credits |
|---|---|---|
| 1 | Desk Research | 2 |
| 2 | Project Work | 4 |
Program
Fees
₹ 95,000 /-
Fees Options
- Installment 1
- Installment 2
- Installment 3
Course fee - Installment
- ₹ 30,000 /-
- Within 3 months - ₹ 32,500 /-
- Within 6 months - ₹ 32,500 /-
Course fee - Lumpsum
- Discount- ₹ 5,000 /-
- -
- Total Lumpsum- ₹ 90,000 /-
- Students are required to pay additional exam fee per exam per attempt and Project Evaluation Fees. For Installments
- First Installment needs to be paid at the time of admission.
- Second Installment needs to be paid within 3 months from the date of admission.
- Third Installment needs to be paid within 6 months from the date of admission
After completing this program, learners can pursue roles such as:
- Finances Manager
- Financial Analyst
- Investment Banker
- Credit Risk Analyst
- Corporate Finance Executive
- Mergers and Acquisitions Analyst
- Treasury Manager
- Equity Research Analyst
- Wealth Management Advisor
Frequently asked questions (FAQs)
- Our eLearning programs comprises of pre-recorded videos.
-
You can view the videos unlimited time up-till your validity timeframe i.e. 6 months from the date you are assigned the course.
-
Doubt solving support facility is available through email. You would be provided with a dedicated email ID where you can post your query
-
The sessions are recorded and delivered by EY professionals and Industry experts. The 32 hours of live sessions will be delivered by a mix of sector expertise and industry experts under the guidance of senior EY professionals with significant experience of training delivery.
-
You get 3 attempts to clear the assessment conducted by EY
-
The EY assessment would comprise objective questions
-
No, there is no negative marking for EY assessment.
-
You are required to score 60% to pass the assessment conducted by EY
-
You would be awarded with a certificate of completion.
-
You will be provided with 3 attempts and in case you are unable to clear in 3 attempts you will be given participation certificate instead of completion certificate.
-
No, soft-copy of certificate would be provided after successfully clearing the EY assessment.
-
EY certificate does not have any expiry.
-
You can take the assessment within 15 days of completion of the batch; however, eLearning access will stay active till 6 months from the date you have been assigned the course. In a situation where the participant is unable to clear the assessment in 1st attempt, 20 more days will be provided to clear the assessment with 2 more attempts.
-
LMS (Learning Management system) is the learning portal from where you will access your eLearning program.
-
No, we don’t provide any hard-copy material within our program.
-
Our pedagogy involves practical understanding with help case studies and relevant examples.
-
MIT will have a separate email id for all the student queries for this program which will be sent to EY every week. Mutual TAT: 12 days (to be discussed)
-
We provide you with EY presentations in the form of PDFs in support of the pre-recorded videos/live sessions.
The total duration of the course is divided as below:
eLearning
8 hours of excel program (eLearning)
36+ hours of eLearning Financial Modelling and valuation
Virtual instructor led training:
32 hours of virtual instructor led training on Financial Modelling and valuation.
Total Score: 100, Min Score for Qualification: 60%
Format:
Mix of numerical, concept testing and case scenarios
-
Finance professionals working in investment banking and equity research
Finance managers
Corporate finance, private equity and M&A professionals
CA, FRM, MBA finance, CFA course candidates
Self-employed finance professionals
Graduates
-
Candidate should have basic understanding on MS Excel which us also provided as part of the program. The prior excel knowledge will be helpful as the models will be prepared using advance excel tools.
-
No, the certificate is solely issued to you by EY.
-
No, the program does not comprise of any live projects but explains the concepts using the case studies and examples.
-
The course is basic to intermediate level
-
Yes, the course does not require you to be a CA/CS to apply for the course.
-
Best practices
Structuring and designing models
Sector-specific working of revenue and expense
Understanding various possible ways to compute different line items forming part of financial statements
Tax calculation
Integrating financial statements to present a cohesive output
building macros
Various approaches to valuation and how to apply them
Presentation of output in an appealing as well as meaningful manner
-
Investment Banking Analyst
Equity Research Analyst
Financial planning Analyst
Credit Analyst
Corporate Finance
Financial Analyst
Project Finance
-
Yes, case study is part of the curriculum which would be generic in nature.
-
VILT will give the students an opportunity to solve the case studies and create models with faculty and will also have the access to case solutions. Additionally, the case studies will be unique from eLearning material. Additionally, eLearning is the best platform to reiterate the concepts and practice the concepts as per the available time of the individuals.
The program spans 15 months.
Graduates with over 5 years of work experience are eligible to apply.
The course is delivered online, providing flexibility for working professionals.
The program fee is ₹95,000.
Yes, MITSDE provides placement support to students after they complete the program.
After completing this program, learners can pursue roles such as:
Yes, the program applies finance management principles across various sectors, including services and manufacturing.
While a background in finance management is beneficial, the program is designed to equip professionals from diverse fields with the necessary skills.
MITSDE's online platform offers interactive learning Finances, discussion forums, and access to faculty for queries and support.
The program offers a comprehensive curriculum tailored for middle and senior executives, focusing on Finance management practices across various industries.
Note: To access all the live sessions, the learner will have to access the link from the MITSDE LMS. However, all learning materials and reading materials of the EY Financial Modelling and Valuation Certification Program will be available on the EY LMS.
Please note that all learning materials and reading materials of the PGDM Exe COURSE will be available on the MITSDE LMS.
12 Months
PGCM - Business Analytics
Become part of India's fastest growing Fintech Industry with our Professional course in Fintech
Course Fees
₹ 64,000 /-
12 Months
PGCM - Digital Marketing
Upgrade your skills with trending AI tools & become a top digital marketer!
Course Fees
₹ 64,000 /-
24 Months
PGDBA Operations Management
Get the World's Highest Accredited Lean Six Sigma (Green & Black belt) Certification
Course Fees
₹ 95,000 /-
24 Months
PGDM Project Management
Leverage your exceptional management skills with our PMP Prep course and land your dream job today!
Course Fees
₹ 90,000 /-
15 Months
PGDM Executive Modern Project Management
Aspiring to be a Project Manager? Take the first important step with the CAPM Prep course today!
Course Fees
₹ 95,000/-
