Welcome to Financial Corridor

## FINANCIAL MODELLING PROGRAM

COURSE OBJECTIVE

Financial modeling based on advance excel expertise , this program useful for Fundamental Analysis like Equity valuation , investment research, Company valuation, Hedge fund investment , corporate finance, Merger & acquisitions. Financial Modeling 2 months Module program is both an academic learning process and a hands-on practical exposure to Advance excel. This course provides modeling experience that begins with construction of a basic financial model on excel spreadsheet and ends with completion of a full-scale forecasted model with valuation components. This course provides practical modeling knowledge and techniques as well as valuation tools for valuing Company  with and analysis of Economy & industries and determining the effects of mergers and acquisitions. Actual company financial statements are used.

1. Fundamental of Excel

• What is financial modeling?
• Application of Excel
• Excel Keywords shortcut

2. Tools of Financial Modeling

• Data tables
• Excel function
• Excel formula
• Chart

3. Data Summarize & Formatting

• V lookup
• H lookup
• Pivot table

4. Risk & Return Modeling

• Return
• Beta, standard deviation, variance
• Correlation, Covariance
• Systematic risk, Unsystematic risk

• VBA
• Visual basic
• Macros, Modules

6. Valuation Modeling

Part 1 Financial Statement Analysis

• Prepare an Income Statement
• Prepare a Balance sheet
• Prepare Cash flow statement
• Case study: financial statement of Particular Company
• Cost of equity, cost of debt, cost of capital
• Weighted Average Cost of capital WACC
• Time value of Money-PVIF, PVIFA, FVIF, FVIFA

Part 2 Company Valuation

• COMPANY valuation
• DCF-FCFE, FCFF, DDM, EVA, MVA

Part 3 ROE Analysis & Relative Valuation

• DuPont Analysis-ROE Analysis
• Relative Valuation- P/EPS, P/SALE, P/BV

7. Merger & Acquisition (M&A) Analysis

• Merger & acquisition model

STUDENTS WILL BE ABLE TO:

• Learning different modeling techniques
• Developing hands-on Excel modeling skills
• Understanding and selecting appropriate true value drivers
• Building and forecasting an integrated set of financial statements
• Analyzing different valuation approaches
• Developing complete Discounted Cash Flow (DCF) valuation models
• Incorporating elements, such as risk and sensitivity, into financial models
• Fixing modeling problems, such as circular references
• Producing high-quality, accurate financial reports

PLACEMENT ASSISTANCE:

After completing FINANCIAL MODELING course lot of jobs available in financial services industry like.

• Financial Analyst
• Research Associate
• Investment Analyst
• Equity Research Analyst
• Private Equity Analyst
• Derivative Analyst
• Fixed Income Analyst
• Credit Analyst
• Receivable Analyst

FEE STRUCTURE

 Training program DURATION FEE PAY NOW Financial modelling 2 months 25000/-

 Quick Query Online Course Technical Analysis ISTP Advance Technical Analysis CA IPCC CA CPT CA SFM CS Foundation CS Executive CS Final CMA Foundation CMA Inter Financial Modelling CFA Level 1 CFA Level 2 CFA Level 3 Location Delhi Indore Chandigarh