<

Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

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

Posted on
6,344 Points
344 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
Comment
Author:Toby Reaper
0 Comments

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Join & Write a Comment

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Gain an elementary understanding of Blockchain technology.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month