Company Valuation using a Monte Carlo Simulation

Implementation in an example Excel file

3.80 (53 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
instructor
Company Valuation using a Monte Carlo Simulation
277
students
3.5 hours
content
Feb 2021
last update
$39.99
regular price

What you will learn

Usage of the Monte Carlo Simulation in Microsoft Excel

Company Valuation with Discounted Cashflows

Implementing a way to reflect different possible cases in your company valuation

Understanding the effect of the different variables on the calculated company value

Creation of Monte Carlo Simulations without buying expensive Excel add-ins

Description

In my Online Course we will create together an Excel File that uses the Monte Carlo Simulation for various variables necessary in a company valuation. I explain the steps to value a firm with the discounted cashflow method and we will complete an example valuation on screen to deepen the understanding of various Excel formulas and financial modeling.

At the End you will have an example Excel File to quickly value any firm you want by taking into account the uncertainty of future values.

You will have the knowledge to adapt the Excel File for your own needs, to extend it if you want to include more variables or to increase the accuracy of your valuation.

In addition you will be able to perform Monte Carlo simulations with different probability distributions in Excel for any topic.

Content

Introduction

Presentation
The Monte Carlo Simulation in Theory
Steps to a successful company valuation
Presenting the Final Result

Company Valuation in Excel

Starting a new valuation
Importing the Source Data
Calculating the Free Cashflow
Cost of Debt
Defining the Discount Rate

Including a Monte Carlo Simulation in our Valuation

Simulation of Revenue, EBIT Margin and R&D adjustment
Simulation of CAPEX, change in Working Capital and the Tax Rate
Estimating Future Cashflows
Finishing the Cashflow Calculation

Analyzing the Results

Analyzing the Results
Summary and Outlook

Reviews

Manogane
October 5, 2022
Great Course! The Lecturer speaks clearly from an experienced and educated perspective. My only recommendation would be that he creates more courses on finance, weather this be more courses on Monte Carlo(maybe for Value at Risk), or more valuation techniques. Thank you for the great learning experience!!
Nikita
December 3, 2020
Хорошо, я бы не сказал, что курс профессиональный, хоть и тематика нестандартной DCF довольно специфична , парень старался, видно, что хороший бекграунд по отчетностям, но в плане допущений как по прогнозам, так и по будущему росту слабовато, хороший математический аппарат и идеи хорошие, но подача сыровата, видно что делает не профи (легко и быстро).В целом доволен курсом, свою символичную плату вполне стоит, особенно если берете в Черную пятницу.
Anton
October 24, 2020
Marcel explains the Monte Carlo Simulation in a very comprehensive and pleasant way with scientific accuracy. I really learned a lot! Thank you.

Charts

Price

Company Valuation using a Monte Carlo Simulation - Price chart

Rating

Company Valuation using a Monte Carlo Simulation - Ratings chart

Enrollment distribution

Company Valuation using a Monte Carlo Simulation - Distribution chart
3504728
udemy ID
9/16/2020
course created date
10/20/2020
course indexed date
Bot
course submited by