Originally published: 28/03/2019 08:15
Last version published: 14/12/2019 08:56
Publication number: ELQ-33616-2
View all versions & Certificate
Last version published: 14/12/2019 08:56
Publication number: ELQ-33616-2
View all versions & Certificate
Monte Carlo Analysis (without macros) Excel Model
This post explains how to run full Monte Carlo analysis in Excel without macros
Further information
Perform sensitivity analysis in situations of uncertainty or limited input data
Financial modelling in situations involving uncertainty
None
Reviews
4.6 / 5 (26 votes)- 69%
- 23%
- 8%
- -
- -
Write a review
- Excellent modelExcellent model
People using this Best Practice also downloaded
Unlocking Full Potential of Excel Data Tables (Part 1)
The model explains how to show models outputs under different scenarios simultaneously.4,695Discussadd_shopping_cartfreeby Andrei Okhlopkov
Unlocking Full Potential of Excel Data Tables (Part 2)
This is an enhanced version of my 'Unlocking Full Potential of Excel Data Tables (Part 1)' post597Discussadd_shopping_cart$15.00OneClick US S&P Stock Prediction Using Monte Carlo and Brownian Motion in Python
Monte Carlo and Brownian Motion Models Python script to predict future stock movements.2123add_shopping_cartDCF (Discounted Cash Flow) Excel Monte Carlo Simulation Model
A simplified DCF (Discounted Cash Flow) Monte Carlo Simulation model in Excel3,3251add_shopping_cartfreeby Hans Ensing
Sensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model1,1631add_shopping_cartfreeOneClick Saudi Stock Prediction Using Monte Carlo and Brownian Motion in Python
Monte Carlo and Brownian Motion Models Python script to predict future stock movements.57Discussadd_shopping_cartOneClick Brazil Stock Prediction Using Monte Carlo and Brownian Motion in Python
Monte Carlo and Brownian Motion Models Python script to predict future stock movements.20Discussadd_shopping_cartOneClick Shanghai Stock Prediction Using Monte Carlo and Brownian Motion in Python
Monte Carlo and Brownian Motion Models Python script to predict future stock movements.27Discussadd_shopping_cartOneClick Malaysian Stock Prediction Using Monte Carlo and Brownian Motion in Python
Monte Carlo and Brownian Motion Models Python script to predict future stock movements.25Discussadd_shopping_cartOneClick Toronto Stock Prediction Using Monte Carlo and Brownian Motion in Python
Monte Carlo and Brownian Motion Models Python script to predict future stock movements.24Discussadd_shopping_cart
More Best Practices from Andrei Okhlopkov
Unlocking Full Potential of Excel Data Tables (Part 2)
This is an enhanced version of my 'Unlocking Full Potential of Excel Data Tables (Part 1)' post597Discussadd_shopping_cart$15.00VBA Interface Collection (full version)
A set of Excel VBA macros aimed at enhancing user interface43Discussadd_shopping_cart$20.00Portfolio Analysis and Sales Forecasting
A set of templates to describe the current sales performance and to make predictions and sensitivities for the future500Discussadd_shopping_cart$12.00Sensitivity analysis Excel Model with indifference curves (unlocked)
An Excel utility (unlocked) to draw indifference curves for two inputs in a financial model141Discussadd_shopping_cart$10.00Charts and Dashboards in Excel (full version)
Explains the basics of designing professional charts in Excel with practical examples (full version)223Discussadd_shopping_cart$20.00Form Controls and Other Interactive Tools in Excel
An overview of form controls, ActiveX controls and hyperlinks used in financial models.1,1542add_shopping_cartfreeDates and Timelines in Excel Financial Models
Financial models use dates and timelines very extensively, so it is important to become familiar with relevant functions1,439Discussadd_shopping_cartfreeUnlocking Full Potential of Excel Data Tables (Part 1)
The model explains how to show models outputs under different scenarios simultaneously.4,695Discussadd_shopping_cartfreeGuiding principles of Financial Modelling
The file explains the general principles of building financial models with a few practical examples.944Discussadd_shopping_cartfreeDescriptive statistics for grouped (weighted) data
Calculating key statistics measures (average, median, standard deviation, skewness etc.) for grouped or weighted data426Discussadd_shopping_cartfreeSensitivity analysis Excel Model with indifference curves
An Excel utility to draw indifference curves for two inputs in a financial model1,1631add_shopping_cartfreeAnalysing data in Excel
A set of techniques for working with data in Excel1,648Discussadd_shopping_cartfree
Discussion feed for Monte Carlo Analysis (without Macros) Excel Model
The user community and author are here to help. Go ahead!
- Andrei, how do you deal with correlations among inputs without VBA? I understand that one need e.g. Cholesky decomposition to transform uncorrelated to correlated inputs? Alexei
- Hi Alexei -
If you look at "Indexation and interest" of the file, to make two correlated arrays I take numbers from an array and "mix" it with random numbers from an independent array. This "mixing" take place in column H (titled "Correlated") and the formula is:
Random_number x Corr_coeff + New_random_number x SqRoot(1 - Corr_coeff^2)
This formula essentially "decomposes" the definition of linear correlation. No need for VBA or complex matrices...
Andrei
