{"title":"The Minimum Variance Portfolio, the Tangency Portfolio, and the Associated Matrix Algebra","authors":"Tom Arnold, Terry D. Nixon","doi":"10.2139/ssrn.3607332","DOIUrl":null,"url":null,"abstract":"The matrix algebra associated with finding minimum variance portfolio weights and tangency portfolio weights is greatly simplified by using an Excel presentation. A further simplification of the tangency portfolio weights process is also presented using excess returns for the risky securities. The lesson drawn from this presentation is readily performed online by sharing or recording an Excel screen with students.","PeriodicalId":143061,"journal":{"name":"Practitioner Articles & Resources eJournal","volume":"8 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2020-05-21","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Practitioner Articles & Resources eJournal","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.2139/ssrn.3607332","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
Abstract
The matrix algebra associated with finding minimum variance portfolio weights and tangency portfolio weights is greatly simplified by using an Excel presentation. A further simplification of the tangency portfolio weights process is also presented using excess returns for the risky securities. The lesson drawn from this presentation is readily performed online by sharing or recording an Excel screen with students.