Learn from the Scholars. Become a Pro

Upcoming Webinars

ABOUT US

ScholarsPro is a learning platform providing live instructor-led interactive online training, self paced video training and classroom training for students across the globe. We cater to professionals and students in categories like Financial Modeling, Big Data & Hadoop, Business Analytics & Data Science, Machine Learning, Data Visualization, Project Management and Programming.


INTERNATIONAL SCHOLARS

Certified trainers and industry experts from IITs, IIMs, ISB


CHOICE OF LEARNING STYLES

Three learning modes to choose from self-paced, classroom and live online


HANDS-ON
EXPERIENCE

Live projects and real life case studies supported by exercises and evaluations


ROBUST LEARNING MANAGEMENT SYSTEM

Interactive platform for high quality learning


HAPPY
CUSTOMERS

Best ratings from our learners


Financial Modeling Masterclass - Get Job Ready

Financial Modeling is a skill that can be used to forecast a picture of a security or a financial instrument or a company’s future financial performance based on the historical performance of the entity. This Master Class aims at imparting you the ability to learn and apply financial modeling techniques in a wide range of practical scenarios. You will learn the latest tools and techniques of building financial models using excel, project financial statements, and master a host of tools and techniques around Equity Valuation.

Pre-requisites

  • Familiarity with Excel - functions and tools
  • Understanding basic accounting concepts
  • Basic knowledge of valuation, project finance, return concepts.

Mode: Instructor-led (classroom) and Self Study Online

Course duration: 4 Days/ 40Hours


PROGRAM AGENDA


DAY 1

Financial Modeling Principles

  • Excel as a tool for Financial Modeling
  • Building Financial Models from scratch
  • Modeling Growth Drivers, Depreciation, Cost Drivers, Asset & Debt Schedules
DAY 3

Advanced Functions, Tools & Charting

  • Advanced Tools in Excel for Auditing Financial Models
  • Mastering Financial Functions
  • Advanced Charting Techniques in Excel
DAY 2

Valuation Principles

  • Projecting Cash Flow Statement
  • Circular References and Handling Them
  • Financial Ratio Analysis
  • Valuation using DCF & Comps
  • Scenario Analysis and Building Valuation Dashboards
  • Q & A
DAY 4

Using Macros & VBA for Financial Modeling

  • Understanding Macros & VBA for Financial Modeling
  • Implementing Monte Carlo Simulation
  • Advanced Charting Techniques in Excel
  • Commodities, Foreign Exchange & Corporate Bonds
  • Q & A

Program Details

Excel Tips
  • Understanding And Creating A Financial Model Template
  • Learning referencing (usage of $)Frame work in Excel
  • Learning Custom formatting in Excel
  • Excel Skills - Shortcuts, Formulas, Array Function and Pivot Tables
  • Implementing simple business modeling case in Excel
  • Simple exercise/models in excel
Project Finance
  • Understanding the Project Finance Model
  • Characteristics of Project Finance
  • Risk and contractual arrangement to Mitigate Risk
  • Understanding the Escrow Arrangement
  • Incorporating Date, logical functions and flags to make the Model Flexible
  • Incorporating Delays in the Model
  • Cash Flow Waterfall model - Modeling Payoffs to Investors using Goal Seek
  • Implementing Interest During Construction and Breaking Circular Loops
Data Preparation 1
  • Data Collection and Data Structuring
  • Preliminary Scrutiny of the Data and Information
  • Understand the Business Model and Operating Model
  • Modeling the Historical Statement
  • Business Drivers Identification and Modeling
  • Modeling Assumptions for Future Action
  • Modeling Revenue Build-up - projecting the future revenues
  • Modeling Cost Build-up - projecting the future cost
  • Modeling the Asset Schedule
  • Modeling the Depreciation Schedule - Book and Income Tax Depreciation
  • Working Capital & Term Loan Modeling - Debt Infusion
  • Tax Modeling
  • Modeling MAT and MAT credit
  • Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payable
Data Preparation 2
  • Equity Modeling - Equity Infusion
  • Modeling Paid Up Capital and Share Premium Account
  • Modeling Retained Earning Schedule
  • Modeling the projected P/L and BS
  • Modeling the projected Cash Flow Statement
  • Conducting Covenant Testing
  • Performing Ratio Analysis
  • WACC and Cost of Equity Analysis
  • Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
  • Performing sensitivity/scenario analysis
M&A I&II
  • Meaning and categories of M&A
  • Merger motivations
  • Forms of payment in a Merger Deal
  • Hostile Vs Friendly offer
  • Evaluating a Merger Bid
  • Merger Analysis - Key Drivers and Inputs
  • Accretion/Dilution Analysis
  • Merger Plan - Ownership Vs Deal Price
  • Modeling a financing plan
  • Performing sensitivity analysis on Acquirer's EPS
  • Performing Contribution Analysis
  • Estimating value of a Merger Transaction
  • Discounted Cashflow Analysis
  • Comparable Company Analysis
  • Comparable Transaction Analysis
