MENUMENU

Explore
Blog
Enterprise
Free Courses
Log in
Sign Up

Valuation Project # 14 – Zee TV

Home Courses Valuation Project # 14 – Zee TV

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Δ

Primary Sidebar

Curriculum

1. Basic Excel

Getting Started Ribbons Quick Access Toolbar

Getting Started Surfing Excel HELP Function

XYZ Company Basic Excel Case Study

Excel Case Study

Data Entry in Excel

Populating the Case Study in Excel

Populating case study in excel without solution

Populating case study in excel with solution

Calculations Addition Subtract Multiply Division

Calculations without solution

Calculations with solution

Formulas SUM MAX MIN AVERAGE

Formulas without solution

Formulas with solution

Formatting Number Formats

Formatting Number Formats without solution

Formatting Number Formats with solution

Formatting Table Formats

Formatting Table Formats without solution

Formatting Table Formats with solution

Updating a Calculation

Updating a calculation without solution

Updating a calculation with solution

Percentages and Absolute References

Percentage asbsolute refernceswithout solution

Percentage asbsolute refernceswith solution

Conditional Formatting

Conditional formatting without solution

Conditional formatting with solution

If function without solution

If function with solution

COUNTIF Function

Count if without solution

Count if with solution

Sum if without solution

Sum if with solution

Creating Charts and Graphs

Creating Charts and Graphs without solution

Creating Charts and Graphs with solution

Create Pie Charts

Create Pie Charts without solution

Create Pie Charts with solution

Sorts without solution

Sorts with solution

Filter without solution

Filter with solution

Pivot table without solution

Pivot table with solution

Freeze and Split

Freeze and split without solution

Freeze and split with solution

Presentation Table Formats

Presentation 1 without solution

Presentation 1 with solution

Presentation Indents and Formatting Charts

Presentation Indents and Formatting Charts without solution

Presentation Indents and Formatting Charts with solution

Printing the Worksheet

Printing Headers and Titles

Shortcuts Formatting and Navigation

Shortcuts Selection Data and Formula

Excel Shortcuts

2. Advanced Excel

Office Button and Paste Function

Sparklines Custom Ribbons and Screenshots

Conditional Formatting and Equation Editor

Paste Special Base File

Logical functions IF AND OR

Logical functions IF AND OR

Logical Function Quiz Without Solution

Logical Function Quiz With Solution

Arithmetic functions MAX MIN ABS etc

Arithmetic functions MAX MIN ABS etc

Quiz Arithmetic Function Without Solution

Quiz Arithmetic Function With Solution

COUNT COUNTIF COUNTA COUNTBLANK

COUNT COUNTIF COUNTA COUNTBLANK

Cell Information ISERROR ISBLANK etc

Cell Information Without Solution

Cell Information With Solution

CHOOSE Function

CHOOSE Function

Choose Function Without Solution

Choose Function With Solution

VLOOKUP Function

VLOOKUP Function

Vlookup Referencing Database File

Vlookup Function Without Solution

Vlookup Function With Solution

HLOOKUP Function

HLOOKUP Function

Hlookup Referencing Database File

Hlookup Function Without Solution

Hlookup Function With Solution

Database functions DSUM DAVERAGE DCOUNT

Database functions DSUM DAVERAGE DCOUNT

Database functions Without Solution

Database functions With Solution

OFFSET Function Part 1

OFFSET Function Part 2

OFFSET Function Without Solution

OFFSET Function With Solution

FORECAST Function

FORECAST Function Without Solution

FORECAST Function With Solution

One Dimensional Data Tables

One Dimensional Data Tables

One Dimensional Data Tables Without Solution

One Dimensional Data Tables With Solution

Two dimensional Data Tables

Two dimensional Data Tables Without Solution

Two dimensional Data Tables With Solution

Solver Without Solution

Solver With Solution

Goal Seek Without Solution

Goal Seek With Solution

Array Function Introduction

Array Function Part 1 Without Solution

Array Function Part 1 With Solution

Array Function Row and Columns

Array Function Part 2 Without Solution

Array Function Part 2 With Solution

Array Function TRANSPOSE

Array Function Part 3 Without Solution

Array Function Part 3 With Solution

Array Function FREQUENCY

Array Function Part 4 Without Solution

Array Function Part 4 With Solution

PROPER UPPER LOWER LEFT RIGHT MID

Text and String Function Part 1 Without Solution

Text and String Function Part 1 With Solution

FIND CLEAN REPT CONCATENATE

Text and String Function Part 2 Without Solution

Text and String Function Part 2 With Solution

Pivot Tables Without Solution

Pivot Tables With Solution

Pivot Table Filter Slicer

Pivot Table Filter Slicer Without Solution

Pivot Table Filter Slicer With Solution

Pivot Charts Without Solution

Pivot Charts With Solution

Naming a Cell and a Range

Names Dynamic Ranges Part 1 Without Solution

Names Dynamic Ranges Part 1 With Solution

Naming Dynamic Ranges

