Efficient Frontier Exercise: Analyzing Portfolio Risk and Return
Introduction:
The Efficient Frontier (EF) is a concept developed by Nobel Prize-winning economist Harry Markowitz, which aims to find the optimal portfolio for an investor by balancing risk and return.
Watch the following video Efficient Frontier prior to completing the EF exercise: https://youtu.be/Rz5tGZdyViw?si=NtaL_LoFt_OMDibj
Markowitz EF Assignment The following video illustrates instructions for getting started with this assignment. PLEASE NOTE: I modified the Excel spreadsheet so you no longer need to sort and before copying and pasting the data. Please enter dates in same order as supplied on Excel template below which matches the order originally provided in Yahoo Finance. (Video provided in file section).
Complete the EF Exercise in Excel by using the following instructions and Excel model: (Provided in file section)