Financial Modelling - Financial Statement Analysis

Financial Statement Analysis in today's world is important for both Internal and External purposes like Credit & Investment decission plans, forecasting and comparison within the industry.

Topics Covered

Financial Statement Analysis using EXCEL

Understanding need for Financial Statements Analysis

Relation of Balance sheet, Income Statement & Cash Flow Statements

Forecasting Financial Statements

In depth - Key financial ratios in Decision making process

Use of FSA in Credit & Equity Analysis

Common Size Analysis, Ratio Analysis & Dupont Model

Understanding EBIDTA, EBIT & PAT

Inventories, Fixed Assets, Goodwill & Income Taxes

 Depreciation & Amortization Understanding Minority Interest

Expense & Revenue Recognition

Dividend Discount Models and P/E Ratios

 ROE and implied growth Reporting on overall Financial Health Valuation Ratios & Working Capital Analysis
Measure financial strength Profitability & Liquidity Analysis Efficiency & Common-size Analysis Manipulations in Financial Statements Case Study with Questions

Financial Statement Analysis using EXCEL Training COURSE

  • Training driven through Case Studies (A listed company).
  • Training conducted by IIM Alumnus
  • After Classes SUPPORT for 1 YEAR.
  • Hands On Coaching- Participants may get their laptops for the training to perform along with the trainer.
  • Support via Email/Phone/Chat/One on One session (with prior appointment).
  • Complete Recording of the complete Training in Downloadable Format.
  • Attending training again for NO COST.
  • Training Completion Certificate for all participants.

Batch Start Dates

Batch Start Date Batch End Date Timings Fee

Yet to be Announced

 

 9AM to 5PM Rs. 4,000

 

 

 

10% discount for a group of 3 or more

15% discount for a group of 5 or more

P.A.C.E - Financial Statements Analysis using EXCEL Recorded DVD's:

P.A.C.E - Recorded Trainingavailable for Rs. 2,000. Fee Adjustment for Participants willing upgrade Classroom Training.

SUPPORT FOR RECORDED DVD'S:

  • Support via Email/Phone/Chat/One on One session for 1 hour (with prior appointment).
  • Updated recordings of the training in downloadable format for 1 year at no extra cost.

Who should attend Financial Statements Analysis using EXCEL Training

  • Investors.
  • Credit analysts.
  • Fund managers.
  • Equity analysts.
  • Equity Traders.
  • Equity sales.
  • Investment bankers.
  • Equity Researchers.
  • Chartered Accountants.
  • Treasures.
  • Executive Level managers.
  • Graduates from any Stream.
  • Students.