Certified Financial Modelling Professional Vskills

Certified Financial Modelling Professional

Vskills

Price: USD 49

Duration: 1 To 2 Months
Timings: Part Time, Flexible

Course details

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.

Table of Contents

Financial Modelling Basics

What is Financial Modelling
Financial Models Application
Financial Modeling Approaches
Financial Modeling Guidelines
Income Statement (Profit and Loss Account)
Cash Flow Statement
Cash Flows from Operations
Cash Flows from Investments
Cash Flows from Financing
Balance Sheet

Financial Ratios

Liquidity ratios
Leverage ratios
Turnover Ratios
Profitability Ratios
Market Value Ratios
Du Point

Components of Balance Sheet

Shareholders' equity
Depreciation
Goodwill
Non-Controlling Interest
Deferred Tax Liability
Time Value of Money
Internal Rate of Return
Net Present value

Using Excel for Financial Modelling

Excel 2013 Basics
Workbook and Worksheet
Manipulating Data
Worksheet Formatting
Page Properties and Printing
Excel Formulas
Sort and Filter
Charts
Macros
Excel Shortcuts
Access keys for ribbon tabs
Work in the ribbon with the keyboard
Keyboard shortcuts for navigating in cells
Keyboard shortcuts for formatting cells
Keyboard shortcuts for making selections and performing actions
Keyboard shortcuts for working with data, functions, and the formula bar
Function keys
CTRL combination shortcut keys
EMI Calculation in Excel
Iterating Circular References
Macros

Valuation

Valuation Basics
Discounted Cash Flow
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
Capital Asset Pricing Model (CAPM)
Risk Free Rate
Beta
Market Risk Premium
Trading and Transaction Comparable
Football Field Analysis
Mergers and Acquisitions

Case Study

Financial Modelling Case Study - 1
Financial Modelling Case Study - 2

Updated on 01 February, 2019

Job roles this course is suitable for:

Financial Analyst , Financial Modeler , Financial Modelling Specilist

About Vskills

Vskills is the largest certification body of India. We conducts skills testing and certification exam to improve employability. The certifications are quite popular and top companies hire Vskills certified professionals.

Companies have benefitted by hiring pre-certified candidates from Vskills and also use the certifications for their in house employee appraisals. Certification helps in distinguishing individuals to demonstrate their domain knowledge or skills needed for a specific profile. So a professional certification offers tangible benefits to both the individual and the employer.

Tests are conducted in a secure and unbiased manner, and certificates are awarded based on merit of the candidates who qualify tests.
Vskills certifications are for relevant qualifications that help students/employees quantify and prove those skills that are valued by the employer and are in great demand. See all Vskills courses

Ask Laimoon

View more similar courses

Courses you can instantly connect with... Do an online course on Finance starting now.