FINANCIAL MODELING in Depth using EXCEL Training

LEARNING OBJECTIVES

A good Financialmodeling course helps you to effectively build financial models right from scratch. It starts from what is financial modelling and ends up with a full blown financial model for equity valuation. Detailed Understanding of Financial Statement, Financial Analysis, financial ratios, financial forecastingmodels and valuation tools are discussed in this program. Concepts of Financial Accounting, Corporate Finance, financial mathematics,financial markets,financial risk management and financial management are discussed wherever applicable. This is a perfect program for a financial analyst and financial advisoraspiring to get into investment banking, financial planning and analysis, business modelling, and other areas of investment and financial services. It can serve as an introductory program towards financial engineering as well as other investment banking courses. It is a good supplement for people pursuing finance courses, banking courses or any other program in financial education or any other courses in finance. This can also help people pursuing mba in finance and finance certifications like CFA® and FRM®.

Theme

Key Topics

Introduction

Introduction to Financial modelling, Different Models overview, Steps in Model Creation

Advanced EXCEL Features & Functions

Absolute vs. Relative References, Named cells and Ranges, Comments, Data Table, Scenario Manager, Goal Seek, Data validation, Circular reference, Controls, Custom Number formats, Conditional Formatting, Protecting, Hiding, Custom Views, Solver, Pivot Tables, Financial, Logical, Statistical, Mathematical, Trigonometric, Lookup, Reference, Date and Time, Text, Arrays, Information, Analysis ToolPak

Important Functions

Annuity, Time value of Money, Bond, Depreciation, Probability Distributions, Random Numbers, Linear Regression, Statistical Tests, Rounding, Logarithms, Miscellaneous

Model Building Process

Attributes of Good Models, Documenting, Debugging, Formula Auditing Tools

VBA for Financial Modeling

Recording Macros, Using VBA’s Help, Visual Basic Editor, Variables, Constants, and Arrays, Objects, Properties, and Methods, Branching, Looping, Using Built-In Functions, Sub Procedures, Functions Procedures, Debugging

Financial Statements Analysis

Historical data, Comprehensive set of Model assumptions, Model Building, Plug, Depreciation, Retained Earnings, Interest expense, Model Improvement, Cash flow statement, Free cash flow, Common Size, Financial Indicators, Modelling Strategy, Different ways of forecasting, Sensitivity Analysis, Scenario Analysis

Time Value of Money

Present Value, Future Value, Investment and Project Evaluation, Annuities, Growing Annuities, Compounding frequency, Loan Amortization, Changing Interest rate, Changing Annual payment

Financial Planning

Basic Issues, Retirement Planning, Portfolio Structuring, Changing reinvestment rates

Market History Analysis

Indexes, Returns, Comparing returns, Nominal vs. Real growth, Rolling period

Bond Pricing and Duration

Characteristics, Valuation, Risks, Duration, Yield curve, Forward rates, spot rates, YTM

Stock Price Simulation

Simulation, Geometric Brownian Motion, Lognormal distribution, Random Numbers, Volatility Estimation

Option Pricing

Payoffs, Black Scholes, Greeks, Option portfolios, Leverage, Binomial Tree based pricing, European and American stock options

Faculty profile

FEES for Corporates

Based on the syllabus, contents and other requirements for the corporate training, scope with detailed inclusions and exclusions along with the fee will be shared. There will be a 14% service tax over and above the training fee.