Course

Course Overview

Estimated Training Hours: 200 Hours

Mode - Online

To be completed within 200 Hours

This e-learning program is designed in such a manner so that the financial models and the concepts taught through online instructions are easily understood by the learners. It will address specific areas of financial modeling and will help the finance professionals in upgrading and brushing up their knowledge. Excel is a very popular tool to perform financial modeling. This course will help the learners with basic and advanced Excel skills required to move up the career ladder in finance. It offers easy-to-follow study material which includes knowledge check exercises after each module, ensuring that learners absorb the content at a fast pace.

The course work involves the following:
  • Reading Material
  • Video Tutorials
  • Reusable, modifiable Valuation Modeling Excel templates
  • Live Chat Support to resolve queries and clear the doubts on a real time basis
  • Interactive Check Your Understanding (CYU) questions
  • Home Work (comprising of assignments and submission of projects which will be evaluated by experts through an e-mail correspondence)
  • Final Assessment
  • Test and Certification (are optional depending on individual need of the learner)
Course Sections
  • Overview of Financial Modeling
  • Getting Familiar with Excel Basics
  • Working with Advanced Excel
  • Preparing a Financial Model
  • Discounted Cash Flow (DCF) Analysis
Course Goals and Objectives

This course will help you in understanding the Financial Modeling. By creating your own user-friendly financial model, you will learn to translate business concepts into a structured format to identify weaknesses and predict future performance.

Here you will get a thorough understanding of how to work with Advanced Excel tools and gain relevant skills to build good, integrated financial models. This course builds upon, and implements in Excel, the fundamental financial analysis topics. It will help you understand the performance of business, ongoing projects, and investments.

Knowledge of Advanced Excel will further help you in evaluating business options and risks in a cost effective manner against a range of assumptions. It helps in identifying optimal solutions and evaluating financial returns. Not only this, it will also help you explore the practical usage of advanced excel functions in a financial model.

It focuses on how to build a Full DCF model and will help you gain an expertise in doing valuation analysis in investment industry. You will be able to improve your efficiency and will be able to do valuation much quicker after undergoing the module on Discounted Cash Flow (DCF).

During this course, you will create your own financial model which you can take away and use for future reference. You will learn how to design and create a user-friendly model, which can be used by anyone with limited knowledge of Excel.

Topics covered include
  • Learn Excel Basics – Menu Commands, Data Manipulation, and Formatting
  • Gain Excel Proficiency – Calculations, Functions, Formulas, and Excel best practices
  • Gain Excel Expertise – Data Tables and Macros
  • Incorporate Excel Functions – Graphs; Charts; Direct/Indirect linking; Pivot table; Auto filter & Advance Filter; Conditional Formatting
  • Excel and Financial Modeling – Introduction to modeling techniques; Excel and its role in Financial Modeling
  • What do you understand by Financial Modeling?
  • What are the steps involved in preparing a financial model?
  • How to go ahead with modeling preparation?
  • What do you understand by projections?
  • What are the key assumptions that determine important performance measures?
  • How do you determine quality of assumptions?
  • What are the drivers that derive projections?
  • What is the importance of projecting financial statements?
  • What are the components required for projecting model?
  • What are the different methods used to prepare financial statements?
  • What are the historical ratios used to derive projections?
  • How to build an Earnings Projection Model?
  • How to prepare Depreciation Schedule?
  • How to prepare Amortization Schedule?
  • What do you understand by DCF Analysis?
  • How to calculate Terminal Value (Exit Value, perpetuity Growth Method)?
  • How to work on Discount Rate (cost of debit, cost of Equity, CAPM)?
  • How to calculate Sensitivity Analysis (TABLE Function)?
  • How to calculate Equity value multiples: P/E, P/CF, P/BV, PEG, and Dividend Yield?
  • How to build a Full DCF Model?
Hands on experience

Interactive CYUs, home assignments, project submission, project evaluation done by industry experts and feedback shared accordingly.


Prerequisites:

(What level of Knowledge you should have)

  • Knowledge of Accounting & Financial Statements Integration
  • Knowledge of Valuation Modeling
  • Basic to Moderate understanding of Excel worksheets
  • Laptop/Desktop with Windows applications (Excel and PowerPoint)
Package Cost

INR 14,000**with 6 months validity **

*(Cost including all taxes)

**Offer valid for a limited period only


What you will get:
  • Industry recognised certificate
  • Fast track your career in Capital Markets

*Completing this course does not guarantee a job or internship with MAKS.

You may also like

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Comparable Company Analysis....

Course duration - 60 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Comparable Transaction Analysis....

Course duration - 60 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Discounted Cash Flow Analysis....

Course duration - 50 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Financial Statement Analysis....

Course duration - 40 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

LBO Modeling....

Course duration - 50 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Acuity Knowledge Partners Certified Financial Rese....

Course duration -

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Investment Analyst Training Program....

Course duration -

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Finance for Non-Finance....

Course duration - 20 Hrs

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

MS Excel for Data Analysis....

Course duration - 30 Hrs

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

LBO Modelling....

Course duration - 20 Hrs

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Valuation Modeling....

Course duration -

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Advanced Financial Modeling for Investment Banking....

Course duration - 320 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Financial Modeling + Valuation Modeling (Combo)....

Course duration - 400 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Equity Research....

Course duration - 120 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Private Equity....

Course duration - 80 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Advanced FMIB + Credit Research (Combo)....

Course duration - 300 Hours

Developing Financial Acumen

MAKS's financial skills learning journeys are part of our business acumen development competency and services. This series of customized training programs...

Advanced Financial Modeling for Investment Banking....

Course duration - 200 Hours