Financial Modelling Using Excel Certification Training
Learn financial modelling and build yourself a rewarding career by gaining an in-depth understanding of financial projections, equity research and valuation.
-
3533
Learners -
76+
Hours -
24x7
Online LMS -
30 Hours of
Video Lectures
3533
Learners
Learners
76+
Hours
Hours
24x7
Online LMS
Online LMS
30 Hours of
Video Lectures
Video Lectures
₹
14,500
Ask us everything about the program
Financial Modelling Using Excel Certification Training
_
Overview
-
CertificationGet an industry-wide recognised certificate in Financial Modelling using Excel from Manipal Prolearn -
Enhanced Job OpportunitiesThe scope of financial modelling is on the rise across the world. CA’s/CFA’s can kick-start their career and join the corporate world as an Equity Valuation Associate immediately after completing the financial modelling course. -
Who Should AttendMBAs, CFAs, CAs, FRMs, B-Tech and Commerce Graduates -
Salary PackagesA fresh graduate having successfully completed the financial modelling course can expect to earn a salary in the range of 3-5 lakhs INR p.a. -
Expert FacultyLearn from subject matter experts, course designers and developers who come with a vast experience in financial modelling using excel.
Certification
Get an industry-wide recognised certificate in Financial Modelling using Excel from Manipal Prolearn
Enhanced Job Opportunities
The scope of financial modelling is on the rise across the world. CA’s/CFA’s can kick-start their career and join the corporate world as an Equity Valuation Associate immediately after completing the financial modelling course.
Who Should Attend
MBAs, CFAs, CAs, FRMs, B-Tech and Commerce Graduates
Salary Packages
A fresh graduate having successfully completed the financial modelling course can expect to earn a salary in the range of 3-5 lakhs INR p.a.
Expert Faculty
Learn from subject matter experts, course designers and developers who come with a vast experience in financial modelling using excel.
About Course
Stay ahead of the curve and jumpstart your career in the field of finance by equipping yourself with the knowledge of financial modelling – one of the most sought-after skills in today’s corporate world. Learn how to determine the financial health of a company and build financial projections using Microsoft Excel with Manipal ProLearn’s Financial Modelling course.
This course helps you to learn financial modelling in all aspects - starting from using basic and advanced Excel to value companies, as well as analysing the Merger & Acquisition (M&A). Designed to help students understand the essence of the subject, it simultaneously teaches you how to use real-world problems to construct consistent and realistic financial models using MS Excel as an analytical tool.
What skills you learn
After completing the course in Financial Modelling using Excel, you’ll gain proficient knowledge in financial modelling through an experiential model that incorporates a rich set of examples and industry scenarios. This financial modelling course will help you:
- Perform Basic and Advanced Calculations in MS Excel
- Analyse Companies
- Build Financial Projections-Income Statement, Balance Sheet, Cash Flow Statement
- Perform a Discounted Cash Flow (DCF) & Relative Valuation
- Analyse Mergers & Acquisitions (M&A)
- Analyse and Build Projects Finance Models
- Build M&A models and analyse the transaction
Who Should Attend this course
MBAs/CFAs,
CAs/FRMs
B-Tech/Commerce Graduates
Candidates looking to make a career in equity research, valuation, private equity funds, investment banking or commercial banking, project management etc.
MBAs/CFAs, | CAs/FRMs |
B-Tech/Commerce Graduates | Candidates looking to make a career in equity research, valuation, private equity funds, investment banking or commercial banking, project management etc. |
Key Features
Master Microsoft Excel
Post-completion of the financial modelling course, you’ll be able to perform Basic and Advanced Calculation in MS Excel
Comprehensive Course Curriculum
An online financial modelling tutorial, taught through videos, case studies, reading material, and demos.
Superior Learning Outcome
Upon successful completion of the course, you’ll be able to do financial modelling using excel to determine the valuation of a company and build financial projections.
Request a Call Back
_
Course Curriculum
1.1 Excel - Basics & Advanced
Basic Shortcuts & formulas in Excel (sumif, sumifs, nested if, vlookup, hlookup and many more)
Advanced formulas -Named Ranges, Index Match, Array Functions, Building Scenarios using Offset Functions, Index functions, Usage of Indirect Functions, Usage of Goal Seek and Solver Function
Array Functions
Pivot tables
1.2 Charts
Creating and formatting Basic Charts in Excel
Charting with two axes and chart type
Bubble Charts
Creating a Dynamic Range Chart
Creating Radar/Spider Charts
Creating Waterfall Charts
Creating a Football Field Chart
Creating Gantt Chart
2.1 Financial Statement Analysis
Building a financial model template
Gathering and organising the historical data
Understanding the Income Statement, Balance Sheet and Cash Flow statement of a company
Calculating Financial ratios
2.2 Forecasting Financial Statements
Understanding the Business Model – Identifying key Revenue & Cost Drivers
Forecasting the drivers
Preparing Balance Sheet schedules
Forecasting Profit & Loss Statement
Forecasting Balance Sheet
Linking the Cash Flow Statement
Ratio Analysis
3.1 DCF Modelling
Calculating Cost of Capital [Weighted Average Cost of Capital (WACC), Capital Asset Pricing Model (CAPM)]
Discounted Cash Flow (DCF) Model – Free Cash Flow to Firm (FCFF) v/s Free Cash Flow To Equity (FCFE) model
Relative Valuation
Performing Sensitivity / Scenario Analysis
3.2 Project Finance
Understanding Project Finance
Building the Project Finance Model
3.3 M&A Analysis
What are Mergers & Acquisitions (M&A) and why do companies need M&A
Payment Methods in M&A
Types of offer
Key Inputs into an M&A Analysis
Understanding & analysing accretion & dilution
Analysing the impact of different financing plans
Analysing the impact of different ownership structures
Analysing the impact of Transaction Price and Financing Structure through Sensitivity Analysis
Performing Contribution Analysis
Valuing a transaction
Valuation Analysis with different methods of valuation
3.4 Case Study
Analysing a Company
Gathering Historical Data
Building Business Model and revenue drivers
Calculating WACC (Weighted Average Cost of Capital) Cost of Equity, Terminal Value
Arriving at the value of a Company using DCF and Relative valuation
Doing a sensitivity analysis of your assumptions
_
Frequent Questions we get
What topics are covered in this program?
During this program, you will learn Financial Modelling techniques like forecasting financial statements, analysing M&A transactions among others.
How will this program help me in my career?
Always Relevant: This course trains you on expert level of knowledge of MS Excel and creating finance models for many relevant situations that either can pertain to your job or personal life.
Build Projections: With the taught skills, you can build a cash projection for your personal income, a company valuation model to a project finance model.
Increase your Efficiency: You can create wonderful analysis using great visuals including charts and graphs, and give better business insights to your company. This will help you be more effective in your job.
Job Search: You can showcase your Financial Modelling skills on your resume and grab coveted job positions.
Do you provide face-to-face classes?
No, this course is available only through online mode of study. This mode of learning allows you to study anytime and from anywhere, based on your convenience. We also provide 365 days access to all course materials. You can download them and refresh what you learnt whenever you need it.
What kind of case studies are included in this program?
Currently, we provide one case study from each sector, viz retail, healthcare etc.
How many video sessions will I get during the course of the program?
We provide 30 hours of video assistance to the learners. These recorded videos include every aspect of the course and cover them in minute details to ensure an in-depth understanding of the topics. You will also get contact details of faculty whom you can reach out in case of any confusion.
Do you provide placement assistance?
Yes, we do.
I have enrolled successfully, what are the next steps?
As soon you pay for the course, you will be provided with a login and password to access EDUNXT.MANIPALPROLEARN.COM. You can find all the information and study material related to your course on the EDUNXT.MANIPALPROLEARN.COM platform. You can access this platform 24x7, download PDF files of study material and chat with faculty, when in doubt.
What are the payment options?
You can pay through your debit card or net banking in one shot. You can also pay by Credit Card from all the leading banks. EMI Option can be availed when using a credit card (interest will have to be borne by you).
What If I have more queries?
In case, there is something more that you want to know, then please do call us at our toll-free number 1800-103-5941 or drop us a mail at support@manipalprolearn.com
Didn’t find your question here? What would you like to know?
Ask a Question add_circle_outline
_
Read up our trending blogs
Apr 04
Top Five Skills Necessary to Set Up a Stellar Career in Cyber Security
The mind-boggling pace at which technologies continue to evolve has opened a whole new front of...
1949
Apr 04
How to Get Hands-On Experience in Cyber Security
This is the best time to take up a career in Cyber Security! The ever-growing market for experts...
1890
Apr 04
3 Steps to create an AI-First Enterprise
Smarter organisations are already adopting AI to reduce time-to-market and enable better customer...
2008