Names Dynamic Ranges Part 2 Without Solution

Names Dynamic Ranges Part 2 With Solution

Auditing Toolbar

Auditing Toolbar Base File

Watch Window Base File

Group Boxes and Options Button

Group Boxes and Options Button Base File

Check Boxes Base File

List Boxes and Combo Boxes

List Boxes and Combo Boxes Base File

Scroll Bar and Spinners

Scroll Bar and Spinners Base File

Text to Columns

Text to Columns Without Solution

Text to Columns With Solution

Grouping Tabs Without Solution

Grouping Tabs With Solution

SUBTOTAL Function

SUBTOTAL Function Without Solution

SUBTOTAL Function With Solution

Hyperlinks Base File

Data Validation

Data Validation Without Solution

Data Validation With Solution

Random Numbers Without Solution

Random Numbers With Solution

Custom View Without Solution

Custom View With Solution

Protecting Worksheet and Workbook

Protecting Worksheet and Workbook Without Solution

Protecting Worksheet and Workbook With Solution

Excel 2010 Sparklines

Excel 2010 Sparklines Without Solution

Excel 2010 Sparklines With Solution

Range Charts Type 1 Part a

Range Charts Type 1 Part b

Range Charts Without Solution

Range Charts With Solution

Range Charts Area

Range Charts Area Type 2 Part a

Range Charts Area Type 2 Part b

Range Charts Area Without Solution

Range Charts Area With Solution

Funding Graph Without Solution

Funding Graph With Solution

Two Axis Graphs

Two Axis Graphs

Two Axis Graphs Without Solution

Two Axis Graphs With Solution

Scenario Graphs

Scenario Graphs Part 1

Scenario Graphs Part 2

Scenario Graphs Without Solution

Scenario Graphs With Solution

Adding an average line without solution

Adding an average line with solution

Bar to Pie chart

Bar to Pie Chart without solution

Bar to Pie Chart with solution

Combo Charts without solution

Combo Charts with solution

Creating Histogram

Creating Histogram without solution

Creating Histogram with solution

Invert Negatives

CBA Invert Negatives in Chart without solution

CBA Invert Negatives in Chart with solution

Scrolling Chart part 1

Scrolling Charts part 1 without solution

Scrolling Charts part 1 with solution

Scrolling Chart part 2

Scrolling Charts part 2 without solution

Scrolling Charts part 2 with solution

3. Corporate Valuation

Introduction to Valuation

Dividend Discount Module

Dividend discount model DDM Example 1

Dividend discount model DDM Example 2

Dividend discount model DDM Example 3

Dividend discount model DDM Example 4

Dividend discount model DDM Example 4

Dividend Discount Model without solutions

Dividend Discount Model with solutions

Dividend Discount Model

Discounted Cash Flow

Introduction to DCF

Introduction to DCF

FCFF FCFE Example without solutions

FCFF FCFE Example with solutions

Forecasting Income Statement EBITDA

Understanding the Working Capital

Completing the Working Capital Calculations

Linking the Free Cash Flow to Firm FCFF

Discounting the Explicit Period Cash Flows

Detailed view on Calculating FCFF

Calculation of Terminal Values

Terminal Value Perpetuity Growth and Exit Multiple Method

Projecting FCFF Terminal Value without solution

Projecting FCFF Terminal Value with solution

DCF Valuation Summary

DCF Sensitivity Analysis

Understanding the Capital Structure

Options Treasury Stock Method

Options Explained Part 2

Calculation of inthemoney Convertibles

Calculation of inthemoney Stock Options

Calculation of Debt Equity Ratio

Understanding the Capital Structure without solution

Understanding the Capital Structure with solution

Cost of Debt Calculations

Cost of Debt Calculations

Cost of Equity Calculation

Weighted Average Cost of Capital WACC

WACC Calculations without Solution

WACC Calculations with Solution

Enterprise Value Calculation Completing the Missing Links

Enterprise Value Calculation

Adjustments to Enterprise Value

DCF Synthesis without solution

DCF Synthesis with solution

WACC Calculations Internet Companies Case Study

DCF Application Asian Paints without solution

DCF Application Asian Paints with solution

DCF Application Asian Paints

DCF Application Google Inc without solution

DCF Application Google Inc with solution

DCF Application Google Inc

Relative Valuation

Introduction to Relative Valuation

Introduction to Relative Valuation

Relative Valuations Enterprise Value and Equity Value

Relative Valuations Comparable Comp Sheet

Relative Valuations Equity Value Method

Understanding PE Ratio

Forward and Trailing PE

Advantages and Limitations of PE

Understanding PBV Ratio

Why PBV is used in Banks

PBV and ROE Used for Energy Sector

Understanding PCF Ratio

Why PCF used in Oil Gas Gold Real Estate

Relative Valuation Enterprise Value

Benchmarking Analysis

Benchmarking Analysis part 1

Benchmarking Analysis part 2

Benchmarking Analysis part 3

Benchmarking Analysis part 4

