Question
I am doing a Investment and Portfolio module and I need to find out how to determine the fund's optimal strategic asset allocation (SAA) for
I am doing a Investment and Portfolio module and I need to find out how to determine the fund's optimal strategic asset allocation (SAA) for each asset class, including the allocation to cash via excel. Through the tutorials so far, we have only been taught how to do it when we have the historical data provided. However, for this the only data provided is as shown in the screenshot below. Moreover, we find it through the correlation matrix and covariance matrix, in which I am unsure of how to obtain the covariance matrix with the limited information provided.
I would appreciate if someone could teach and explain to me how to obtain the covariance matrix and fund's optimal strategic asset allocation for each asset class. You can assume equal weights for the assets.
Thanks
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