Financial Modelling in Excel 2013

  • Overview

    Financial Modeling covers standard financial models in the areas of financial statement simulation, corporate finance, options, portfolio problems, duration, portfolio insurance, and immunization. This training will provide concise clarifications in each case for the implementation of the models using Excel.

    Audience: This course is best suited for investment bankers, commerce graduates, business analysts, and corporate finance professionals.

    Course Objectives

    • Comprehend the basic Financial Calculations
    • Calculate the Cost of Capital
    • Comprehend the Financial Statement Modeling
    • Build a Financial Model
    • Comprehend the Bank Valuation
    • Comprehend the Financial Analysis of Leasing
    • Comprehend the Financial Analysis of Leveraged Leases
    • Calculate Efficient Portfolios when there are no short sales restrictions
    • Calculate Variance Covariance Matrix
    • Estimate Beta & Security Market Line
    • Comprehend the Binomial Options Pricing Model
    • Comprehend the Lognormal Distribution
    • Comprehend the Array Functions & Formulas
    • Comprehend the User Defined Functions with VBA
    • Comprehend the Types & Loops
    • Comprehend the Macros & User Interaction

    Course Details / Exam(s)

    Schedule for Financial Modelling in Excel 2013
    Course Regular Track
    Financial Modelling In Excel 2013 12
    Total 12
    • Basic knowledge of Finance i.e. (Cost of Capital, Annuties, Discounting, Accumulation, WACC etc)
    • Statistical Knowledge i.e.(Log, Exponential, Integration, Probability Distribution - Binomial & Normal etc)
    Recommended Courses and Certification:
    Give an edge to your career with Microsoft certification training courses. Students can join the classes for Financial Modelling in Excel 2013 at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
  • Students Reviews
    Mir Uzairuddin Ansari Koenig IT Training Student

    I came to Koenig Delhi for training on Microsoft Office Advance Excel Skills. I found this course through my colleagues and Koenig website. I thank Koenig Delhi administration for good services...

    Read MoreMir Uzairuddin AnsariAfghanistan
    Ghulam Ali Yousufi Koenig IT Training Student

    This is Ghulam Ali Yousufi and I found this course via my colleagues and via Koenig web too. I once again thank Koenig Delhi administration for good services including excellent food, good internet...

    Read MoreGhulam Ali YousufiAfghanistan
    Lawal Ahmad Koenig IT Training Student

    I am highly impressed with the Microsoft Office Specialist 2010 training at Koenig Delhi. I have learnt a lot, and I will not hesitate to recommend training from Koenig Solutions to any one that may...

    Read MoreLawal AhmadNigeria
    Harish Kumar  Asmith Koenig IT Training Student

    I had a very good learning experience in Koenig Solutions Delhi. I enrolled into the program: Fundamentals of C++ 11, Excel, VBA. This whole learning curve helped me make a very satisfying...

    Read MoreHarish Kumar AsmithIndia
    View All Testimonials
  • Schedule & Course Fees
    Classes will be conducted from 09:00 am - 05:00 pm at Your Local Time
    Price includes Courseware.
    For any Query or Custom Plan +1 877 226 2244
  • Enquire Now
    * Required Fields