COURSE DESCRIPTION

Financial Modelling involves analysing financial data in real world scenario for decision making, Financial Modelling applies variety of skills like Equity Research, Mergers and acquisitions, Project Management etc.

Flow of the course

Flow 1: Mini-caselets will be used to explain the concept of Flags, Circularity Switch, scenario building formulas and logic building Excel functions

Flow 2: One case study will be taken to explain the linkages between Assumptions, Working Schedules, Income Statement, Balance Sheet and Cash Flow Statement. This will ensure that the model is correctly integrated. A full Financial Model will be taken up.

What you'll learn in this course:

  • Excel Based Taining
  • Industry Relevent Content
  • Training by Industry Experts
  • Presentation Skills
  • Advance strategies of Derivatives
  • Case Study Based Hands-on Training

This Course Includes

  • 20% OFF ₹ 24,999 ₹ 19,999 Only few day left at this price!
  • Duration 30+ hours
  • Topics 43+
  • Validity Life Time
  • Class Delivery Live Online
  • Language English/Hindi
  • Students 1649+
  • Certificate Yes
  • Enroll Now
Live Classes
Module 1 Excel
  • Basic Excel
  • Lookup Function
  • Index & Match
  • Logical Statement
  • Module 1 Countinued
  • Pivot Tables
  • What if Analysis
  • Date & Text Functions
  • Arrays
  • Module 2 Topics Covered
  • Assumptions Build Up
  • Accomodate Project Delays
  • Upfron Capex in a Phased Manner
  • Building Time Line
  • Module 2 Countinued
  • Timing & Event Activation
  • Operation Start Flags
  • Operation Count. Flags
  • Operation Year Counter
  • Module 2 Countinued
  • Loan Repayment Flag
  • Revenue Vuild up
  • Capex Schedule
  • Base Analysis
  • Module 2 Countinued
  • Depreciation Schedule
  • Building Depr. Calculaiton
  • Interest During Construction
  • Hard vs Soft Capex
  • Module 2 Continued
  • Dividing Interest(IDC & P&L)
  • Waterfall Structure
  • Equity Drawdown
  • Incorporation Revolver
  • Debt Schedule & Repayment
  • Module 2 Continued
  • Working Capital Schedule
  • Building Iterative Calculation
  • Incorporation Circularity
    • Who Should Do This Course

      • Finance graduates, Credit Analysts, Business analysts, Researchers, Financial consultants, Small and mid-size business owners.
      • Anyone wishes to understand the basic to advance function of excel for financial models.
      • Those who want to enhace their excel skills
    • Eligibility

      • No minimum criteria
      • But due to the complexity of the course, it is easier for students with Accounting, statistics and Finance background to understand the concept of Financial Models.
    • Live Training Has an Edge

    • Live trainings are more interactive than recorded videos to get practical and experiential learning from Industry experts with our Live online Classroom training. Moneyweiss is determine to provide best in class delivery methodology.

    • Objectives of this course

      This course covers the basic and advance excel and fundamental and practical knowledge of valuation analysis, assumption build up (Project Start Date, Gestation Period, Project Commissioning Date etc.), Revenue Build-up (PPA / Merchant Sale) with YoY escalation in prices, building depreciation calculations that stops after the book balance is fully depreciated. Financial Modelling through Excel will make the learners confident enough to create their financial model right from scratch. Learn Financial Modelling and be an expert in deriving company valuation! It is designed to offer students the intensive instruction and training needed to successfully compete in rapidly developing global financial markets.

    • Benefit of this course

      Financial modelling is one of the most desired skills in todays corporate world. The demand of a financial modelling analyst is increasing day by day. It is no surprise that the essential skills required by finance professionals is proficiency in financial modelling.

    • Nitin Vashist

      Lead Trainer

      Nitin is sr. research analyst in equity and derivatives. Nitin has trained many students and corporate employees and always passionate about finding new ways to share his knowledge.

    REVIEWS
    Average Rating
    Detailed Rating
    5
    3 ratings

    Detailed Rating

    5
    100%
    4
    0%
    3
    0%
    2
    0%
    1
    0%

    Anthony

    Beautiful theme - Awesome plugin

    5 stars for this theme too. Education WP theme brings the best LMS experience ever with super friendly UX and complete eLearning features. Really satisfied

    Anthony

    Beautiful theme - Awesome plugin

    5 stars for this theme too. Education WP theme brings the best LMS experience ever with super friendly UX and complete eLearning features. Really satisfied

    Anthony

    Beautiful theme - Awesome plugin

    5 stars for this theme too. Education WP theme brings the best LMS experience ever with super friendly UX and complete eLearning features. Really satisfied

    Anthony

    Beautiful theme - Awesome plugin

    5 stars for this theme too. Education WP theme brings the best LMS experience ever with super friendly UX and complete eLearning features. Really satisfied

    Anthony

    Beautiful theme - Awesome plugin

    5 stars for this theme too. Education WP theme brings the best LMS experience ever with super friendly UX and complete eLearning features. Really satisfied

    Anthony

    Beautiful theme - Awesome plugin

    5 stars for this theme too. Education WP theme brings the best LMS experience ever with super friendly UX and complete eLearning features. Really satisfied

    Do You Know

    It's a common myth that financial modeling is only about

    Excel Modeling.

    Financial modeling is the process of creating a summary of a company's expenses and earnings, valuation of the business that can be used to calculate the impact of a future event and can be used in taking informed decisions.

    Financial Modelling is the main core skill to take the major business decisions in a corporate world. Financial models are extremely valuable tools for implementing business decisions to get perfect results. A model can advise regarding the grade of risk associated with implementing certain decisions. They can also be utilized to devise an effective financial statement that reflects the finances and operations of the business. These models help online internet businesses take quick decisions more confidently.

    SUCCESS STORIES

    WANT TO ACQUIRE MORE SKILLS

    HERE ARE SOME UNIQUE COURSES