Financial Analyst Course in Pune Fees
Financial analyst course in Pune provided by Mentor Me Careers is a top Financial training course 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. The course also has a BSE Certification & Optional NSE Certification.
Placement Success
Train with Real Industry Experts
Financial Analyst Course in Pune Fees
Financial Analyst Course Placement
Features
-
200 Hrs online training
-
Guranteed interviews
-
12 Specialisations
-
Life Time Portal Validity
Financial Analyst Live Classes Online
Features
-
200 Hrs online training
-
Guranteed interviews
-
3 Specialisations
-
Life Time Portal Validity
Financial Analyst Offline Classes
Features
-
200 Hrs Offline
-
Guranteed interviews
-
12 Specialisations
-
Life Time Portal Validity
Expert Faculties
Nikhil Jain, CFA
Expertise: Credit Analysis, Financial Statement Analysis, Risk Management
Course Introduction
Financial analyst course at mentormecareers is a comprehensive 200 hrs training program for aspiring financial analysts who want to make a career in core finance and investment banking
Learning Outcomes
What is needed is an all-encompassing knowledge of excel and advanced financial functions.
• Being comfortable with mathematical calculations for finance
• The ability to create financial statements manually.
• Analysing companies’ financial statements and related data.
• Making a valuation model and giving stock recommendations.
Joint Certification from BSE Institute & Mentormecareers
Mentormcareer's financial modeling course in Mumbai comes with a built in association with Bombay stock exchange institute's Checkmy skills for providing valid certification for students.
Program Overview
Mentor Me Careers created their course for financial analysts with the help of former investment bankers, fund managers and credit analysts who have been working in this field for years.
The curriculum was made to bring together what students learn during their academic qualifications with what is required by industries. This program mainly targets at equipping individuals with skills necessary for investment banking as well as equity research profile jobs.
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
Placement Process
Goal Setting
Baselining
Profile Building
Job Applications
Mock Interviews
Success
Recent Placements in Pune
FAQ's
We believe in maximising learning efficiency and minimising student discomfort.We aim at maximum twenty students per batch in the financial analyst course
This skill should be learnt to crack investment banking interviews. Check out the kind of questions you will face in an interview here.
I will try to answer this in a very short and brief manner
- Our focus is only on placements
- We have the highest rated course delivery in India
- We provide unlimited interviews
- Finally we have more than 1000 recruiters on board to provide you maximum opportunities.
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 Weekday- For Freshers
- Live online Plus weekend- for working professionals
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.
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.
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.
Reach Us Out
Mentormecareers,office No 130, 1st Floor, Regus Manikchand, SKY ONE, Lunkad Sky Lounge, Kalyani Nagar, Pune, Maharashtra 411006