MENTOR ME CAREERS

Financial Modeling Course Fees |Guranteed Interviews

Financial modeling course fees at mentormecareers are available with the following variants
  • Self paced at INR 10999
  • Live virtual at INR 16499
  • Live with Placement at INR 32999

Financial Modeling Course Fees & Features

Recommended For Placements

Financial Modeling Course with Placement

INR32999
Plust GST

Features

  • 200 Hrs online training
  • Guranteed interviews
  • 12 Specialisations
  • Life Time Portal Validity
Enrol Now
For Learning

Financial Modeling Live Classes Online

INR16499
Plus GST

Features

  • 200 Hrs online training
  • Guranteed interviews
  • 3 Specialisations
  • Life Time Portal Validity
Enrol Now
I got placed in MITCON as a project consultant after completion of financial modeling course provided by mentormecareers.
Numan palced in MITCON pune
Numan Baghwan
Project Consultant, MITCON
I got placed in Wirpo as a financial planning & analysis after completion of financial modeling course by mentormecareers.
Nikita Shinde placed in WIPRO
Nikita Shinde
FP&A Analyst WIPRO Pune
I got placed in ADO Pune with the placement support from financial modeling course in Pune by mentormecareers
Mruga Gadkari Placed in ADP Pune
Mruga Gadkari
Financial Analyst, ADP
Financial Modeling Already Done

Financial Modeling Placements Support

INR16499
Plus GST

Features

  • 200 Hrs online training
  • Guranteed interviews
  • 3 Specialisations
  • Life Time Portal Validity
Enrol Now
For Experienced Candidates

Self Paced
Learning

INR10999
Plus GST

Features

  • 200 Hrs online training
  • Guranteed interviews
  • 3 Specialisations
  • Life Time Portal Validity
Enrol Now
Abhishek Dhumale
Abhishek Dhumale
2024-06-04
i have enrolled for financial modeling course with mentorme careers it was grate experience. Highly recommend if you want to make your career in core finance field.The placement support of Mentor Me Careers is good and very supportive thank you very much all mentorme career team.
Rohan Mhetre
Rohan Mhetre
2024-05-30
The Financial Modelling course has been an incredible experience. The faculty members have an exceptional teaching style, providing in-depth explanations and real-world examples that truly prepare you for success in the job market. I highly recommend this course to anyone looking to gain practical skills in financial modelling
Ritesh Sawarkar
Ritesh Sawarkar
2024-05-30
I think mentor me is best platform for Finance career, I learnt a lot from Allen sir in vedio lectures classes... My concept now very clear regarding finance. All thanks to Mr. Allen sir, Mentor Me Careers.
Prachi Arora
Prachi Arora
2024-05-28
Best career services provided by them!
Prachi Arora
Prachi Arora
2024-05-28
The best career services. Provide guidance and training according to the requirement of the job market. Totally recommended!👍

Syllabus

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.

Module 1: Excel Part 1

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

Financial mathematics is a key learning required for corporate finance calculations. Hence the following topics are covered

  • 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, to analyse the companys performance.

  • 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

  1.  

    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

  1.  

    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

  1.  

    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

  1.  

    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(Discounted cash flow) 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

  1. Valuation Basics- DCF, Gordon growth, WACC, Cost of equity , Levered, Un levered Beta, Terminal Value

  2. Creating a model template

  3. Data collection and data feeding in financial model

  4. Revenue Driver- breaking the business into Price and quantity metrics, so that you can forecast those metrics

  5. Cost Driver

  6. Debt Schedule , Asset schedule Forecast

  7. Free Cash flow calculation

  8. Valuation Calculation

  9. Sensitivity Analysis

  10. 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. Particularly this specialisation is usefull for private equity job opportunties.

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

Certificate in investment banking

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.

Recruiters

Placement Process

Goal Setting

Baselining

Profile Building

Job Applications

Mock Interviews

Success

FAQ's Financial Modeling Course Fees

We at mentor me careers, provided the best value for money proposition for financial modelling course. Our lowest fees is a result of optimising our business’s, to provide you with the best price possible. 

Also, we don’t have any hidden charges or extra chargest that will every surprise a student.

Based on your goals, of doing this course we provide;

  • Pre- recorded content
  • Live classes
  • One to one mentoring and doubt solving sessions.
  • Longer validity of the live course.
  • Interviews based on your preference of profile and city.
  • Question bank for interviews

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.

It all depends on the your learning curve and previous backgrounds. Below is the summary of recommendation’

  1. Self Paced Basic- Suitable for Finance professionals

  2. Self Paced Plus- Suitable for candidates who are well versed with fundamentals and are self learners

  3. Live Online Basic- Suitable if you are not looking for placement and are just up skilling

  4. Live Online Plus- Suitable for MBA Freshers, CA Inters, CFA Level 1 ,2 Candidates, Commerce Graduates who are looking for a Job.

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. 

×