Building Probability Models in Excel Part 5: Modeling an Investment Using Discrete Random Variables
Posted on
6,517 Points
6:51
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over 500 iterations.
Video Steps
1. Modeling a Simple Investment: Type in the amount invested, the possible returns, and the corresponding probabilities
2. Label column A and B “Return” and “Wealth,” respectively in A11 and B10
3. Enter =DISCRINV(RAND(),$B$2:$B$7,$A$2:$A$7) into cell A12 and copy down to cell A21
4. Enter =D2 into cell B11
5. Enter =B11*A12 into cell B12 and copy down to cell B21
6. Create a Monte Carlo Simulation: Enter =B21 into cell B23
7. Enter =B21 into cell B23
8. Click Tools > SimTools > Simulation Table
0 Comments
Suggested Videos
The version of Microsoft 365 you have installed may not be ideal. This article explains how to change from a 32-bit install to a 64-bit install or vice versa. Snapshots are included for every step so very easy to follow. Works regardless if you use…
- Microsoft
- Windows 10
- Microsoft Office
- Installation
- Outlook
- Microsoft 365, Windows OS
On the official Microsoft website we can find out curious data about Excel. In this post, I will tell you about the ones that have caught my attention the most.
