Course

Course Overview

Estimated Training Hours: 50 Hours

Mode - Online

To be completed within 50 Hours

DCF analysis is one of the most popular method of valuation. Here, you will learn how to build a complete, working discounted cash flow (DCF) model in Excel from scratch, using real case studies, industry best practices, and sensitivity analyses. It will help you understand how the potential for an investment is evaluated. Not only this, you will also be getting reusable, modifiable Excel DCF model templates for practice.

This course will guide you through the mechanics of the DCF valuation process with simple and easy to understand steps. Once you enroll in this course you will get free support from our highly skilled and experienced trainers. The concepts and models taught here are designed to be of practical benefit and are immediately usable in the workplace.

After successful completion of this course, you will gain good knowledge which will help you move ahead in your career.

The course work involves the following:
  • Reading Material
  • Video Tutorials
  • Reusable, modifiable Excel DCF model 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 Goals and Objectives

Here you will learn how corporations are valued and the major analytical tools that are used. You will go beyond academic theory to real-world methods as used by professionals; includes a crucial primer to Corporate Finance and its non-theoretical application. Apply learning objectives and goals immediately by analyzing various concepts.

Topics covered include
  • Overview of Valuation Modeling
  • Explaining the Discounted Cash Flow
  • Gathering information for Historical Financials
  • Determining WACC
  • Understanding the cost of equity, CAPM model
  • Understanding the cost of debt and hybrid securities
  • Spreading historical financials
  • Formulating assumptions for forecasted financials
  • Forecasting Free Cash Flows
  • Calculating the Cash flows to Valuation date
  • Calculating the Terminal Value
  • Calculating the Discount Rate
  • Perform the calculations to derive the Enterprise Value
  • Calculating TEV and Equity Value
  • Performing Sensitivity Analysis
  • Building a Full DCF model
  • Video tutorial on DCF and sensitivity analysis
  • Assignments on DCF model
Hands on experience

Interactive CYUs, home assignments, project submission, project evaluation done by industry experts and feedback shared accordingly, Live Chat support for clearing doubts and resolving queries


Prerequisites:

(What level of Knowledge you should have)

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

INR 6,250*with 3 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 Acuity Knowledge Partners.

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...

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...

On-line Investment Analyst Training Program....

Course duration - 200 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