Macros I
  • Introduction to Macros & Advanced Application Building in Excel
  • Key Concepts in Macros
  • Macros as recorded Robots!
  • Form Controls and Active X controls
  • Implementing user forms in Excel Macros
  • Linking forms to excel cells
  • Building flexible Charts in Excel 
Macros II
  • Understanding VBA - Sub & Functions
  • Understanding the Relevant Language Constructs
  • IDC Implementation using Macros
  • Breaking Circular Loops using Macro
  • Monte Carlo Simulation
  • Basics of Debugging VBA Code
Charting
  • Building Primary & Secondary Axis in a Chart
  • Radar Charts - Showing the progress of Commercial Property Development
  • Waterfall Charts - Showing Funding Breakup for Renewable Energy project
  • Football Field - Showing Valuation Summary using Different Parameters
  • Gantt Chart - Tracking the status of an Ongoing Project
AdvanceD Function
  • Named Ranges
  • Index Match
  • Array Functions
  • Building Scenarios using Offset Functions
  • Creating growing models & Index functions
  • Usage of Indirect Functions
  • Usage of Goal Seek and Solver Functions

Financial Modeling Master Class : Case Studies


  • Data collection from public sources
  • Understanding the business profile of the company
  • Modeling revenue & expenses drivers
  • Modeling income statement
  • Modeling implied EBITDA
  • Balance sheet projections
  • Cash flow statement projection
  • Performing valuation and sensitivity analysis
  • Calculating enterprise value and implied market capitalization

Our members make ScholarsPro community


Krishnan
Krishnan National Head - Business Development
MYK SCHOMBURG INDIA PVT.LTD.
The course of digital marketing is very informative and useful. Our trainer was quite supportive of queries & clarifications. The content helps me a lot in profession & my venture. A very good place to learn the skills and apply them practically. Scholarspro is certainly a good platform to develop & strengthen your knowledge that's crucial to excelling in your profession.
Harshit Gupta
Harshit Gupta Freelancer
Freelancer
"Satisfied with the type of content and detailed teaching approach used by the mentors, Team at scholars pro do help in solving doubts at a personal level too. Will definitely recommend someone who is looking to start his/her career in Digital Marketing and is eager to learn skills and tools of this dynamic field."
Ajinkya Kulkarni
Ajinkya Kulkarni Digital Marketing Trainee
Geek Octopus
The course was very informative. The study material provided by the trainer was extremely helpful.
Aarti
Aarti Trainee
CSC
The course content on Digital Marketing was excellent and covered the latest trends. The faculties were SME's and were updated on every aspect of the subject. I would recommend Simplilearn to all my peers. Happy Learning.
Arvind Pathak
Arvind Pathak Owner
Businessman
My trainer Mr.sanjay have good knowledge of theoretical and practical as well.Very much impressed by his teaching style.
Rakesh Alluwalia
Rakesh Alluwalia
Birlasoft
The training was delivered well and objectives were met.the trainer was well versed.
Sharath
Sharath
Birlasoft
Participation and interaction were encouraged and content delivered was well organized. Very much satisfied.
Harpreet Kaur
Harpreet Kaur SPM
Infogain
The trainer was well organized and fully engaged with me as a participant. The direction and knowledge shared was right implementation in projects not solely focussing on exams.
Rasul Mohamed
Rasul Mohamed Project Lead JIE
Singapore Refining Company Private Limited
I joined ScholarsPro for Project Management Professional (PMP). The course structure is very comprehensive, covering a wide range of aspects of Project Management like Mobile App, High-Quality videos, Study Materials and many more. Getting a job is never an easy task, especially in reputed organizations where the biggest challenge is having your CV being even considered. I have completed my Project Management Course. It was a great course. I got a lot to learn from it and I can also apply it to my daily work. Thanks ScholarsPro 
Loknathan A S
Loknathan A S Engineering Manager
Sulzer singapore pvt. ltd.
The schedule of classroom training has been better organized and training was amazing. I have learned more and thanks to our trainer Mr. Zack, He has been cleared of all my doubts.
Sanjay S. Khed
Sanjay S. Khed

The training program was very helpful and I learned more than what I had expected. The trainer made us understand the topics with brilliant examples with a very simple format.

J. Muhunthan
J. Muhunthan

The classroom training was good. Training venue was really good. I would like to thanks to who have been organized the PMP classroom training. Our trainer Mr. Zack was excellent.

Sanjay Narang
Sanjay Narang

A trainer was really enthusiastic and I thoroughly enjoyed his presentation in this course. I would like to Thank and Appreciate Mr. Vijay for his excellent salesmanship.

Ivan Klenner
Ivan Klenner

Training and trainer ware really good. Very much impressed by the teaching style and delivery of the course of PMP by Scholars Pro. Thank you for providing me a platform for my future growth.

K. Rajesh
K. Rajesh

Very good PMP classroom training to help and improve our skills. Good course material and structured modules for learning PMP. Wonderful experience!

Yusran Ariffin
Yusran Ariffin Project Lead
TRX City Sdn Bhd, Malaysia

