How To Graph The Efficient Frontier For A Two-Stock Portfolio In Excel

We graph the Efficient Frontier in Excel which is the set of optimal portfolios that offer the highest expected return for a given level of risk. To do this, we use a scatter chart, swapping the data on the x and y axis to ensure that return is on the x axis and risk is on the y axis. After plotting the graph, we notice that all the points below the minimum risk portfolio on the chart are sub-optimal, while the points including and above this point are known as the efficient frontier. In other words, picking any of the points including and above the minimum risk portfolio would make sense depending on your risk/return trade-off.

Access the templates featured in The Excel Hub's video tutorials here:
https://theexcelhub.myshopify.com/

Calculate The Minimum Risk Two Stock Portfolio Using SOLVER In Excel:
https://youtu.be/XEzPi9WxptQ

Calculate Risk And Return Of A Two-Asset Portfolio In Excel:
https://youtu.be/GwLF8RHCZeQ

Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation=1

Please share this video with others that may find it useful:
https://youtu.be/mIWf0Z-jMe0

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: https://www.instagram.com/theexcelhub/

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:
theexcelhub@outlook.com

Overview: (0:00)
Plotting The Individual Portfolios: (0:27)
Interpreting The Efficient Frontier: (2:23)

Видео How To Graph The Efficient Frontier For A Two-Stock Portfolio In Excel канала The Excel Hub