Go Premium for a chance to win a PS4. Enter to Win


Building Probability Models in Excel Part 5: Modeling an Investment Using Discrete Random Variables

Posted on
6,387 Points
Last Modified:
Experience Level: Beginner
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

Author:Toby Reaper

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Join & Write a Comment

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month