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
- Liquidity ratios
- Leverage ratios
- Turnover Ratios
- Profitability Ratios
- Market Value Ratios
- Du Point
- Shareholders' equity
- Depreciation
- Goodwill
- Non-Controlling Interest
- Deferred Tax Liability
- Time Value of Money
- Internal Rate of Return
- Net Present value
- 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 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
- Financial Modelling Case Study - 1
- Financial Modelling Case Study - 2
Job roles this course is suitable for:
Financial Analyst , Financial Modeler , Financial Modelling SpecilistAbout 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
Courses you can instantly connect with... Do an online course on Finance starting now.
- Accounting and Finance Course LineUSD 24
USD 260Duration: Upto 13 Hours - Diploma in Accounting and Business Finance Academy for Health & FitnessUSD 218Duration: Upto 114 Hours
