Share with your network!

EduPristine is registered with CFA Institute as an Approved Provider of continuing education programs for CFA Institute members. These members can avail the CE credits by taking the financial modeling course.

Students or professionals working in the Investment and Finance sector can take the course to improve their professional expertise and stay in the industry with the ever- changing environment. It prepares the professional for the role in core finance areas such as

  • Equity Research
  • Investment Banking
  • Project Finance
  • Business Analysis
  • Financial Analysis
  • Corporate finance
  • Credit rating
  • Mergers and Acquisitions
  • IPO Analysis

About Financial Modeling

Number crunching is one the most important aspects of any job in the world of finance. Financial Modeling is one of the standout and widely sought after skills in the finance industry where one have to work with large amounts of numbers. It is the practice of building a model to portray 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, participant will be able to do the task of building a model depicting financial statements/business model, which helps in decision making. 

The EduPristine Financial Modeling course will teach the basic of MS Excel all the way to creating successful Financial Models. By the end of the course, one will be able to independently build models that are robust and provide dynamic projections that can be utilized to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation. 

Course Topics Covered

Financial Modeling Principles

  • Excel as a tool for financial modeling
  • Building financial models best practices
  • Modeling growth drivers depreciations, cost drivers  asset and debt schedule

Valuation Principles

  • Projecting cash flow statement
  • Circular references and handling them
  • Financial ratio analysis
  • Valuation using DCF & Comps
  • Scenario analysis and Building valuation dashboards 
  • Advanced functions, tools and Charting
  • Using Macros & VBA for Financial Modeling

Advanced Functions, Tools and Charting

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

Using Macros & VBA for Financial Modeling

  • Understanding Macros & VBA for Financial Modeling 
  • Implementing Monte Carlo Simulation
  • Advanced Charting Techniques in Excel

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 advantageous edge over others.

The number of credits participants will earn will depend on the various course offerings provided by us and as per the standards decided by CFA Institute. For more details on CE credits, visit the CFA Institute site or write a mail to us at help@edupristine.com