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:
[ Ссылка ]
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:
[ Ссылка ]
You can also follow us on X (Twitter):
[ Ссылка ]
And, visit our website for free courses, tutorials, and more:
[ Ссылка ]
#investing #tutorial #portfoliomanagement
![](https://s2.save4k.ru/pic/8vKQdPZ92C0/maxresdefault.jpg)