Question
I have calculated the daily returns in excel as attached however, I am unsure how to calculate the following homework task below, can someone assist
I have calculated the daily returns in excel as attached however, I am unsure how to calculate the following homework task below, can someone assist please and thank you
Based on the 500 returns for each stock calculated in b., calculate 500 alternative scenarios for the $ value of the $350,000 investment in company A stock and the $650,000 investment in company B stock, respectively. Sum these two for each scenario to obtain 500 simulations for the $ value of your portfolio consisting of stock A and stock B.
The companies in question are APA Group and Transurban and I have also provided a small screenshot of some of the daily returns calculated with Excel.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started