Financial Modelling In Excel 2013 Training & Certification Courses
 800 Ratings

Financial Modelling In Excel 2013 Training and Certification Courses Expert Chat

Microsoft #1 Training Partner

Guarantee to Run the Classes

Get Trained by Industry Expert

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 Content / Exam(s)

Schedule for Financial Modelling In Excel 2013

Course Name Duration (days)
Financial Modelling In Excel 201312

Course Prerequisites

  • 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)

Financial Modelling In Excel 2013 Benefits

Upon Completion of this Course, you will accomplish following:

  • 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

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.

Schedule & Prices

Delivery Mode Location Course Duration Fees  Schedule
Instructor-Led Online Training (1-on-1) Client's Home/Office12 Days $ 3,410 As per mutual convenience (4-Hours Evenings & Weekends Possible
Classroom Training * India (Delhi, Shimla, Goa, Bangalore, Dehradun) 12 Days $ 1,720 11-23 Dec 2017, 8-20 Jan 2018, 12-24 Feb 2018
Fly-Me-a-Trainer Client's Location12 Days On Request As per mutual convenience

Enquire Now

 


 
Loading...

Processing data, please wait...