001 2.1-Holding-Period-Return-HPR.xlsx
001 Holding Period Return (HPR)
002 AAPL-Daily-Returns-01.07.2018-01.07.2020-Formatted.xlsx
002 AAPL-Daily-Returns-01.07.2018-01.07.2020-Unformatted.csv
002 How to Download Historical Price Data in Excel Using Yahoo Finance
003 Blank-Workbook.xlsx
003 Formatted-Spreadsheet.xlsx
003 How to Format an Excel Spreadsheet
004 Log Return (Bonus)
004 Portfolio-Return-using-HPR-and-Log-Return.xlsx
005 Arithmetic vs Geometric Mean Return
006 AAPL-Average-Rates-of-Return.xlsx
006 AAPL-Average-Rates-of-Return-Solution.xlsx
006 How to Ccalculate Rates of Return in Excel
007 Money-weighted Rate of Return
007 Money-weighted-rate-of-return.xlsx
007 Money-weighted-rate-of-return-Solution.xlsx
007 Money-weighted-rate-of-return-Template.xlsx
008 Time-weighted Rate of Return
008 Time-weighted-rate-of-return-Template.xlsx
009 2.8-Money-weighted-vs-time-weighted.xlsx
009 2.8-Money-weighted-vs-time-weighted-Solution.xlsx
009 Money-weighted vs Time-weighted Rate of Return
010 Annualized Return
011 The Effect of Fees, Taxes, Inflation and Leverage
012 Major Asset Classes
013 Historical vs Expected Returns
014 Mean, Variance and Covariance of Asset Returns
015 Variance and Standard Deviation of Returns (Excel)
015 Variance-and-Standard-Deviation-of-Returns.xlsx
015 Variance-and-Standard-Deviation-of-Returns-Solution.xlsx
016 Covariance and Correlation Between Two Assets (Excel)
016 Covariance-and-Correlation.xlsx
016 Covariance-and-Correlation-Solution.xlsx
017 Risk Aversion
018 Risk Aversion (Implications)
019 Portfolio Risk and Return
020 Portfolio Risk and Return (Excel)
020 Portfolio-Risk-and-Return.xlsx
020 Portfolio-Risk-and-Return-Solution.xlsx
021 The Correlation Coefficient
022 Investment Opportunity Set
023 Minimum-Variance Frontier
024 Efficient-Frontier.xlsx
024 Efficient-Frontier-Solution.xlsx
024 Minimum-Variance Frontier (Excel)
025 Capital Allocation Line
026 Optimal Risky Portfolio (Excel)
026 Optimal-Risky-Portfolio.xlsx
026 Optimal-Risky-Portfolio-Solution.xlsx
026 Optimal-Risky-Portfolio-Template.xlsx
027 Capital Allocation Line (Excel)
027 Capital-Allocation-Line.xlsx
027 Capital-Allocation-Line-Solution.xlsx
028 Optimal Investor Portfolio
028 Optimal-Risky-Portfolio-Template.xlsx
