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


Download link

rapidgator.net:

Código:

https://rapidgator.net/file/7fe251a2e24d6aa2c16ed9e8be439a91/lzhni.How.To.Value.A.Company..Dcf.Valuation..Financial.Modelling.part1.rar.html
https://rapidgator.net/file/34e3a92c80133fc49b91eee798b500a8/lzhni.How.To.Value.A.Company..Dcf.Valuation..Financial.Modelling.part2.rar.html

uploadgig.com:

Código:

https://uploadgig.com/file/download/b074c43cd0E8498d/lzhni.How.To.Value.A.Company..Dcf.Valuation..Financial.Modelling.part1.rar
https://uploadgig.com/file/download/4acfc5Eefd45B984/lzhni.How.To.Value.A.Company..Dcf.Valuation..Financial.Modelling.part2.rar

nitroflare.com:

Código:

https://nitroflare.com/view/20BA43B9024371D/lzhni.How.To.Value.A.Company..Dcf.Valuation..Financial.Modelling.part1.rar
https://nitroflare.com/view/E342553073F7684/lzhni.How.To.Value.A.Company..Dcf.Valuation..Financial.Modelling.part2.rar

1dl.net:

Código:

https://1dl.net/2k10klmm23hc/lzhni.How.To.Value.A.Company..Dcf.Valuation..Financial.Modelling.part1.rar.html
https://1dl.net/egnxcb3tq4z0/lzhni.How.To.Value.A.Company..Dcf.Valuation..Financial.Modelling.part2.rar.html