<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

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

Posted on
6,442 Points
442 Views
Last Modified:
Experience Level: Beginner
6:52
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
Author:Toby Reaper
0 Comments

Featured Post

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Are you among those users who need to move email from Outlook to Office 365 or Exchange Online? Are you facing an issue in importing Outlook PST files or does not have an idea how to migrate PST file to Office 365? Then you will get an exact solutio…
While it's a fact that PST file corruption is the root cause of a majority of Outlook errors, in this post we’ve listed all the signs that can help you make sure if the real reason behind your troubled Outlook is a corrupted PST.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month