Financial Modeling
Financial Modeling
Financial Modeling
Certification in
Financial Modeling and Company Valuation
From Investment Banking Institute
Basic and Advance Excel Specialist
from MICROSOFT (USA)
IBInstitute
Investment Banking Institute
Tel:. 011-42244126
www.globalresearch.org.in
www.ibinstitute.in
-1-
6. Aranca
7. SBI Capital
8. Barclays Capital
9. Cians Anlytics
10. Crisil
11. D E Shaw
12. ICRA
13. Analec Research
14. pipal Research
15. Smart Cube
Day 3
To increase the efficiency, accuracy and speed to find the right information in the reports.
Learn to interpret the various schedule and find various hidden information
Learn various types and layout and composition of financial reports like 10-K, 10-Q, AR, 8-K,20-F etc.
Learn to recognize the structure of the various financial reports to improve efficiency and accuracy on the job.
Taught using clear, easy-to-follow materials that bridge academic concepts with how they are presented in
financial reports.
Reasons for Deferred tax, items which are treated differently in Financial Reporting and tax reporting treatment
Financial Modeling refers to the process of building a structure that integrates the Balance Sheet, Income Statement, Cash
Flow Statement and supporting schedules to enable decision making in areas like, Business Planning and Forecasting, Equity
Valuation, Credit Analysis/Appraisal, Merger/acquisition analysis, Project Appraisal etc. Trainees learn how to build full,
dynamic Financial Statement Projection models in Excel from scratch, using real case studies and sensitivity analyses.
Participants develop a model completely from scratch, inputting historical data and assumptions to project financial
statements using step-by-step instruction on selecting and developing appropriate projection drivers. At completion,
participants will have developed a complete and comprehensive three-statement model using various supporting
schedules.
Annual report.
Design various supporting schedules of: Working Capital, Deferred Taxes, Property, plant and equipments /
of an enterprise.
Understand and identify the treatment of Dilutive Securities
marketable securities
Comparable Company analysis Vs Comparable Transaction analysis
profits.
Project working capital items (Accounts payables, Inventory, account payables etc), deferred taxes, capital expenditures,
Training Methodology:
Leaning Outcomes:
The participants are first explained how to select the Participants learn to select appropriate comparable
companies by evaluating operational, financial, size, and
Peer Group (Comparables) before building the
other
similarities
Models for Relative Valuation. In this part of the
Program, we shall learn to design the real Template Set evaluation benchmarks & select comparable
for Trading Combs which is actually used various
companies
Research companies.
Gather appropriate financial history and projections
Then we shall take 10 companies from world over for
Normalizing operating results and calculating LTM
relative valuations.
operating results
Then participants are directed to build superb comps
Exclude nonrecurring charges, normalize for stock option
models in Excel from scratch, using real case studies,
expense
industry best practices, and sensitivity analyses.
This model includes Switches, Output sheet, Standardize various expense classifications including
FIFO to LIFO inventory accounting
Valuations sheets, Currency Converter and forecasts.
Calculate shares outstanding using the treasury stock
method
Input financial data & calculate and interpret financial and
market ratios
Presenting trading comps by structuring output schedule
Selecting and Evaluating Appropriate Multiples (P/E Trailing
4.
5.
6.
7.
acquisition.
Participant build a model of M&A to see the pro forma impact of
statements
Synergies required to break-even before and after tax if premium is paid
Sensitivity analysis: EPS accretion/dilution in stock vs. cash deal; interest rate assumptions, premium paid.
Analysis of contribution of Revenue, EBITDA, and Net Income post merger
This model is designed with very practical approach to see the impact of acquisition of one company by
another company after the real adjustments have been made to Financial Statements.
M&A Accretion/Dilution Modeling
Superb exhaustive accretion-dilution analysis
Buy side and sell side processes
Project the Consolidated Financial statements post merger and do the various adjustments for goodwill calculation
Handle the Fair market value write ups, advisory fees and financing fees and debt refinancing
Learn the proper treatment of various items like deferred taxes created in M&A and convertible securities and options.