Home > Finance > Financial Modelling Using Excel Certification Training

Ask us everything about the program

Financial Modelling Using Excel Certification Training

_
Overview
  • manipal overview icon
    Certification
    Get an industry-wide recognised certificate in Financial Modelling using Excel from Manipal Prolearn
  • manipal overview icon
    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.
  • manipal overview icon
    Who Should Attend
    MBAs, CFAs, CAs, FRMs, B-Tech and Commerce Graduates
  • manipal overview icon
    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.
  • manipal overview icon
    Expert Faculty
    Learn from subject matter experts, course designers and developers who come with a vast experience in financial modelling using excel.
manipal overview icon
Certification
Get an industry-wide recognised certificate in Financial Modelling using Excel from Manipal Prolearn
manipal overview icon
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.
manipal overview icon
Who Should Attend
MBAs, CFAs, CAs, FRMs, B-Tech and Commerce Graduates
manipal overview icon
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.
manipal overview icon
Expert Faculty
Learn from subject matter experts, course designers and developers who come with a vast experience in financial modelling using excel.
_
Course Curriculum
1.1 Excel - Basics & Advanced
manipal icon

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
manipal icon

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
manipal icon

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
manipal icon

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
manipal icon

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
manipal icon

Understanding Project Finance
Building the Project Finance Model

3.3 M&A Analysis
manipal icon

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
manipal icon

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?
manipal icon

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?
manipal icon

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?
manipal icon

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?
manipal icon

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?
manipal icon

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?
manipal icon

Yes, we do.

I have enrolled successfully, what are the next steps?
manipal icon

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?
manipal icon

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?
manipal icon

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
Back To Topmanipal icon

Find Financial Modelling Using Excel Certification Training in Other Cities