Certificate Program in Financial Modelling

Home > Finance >Certificate Program in Financial Modelling

Ask us everything about the program
_
Overview
  • 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.
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.
_
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
Back To Top