How to Value a Company - DCF Valuation & Financial Modelling

Focused View

Findamentals Education

3:56:46

199 View

1 - Introduction and Setting up your Spreadsheet

1 - Findamentals-How-to-Value-a-Company-AAPL-Model.xlsx

1 - Welcome to the Course.mp4

02:16

2 - Introduction to Valuations.mp4

17:28

3 - Setting Up your Spreadsheet.mp4

18:21

3 - apple financial reports.zip

2 - Constructing Pro forma Financial Statements

4 - Constructing a Pro forma Income Statement 12.mp4

22:07

5 - Constructing a Pro forma Income Statement 22.mp4

30:20

6 - Constructing a Pro forma Balance Sheet.mp4

31:38

7 - Working Capital.mp4

05:28

8 - Constructing a Pro forma Cash Flow Statement Revolver.mp4

16:25

3 - The Weighted Average Cost of Capital WACC

9 - WACC Introduction.mp4

10:38

10 - WACC Cost of Equity.mp4

17:17

10 - damodaran equity risk premium.zip

11 - WACC Cost of Debt.mp4

18:49

12 - WACC Terminal.mp4

06:05

4 - Calculating Free Cash Flows and Share Price

13 - Calculating Free Cash Flows and Share Price.mp4

15:37

5 - Further Analyses and Tools

14 - Chart Building Football Field.mp4

04:36

15 - Ratio Analysis.mp4

10:47

16 - Sensitivity Analysis.mp4

05:22

17 - Case Scenario.mp4

03:32

Description

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

Who is this for?

Pursuing a career in finance

Interested in investing and picking stocks

More details

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.
Disclaimers
This is educational content and does not constitute financial advice.
Â© Findamentals 2020
Who this course is for:
Pursuing a career in finance
Interested in investing and picking stocks

User Reviews

Rating

average 0

Total votes0

Focused display

Company Valuation

Findamentals Education

Instructor's Courses

Hi there! My name is Josh and I founded Findamentals as a way of educating a new wave of students interested in finance, business and investing.I am passionate about all things finance and investing. During my time at business school, I wanted to identify undervalued stocks to invest in and I also wanted to pursue a career in finance, however, it was difficult to find content that was comprehensive as well as practical. At Findamentals, I aim to create relevant, interesting and practical content, taking my students through everything I have learn in my professional, academic and personal experiences, supplemented with industry best practice and academic research.I currently work as a buy-side Investment Analyst covering Australian Equities at a highly regarded diversified equity fund manager. I also have experience at notable firms including Deloitte and Grant Thornton, as well as an industry-leading and fast-growing tech company headquartered in San Fransisco.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.