Certified Financial Modeling Professional

How It Works

  1. 1. Select Certification & Register
  2. 2. Receive Online e-Learning Access (LMS)
  3. 3. Take exam online anywhere, anytime
  4. 4. Get certified & Increase Employability

Test Details

  • Duration: 60 minutes
  • No. of questions: 50
  • Maximum marks: 50, Passing marks: 25 (50%).
  • There is NO negative marking in this module.
  • Online exam.

Benefits of Certification


$49.00 /-
Download Brochure

Vskills certification for Financial Modelling assesses the candidate as per the company’s need for building financial models for analyzing firms, IPOs & FPOs. The certification tests the candidates on various areas in Financial Modelling and Valuation principles.

Why should one take this certification?

This Course is intended for professionals and graduates wanting to excel in their chosen areas. It is also well suited for those who are already working and would like to take certification for further career progression.

Earning Vskills Financial Modelling Certification can help candidate differentiate in today's competitive job market, broaden their employment opportunities by displaying their advanced skills, and result in higher earning potential.

Note: Please note the course comes with online learning, no hard copy will be provided.

Who will benefit from taking this certification?

Job seekers looking to find employment in the finance or banking sectors, departments of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.

Financial Modelling Table of Contents

https://www.vskills.in/certification/financial-modelling-table-of-contents

Financial Modelling Tutorials

https://www.vskills.in/certification/tutorial/financial-modelling-professional/

Financial Modelling Practice Test

https://www.vskills.in/practice/financial-modelling

Financial Modelling Interview Questions

https://www.vskills.in/interview-questions/financial-modelling-interview-questions

Companies that hire Financial Modelling Professionals

Financial Modelling professionals are in great demand. Companies specializing in Investment, Equity Research, Credit, Project, Mergers & Acquisition, Corporate Finance, etc. are constantly hiring skilled financial modeling experts. Various public and private companies also need financial modelers for their array of departments.


Financial Modelling Related Blogs

Checkout the latest online blogs on Financial Modelling.

Financial Modelling Jobs

Checkout the various job openings for Financial Modelling, click here..

Financial Modelling Internships

Vskills runs its flagship internship programme where bright interns work with academic council, click to know more details..

Apply for Financial Modelling Certification

By Net banking / Credit Card/Debit Card

We accept Visa/Master/Amex cards and all Indian Banks Debit Cards. There is no need to fill application form in case you are paying online.

Please click buy now to proceed for online payments.

​Visa Card Master Card American Express

Buy Now

TABLE OF CONTENT

Chapter 1. Financial Modelling Basics

  • What is Financial Modelling
  • Financial Models Application
  • Types of Financial Models
  • Financial Modelling Guidelines
  • Income Statement (Profit and Loss Account)
  • Cash Flow Statement & its components
  • Balance Sheet
  • 3-Statement Model Integration (linking P&L → BS → CF)
  • Model Architecture & Best Practices (hardcoding, color coding, error checks)
  • Scenario & Sensitivity Analysis Fundamentals

Chapter 2. Financial Ratios

  • Liquidity Ratios
  • Leverage Ratios
  • Turnover Ratios
  • Profitability Ratios
  • Market Value Ratios
  • DuPont Analysis
  • Ratio-based Red Flags & Interpretation in Models

Chapter 3. Components of Balance Sheet

  • Shareholders' Equity
  • Depreciation
  • Goodwill
  • Non-Controlling Interest
  • Deferred Tax Liability
  • Time Value of Money (Financial Mathematics)
  • Internal Rate of Return / Net Present Value (Valuation)
  • Working Capital & Working Capital Adjustments
  • Debt Schedule & Amortization

Chapter 4. Using Excel for Financial Modelling

  • Workbook and Worksheet (Examples to Excel 365/2021)
  • Manipulating Data
  • Worksheet Formatting
  • Excel Formulas (but expand)
  • Merge into Manipulating Data
  • Financial Charts & Dashboards
  • Macros with VBA basics (intro to Power Query)
  • Essential Keyboard Shortcuts
  • EMI Calculation in Excel
  • Iterating Circular References
  • Key Financial Functions (XNPV, XIRR, OFFSET, INDEX/MATCH, SUMIFS)
  • Data Tables for Sensitivity Analysis (1-way & 2-way)
  • Named Ranges & Dynamic Arrays
  • Power Query for Financial Data Cleanup

Chapter 5. Valuation

  • Valuation Basics
  • Discounted Cash Flow (DCF)
  • Estimating Future Cash Flow
  • Free Cash Flow to Firm (FCFF)
  • Free Cash Flow to Equity (FCFE)
  • Weighted Average Cost of Capital (WACC)
  • Cost of Debt & Cost of Equity
  • CAPM, Risk-Free Rate, Beta, Market Risk Premium
  • Trading & Transaction Comparables
  • Football Field Analysis
  • Mergers and Acquisitions (M&A Modelling)
  • Terminal Value (Gordon Growth vs Exit Multiple)
  • Enterprise Value vs Equity Value Bridge
  • Relative Valuation — EV/EBITDA, P/E, P/B multiples
  • Sum-of-the-Parts (SOTP) Valuation

Chapter 6. M&A Modelling (New Section)

  • Merger Model Overview & Deal Structure
  • Accretion / Dilution Analysis
  • Purchase Price Allocation (PPA)
  • Pro Forma Combined Financial Statements
  • LBO (Leveraged Buyout) Model Basics

Chapter 7. Revenue & Cost Modelling / FP&A (New Section)

  • Revenue Build-Up (Volume × Price, subscription, unit economics)
  • Cost Build-Up (fixed vs variable, COGS, OpEx structure)
  • EBITDA Bridge & Waterfall Charts
  • Budget vs Actuals & Variance Analysis
  • Rolling Forecasts & Dynamic Models

Chapter 8. Case Studies

  • Case Study 1 → Specify industry (e.g., manufacturing / FMCG 3-statement model)
  • Case Study 2 → Specify type (e.g., DCF valuation of a listed company)
  • Case Study 3 — M&A / Accretion-Dilution Model
  • Case Study 4 — Startup Financial Plan & Funding Model

Write a review

Please login or register to review

 For Support