based on the attached files, you find my first report , second report, no i want

Photo of author

By admin

based on the attached files, you find my first report , second report, no i want to do the third report based on the prices list of my stocks and bonds , and i already have the template for needed requirements. 1- Prepare the required inputs for the Markowitz model (Full covariance model). 2- Determine the covariance between each pair of assets to understand their co-movements and diversify accordingly. 3- Apply the Markowitz optimization procedure to calculate the weights that will minimize the portfolio’s variance for a target level of return. This involves using tools such as Excel’s Solver. 4- Summarize the optimized asset weights within the risky portfolio. Considering 4 as your level of risk aversion, identify the best mix of risky portfolio and risk-free asset to be able to reach the optimal complete portfolio. 5- Identify expected portfolio return and risk derived from the Markowitz Model Kindly clarify each step in the excel with their formulas.