reed.co.uk Courses

Header

Online Equity Valuation of Media Sector Training


EduCBA

Summary

Price
Save 87%
£25 inc VAT (was £189)
Offer ends 31 December 2019
Study method
Online, self-paced
Duration
19 Hours
Access to content
Lifetime access
Qualification
No formal qualification
Additional info
  • Certificate of completion available and is included in the price

Add to basket or enquire

Overview

About Media Company Equity Valuation Training

  • 19+ Hours OF HD VIDEOS
  • Verifiable CERTIFICATION
  • Practical SKILLS DEVELOPMENT
  • Accelerate YOUR CAREER
  • Lifetime Access 24*7 Unlimited Access
  • Access through any device
  • Technical support
  • Mobile App Access

Knowing what a company is worth and what determines is value, is a prerequisite towards intelligent decision making. It’s the process to determine the economic worth of a company under some specific assumptions and conditions, and subject to the available data on the date of valuation. It’s important to mention that business valuation is not a science and depends on several factors like purpose of valuation, stage of the business, projected financial results, past financial performance, market recognition, industry scenario etc.

Description

About Media Company Equity Valuation Training

Knowing what a company is worth and what determines is value, is a prerequisite towards intelligent decision making. It’s the process to determine the economic worth of a company under some specific assumptions and conditions, and subject to the available data on the date of valuation. It’s important to mention that business valuation is not a science and depends on several factors like purpose of valuation, stage of the business, projected financial results, past financial performance, market recognition, industry scenario etc.

Equity Valuation Course description

The media company valuation course description is as follows.

Basic Excel:

Fundamentals of the popular electronic spreadsheet are introduced in this section. These include ribbons and the quick access toolbar, surfing the Excel “Help” function, case studies, data entry, populating the case study, calculations i.e. addition, subtraction, multiplication, and division, formulas like sum, max, min, and average, formatting the number and table formats, updating calculations, percentage and absolute references, “If” function, conditional formatting, Countif and Sumif functions, creating graphs and charts, creating pie charts, filters, sorts, pivot tables, presentation table formats, freeze and split, formatting charts and presentation indents, printing worksheets, printing headers and titles, shortcuts to formatting and navigation, shortcuts to selection data and formula, and common errors.

Advanced Excel:

This section is divided into 61 parts. Here you learn about the office button and paste function, screenshots and sparklines custom ribbons, equation editor and conditional formatting, paste special, logical functions i.e. if and or, arithmetic functions like max, min, abs, and others, Count, countif, countblank, and counta, cell information like isblank, iserror and others, the CHOOSE, HLOOKUP and VLOOKUP functions, MATCH INDEX, database functions like DAVERAGE, DSUM, and DCOUNT, one dimensional and two dimensional data tables, FORECAST function, OFFSET functions, solver and goal seek, introduction to array function and its rows and columns, TRANSPOSE, and FREQUENCY, major array functions like UPPER, LOWER, LEFT, MID, RIGHT, and PROPER, CLEAN, FIND, CONTAENATE, and RPT, pivot tables, filter slicer and charts, naming cells, ranges, and dynamic ranges, watch window, auditing toolbar, group boxes and the options button, check boxes, list and combo boxes, scroll bars and spinner, grouping tabs, text to columns, SUBTOTAL function, data validation, hyperlinks, custom view, random numbers, protecting your worksheet and workbook, range charts type and area, two axis graphs, funding graphs, scenario graphs, bar to pie chart, average line, combo charts, inverting negatives, creating histograms, and scrolling charts.

Corporate valuation:

In this section you learn about the dividend discount model (DDM) with examples, introduction to DCF and its equity valuations, forecasting the income statement EBITDA, understanding working capital, completing working capital calculations, linking free cash flow to the firm, discounting explicit period cash flows, calculating terminal values, DCF sensitivity analysis and valuation summary, options treasury stock method, calculation of “in the money” stock options and debt equity ratio, CAPM, cost of debt calculation, terminal value, enterprise value calculation: calculating the missing links, DCF using Reliance Industries as an example, introduction to relative valuation, enterprise and equity value, and comparable comp sheet, understanding the PE ratio and its advantages and limitations, forward and trailing PE, understanding the PE ratio and why it’s used in banks, understanding the PCF ratio and why it’s used in real estate, oil and gas, and gold, benchmarking analysis, Wockhardt equity valuation summary comparable company valuation (in two parts), football field Wockhardt case study, comparables for hospital companies, comparable company analysis in the pharmaceutical and cement sector, valuing property companies (in four parts), the comps sheet global benchmarking model, oil and gas sector comparable energy analysis, valuation methodologies (in four parts), Cairn India valuation methodology, calculation of discounted cash flows, WACC analysisPE companies, and football field.

Who is this course for?

The course is mainly aimed at those who are from a financial background and want to explore advanced subjects of financial modelling and company valuation. These include equity analysts, investment bankers, fund managers, merger and acquisition professionals, finance directors and treasurers, venture capitalists and private equity specialists, commercial bankers, business analysts, and other finance professionals.

Requirements

Business valuation involves opinions for gifting, estate planning and taxation, opinions on mergers and acquisitions, recapitalisation, divestitures, financial opinion regarding litigation, transfer pricing engagement to provide clients overseas operation inoculation against audit risk, financial options regarding retirement and exit strategy planning.

Questions and answers

Currently there are no Q&As for this course.Be the first to ask a question.

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals