Skip to content
Felix
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
  • Ask An Instructor
  • Support
  • Log in
  • Topics
    • My List
    • Felix Guide
    • Asset Management
    • Coding and Data Analysis
      • Data Analysis and Visualization
      • Financial Data Tools
      • Python
      • SQL
    • Credit
      • Credit Analysis
      • Restructuring
    • Financial Literacy Essentials
      • Financial Data Tools
      • Financial Math
      • Foundations of Accounting
    • Industry Specific
      • Banks
      • Chemicals
      • Consumer
      • ESG
      • Insurance
      • Oil and Gas
      • Pharmaceuticals
      • Project Finance
      • Real Estate
      • Renewable Energy
      • Technology
      • Telecoms
    • Introductory Courses
    • Investment Banking
      • Accounting
      • Financial Modeling
      • M&A and Divestitures
      • Private Debt
      • Private Equity
      • Valuation
      • Venture Capital
    • Markets
      • Economics
      • Equity Markets and Derivatives
      • Fixed Income and Derivatives
      • Introduction to Markets
      • Options and Structured Products
      • Other Capital Markets
      • Securities Services
    • Microsoft Office
      • Excel
      • PowerPoint
      • Word & Outlook
    • Professional Skills
      • Career Development
      • Expert Interviews
      • Interview Skills
    • Risk Management
    • Transaction Banking
    • Felix Live
  • Pathways
    • Investment Banking
    • Asset Management
    • Equity Research
    • Sales and Trading
    • Commercial Banking
    • Engineering
    • Operations
    • Private Equity
    • Credit Analysis
    • Restructuring
    • Venture Capital
    • CFA Institute
  • Certified Courses
Felix
  • Data
    • Company Analytics
    • My Filing Annotations
    • Market & Industry Data
    • United States
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
    • Europe
    • Relative Valuation
    • Discount Rate
    • Building Forecasts
    • Capital Structure Analysis
  • Models
  • Account
    • Edit my profile
    • My List
    • Restart Homepage Tour
    • Restart Company Analytics Tour
    • Restart Filings Tour
  • Log in
  • Ask An Instructor
    • Email Our Experts
    • Felix User Guide
    • Contact Support

Statistics - Analytic Methods

Regressions, Monte Carlo simulations, and interpreting data analysis.

Unlock Your Certificate   
 
0% Complete

4 Lessons (17m)

Show lesson playlist
  • Description & Objectives

  • 1. Regressions

    06:28
  • 2. Monte Carlo Simulations

    05:33
  • 3. Interpreting Data Analysis

    04:42
  • 4. Statistics - Analytic Methods Tryout


Prev: Statistics - Portfolio Statistics

Monte Carlo Simulations

  • Notes
  • Questions
  • Transcript
  • 05:33

Understand how Monte Carlo Analysis can be used to analyze volatile portfolio returns

Downloads

No associated resources to download.

Glossary

Probability Analysis Random Portfolio Return Sequence of Returns Stochastic Modeling Success Probability
Back to top
Financial Edge Training

© Financial Edge Training 2025

Topics
Introduction to Finance Accounting Financial Modeling Valuation M&A and Divestitures Private Equity
Venture Capital Project Finance Credit Analysis Transaction Banking Restructuring Capital Markets
Asset Management Risk Management Economics Data Science and System
Request New Content
System Account User Guide Privacy Policy Terms & Conditions Log in
Transcript