It’s a good place to learn, mainly the learning guidance is great. The course material provided is good, one can understand the codes and technical aspects well.  It is one the best platform to learn and get ahead, I enrolled for PMP self-paced and I am able to understand the concepts, also the learning support  is very good, they are always available to help and are prompt in returning your call, the consultants have deep knowledge, they guide you in the best possible way, thanks ScholarsPro!

Rajat
Rajat Developer
HCL Technologies (India)

My Hadoop training with Scholarspro was what I was looking for. Wonderful experience and I will recommend to others too.

Snjana Sudaresan
Snjana Sudaresan Student
Shanmugha Arts, Science, Technology and Research Academy

Very good training to help improve our skills.  Good course material and structured modules for learning R. Wonderful experience!

Manisha Vatsayam
Manisha Vatsayam Business Development Manager
ICRI, India

It was wonderful getting trained in Digital Marketing from SchoalrsPro. The trainer had a lot of knowledge in which will be very helpful in my work and career.

Ritesh Garg
Ritesh Garg Vice President
ELI, India

I am very impressed with teaching skills and knowledge of the trainer for PRINCE2. Thanks to the trainer and Scholars Team for proving such a good environment to learn.

Satyajeet Sharma
Satyajeet Sharma Manager
AGS Transact Technologies Ltd., India

My experience was good as the trainer of PRINCE2 was very enthusiastic, answered all my queries in depth & also provided useful pointers for exams & real life scenarios. Thanks a lot to the trainer & ScholarsPro Team

Dinesh Kumar Lal
Dinesh Kumar Lal Senior Project Engineer
Rotary Engineering Limited, Singapore

Courses offered by ScholarsPro have been very helpful in keeping myself updated with the best practices in the industry. Video quality is good; simulation tests are very helpful to confirming the understanding. People in the customer services team have been very helpful and been able to handle requests without much escalation. Thanks for a short extension to help me complete my PMP session. Much appreciated!

Tapadhir
Tapadhir Manager
Janalaxmi Financials, India

Very much impressed by the teaching style and delivery of the course of PMP by ScholarsPro. Thank you for providing me a platform for my future growth.

Sanjay Sinha
Sanjay Sinha Secretary
ICAS, India

SchoalrsPro good place to learn R through online course. Great environment and very nice faculty. All the best!

Sanchita Dey
Sanchita Dey Senior Manager
Hewlett Packard, India
Satisfied with the content and pattern of teaching online. Thank you ScholarsPro for my certification in PMP with you. Knowledgeable professor with full understanding.
Nipun Raj
Nipun Raj Nipun Raj
Reliance Capital, India

My experience is very good with ScholarsPro. Trainer of Digital Marketing is very much supportive and knowledgeable.

Bhavna Singh
Bhavna Singh Market development SE Snapdeal

Great learning by the trainer ,satisfied with the delivery of content

Baljinder Sachdeva
Baljinder Sachdeva Marketing Head
IVF Fertility Centre

Great learning by the trainer ,satisfied with the delivery of content.

Aayush Bhardwaj
Aayush Bhardwaj Student NMIMS

The DM course study material, classes was very helpful in terms of knowledge and exposure about the SMO,SEO,TRainer ...

Santosh Nayak
Santosh Nayak Infrastructure Project Manager
HCL, Singapore

Excellent learning center for management and technical trainings. ScholarsPro’s training would be the first step for a career change. Materials and online training videos are great – you can upgrade your skills without attending face to face session. Good work from the company. I have been attending the training from 2014. Recently I have taken PMP training. I feel ScholarsPro is my place to upgrade my career.

Sanjeev Sharma
Sanjeev Sharma Manager
Evalueserve, India

The course curriculum, study material and classes for Business Analytics course were very helpful in terms of knowledge and exposure about the Business Analytics profile. The faculty was also very helpful and very knowledgeable.

Manish
Manish Assistant Manager
Barclays Bank, India

Incredible Trainer! I have been trying to learn SAS since 1 month on my own. Everything got jumbled up. Thanks to the trainer – just one session straightened my thoughts.

Amit Kumar Singh
Amit Kumar Singh Software Development Engineer
Allegis Services, India

I would like to thank you for your support. I enjoyed your Hadoop classes.

Kuldeep Walia
Kuldeep Walia Self-employed (IT Sector)

I am very impressed with teaching skills & knowledge of PRINCE2 trainer. Thanks to him & ScholarsPro

Ayush Sethi
Ayush Sethi
Evalueserve, India

First of all I would like to thank you for teaching some really good things in SAS. I found Macros the best part during the training (Proc Sql and Base SAS I had studied earlier as well). The content of the training was very good. I will try my best to take some time out of my working hours and practice on SAS.

Helly Shah
Helly Shah Content Writer

Digital marketing course by scholars helps me to gain knowledge in the field of marketing,Trainer was very nice and adjustable ...

Diksha Thakur
Diksha Thakur Student NMIMS

Very supportive ands cooperative trainer ,Pranav sir always helps us to improvise the things .The course is very knowledgable which ...

Enterprises we helped to UPSKILL

stars based onLearners