347 647 9001+1 714 797 8196Request a Call
Call Me



Financial Modeling

Learn how to construct an integrated financial model from scratch. You will soon be building models that are robust, and provide you with dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.

This Virtual class will be conducted in this time-zone:

  • Class Timing: 09:30 am to 01:30 pm GMT
To check timings in your time zone click here


Financial Modeling is one the most fundamental and widely sought after skills in the finance industry. It is the art of building a model to depict financial statements and investment analysis using MS Excel. This helps arrive at optimal business solutions by analyzing various parameters. At the end of the course,You will be able to do the task of building a model depicting financial statements/ business model, which helps in decision making.>


LVC Schedule
Module 1: Financial Modeling Principles Excel as a tool for financial modelling
Building financial models best practices
Modeling growth drivers
Cost drivers
Asset & debt schedules
Module 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
Module 3: Charting Techniques Modeling Using Named Ranges
Revenue Matching (Index Match)
Portfolio Analysis (SumProduct)
Generating Scenarios (Offset function)
Building Flexible & Growing Models (Offset, Index)
Formula Auditing
Building Primary & Secondary Axis in a Chart
Module 4: Macros and VBA Introduction and context
Implementing user forms in Excel Macros
Linking forms to excel cells
Building flexible Charts in Excel
Understanding the relevant language constructs
Errors and steps in VBA
Random Number Generator: Use of Loop, Excel Functions
Message Box, Input Box
Breaking circular loops
Monte Carlo Simulation


At the end of the course, you will know the techniques to value and analyze Firms, IPOs and FPOs in Financial Modeling. Investments in nascent stages can be valued with accuracy with hands on Financial Modeling for eg. Private Equity/ Venture Capital Investing.

Sample Preview of our material :

LinkedIn , Groupon Models et al.


This program is suitable for people in Investment banking, Project management, Equity research, Business planning & strategy, Private equity funds or commercial banking. It is also ideal for CA, CFA Program, FRM, MBA Finance, B .TECH and Commerce Graduates who want a career in any of the above profiles.


Financial Models constructed in Financial Modeling help in decision making and business modeling for firms and check the viability of projects. You learn techniques to value and analyze Firms, IPOs and FPOs in Financial Modeling. Investments in nascent stages can be valued with accuracy with hands on Financial Modeling for eg. Private Equity/ Venture Capital Investing

Commercial Banks use Financial Modeling for disbursing loans for the projects; Project Management uses it for performance tracking of on-going projects.

Financial Modeling concepts can be applied to any industry. Individuals who hold an MBA and also possess knowledge of Financial Modeling have an edge over others


Student should have hands on experience on Excel and brief idea about Finance, Balance Sheets and Cash Flow Models.


Live Virtual Classroom Training

Get trained by topic experts with interactive learning.

Excel Workbooks

Create models following a step-by-step approach devised by professionals. These workbooks have been specially designed to ensure you incorporate best industry practices of financial modeling.

Bonus Package

Exclusive 1000+ minutes of video tutorials explaining the process of constructing a financial model for project finance.

Video Tutorials

Easy to follow byte sized video tutorials of over 1200 minutes created by topic experts. Learn the concepts at your own pace.

Doubt Solving By Experts

Write to us and get your doubts solved by our experts within 2 business days. You can also initiate a discussion by posting it on active forums.

Study Notes

Download the study notes to supplement video tutorials.

Case Study Approach(Using models for analysis, including valuations)

Appreciate the concepts by working on case studies derived from real-life situations.



it blended with my experience as a controller for a construction company. Specifically integrating the BS, P&L and CFS. I like modeling, budgeting and releasing Pro Forma statements. Aslo, I liked the way dates were used.

I followed the course closely, it was helpful both from the perpective of understanding financial modeling as well as to improve my knowledge of excel. Hoping to master my skills over time with EduPristine's support.


Absolutely not. You can create a financial model using only a pen and paper or calculator. Financial models existed even before we were introduced to Microsoft. Having said that, building financial models using MS Excel is an advantage.
90% of professionals use MS Excel. It is fast, accurate, easy to use and modular. Almost everybody in the corporate world communicates using MS Excel, and so there will be an unsaid expectation for you also to be sound in its knowledge.
This should not worry you. Our course on Financial Modeling will help you learn the nuances of making a financial model in a very basic step-by-step manner. By the end of the course you will be confident to make models for any company. To get acquainted to financial modeling, check out our downloads on models for LinkedIn, Zynga and GroupOn to see the power of MS Excel for Financial Modeling.

The relationship between MS Excel and Financial Modeling is like that of a shovel and a vegetable garden. MS Excel is a very important tool to learn Financial Modeling. As a finance professional, you will be working a lot on spread-sheets and so it is important for you to understand how to use MS Excel efficiently.
You can learn to work faster and use all the latent features of MS Excel to make the models look better and cleaner. Simple tricks and techniques like using shortcuts to create models can significantly reduce time spent on building models and financial analysis. You can learn tips and techniques in MS Excel and become an expert in Financial Modeling with our training program.
For your reference, MS Excel is necessary but not sufficient for doing analysis of financial statements. In Financial Modeling one can learn structuring of various components of financial statements across different sheets and how to link them. There are best practices which are followed by finance professionals across the world which will help you make logical and efficient models. These best practices help you build models which are more robust. Examples of such models can be downloaded for LinkedIn, Facebook, Zynga here.

A rewarding career in the finance industry!
The kind of job profiles would include:
Investment Bankers
Commercial bankers
Project finance People
Equity Research
Consultants involved in strategy and business planning

related links

Batch Start Date

13 Nov

Ph: +1 347 647 9001
Venue Details: TBD
Buy Now

Upcoming Batches




Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

new_us_ classroom_courses.php Post ID = 50360