Valuation Project # 6 - Cipla

This is an online course on Corporate Valuation - Pharma where you will learn how to valuate the company's value by using discounted cash flow method and relative valuation method. Through this online course you will learn about Basic Excel, Advanced Excel, Corporate Valuation and Report Writing Technique.

141

 18h 4m | 182 Videos | 87421 Views |   Intermediate| English[Auto-generated]

Corporate Valuation – Pharma Course 

This dynamic online course valuation-pharma provides practical experience in valuation. This includes practical excel exercises files, video tutorials and downloadable PDF Files. This course on Valuation-Pharma provides Excel templates along with their solutions.
This intensive training course on valuation-pharma emphasis on the core skills required for the successful application of corporate valuation techniques. We will learn following:

• Basic and advance excel proficiency.
• Corporate Valuation techniques like Dividend Discount Model DDM, Discounted Cash Flows DCF, Relative Valuations Enterprise Valuation Equity Value and many more.
• Also we will learn about Report Writing Technique

Target Audience

• MBA (Finance) Students
• Chartered accountant
• ICWA (intern)
• Finance professionals
• Financial Analyst
• Keen Learners.

Valuation-Pharma Course Highlights:

This course is divided into mainly four modules:

Basic Excel 2010:

This basic Excel module will teach you basic feature of Excel .In this module you will learn following functions:

We will start with small Case Study, and then we will learn basic excel functions Calculations, Formulas used in spreadsheets, Formatting of data,Percentages Absolute References, Conditional Formatting, IF Functions, Charts and Graphs, Sorts and Filters, Pivot Tables,  Freeze and Split and many more.

Advanced Excel 2010:

In today’s changing business scenario, it is very important to having advance excel skills for business professionals. This module on advanced training course follows up from the Basic Excel course.

In this online course, you will learn advanced features such as What If Analysis, how to use Names and Dynamic Range effectively, and more. Also you will learn about performing lookups and HLOOKUP. This video tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts.

Corporate Valuation:

You will learn about various valuation techniques like Dividend Discount Model, Discounted Cash Flows DCF. This module includes DCF Application with reference to Asian Paints, Google and Reliance Industries. Also in this module you will learn Relative Valuations, Enterprise Valuation, Residual Income Method, Sector wise Specific Valuation Methodologies, and various Private Equity Valuation Approaches and much more.

Report Writing Technique:

In this module learn what is Equity Research Report,Anatomy of Equity Research Report, Report writing techniques, Do’s & Don’ts of Research Report Writing. Also refer some useful websites given in training material, learn about Peer Analysis and much more.