FINANCIAL
MODELING
P R O G R A M F E A T U R E S
• Unmatched learning experience
• Library of Models - From all Sectors
• Batches on Demand
• Challenging case studies
IT'S EASIER TO SAVEPAPER THAN PLANTING TREES. ASK FOR AN E-BROCHURE
INVESTMENT BANKING
EQUITY RESEARCH
CREDIT RATING
PROJECT FINANCE
MERGERS & ACQUISTIONS
FINANCIAL ANALYSIS
Financial Modeling is a key skill with application in several areas within banking and finance industry as well as within corporations. In financial modeling, you learn to gather historical information on companies and analyze company / industry performance on various financial parameters.
This analysis is then used to build a company’s financial model, which in turn is key to projecting a future financial performance. Based on this model companies / investors can arrive at a suitable valuation for the companies.
W H A T I S F I N A N C I A L M O D E L I N G ?
At Proschool, our effort is to make learning more engaging and effective in imparting skills, which is why we have introduced ‘Active Learning’
Self learning by Student- Using Resources Learn by doing-10 Live Case studies Personalized attention from faculty Work in
groups Personalized Discussion Group Discussions With Mentor
ACTIVE
LEARNING
SUPREETH SHANK ARGHAL Ex CEO & Founder (QF Assets Limited) India’s First Hedge Fund
IMS Proschool has the most innovative learning
method -active learning, which I feel is the way
to learn any program. I would like to recommend
any student or college to adopt IMS Proschool’s
Financial modeling program”
S Y L L A B U S
Prepare Financial Statement
• Analyze Revenue and Costs • Forecast Revenues, Costs, Debt etc. • Project Future Financial Statements • Perform Adjustments, Compute
Margins/Ratios
• Valuation- Discounted Cash Flow Method (DCF), Others
• Prepare Presentation Sheet, Company Overview , Sector Overview
Financial Statement & Ratios Analysis (Case Studies)
• Introduction to Financial Statement Analysis
• Understanding Income Statement • Balance Sheet, Cash Flow Statement
Du point Analysis & Peer to peer analysism
• Financial Analysis Techniques • Ratio analysis of industries
Basic Excel And Financial Functions for Financial Modeling
• Data Filter and Sort, • Charts and Graphs, • Table formula, • Scenario building, • Look-up,
• Pivot tables,
• Use of Excel Formula Function, • Time value of money
Investment Banking – Merger & Acquisitions
• Types of Mergers & Acquisitions (Consolidation, Spin off, Drivers of M&A) • Differentiate between financing and
operating synergies
• M&A Regulatory Environment • Developing M&A Models
• Integration of Financial Statements
Financial Model Library & Videos
• Oil & Gas • Automobile • Banking • Telecom • Solar Project • Real estate Project
Advance Macros & VBA for Finance
• Recording Macros
• Application of Macros to Financial Modeling
Basics of Coding • Circular reference problem • Sensitivity table
• Scenario Analysis & Simulation • Objects & Control statements in
VBA code
Get additional learning resources on fulfilling
internal evaluation criteria
A D D I T I O N A L L E A R N I N G R E S O U R C E S
Project Finance:
• Project evaluations
• Life of project; decision making • Construction & development phase • Cash flow waterfall
• Funding during investment phase • Resolving circular reference • Costs during investment phase
Equity Research Modeling
• Prepare Financial Statement • Analyze Revenue and Costs • Forecast Revenues, Costs, Debt etc • Project Future Financial Statements • Perform Adjustments, Compute
Margins/Ratios
• Valuation-Discounted Cash Flow Method (DCF), Others
• Prepare Presentation Sheet, Company overview, Sector Overview
“Financial Modeling
certification at IMS
Proschool with its student
friendly innovative teaching
methods is arguably one of
the most sought after courses
among today’s finance
professionals.”
HIMANSHU SHAH Ex-CRISIL Equity Analyst
Classroom
› Active learning › 10 Live case studies › Train with Industry experts › On Demand Batches
› Additional Financial Modeling Library › 10 Live case studies
Live Virtual Classroom
› Audio – Video enabled “Live & Interactive training program on CISCO Platform
› Learn from the industry experts at affordable cost.
› Clear your subject doubts face-to-face with experts
› Get recorded sessions for future reference.
› 55 hrs training program
Online Training – Self study
› Online reading material › Financial Modeling book
(First book in India with ref. to an Indian Company)
› Audio Video presentation on building models
› Question & Answer forum for solving your doubts
M O D E O F L E A R N I N G
C E R T I F I C A T I O N
P R O C E S S
Complete Internal EvaluationGet Access to Additional Learning Resources
Write NSE Exam (Optional) ( Fee: 1700+ GST)
SAMEER GUNJAL
DAKSHINA MURTHY
CEO (Ennovat Research Investment and Capital (Hedge Fund)
Investment Banker IIM Lucknow
“Financial Modeling at IMS
Proschool stands the best
among its contemporaries.
Being pioneers in introducing
active learning in India, it is
surely one of the best upskilling
courses for finance professionals
in today’s scenario.”
“Proschool through its active learning approach
has revolutionised skill training in India. Classroom
learning is not just limited to concepts but also
developing skills to apply the concepts.”
INDUSTRY
Proschool, is an initiative of IMS. At IMS, our goal for the past 40 years has been simple ─ Build a long-term successful career. Proschool is an extension
of the same mission. At Proschool, we provide practical skills and knowlegde at affordable cost, in the shortest possible time. Our endeavour is to get students into jobs that give them useful experience for a successful and long term careeer.
Leading Financial Training Company
• Trained over 20,000 working professionals for leading BFSI Companies such as SBI, BOI, UTI, Kotak, ICICI, Sundaram BNP Paribas, Citibank. • Trained over 6,000 students under Financial Analyst Series.
• Trained over 10,000 under-privileged students for State & Central Government
History of trust
• IMS Group is training students since 1977
• IMS ranked among the “most trusted” educational brands.
• IMS Proschool has emerged as a leading, national player in professional skills training.
A B O U T U S :
Mumbai - Andheri +91 7710003157 +91 9619207323 Navi Mumbai +91 9619207323 +91 9152729315 Mumbai - Sion +91 9619207323 +91 7389180009 Thane +91 8879998784 022-25301030 Pune +91 8454988892 +91 9769162050Delhi - Connaught Place +91 7304957452 +91 9967841025 Delhi -Preet Vihar +91 7304957452 +91 9967841025 Delhi - Pitampura +91 7304957452 +91 9967841025 Gurgaon +91 9971414355 +91 9971414321 Bengaluru - MG Road +91 9900799981 +91 7892295842 Chennai +91 9600137479 +91 8248453302 Kochi +91 96456 29999 0484 4300 900 Hyderabad +91 9985072173 +91 7799566456 Online Centre +91 9892517572 +91 7045734304
F I N A N C E
C A R E E R S
O U R C E N T R E S
Financial Analyst: CFA® | Financial Modeling | PGP-IBCM | CFPCM Certification
Management Accounting: CIMA | PGP in Management Accounting Accounting: ACCA | IFRS
Analytics: Business Analytics | PGD in Data Science Marketing: Digital Marketing
