Financial Modelling Online Training

Overview

  • Lectures 8
  • Quizzes 1
  • Duration 60 hours
  • Skill level Beginner
  • Language English
  • Students 32
  • Assessments Yes
Learning Outcomes & Flexibilities
  • Over 17 modules and 55.5 hours of content!
  • Implement your theoretical learning practically on your own website .
  • Understand Design-Based Thinking & Planning.
  • Demonstrate cognitive knowledge of the skills required in conducting online research and research on online markets, as well as in identifying, assessing and selecting digital market opportunities..
  • Investigate and evaluate issues in adapting to globalised markets that are constantly changing and increasingly networked.
  • Interpret the traditional marketing mix within the context of a changing and extended range of digital strategies and tactics.
  • Comprehend the importance of conversion and working with digital relationship marketing.
  • Analyse cross-cultural and ethical issues in globalised digital markets
  • One Training 9 Certifications: DSIM industry recognised certification, 7 google certifications & facebook certification.
  • Build your own Website .
  • Best suitable for beginners to advanced level users and who learn faster when demonstrated.
  • Back up classes, in case you miss few classes.
  • Batches as per your availability- Evening, Weekend, Sunday, Online .
  • Doubt Clearing Session: 2 hours doubt session every month after completion of training at no charges
  • INR 63,624/- Free Tools & Softwares: Lead capture plugin, WP Theme, E-commerce tools, Content builder tool, SEO Software, Push notification tool, website conversion app.
  • Learn the art of making money online known to very few experts worldwide.
  • In-Class & Online Classes: 2 comprehensive platforms to choose from: Live interactive online training & in-class training.
  • Job assistance and interview scheduling.

Curriculum

  • 1.Excel Proficiency Overview
    • 1.1 Formatting of Excel Sheets
    • 1.2 Advanced Modeling Techniques
    • 1.3 Data Filter and Sort
    • 1.4 Charts and Graphs
    • 1.5 Table formula and Scenario building
    • 1.6 Lookups:Vlookup
    • 1.7 pivot tables
    • 1.8 Use of Excel Formula Function
  • 2. Financial Statement Analysis & Ratios
    • 2.1 Introduction to Financial Statement Analysis
    • 2.2 Introduction to Financial Statement Analysis
    • 2.3 Understanding Income Statement, Balance Sheet, Cash Flow Statement
    • 2.4 Financial Analysis Techniques
    • 2.5 Inventories,Long-Lived Assets
    • 2.6 Non-Current Liabilities
    • 2.7 Financial Statement Application
    • 2.8 Ratio analysis of industries
    • 2.9 Du point Analysis
    • 2.10 Peer to peer analysis
    • 2.11 Preparation of Financial Analysis report on an industry
  • 3. Financial Management & Corporate Finance
    • 3.1 TIMEVALUE OF MONEY.
    • 3.2 LONG TERMFINANCING
    • 3.3 COST OF CAPITAL
    • 3.4 MEASURE OF LEVERAGE
  • 4. Project Finance Modeling
    • 4.1 Why Project evaluations
    • 4.2 Stages of project
    • 4.3 Construction & development phase
    • 4.4 Funding during investment phase
    • 4.5 Costs duringinvestment phase
    • 4.6 Life of project; decision making
    • 4.7 Cash flow waterfall
    • 4.8 Resolving circular reference
  • 5. Equity Research Modeling
    • 5.1 Prepare Financial Statement
    • 5.2 Analyze Revenue and Costs
    • 5.3 Forecast Revenues, Costs, Debt etc
    • 5.4 Project Future Financial Statements
    • 5.5 Performa Adjustments, Compute Margins/Ratios
    • 5.6 Valuation- Discounted Cash Flow Method (DCF), Others
    • 5.7 Prepare Presentation Sheet,Company Overview , Sector Overview
  • Final
    • Part 1. Final Test
      120 minutes