Chapter 75. Simulating stock prices and asset allocation modeling

Questions answered in this chapter:

  • I recently bought 100 shares of GE stock. What is the probability that during the next year this investment will return more than 10 percent?

  • I’m trying to determine how to allocate my investment portfolio among stocks, T-bills, and bonds. What asset allocation over a five-year planning horizon will yield an expected return of at least 10 percent and minimize risk?

The past few years have shown that future returns on investments are highly uncertain. Chapter 72 showed how to use the lognormal random variable to model stock prices. Many financial experts have been critical of using the lognormal random variable to model stock prices because the lognormal ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.