# 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 (days) Financial Modelling In Excel 2013 12 Total 12
##### 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)
##### Recommended Courses and Certification:
Give an edge to your career with technical certifications and 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

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...

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...

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...

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...