How To Value A Company - Dcf Valuation & Financial Modelling

A Practical DCF Valuation and Financial Modelling Masterclass - Learn how to value a company and derive a share price

What you'll learn

Build a financial model in Excel from beginning to end

Value a company and derive a share price

Construct an integrated three statement financial model

Construct pro-forma financial statements

Calculate a weighted average cost of capital (WACC)

Perform analyses including ratio analysis and sensitivity analysis

Set up case scenarios and professional charts

Determine whether a stock is over or undervalued

Requirements

Basic understanding of corporate finance

Basic knowledge of Microsoft Excel

Description

In this class, you will learn how to value a company, construct an integrated three statement financial model, and arrive at a share price using a Discounted Cash Flow or DCF valuation method. Building a skillset in financial modelling and equity valuations can transform your ability to understand a business and its value. Note: A valuation is a technique in finance that looks to estimate the current worth of an asset or company.Why this course?This course uses a highly practical and comprehensive approach to teaching equity valuation and building a DCF model to derive an implied share price, by building a financial model for Apple Inc. as a detailed, current, real life example.Universities and most online courses typically don’t teach this content in a practical manner, despite its usefulness in industry and how much it can help boost your financial understanding. In this online class I will be taking you through everything I have learnt about equity valuations supplemented with industry best practice and academic literature. Throughout the course, I also provide useful tips and discuss important considerations that will reinforce your finance knowledge and help you with future equity valuations.  By the end of this course, you should be able to build your own financial models and determine the value of companies. So thanks for stopping by - I hope you learn a lot and are able to apply it to your own investment opportunities and future career.Please feel free to contact me with any questions, requests, or feedback.DisclaimersThis is educational content and does not constitute financial advice.© Findamentals 2020

Overview

Section 1: Introduction and Setting up your Spreadsheet

Lecture 1 Welcome to the Course

Lecture 2 Introduction to Valuations

Lecture 3 Setting Up your Spreadsheet

Section 2: Constructing Pro forma Financial Statements

Lecture 4 Constructing a Pro forma Income Statement [1/2]

Lecture 5 Constructing a Pro forma Income Statement [2/2]

Lecture 6 Constructing a Pro forma Balance Sheet

Lecture 7 Working Capital

Lecture 8 Constructing a Pro forma Cash Flow Statement & Revolver

Section 3: The Weighted Average Cost of Capital (WACC)

Lecture 9 WACC: Introduction

Lecture 10 WACC: Cost of Equity

Lecture 11 WACC: Cost of Debt

Lecture 12 WACC: Terminal

Section 4: Calculating Free Cash Flows and Share Price

Lecture 13 Calculating Free Cash Flows and Share Price

Section 5: Further Analyses and Tools

Lecture 14 Chart Building - Football Field

Lecture 15 Ratio Analysis

Lecture 16 Sensitivity Analysis

Lecture 17 Case Scenario

Pursuing a career in finance,Interested in investing and picking stocks