Company Valuation using a Monte Carlo Simulation

Company Valuation using a Monte Carlo Simulation

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.

Implementation in an example Excel file

Url: View Details

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

Rating: 3.75

Level: Intermediate Level

Duration: 3.5 hours

Instructor: Marcel Illgen