Financial Modeling Course Pune for
Investment Banking Jobs
Financial modeling online course in Pune provided by Mentor Me Careers is a top Financial modeling online training with 12 specializations, 200 Hrs live training, and placement assistance in core finance jobs. Mentor Me Careers is one of the highest rated finance institutes in pune.
Why Mentor Me Careers?
Placements at Mentor Me
Jatin2024-03-31I opted for the financial modeling course, and my overall experience till now has been pretty good. The faculties and administrative staff are really amazing.Babita Shah2024-03-31I have enrolled in Investment Banking Operations with Mentorme Career and it's been almost 3 months They provide learning from scratch. Highly recommend if you want to make your career in finance.Vismay Mishra2024-03-30I enrolled for Investment banking course and I would say their assistance to grow our financial knowledge is quite outstanding, with the regular classes to doubt solving everything is phenomenal, I'm quite pleased with the way they teach, and would definitely recommend this platform to many others.Navnath Rathod2024-03-30I have purchased the investment banking operation and they teaching and organising the hole course is phenomenal, I would recommend this course to all the finance aspirants who want to begin their career in finance 👍ashish pandey2024-03-27It been months since I joined mantormee class. I know confidently tell that I can now face the problem related to financial modelling and attempt to solve them. Overall it's a nice experienceAbhishek Bhosale2024-03-21I am currently learning from Mentor me careers for Investment banking course, for now I found the course is structured in detail. Currently, I look forward that I will get placed in the right organization through Mentor Me Career.Sohail Shaikh2024-03-19I opted course of financial modelling.all mentors are good and supportive. Good platform for upskilling in core finance domain. ⭐️Sumit Kapse2024-03-19Learning experience with Mentor Me has been excellent. I’ve enrolled for financial modeling course and I must say it’s the best place for finance courses.Satvik Chavan2024-03-19Having chosen the investment banking operations batch, I am finding that Mentor Me offers a highly interactive interface in addition to really helpful professors. Overall, I am really enjoying my time with Mentor Me. The fact that courses start from scratch and are therefore incredibly helpful for beginners is something I find appealing about them.
Learning Options
Instructor Led Live Options
Live Online - Basic- Weekends
Live Online Classes *
3 Specializations
Lifetime Content
Course Certification
Fees ₹16,499 (+ GST)
Live Online Plus +Weekday/ Weekend
200 Hrs of Training
Comprehensive Training
12 Specialisations
- Life Time Content Access
Course Certification
Fees – ₹32999 (+ GST)
Self Learning Options
Self Paced - Basic
Pre-recorded
3 Specializations
Forum Support
1 Year Content
Course Certification
Fees ₹5499 (+ GST)
Self Paced - Plus+
Personal Mentors
12 Specializations*
Lifelong Content
Course Certification
Fees ₹10,999 (+ GST)
Course Introduction
Mentor Me Careers offers Financial Modeling in Pune. It is one of the most comprehensive course offered in India. It is a one stop solution for those who want to kick start their career into investment banking. This course will prepare you for the skill needs by the role from basics.
Learning Outcomes
Have a through understanding of working with Excel and advance excel functions for financial modeling
Be comfortable in financial mathematical calculation
Able to create financial statements hands on
Analyze financials statements of company and related data
Create a valuation Model and recommend stocks
Course Mentors
Allen Aravindan, CFA
Lead Trainer at – Mentor Me Careers
Vast 11 Years Experience in Fund Management, Product Management & Entrepreneurship.
Trained 3000 students in premiere institutions
Renowned Visiting Faculty- Symbiosis, Indira, MIT Pune.
Ex-Partner- Ennovate Research Investment and Capital, Hedge Fund
Ex Product Head- IMS Proschool , Large Ed Tech Company
Pankajj Goel
CFA® ,CFP®
Trained More Than 14000 students in finance
13+ years corporate expereince in wealth management and investment banking
- Conducted trainings at corporates like Goldman Sachs, ICAI, Hindware, HFCL,
IDBI bank - Trained various finance aspirants at the premier educational institutions like
Bimtech, Delhi University, UPES(Dehradun), Chandigarh University(Mohali), BSE
Institute, ICICI Centre for Financial Learning
Rythum Verma
CFA Level III Cleared (CFA® Program)
Stock Market and Derivative Market Trader and Investor.
5+ years of training experience in Financial Modeling and Investments
Youtuber @ Knack Backers
NSE Certified Financial Modelling Trainer
- Valuation Mentor for Start-ups
- Regular Contributor to investment blogs and research
Financial Modeling Course Curriculum
Financial Modelling Course Curriculum
The investment banking course training by Mentor Me Careers is carefully crafted by ex investment bankers, credit analysts and fund managers who have spent decades in the industry.
This course curriculum was designed for bridging the gap between what the industry requires and what the students know as a part of their academics qualifications. The core objective of this program is to make students and working professionals job ready for investment banking and equity research profiles.
About The Course
Financial modeling course is the basic skill required to function in the financial and its related industry. For Example
- Risk Management: Used to model credit risk and estimate probable losses
- Equity Research: Used to make valuation models of stocks
- Private Equity: Used to make valuation models for private investments.
- Corporate finance: Used to analyse budgets and create a financial plan.
Financial Modeling Course In Pune Syllabus
The first 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
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
Module 2: Excel Part 2
The second module gets into new functions required for financial model making .
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
Sales Data case study
Module 3: Financial Mathematics
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
Fund selection Case study
No one can become a financial analyst without knowing accounting and financial statement analysis required for investment finance field. The investment banking course offered by Mentor Me will teach you financial accounting from the basics.
Introduction to Financial Statement 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
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.
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 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
12 Comprehensive Specialisations
Mergers models are A+B=C or A+B= A. The purpose of this kind of a model is to actually find the synergies and cost benefits.
LBO modeling is similar to buying a house on debt and using the rent proceeds to reduce the debt over time. Convert this into a large scale acquisition of a business using debt.
One of the favorites of the industry, because of its large contribution to India’s GDP. A very engaging model to make and easily understandable
Learn about the renewable energy project finance case on solar business. Learn its challenges, accounting assumptions and return potential
Aviation is more than just tickets. The major complication of making a aviation Model is the lease calculations and forecasting of it in the future
Education industry has changed over the years and is one of the most sought after business for investment banks. Learn how to model and value such business
Road development projects are the most interesting project finance application because of its easy to understand business details You will learn how to to estimate tolls, construction phasing and Return calculation
This is one of the complicated business to create a financial Model with various factors and a huge number of assumptions to be taken.
Did you know that real estate business model are only created using a one statement model and not three statements. A fairly easy model but complicated excel functions to manage delays
Learn to make a business plan on a star up idea from product to implementation . This can be suitable for those who have a fair idea on products and have worked with start ups before
This is guided full fledged course in which you will be told to research on strategies, read published material and execute a back tested performance of a strategy. Should be done only those, who possess strong statistics background
Make a model on one of the most talked about industry, E commerce. Learn how to forecast sales, handle negative cash flows and complete valuation
Financial Modeling Course Certifications
NSE Academy Certification
Exam Details:
Conducted across 100 centers in India
Life Time validity of the certification
NCFM Registration compulsory
