Minimum variance portfolio in Excel / Analyzing stock returns / Episode 15

In this tutorial, we explain how to find the minimum variance portfolio using Excel's solver tool and locate it on the efficient frontier plot. We do this both with short selling and without it.

If you'd like to learn more about the minimum variance portfolio and/or download the spreadsheet used in this tutorial, please visit:
https://www.initialreturn.com/minimum-variance-portfolio/

00:00 Intro
00:41 Using “Solver” to locate the minimum variance portfolio
02:46 Showing the minimum variance portfolio on the efficient frontier plot
05:54 Minimum variance portfolio without short-selling
08:05 Comparison: with and without short-selling

Enjoying our content?

Click the link below to subscribe to our channel:
https://www.youtube.com/channel/UCshd-qjVDVwSfYi6P7cgAXA/?sub_confirmation=1

You can also follow us on X (Twitter):
https://x.com/initial_return

And, visit our website for free courses, tutorials, and more:
https://www.initialreturn.com/

#investing #tutorial #portfoliomanagement

Видео Minimum variance portfolio in Excel / Analyzing stock returns / Episode 15 канала Initial Return