Financial Modelling Course in Delhi
Financial and modelling course in Delhi with placement by mentor me careers is the only financial modeling certification with the highest success rate in providing investment banking placements in Delhi & NCR Region
- Hands on training for core finance placements
- 12 Specialisations in advance models*
- Average Package 4.5 LPA*
- Life Time Access to Content
- Weekend & Weekday Batches
- Learn with investment bankers with 10 years exp.
Placement Success in Delhi & NCR
Overview of the Program
- Learn to build financial models with five Modules comprising excel, financial statement analysis(income statement, balance sheet, cashflow statements), Quantitative Methods, Equity Valuation, Project finance, Capital budgeting in Live classes or self-paced based on your preference. All of these are crucial concepts which are taught in the mentor me careers flagship program- financial modelling course with placement.
- Also,Post completion get 12 financial modeling specializations in infrastructure, solar, aviation, mergers and acquisitions, LBO(Leverage buy out), IT, Algo trading, retail Banking, Real estate, manufacturing.
- Finally, Get placements in core finance companies in equity research, credit rating, investment banking, and investment banking operations, after completing the placement requisites.
We at mentor me careers focus on the absolute crucial skills which get tested in the interviews, a prime feature of the mentor me careers’s Financial Modeling Course with Placement.
- You get, 200 Hrs Live training for live version students
- However, Self paced students get 100 Hrs videos and live doubt solving support in the mentor me careers NSE financial modelling course with placement
- You will Get lifetime access to live classes in live variant
- Also , Get lifetime validity of portal access and updates on new content
- However, Self paced plus students get free financial modeling live specialisation classs.
This is the only financial modelling course in India with placements that offers highest value for money
- This course includes, five Module certificates with one course completion certificate on financial modeling.
- Also students can apply for NSE course Certificate issued by NSE Academy on exam completion.However, for NSE exam, the minimal cost has to be bourne by the student.
- Each student will be eligible for placements, regardless of their background.
- Firstly, students need to clear the placement technical pre-requisites to start getting interviews.
- Secondly,Placement process starts within one month of the admission, given that the student has full filled the basic requirements of the course.
- Also, we don’t charge any additional fees for placement support.
- Moreover, we hold the record of ” There are zero students in mentor me without placement opportunties till date, which can be verified”.
- We don’t guarantee placements, but we commit our sinciere efforts. self-preparation of the student still remains the deciding factor for placements
- The Average package of CTC, for students enrolled with us is 4.5 L.PA, with the highest CTC till date reaching 10 LPA.
Teaching Methodology
Active Learning Real ProjectsReal ModelsMentoring
Joint Certification from BSE Institute & Mentormecareers
Mentormcareer's financial modeling and valuation course in Delhi comes with a built in association with Bombay stock exchange institute's Checkmy skills for providing valid certification for students.
Program Fees
Investment Banking Course with Placement in Delhi
Features
-
200 Hrs online training
-
Guranteed interviews
-
12 Specialisations
-
Life Time Portal Validity
Financial Modeling Live Classes Online in Delhi
Features
-
200 Hrs online training
-
Guranteed interviews
-
3 Specialisations
-
Life Time Portal Validity
Financial Modeling Offline Classes in Pune
Features
-
200 Hrs Offline
-
Guranteed interviews
-
12 Specialisations
-
Life Time Portal Validity
Learning Experience Review
Detailed Syllabus
Below is the core program outline of the NSE Financial and Modeling Course in Delhi with Placement offered. Now, this forms the base foundation before the candidate, is eligible for specializations in advanced financial modeling certification and modules.
First,The intial module is designed for a comprehensive start with spreadsheet skills and awareness on various sections and features of excel ribbons which is required for a financial analyst , equity analyst or investment banker. So, below is the list of content covered in the program.
Excel layout and structure
Sheet vs Book
Home ribbon
Insert Ribbon
Data Ribbon
Page layout
Formula Ribbon
Review Ribbon
View Ribbon
Cell freeze and referencing
Logical operators
Nest if Function
- Excel shortcuts
Module 2:Advance Excel Part 2
Now, the second module gets into advance functions required for working as a financial analyst in the industry. Also, this section is specifically very important for candidates looking to work in FP&A.
Vlook up/ Hlook up/ Xlook up
Index and Match
Sum, Average, Count, Max, Min, Counta
Sumproduct
Conditional operators, Sumif, Countif, Average if
Pivot Table, Pivot Chart, Slicer
Financial analysis and template
Data Look up case study on stock market data
Charts- Waterfall, Radar, Clustered column, Histogram
Data Analysis tool pack
Now, this section ends with a comprhensive case study on Sales Data summarization.
Module 3: Financial Mathematics
This model is especially important for candidates, who want to enter equity research or valuation based roles.
What is time value of money
What is compounding
What is discounting
Definitions of rate
Frequency of compounding
Continuous compounding
Series of cashflow
TVM Excel functions
Beginning and ending cashflow
IRR and NPV. Problems with IRR
Module 4: Statistics for Finance
Financial modeling is incomplete without learning the statistics required to make forecasting , and creating insights on the business risks
Need of statistics
Central tendency
Presentation and analysis of data
Risk Calculation
Risk adjusted calculations- Sharpe, MAR, Sortio
Now, statistics is understood with Fund selection Case study.
No one can become a financial analyst without knowing accounting and financial statement analysis required for investment finance field for analysing the financial performance. The investment banking course offered by Mentor Me will teach you financial accounting , analysis, various line items from the basics.
Introduction to Fundamental Analysis Framework– Annual report reading, Con Call reports, Quarterly reports, statement of change in equity, Supplementary information
Financial statement linkages and creating financial statement in excel
Income statement– Revenue recognition principles, Expense recognition principles, Diluted EPS, EPS, LIFO, FIFIO,AVCO
Balance Sheet– Format of balance sheet, current assets, current liabilities, Fixed assets, Non current liabilities
Cash flow statement– Format of cash flow statement, Direct method , Indirect method, FCFF, FCFEE
Ratio analysis– Solvency Ratios, Profitability ratios, Activity Ratios.
Ratio Analysis Case Study- Analyse persistent systems annual report
How to Read an annual Report step by step
Franchisee Business Model Valuation- NPV , IRR, Sensitivity analysis
Minority Interest, Impairment, Good will analysis
Once the finance fundamentals are set now its time to dig into creating financial models in practice. We will start applying all the concepts learnt into practical real life financial decision making. Check a project finance class here.
Start-Up Model Travel agency Business
You will learn how to think of the template of the business model. How a three statement financial model is made . Also you will learn how small business assumptions can make the decision making difficult
Manufacturing Plant Business Modeling
In this financial model you will learn how funding complications affect the model. Interest capitalisation, Construction phasing , Soft cost and hard cost of projects will be taught in this section
Tax Modeling
Tax is an important part of investment decision making calculation. Taxation is much more complicated than calculating 30% of the PBT. Here you will learn tax loss carry forwards, Carry forward loss set off, Minimum alternate tax, MAT Credits, MAT Set off,Deffered tax liability & Deffered Tax Asset. All of this practically using excel
Manufacturing Plant Set Up Model
This is a real model of the industry made from scratch using real world assumptions and calculations. You will learn what it means to work in a industry level financial model from zero. All the complications thrown into one project finance case. You also learn how to create deb schedule with various interest rate calculations.
Check out our demo class of financial modeling valuation .
This is the final section before the specialization kicks in. In this section we will take a publicly listed company from NSE stock exchange and create a DCF Valuation Model and Relative /Comparable analysis financial model. This is one of the other applications of financial modeling in decision making. This model is specifically useful for people who want to pursue to join equity research and Investment banking
Valuation Basics- DCF, Gordon growth, WACC, Cost of equity , Levered, Un levered Beta, Terminal Value
Creating a model template
Data collection and data feeding in financial model
Revenue Driver- breaking the business into Price and quantity metrics, so that you can forecast those metrics
Cost Driver
Debt Schedule , Asset schedule Forecast
Free Cash flow calculation
Valuation Techniques and Calculation
Sensitivity Analysis
Report Writing
This is our major success metric at Mentor Me, your placement. With over a decade of experience in this field, we have developed resources and process which will make you polished for the interview and job in investment banking and research. This module will include
Employability quizzes for each skill tested in the interview
Case studies practice for interview
Written test question bank
Mock Interviews- Face to face
Stress Interviews
CV Edits and recommendation
Soft Questions practice for HR Rounds
More and more finance Jobs require candidates to know the basics of python. In the Financial modeling course with placement in the weekday program we cover
- Python basics
- Data Sets
- Data visualisation using matplotlib and seaborn
- Linear and logistic Regression machine learning models using python.
Case study for finance on python.
Module 1: Power BI Set up
Learn the basic set up requirements of Microsoft Power BI & Overview of the major functionalities.
Module 2: EDA Using Power BI
Learn how to use the easy to use power BI Functionalities, to explore the data. Before beginning any analysis further
Module 3: Data Visualization with Reports Learn how to create beautiful charts and data presentation using Power BI
Module 4: Dashboards using Power BI
Learn how to create powerful interactive dashboards to summarize the data analysis in Power B
- Sql introduction
- SqL Operators
- Data tables in SQL
- Major Sql functions
- SQL Data base
- 4 Technical Mocks
- Interview cases role wise
- Face to face advice questions in finance
- General Market Questions
- Practice Questions
- Vocabulary Training
- Role Play
- Non Verbal Communication
- Difficult HR Questions
Recruiters in Delhi & NCR
Careers that can be targeted after financial modeling course are in equity research, finance and accounting, fp&a, risk management, financial analysis. Below are the list of companies in Delhi
- Mcube Financials :Tower 3A, 4th Floor DLF Corporate Park,
Sector 24, Gurugram, Haryana-122002 – India - Nirmal Bang:Nirmal Bang Securities Pvt. Ltd. 10185A,Mezzanine Floor, Arya Samaj Road,Karol Bagh, New Delhi-110005
- Wipro:Plot No 2,3,4 Knowledge Park-4 Gautam Budh Nagar,
Greater Noida – 201308 - Visible Alpha:8 Square, Plot No. 8, 2nd Floor
Sector 125
Noida 201303
- Daloopa:1301, 13 Floor, Tower-B, Plot No. 7, Sector 142, Noida, Uttar Pradesh 201305
- Nirvana Solutions:Unit No 951-955, TOWER-B, SPAZE ITECH PARK, Sector 49, Gurugram, Haryana 122018
August 2024 Placements
Placement Assistance Process
Mentormecareers has close to 1500 recruiter relationships accross India including Delhi. And the students who opt for the course option with placement assistance are assisted with preperation for placements as well as lining up of interviews in relevant companies.
Our placement assistance scope is as follows;
- On boarding your requirements during the time of enrollment
- Preferences of location, CTC expectations and Profiles
- Specific mock preparation related to the investment banking profiles
- Interviews lined up, offline and online in Delhi
- Post Placement Follow ups.
We don’t offer the following;
- No Pay after placements
- No Guarantees for placements
- We don’t charge for placements separately.
- We don’t just forward your resumes but line up your interviews personally.
Students Video Testimonials
Since mentor me stands for learning, each mentor listed on mentor me can run as many courses as they want but can only take 20 mentees( students) in batch to maintain delivery and at a time mentor 20 students overall.
Moreover financial modeling is a decision making tool used in
1 :banking industry for funding projects 2:Used for business valuation in private equity 3: stock valuation in asset management industry 4:In cororate finance for financial planning and analysis
Financial Modeling is a core skill required in core finance interviews. There is a large gap between what the academic qualifications teach vs what is required in the industry. Hence financial modeling course at mentor me careers, bridges the gap.
Mentor Me Careers has the most comprehensive curriculum of financial modelling course in India. It is rigorous program with 12 specialisation, 21 Modules. Each module is made carefully considering the requirement of placements in investment banking and research.
Financial Modeling cannot be learnt without getting perspective and experience. Since getting core finance placements is a competitive space, doing these specialisation will give you the edge over the other students during interviews and also will help you advance your career in research.
There are various types of modelling, with subtle changes with everys sector that we analyse. However the core factor remains the same in terms of the skill.
At mentor me we are serious on the quality of content you read, use and learn with.
We have high quality pre – recorded videos, recorded by experts
We have reading slides as summary
Class Recordings for staying updated (Applicable for Online Instructor Led)
Cheat Sheets- Get small pocket mind maps to remember formulas and logic
Excel Templates- Get high quality templates to learn financial modeling
Interview question bank- we have compiled over the years question banks for interviews for top 50 companies in India. You will get to practice these from day 1.
- More so, the mock interviews which are conducted are also included which are aimed at personality development of an individual for cracking the interviews
If you are in the Live online plus variant then you can attend multiple batches for a year.
Those who are live online basic- need to pay 2000 Batch transfer fee to enroll for the next batch
Content will be available for all variants for life time
It all depends on the your learning curve and previous backgrounds. Below is the summary of recommendation’
Self Paced Basic- Suitable for Finance professionals
Self Paced Plus- Suitable for candidates who are well versed with fundamentals and are self learners
Live Online Basic- Suitable if you are not looking for placement and are just up skilling
Live Online Plus- Suitable for MBA Freshers, CA Inters, CFA Level 1 ,2 Candidates, Commerce Graduates who are looking for a Job.
The trainer or mentor will provide you with all the support required during this course, and you can access him/ her directly on whatsaap.
A valid internet connection that can handle online meetings , a laptop with a working Microsoft Excel account
Learning is global and accessible to all. We provide services to all
Yes if you enroll with more than 2 students as a group then we provide 10% Waiver for all.
College training with a large of more than 20 students can contact at [email protected]
We teach exactly what is required in placement interviews and we understand the finance space well. With our updated material, high quality content we are pretty sure, with the students effort that one should not have any problems getting success.
However we do not offer placement guarantee. Check the placement report here. Another fact is that all our students who have been placed with previous expereince have got minimum 20% growth rate in their packages.
We have multiple easy payment methods available.
EMI On Credit Card
Debit Card
Early Salary
UPI
Net banking
PayPAL
PayTM
And Many others. You can choose the method which is most convenient for you.
The 12 specialisation models are covered in the completion of the placements process for students. If the student opts for live classes for the same, then one model per month until the student wishes to learn. To clarify further, the 12 extra models are not covered in the 3 months duration of the live course but after the coverage of the regular financial modelling course.
For live classes of specialisations, students are expected to work on prerequisites including but not limited to data entry and research, without which students are not allowed for the live version of the specialisation.
As an alternative, the student can access the pre-recorded versions of it, in case there is a paucity of time.
Moreover, specialisations are intended for “Continuous learning” further, with no effect on the regular course.
200 Hrs training include
- Live Lectures
- Doubt solving sessions
- Ongoing Knowledge series
- Career Guide Sessions
- Placement Mocks
- Placement Prep classes
- Assignments and Projects
The 12 specalisations are over and beyond the 200 Hrs of delivery provided by us.
Mentor Me careers publishes placement reports, including average packages, which are calculated basis arithmetic mean. These are displayed as indicative stat and not the outcome we promise.
The packages and salary perks earned vary from student to student and Mentor Me doesn’t guarantee the same.
For a student to get placed, there are two aspects
- Students’ performance in the course and completion of eligibility prerequisites.
- Mentor Me’s performance of providing opportunities to students in the form of interviews and adequate training for the same.
Hence the final placement is an outcome of the student and us fulfilling our obligations.
As an educational institution, we work tirelessly in providing opportunities and platforms for students, but opportunities can also be affected as a result of hiring conditions in the market.
No, this used to be the case a decade ago, but since all the interviews nowadays follow a live skill test making the certification a decorative asset only.
On an average we have experienced that a fresher with graduation can expect around 3.5 to 5 LPA. Similary a chartered accountant, who is a fresher can expect a starting salary of 7-9 LPA
Recent Blogs on Careers
Is ACCA hard? Truth Be told
So I recently asked a colleague name Rahul Tyagi: Is ACCA hard? His answer was…
Best Extra Courses for Commerce Students
Last updated on October 23rd, 2024 at 02:28 pmSo, you have limited time? May be…
Advanced Excel Course Syllabus-Designed For Industry
Last updated on October 23rd, 2024 at 02:20 pmAccording to a 2023 survey conducted more…