Stock price simulation: A stocks price is lognormally distributed with mean = 15% and =
Question:
Stock price simulation: A stock’s price is lognormally distributed with mean μ = 15% and σ = 50%. The current stock price is S0 = 35. Following the template on the spreadsheet, create 60 dynamic standard normal deviates using Norm.S.Inv(Rand( )). Use these random numbers to simulate the stock price path over 60 months and graph.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
So 35 S1 stock price at t 1 month So expmt st05normsinvrand where m mean return 15 s standard deviation 153060 normsinvrand is the function of excel t...View the full answer
Answered By
Marvine Ekina
Marvine Ekina
Dedicated and experienced Academic Tutor with a proven track record for helping students to improve their academic performance. Adept at evaluating students and creating learning plans based on their strengths and weaknesses. Bringing forth a devotion to education and helping others to achieve their academic and life goals.
PERSONAL INFORMATION
Address: , ,
Nationality:
Driving License:
Hobbies: reading
SKILLS
????? Problem Solving Skills
????? Predictive Modeling
????? Customer Service Skills
????? Creative Problem Solving Skills
????? Strong Analytical Skills
????? Project Management Skills
????? Multitasking Skills
????? Leadership Skills
????? Curriculum Development
????? Excellent Communication Skills
????? SAT Prep
????? Knowledge of Educational Philosophies
????? Informal and Formal Assessments
0 Reviews
10+ Question Solved
Related Book For 
Question Posted:
