How to predict future security prices

I am tasked with predicting the likelihood that a security (variable annuity) will reach a certain value within a certain amount of time. I would like to be able to say that I am 90 percent certain that the value will at least be x in 2 years, 3 years etc. I am a new consultant for a securities consulting firm and am trained as a lawyer, so I haven't take any math classes since getting my undergrad in econ. Please answer as if you're talking to a young child or a golden retriever.

 
resipsa:
I would like to be able to say that I am 90 percent certain that the value will at least be x in 2 years, 3 years etc. .
yerrr, that's just silly talk.
"After you work on Wall Street it’s a choice, would you rather work at McDonalds or on the sell-side? I would choose McDonalds over the sell-side.” - David Tepper
 
resipsa:
I would like to be able to say that I am 90 percent certain that the value will at least be x in 2 years, 3 years etc... Please answer as if you're talking to a young child or a golden retriever.
hah if this is the assignment your boss gave you verbatim then the only thing you can be 90% certain of is that the value of his career will definitely be reduced. If this is a self-imposed goal then you will learn that 90% confidence intervals don't exist in financial markets
 
gammaovertheta:
resipsa:
I would like to be able to say that I am 90 percent certain that the value will at least be x in 2 years, 3 years etc... Please answer as if you're talking to a young child or a golden retriever.

hah if this is the assignment your boss gave you verbatim then the only thing you can be 90% certain of is that the value of his career will definitely be reduced. If this is a self-imposed goal then you will learn that 90% confidence intervals don't exist in financial markets

Ha, well that's not very helpful. This isn't the type of analysis we typically do. I want to run a time series prediction of the expected value of the security. What ever confidence interval. Any help or am I just going to get witty comments?

 
Best Response

You need to run a Monte Carlo simulation. I assume this is a diversified equity portfolio with high embedded fees. You need to estimate the average market return, subtract fees, and run a number of iterations using a specified volatility. Even then, you will not be taking into account non-normal distributions, which will weaken your results. There are some other ways you can account for non-normal returns, but you will need to do some reading on that. I can't explain it in a post. This project is probably more difficult than you think if you have no background in it. If the annuity has other payoff structures besides just being long equities, you need to take that into account as well. The answer will be less than the value you start with for a 90% chance or greater. If there are no cash flows or resets (or other path dependencies), you should be able to do a closed-form solution using periodic assumed volatility (I.e. -- not annualized, but for multi-year periods) and solving for the z-score/return that meets the 10%ile.

By closed form solution, I mean something as simple as this: assume the average expected return is 8% and the expected vol is 20% annualized. To get the 2 year vol, multiply the vol by the square root of 2. Roughly speaking, 20% x 1.4 = 28%. For two years, 2/3 of your results will be between 16% +/- 28%; 95% will be between 16% +/- (2 x 28%). For three years, multiply by the square root of three and repeat. To get the result where exactly 90% or more of your results will be you need to look it up on statistical tables.

Keep in mind, these are far from perfect models, but this is probably what your boss is looking for.

 
SirTradesaLot:
You need to run a Monte Carlo simulation. I assume this is a diversified equity portfolio with high embedded fees. You need to estimate the average market return, subtract fees, and run a number of iterations using a specified volatility. Even then, you will not be taking into account non-normal distributions, which will weaken your results. There are some other ways you can account for non-normal returns, but you will need to do some reading on that. I can't explain it in a post. This project is probably more difficult than you think if you have no background in it. If the annuity has other payoff structures besides just being long equities, you need to take that into account as well. The answer will be less than the value you start with for a 90% chance or greater. If there are no cash flows or resets (or other path dependencies), you should be able to do a closed-form solution using periodic assumed volatility (I.e. -- not annualized, but for multi-year periods) and solving for the z-score/return that meets the 10%ile.

By closed form solution, I mean something as simple as this: assume the average expected return is 8% and the expected vol is 20% annualized. To get the 2 year vol, multiply the vol by the square root of 2. Roughly speaking, 20% x 1.4 = 28%. For two years, 2/3 of your results will be between 16% +/- 28%; 95% will be between 16% +/- (2 x 28%). For three years, multiply by the square root of three and repeat. To get the result where exactly 90% or more of your results will be you need to look it up on statistical tables.

Keep in mind, these are far from perfect models, but this is probably what your boss is looking for.

This man knows his stuff.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”