Valuation Course - Time Warner Cable Inc.
"Unlocking Value: Mastering Valuation with Time Warner Cable Inc."
Finance and Accounting,Other Finance and Accounting,Private Equity
Lectures -180
Duration -18 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Valuation Course – Broadcasting and Cable TV (Time Warner Cable Inc.)
The objective of this online live project is for the candidates to learn about valuation methodologies such as discounted cash flows (DCF) and relative valuations and apply it on a live company which is Time Warner Cable Inc. and arrive at its fair share price value.
The participants would be provided with the financial model of Time Warner Cable Inc. prepared by our research analysts and using the information participants are supposed to do the valuation. Another part of this project includes preparing a recommendation report on the investment decision arrived at after completing the valuations.
At the end of this course the candidates will be in a position to recommend the buy/sell/hold investment perspective on the stocks of Time Warner Cable Inc.
Target Audience for Valuation Course:
- Financial Analyst or Stock Analyst
- Students seeking to do a short internship
- Anyone keen to learn corporate valuation methodologies and apply it on a live company.
Valuation Course Highlights
The valuation course has been divided into various modules which have been explained as follows;
Excel for analysts
An analyst is required to work on excel day in and out and needs to be very well versed with using excel tools and functions. In order to meet this requirements we have included the module of basic and advanced excel for the candidates to be proficient in excel usage. You would get to learn various excel functions such as IF, COUNT IF, SUM IF, conditional formatting, data functions, sorts and filters, charts and graphs, form control and much more.
Corporate Valuation
This module is to learn about core corporate valuation. It would cover concepts such as Dividend Discount Model (DDM), Discounted Cash Flows (DCF), relative valuation and its application examples comparable company analysis, residual income, sum of parts, sector specific valuation methodologies and private equity valuation approaches.
Report writing techniques
The last module of this course focuses on how the valuation recommendation needs to be presented in the form of an equity research report. The entire module explains what this report is, do’s and don’ts of writing a research reports.
Goals
Course Goals for Valuation Course - Time Warner Cable Inc.
- Familiarize yourself with the concept of Valuation: Acquire in depth knowledge of the significant valuation principles, practices and financial concepts that are applicable to Time Warner Cable Inc.
- Engage in Financial Statement Analysis: Be able to analyze TWC's financial statements and examine its performance by looking at the factors that create its value.
- Employ Valuation Approaches: Understand and utilize different approaches to valuation, such as DCF, comparable company analysis and precedent transactions.
- Assess the Markets: Evaluate industry dynamics, market environments and economic circumstances in the assessment of Time Warner Cable’s value.
- Develop Sensitivity Analysis: Learn to carry out sensitivity and scenario analysis, which is the analysis of behaviour of valuation results in affected by changes in assumptions.
- Relayed Results Don’t Have Sufficient Backing: Realize the importance of presenting the valuation results and insights to the parties concerned in an effective and convincing manner.
- Incorporate Ethical Dimension: Value and resolve the ethical dilemmas that arise from value assessment in any telecommunication sector.
- Learn Through Case Studies: Taking part in groups to study the particular cases that will help make the practical aspect of the valuation exercises more enjoyable.
Prerequisites
Prerequisites for Valuation Course - Time Warner Cable Inc.
Basic Financial Accounting
Introduction to Finance
Statistics and Data Analysis
Corporate Finance
Excel Proficiency

Curriculum
Check out the detailed breakdown of what’s inside the course
Basic Excel
27 Lectures
-
Getting Started Ribbons Quick Access Toolbar 10:12 10:12
-
Getting Started Surfing Excel HELP Function 11:08 11:08
-
Excel Case Study 02:00 02:00
-
Data Entry in Excel 08:56 08:56
-
Populating the Case Study in Excel 07:42 07:42
-
Calculations Addition Subtract Multiply Division 07:29 07:29
-
Formulas SUM MAX MIN AVERAGE 09:58 09:58
-
Formatting Number Formats 08:30 08:30
-
Formatting Table Formats 07:37 07:37
-
Updating a Calculation 02:41 02:41
-
Percentages and Absolute References 09:19 09:19
-
Conditional Formatting 08:28 08:28
-
IF Function 09:58 09:58
-
COUNTIF Function 04:18 04:18
-
SUMIF Function 08:22 08:22
-
Creating Charts and Graphs 08:32 08:32
-
Create Pie Charts 11:24 11:24
-
Sorts 04:54 04:54
-
Filter 04:50 04:50
-
Freeze and Split 06:21 06:21
-
Presentation Table Formats 05:42 05:42
-
Presentation Indents and Formatting Charts 05:40 05:40
-
Printing the Worksheet 07:29 07:29
-
Printing Headers and Titles 06:53 06:53
-
Shortcuts Formatting and Navigation 14:48 14:48
-
Shortcuts Selection Data and Formula 10:46 10:46
-
Common Errors 04:47 04:47
Advanced Excel
61 Lectures

Corporate Valuation
75 Lectures

Report Writing Technique
17 Lectures

Instructor Details

Corporate Bridge Consultancy Private Limited
Corporate Bridge Consultancy Private Limited - EDUCBA is an initiative by IIT IIM Graduates, We are one of the leading providers of skill-based education addressing the needs of 1,000,000+ members across 70+ Countries. With more the 15+ years of experience in Training and Development, our expertise lies in Self-paced learning, Digital Learning content, Corporate Training, Content Development and Consultancy.
Our Vision:
To be a leading and progressive partner with our clients in their journey of progress.
"We are passionate about our work. We believe in empowering and improving our members’ lives with skill-based, hands-on training programs."
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now