How To Value A Company - Dcf Valuation & Financial Modelling

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...

Read more

Continue reading...