Scribd Logo
Upload

Welcome to Scribd!

  • 70 views

    Financial Modeling Topic

    Uploaded by

    AMLAN
    The document outlines the curriculum for a financial modeling certification program. It covers topics such as financial statement analysis, valuation, accounting, ratios, and using Excel for financial modeling. The program teaches skills for building financial models for companies in various sectors such as banking, real estate, energy, and healthcare. It also covers modeling mergers and acquisitions and includes case studies for practical experience.

    Copyright:

    © All Rights Reserved
    Download as RTF, PDF, TXT or read online from Scribd

    Financial Modeling Topic

    Uploaded by

    AMLAN
    70 views5 pages
    The document outlines the curriculum for a financial modeling certification program. It covers topics such as financial statement analysis, valuation, accounting, ratios, and using Excel for financial modeling. The program teaches skills for building financial models for companies in various sectors such as banking, real estate, energy, and healthcare. It also covers modeling mergers and acquisitions and includes case studies for practical experience.

    Copyright

    © © All Rights Reserved

    Available Formats

    RTF, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines the curriculum for a financial modeling certification program. It covers topics such as financial statement analysis, valuation, accounting, ratios, and using Excel for financial modeling. The program teaches skills for building financial models for companies in various sectors such as banking, real estate, energy, and healthcare. It also covers modeling mergers and acquisitions and includes case studies for practical experience.

    Copyright:

    © All Rights Reserved
    Download as RTF, PDF, TXT or read online from Scribd
    Download as rtf, pdf, or txt
    70 views5 pages

    Financial Modeling Topic

    Uploaded by

    AMLAN
    The document outlines the curriculum for a financial modeling certification program. It covers topics such as financial statement analysis, valuation, accounting, ratios, and using Excel for financial modeling. The program teaches skills for building financial models for companies in various sectors such as banking, real estate, energy, and healthcare. It also covers modeling mergers and acquisitions and includes case studies for practical experience.

    Copyright:

    © All Rights Reserved
    Download as RTF, PDF, TXT or read online from Scribd
    Download as rtf, pdf, or txt
    You are on page 1of 5

    1.

    Curriculum
    http://www.cfinstitute.in/financial-modeling-
    program/
    • Advance Excel Tools for Financial Modeling

    • Analyze and Present Data Visually in PowerPoint

    • Macros and VBA

    • Financial Statement Analysis

    • Introduction to Valuation

    • Financial Modeling (Automobile) and DCF Template Creation

    • Comparable Company Analysis – Trading and Transaction Comps

    • Comcast and Time Warner Merger Modeling Training

    • Introduction to Project Finance

    • LBO Modeling

    • Ratio Analysis Foundation

    • Financial Modeling – Banking Sector

    • Financial Modeling – Real Estate Sector

    • Financial Modeling – Energy Sector

    • Financial Modeling – Capital Goods Sector

    • Financial Modeling – Media Sector

    • Financial Modeling – Telecom Sector

    • Financial Modeling – Retail Sector


    • Financial Modeling – Healthcare Sector

    2.TABLE OF CONTENT
    https://www.vskills.in/certification/accounting-banking-and-
    finance/financial-modelling-certification
    ·0 Financial Modelling Basics

    ·1 What is Financial Modelling

    ·2 Financial Models Application

    ·3 Financial Modeling Approaches

    ·4 Financial Modeling Guidelines

    ·5 Income Statement (Profit and Loss Account)

    ·6 Cash Flow Statement

    ·7 Cash Flows from Operations

    ·8 Cash Flows from Investments

    ·9 Cash Flows from Financing

    ·10 Balance Sheet

    ·11 Financial Ratios

    ·12 Liquidity ratios

    ·13 Leverage ratios

    ·14 Turnover Ratios

    ·15 Profitability Ratios

    ·16 Market Value Ratios


    ·17 Du Point

    ·18 Components of Balance Sheet

    ·19 Shareholders' equity

    ·20 Depreciation

    ·21 Goodwill

    ·22 Non-Controlling Interest

    ·23 Deferred Tax Liability

    ·24 Time Value of Money

    ·25 Internal Rate of Return

    ·26 Net Present value

    ·27 Using Excel for Financial Modelling

    ·28 Excel 2013 Basics

    ·29 Workbook and Worksheet

    ·30 Manipulating Data

    ·31 Worksheet Formatting

    ·32 Page Properties and Printing

    ·33 Excel Formulas

    ·34 Sort and Filter

    ·35 Charts

    ·36 Macros

    ·37 Excel Shortcuts

    ·38 Access keys for ribbon tabs


    ·39 Work in the ribbon with the keyboard

    ·40 Keyboard shortcuts for navigating in cells

    ·41 Keyboard shortcuts for formatting cells

    ·42 Keyboard shortcuts for making selections and performing actions

    ·43 Keyboard shortcuts for working with data, functions, and the
    formula bar

    ·44 Function keys

    ·45 CTRL combination shortcut keys

    ·46 EMI Calculation in Excel

    ·47 Iterating Circular References

    ·48 Macros

    ·49 Valuation

    ·50 Valuation Basics

    ·51 Discounted Cash Flow

    ·52 Estimating Future Cash Flow

    ·53 Free Cash Flow to Firm (FCFF)

    ·54 Free Cash Flow to Equity (FCFE)

    ·55 Weighted Average Cost of Capital (WACC)

    ·56 Cost of Debt

    ·57 Cost of Equity

    ·58 Capital Asset Pricing Model (CAPM)

    ·59 Risk Free Rate


    ·60 Beta

    ·61 Market Risk Premium

    ·62 Trading and Transaction Comparable

    ·63 Football Field Analysis

    ·64 Mergers and Acquisitions

    ·65 Case Study

    ·66 Financial Modelling Case Study - 1

    ·67 Financial Modelling Case Study - 2

    You might also like