Financial Analysis Business Valuation DCF IRR and more

Learn to model the valuation of a company using DCF & multiples – Perfect for financial analysts, IB, and PE!
Financial Analysis Business Valuation DCF IRR and more
File Size :
1.58 GB
Total length :
3h 7m

Category

Instructor

Joseph @ Wisdify

Language

Last update

1/2021

Ratings

4.5/5

Financial Analysis Business Valuation DCF IRR and more

What you’ll learn

Build a complete, working discounted cash flow (DCF) model in Excel from scratch
Value a company using the DCF and multiples approach
Use IRR, ROE, and NPV to analyze a project’s feasibility
Calculate the weighted average cost of capital (WACC)
Calculate the cost of equity using the Capital Asset Pricing Model (CAPM)
Determine the terminal value of a cash flow stream

Financial Analysis Business Valuation DCF IRR and more

Requirements

Beginner knowledge of finance
Any version of Excel will be compatible with this course
We recommend taking our other finance courses first (Financial Statement Analysis and Financial Modeling)

Description

If you’re in the finance or accounting world (or aspire to be), you need to know how to create a discounted cash flow model (DCF) to value a company or project!What will you learn in this course?Build a complete, working discounted cash flow (DCF) model in Excel from scratch, using a fictional private companyValue a company using the DCF and multiples approachUse IRR, ROE, and NPV to analyze a project’s feasibilityCalculate the weighted average cost of capital (WACC)Calculate the cost of equity using the Capital Asset Pricing Model (CAPM)​Determine the terminal value of a cash flow streamDon’t worry, you don’t need a deep background in finance or accounting to take this course! We’ll start with the basics and walk you through piece by piece. In this course, we’ll build a complete, working discounted cash flow (DCF) model in Excel from scratch, using a fictional private company. Our course will teach you how to calculate the cost of equity, WACC, and levered/unlevered beta.With this knowledge, we’ll calculate the discounted free cash flow and the terminal value. From there, we’ll learn how to value a company using the multiples approach. We top off the course be learning how to analyze the financial viability of a new project using methods such as IRR, ROE, NPV, and break even.What makes our course so awesome?38 page easy to understand guide: Our workbook is super easy to understand and reference for later dates Real world case-studies: In depth, real-world case studies using both real and fictitious companiesFun: Light-hearted, fun, and enjoyable course (we never take ourselves too seriously)Knowledgeable instructor: Nate is a CPA and has spent his career valuing companies and analyzing financial statements No fluff: We don’t teach theory or waste your time with useless information. Everything we teach you can start applying TODAYThis course is the first part of a 3 part series on the financial statements. The first course focuses on learning the financial statements (Financial Statement Analysis) and the second on on financial modeling (Financial Modeling Bootcamp). We use the same case study in all three courses so your knowledge builds as you build your knowledge. Let’s start learning!

Overview

Section 1: Introduction

Lecture 1 Welcome to the course!

Lecture 2 Intro to the case study

Lecture 3 Resources

Section 2: Intro to Valuation & Free Cash Flow

Lecture 4 Intro to the DCF approach

Lecture 5 Intro to the multiples approach

Lecture 6 Understanding unlevered free cash flow

Lecture 7 Calculating unlevered free cash flow

Section 3: Discount Rate (Weighted Avg. Cost of Capital)

Lecture 8 Intro to the discount rate

Lecture 9 Calculating the weighted average cost of capital (WACC)

Lecture 10 Determining the cost of equity using the CAPM

Lecture 11 Calculating the cost of equity

Lecture 12 Determining the beta in the CAPM

Lecture 13 Calculating the cost of debt and equity

Lecture 14 Finalizing the WACC calculation

Lecture 15 Calculating the unlevered beta

Section 4: Finalizing the DCF and Multiples Approach

Lecture 16 Discounting the free cash flows

Lecture 17 Determining the terminal value

Lecture 18 Completing our DCF model

Lecture 19 Calculating value using the Multiples approach

Section 5: Sensitizing & Presenting our Valuations

Lecture 20 Sensitizing our assumptions pt. I

Lecture 21 Sensitizing our assumptions pt. II

Lecture 22 Creating a football field valuation chart pt. I

Lecture 23 Creating a football field valuation chart pt. II

Section 6: Projecting a Project’s Cash Flow

Lecture 24 Intro to the project valuation case study

Lecture 25 Refining our case study assumptions

Lecture 26 Projecting revenue

Lecture 27 Projecting direct costs

Lecture 28 Projecting indirect costs

Lecture 29 Calculating free cash flow

Section 7: Analyzing a Project w/ Metrics

Lecture 30 Understanding Return on Investment (ROI)

Lecture 31 Understanding Internal Rate of Return (IRR)

Lecture 32 Understanding Net Present Value (NPV)

Lecture 33 Understanding breakeven

Lecture 34 Calculating ROI and IRR

Lecture 35 Calculating NPV and breakeven

Lecture 36 Creating and analyzing a sensitivity table

Section 8: Conclusion & Final Exam

Lecture 37 Final Thoughts

Accountants and Financial Analysts,Accounting and finance students,Aspiring Investment bankers,Business owners,Financial professionals

Course Information:

Udemy | English | 3h 7m | 1.58 GB
Created by: Joseph @ Wisdify

You Can See More Courses in the Business >> Greetings from CourseDown.com

New Courses

Scroll to Top