Overview and Introduction1. Portfolio management drivers and contextPortfolio Management – Introducing risk and returnBuilding the Excel Portfolio management worksheetImpact of taxes and fees on retirement savings and spendingMarket Risk – Portfolio volatilityMarket risk metrics – volatility trend analysis. 2. Multi-asset class portfolio optimizationFixed Income Portfolio Optimization using SolverDuration and Convexity calculations for Fixed Income Bonds.Liquidity stress testing a fixed income portfolio. 3. Portfolio management models – a review of models and weaknessesThe Capital Asset Pricing Model – CAPM (for background and context)Calculating Beta and Alpha for portfolio management in EXCELThe difference between Alpha and BetaAlpha dominant strategy and evaluationPortfolio Alpha stability and cyclicalityOptimal Portfolio Alpha allocationMarket risk metrics – calculating BetaMarket risk metrics – Sharpe ratioMarket risk metrics – calculating Alpha using regressionKelly Criterion – founders, start-ups and bet sizes 4. Portfolio management styles – comparing value and momentumWhere do valuation multiples come from?Index Matching Portfolio Optimization problem setDebunking Finance Data Science mythsThe difference between value and growth investingThe Big Short case study. For value investors, portfolio managers and fixed income tradersValue investing lessons from the Big Short (film) – Part IIUnderstanding CMO CDO and CDS. Big Short Case Study – Part IIIUnderstanding Synthetic CDO – The Goldman Mike Burry Big Short Trade 5. Risk metrics and investment policyEvaluating Portfolio performance using Holding period return – a case studyHolding period returns, aggregate returns and annual returnsHigher Order Portfolio Optimization ModelsEvaluating portfolio performance. A single metric to rule them all?Calculating Portfolio Holding Period ReturnSetting Risk Limits that work