Monte Carlo simulations. Now, Monte Carlo simulations are a very popular statistical method of analyzing return data, and in fact it randomizes return data, which makes it extremely useful. You might hear other names for it, stochastic modeling or probability analysis, but there are they are one in the same. Now, Monte Carlo simulations have rapidly gained adoption and popularity and is named actually after the city of Monte Carlo in Monaco which is famous for its gambling venues. Well, in the simulations we use a roulette wheel like generator of random returns, hence the origin of the name. So to do this we use a computer and that computer program selects the annual returns based upon all of our assumptions. And those assumptions will include a distribution of the returns, the volatility of the returns and the correlation between assets. And then this process gets repeated thousands and thousands of times, allowing us to see not just an estimated value but a range of estimated values and all possible outcomes. Monte Carlo does not use straight line estimates. In straight line estimate analysis, we're using just one expected return as the full range of possible returns and we're ignoring the potential gyrations and returns from year to year, as long as they equal the average. This may not seem like a big deal, but in the end it is very much a big deal because of the sequence of the returns matter dramatically. Let's look at an example. A retired couple has $1 million portfolio and wants to know if they have enough to withdraw $125,000 a year for the next 10 years. A very typical retirement question or issue. In the first example, we're going to look at a straight line analysis, and here you can see that every year we're assuming the average return of 6.6% and by year 10 not only are we able to successfully withdraw $125,000 per year, as the question stated we also still have about $200,000 left in the portfolio. A huge success. However, let's look at an alternate scenario. Here the average return is still the same 6.6% across all the years, but it's not the same in every year. As you can see in the first year, we have a large drawdown of 20%. It's made up in future years, especially in year five with a large increase of 33.2%. But in the end, by year 10, the couple runs out of money. They're not able to make that last $125,000 withdraw despite having the same level of average return across both scenarios. So the, the difference is pretty clear here, right? The straight line estimates use the same return every year and assume no volatility or variance within that return. On the other hand the Monte Carlo simulates a volatile sequence of returns to get a better sense of all possible outcomes. Now here's your typical Monte Carlo output. You can see quartile dollar values. So it gives you a sense of, you know how much the portfolio would be worth in good times and in in bad times. The 90th percentile is essentially the best case scenario, and this couple could have close to $400,000 left in their account after 10 years and after all the withdrawals. However, at the 10th percentile and 25th percentile you see that the value of the portfolio is zero. So a large difference in terms of potential ranges of results. You'll also see a graph dictating the success probability. So after 10,000 simulated portfolios and different sequences of returns, we're able to see that 50% of the time the couple does not reach their goal while 50% of the time it does. And this allows investors to see the trade off that occurs when creating specific goals around a goal like retirement and when they're creating their portfolios. If an investor decides to get more aggressive he may increase the portfolio value in the best case, for example, however the probability of success may not increase. Now, of course, Monte Carlo simulations aren't perfect. They have limitations. And the first being that assumes return streams are normal and that's not always the case. And if they're not, this could indicate a larger amount of tail risk that the simulation is not accounting for which means a larger probability of extreme returns both on the positive and negative side. Another issue is that it assumes what has happened historically will happen in the future. And obviously that's not always the case and if it's not the case. We need to adjust our inputs to incorporate today's environment around return distributions, volatility correlation, or any any other assumptions that we're making. And lastly, returns may be overly random. How could that be? Well, some studies have shown that market returns tend to be mean reverting to some extent anyway, which means that low returns tend to be followed by higher returns and vice versa. And given the random nature of the Monte Carlo process this might not be incorporated into the analysis.

Content Requests and Questions

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account
Help

You need an account to contact support.

Create a free account or log in to an existing one

Sorry, you don't have access to that yet!

You are trying to access premium learning content.

Discover our full catalogue and purchase a course Access all courses with our premium plans or log in to your account

You have reached the limit of annotations (10) under our premium subscription. Upgrade to unlock unlimited annotations.

Find out more about our premium plan

You are trying to access content that requires a free account. Sign up or login in seconds!

Create a free account or log in to an existing one

You are trying to access content that requires a premium plan.

Find out more about our premium plan or log in to your account

Only US listed companies are available under our Free and Boost plans. Upgrade to Pro to access over 7,000 global companies across the US, UK, Canada, France, Italy, Germany, Hong Kong and more.

Find out more about our premium plan or log in to your account

A pro account is required for the Excel Add In

Find out more about our premium plan

Congratulations on completing

This field is hidden when viewing the form
Name(Required)
This field is hidden when viewing the form
Rate this course out of 5, where 5 is excellent and 1 is terrible.
Were the stated learning objectives met?(Required)
Were the stated prerequisite requirements appropriate and sufficient?(Required)
Were the program materials, including the qualified assessment, relevant and did they contribute to the achievement of the learning objectives?(Required)
Was the time allotted to the learning activity appropriate?(Required)
Are you happy for us to use your feedback and details in future marketing?(Required)

Thank you for already submitting feedback for this course.

CPE

What is CPE?

CPE stands for Continuing Professional Education, by completing learning activities you earn CPE credits to retain your professional credentials. CPE is required for Certified Public Accountants (CPAs). Financial Edge Training is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.

What are CPE credits?

For self study programs, 1 CPE credit is awarded for every 50 minutes of elearning content, this includes videos, workouts, tryouts, and exams.

CPE Exams

You must complete the CPE exam within 1 year of accessing a related playlist or course to earn CPE credits. To see how long you have left to complete a CPE exam, hover over the locked CPE credits button.

What if I'm not collecting CPE credits?

CPE exams do not count towards your FE certification. You do not need to complete the CPE exam if you are not collecting CPE credits, but you might find it useful for your own revision.


Further Help
  • Felix How to Guide walks you through the key functions and tools of the learning platform.
  • Playlists & Tryouts: Playlists are a collection of videos that teach you a specific skill and are tested with a tryout at the end. A tryout is a quiz that tests your knowledge and understanding of what you have just learned.
  • Exam: If you are collecting CPE points you must pass the relevant CPE exam within 1 year to receive credits.
  • Glossary: A glossary can be found below each video and provides definitions and explanations for terms and concepts. They are organized alphabetically to make it easy for you to find the term you need.
  • Search function: Use the Felix search function on the homepage to find content related to what you want to learn. Find related video content, lessons, and questions people have asked on the topic.
  • Closed Captions & Transcript: Closed captions and transcripts are available on videos. The video transcript can be found next to the closed captions in the video player. The transcript feature allows you to read the transcript of the video and search for key terms within the transcript.
  • Questions: If you have questions about the course content, you will find a section called Ask a Question underneath each video where you can submit questions to our expert instructor team.