Benchmarking Analysis part 5

Wockhardt Comparable Company Valuation

Wockhardt Equity Valuation Summary Comparable Company Valuation Part 1

Wockhardt Equity Valuation Summary Comparable Company Valuation Part 2

Football Field Wockhardt Case Study

Football Field Wockhardt Case Study

RHI Comparable Company Analysis

RHI Comparable Company Analysis without solutions

RHI Comparable Company Analysis with solutions

Comparable Acquisition Analysis

Introduction to Sum of Parts

ITC Cigarette Segment Comparable Comp without solution

ITC Cigarette Segment Comparable Comp with solution

ITC FMCG Segment Comparable Comp without solution

ITC FMCG Segment Comparable Comp with solution

ITC Hotel Segment Comparable Comp without solution

ITC Hotel Segment Comparable Comp with solution

Introduction to Residual Income Method

Residual Income Method without solution

Residual Income Method with solution

Benchmarking Analysis

Comparables for Hospital Companies Part 1

Comparables for Hospital Companies Part 2

Comparables for Hospital Companies Part 3

Comparable Company Analysis

Comparable Company Analysis Pharma part 1

Comparable Company Analysis Pharma part 2

Comparable Company Analysis Pharma part 3

Comparable Company Analysis Pharma part 4

Cement Sector Comparable Companies Analysis Comps Analysis

Cement Sector Comparable Companies Analysis Comps Analysis

Valuing Property Companies Part 1

Valuing Property Companies Part 2

Valuing Property Companies Part 3

Valuing Property Companies Part 4

Comp Sheet Global Benchmarking Model

Comps Sheet Global Benchmarking Model Part 1

Comps Sheet Global Benchmarking Model Part 2

Comps Sheet Global Benchmarking Model Part 3

Comps Sheet Global Benchmarking Model Part 4

Comps Sheet Global Benchmarking Model Part 5

Comps Sheet Global Benchmarking Model Part 6

Comps Sheet Global Benchmarking Model Part 7

Oil and Gas Sector Comparable Company Analysis COMPS

Oil and Gas Sector Comparable Company Analysis COMPS

Valuation Methodologies for PE Fund managers

Valuation Methodologies part 1

Valuation Methodologies part 2

Valuation Methodologies part 3

Valuation Methodologies part 4

Discounted Cash Flows

Calculating Discounted Cash Flows part 1

Calculating Discounted Cash Flows part 2

Calculating Discounted Cash Flows part 3

Calculating Discounted Cash Flows part 4

Calculating Discounted Cash Flows part 5

Calculating Discounted Cash Flows part 6

Calculating Discounted Cash Flows part 7

Calculating Discounted Cash Flows part 8

WACC analysis PE Companies

WACC analysis PE Companies part 1

WACC analysis PE Companies part 2

4. Report Writing Technique

What is Equity Research Report

What is Equity Research Report Part 1

What is Equity Research Report Part 2

Anatomy of Equity Research Report

Anatomy of Equity Research Report

Comparing Equity Research Report

Comparing Equity Research Report

Report Writing Case Studies

Report Writing Case Studies

Useful Financial Websites

Useful Financial Websites

Indian Media Sector Report

Indian Media Sector Report Part 1

Indian Media Sector Report Part 2

Indian Media Sector Report Part 3

Peer Analysis without solutions

Peer Analysis with solutions

Peer Analysis part 1

Peer Analysis part 2

Peer Analysis part 3

Peer Analysis part 4

Peer Analysis part 5

Peer Analysis part 6

Peer Analysis part 7

Aurobindo Pharma Annual Report

Biocon Ltd Annnual Report

Cadila Annual Report

Dishman Annnual Report

Sun Pharma Annual Report

X

Loading the player...

Related Job Oriented Programs

Footer

Follow us!

APPS

EDUCBA Android App

EDUCBA iOS App

Company

About us
Alumni Speak
Contact Us
Log in
Sign up

Work with us

Careers
Become an Instructor

EDUCBA for Enterprise

Enterprise Solutions
Explore Programs
Free Courses
Free Tutorials
EDUCBA at Coursera
EDUCBA at Udemy

Resources

Blog
Self-Paced Training
ExamTurf
Verifiable Certificate
Popular Skills Catalogue
Exam Prep Catalogue

Popular Categories

Lifetime Membership
All in One Bundles
Featured Skills
New & Trending
Fresh Entries
Finance
Data Science
Programming and Dev
Excel
Marketing
HR
PDP
VFX and Design
Project Management
Exam Prep
Learning Paths @ $19
Learning Paths @ $49
All Courses

Terms & Conditions
Disclaimer
Privacy Policy & Cookie Policy
Shipping Policy

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

Email ID *

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

Email ID *

By signing up, you agree to our Terms of Use and Privacy Policy.

*Please provide your correct email id. Login details for this Free course will be emailed to you

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA Login

Username

Password

Forgot Password?

🚀 Limited Time Offer! - ENROLL NOW