
Master portfolio management and construction in Excel, building the efficient frontier, covariance matrices, and minimum variance portfolios, while exploring single index and Fama-French three-factor models to optimize returns.
This lecture covers the basics of diversification benefits, including why diversification is beneficial and considerations when undertaking diversification.
Learn to construct a global minimum variance portfolio across multiple assets in Excel by using excess returns, covariance matrices, and matrix algebra for optimized weights.
Learn how to construct the efficient frontier for a two-asset portfolio in Excel, calculating returns, variance and standard deviation, and identifying the global minimum-variance frontier.
This lecture discusses how to construct the efficient frontier in excel when the portfolio has many assets.
Explore the Fama French three-factor model, including market, size (small minus big), and value (high minus low), alpha, beta, and residuals, with a Berkshire Hathaway example and regression interpretation.
Explore the four factor model, where returns are explained by the market, small-minus-big, high-minus-low, and momentum factors, estimated via Excel regression.
This course covers the basics of portfolio management. It covers common stock return models , portfolio construction methods and optimization models, and capital markets more generally. The aim of the course is to equip students with the knowledge necessary to form a basic portfolio and to understand the drivers of stock returns and of alpha. In many places, the course includes practical examples, including in Microsoft Excel.
Key concepts covered include:
Stock return models and alpha (i.e., single index model, fama french three factor model, CAPM).
Portfolio construction methods (i.e., minimum variance, mean variance, markowitz)
Additional things to look for when trading.