Investment Portfolio Analysis with Excel

Course details

Course video lectures, content slides and Excel file constantly updated (latest: November 2016, audio re-editing)

Learn investment portfolio analysis through a practical course with Excel using index replicating funds historical data for back-testing. It explores main concepts from basic to expert level which can help you achieve better grades, develop your academic career, apply your knowledge at work or take decisions as DIY investor. All of this while exploring the wisdom of Nobel Prize winners and best practitioners in the field.

Become an Investment Portfolio Analysis Expert in this Practical Course with Excel

• Download index replicating funds data to perform investment portfolio analysis operations directly into worksheet using Excel Add-In.
• Compare main asset classes' returns and risks tradeoffs.
• Estimate portfolio expected returns, historical and market participants' implied volatility.  
• Approximate portfolio excess returns based on market, technical, fundamental and macroeconomic factors.
• Evaluate returns and risks relationship between portfolio and overall market.
• Hedge portfolio market risk with stock option strategies and measure Hedge Fund index performance.
• Calculate maximum historical portfolio leverage and assess returns and risks amplification.
• Build global portfolios following asset allocation strategies from well-known investment managers and compare them using risk adjusted metrics.
• Diversify specific risks through global portfolios' asset allocation strategies through mean and variance optimization.
• Test market efficiency and measure investment costs impact to portfolio returns.

Become an Investment Portfolio Analysis Expert and Put Your Knowledge in Practice

Learning investment portfolio analysis is indispensable for finance careers in areas such as asset management, private wealth management, and risk management within institutional investors represented by banks, insurance companies, pension funds, hedge funds, investment advisors, endowments and mutual funds. It is also essential for academic careers in finance or business research. And it is necessary for DIY investors' portfolio management.

But as learning curve can become steep as complexity grows, this course helps by leading you step by step using index replicating funds historical data for back-testing and to achieve greater effectiveness. 

Content and Overview

This practical course contains 39 lectures and 9 hours of content. It's designed for all investment portfolio analysis knowledge levels and a basic understanding of Excel is recommended.

At first, you'll learn how to download index replicating funds data to perform investment portfolio analysis operations directly into worksheet using Excel Add-In. Then, you'll compare main asset classes' returns and risks tradeoffs for cash, bonds, stocks, commodities, real estate and currencies. 

After that, you'll estimate portfolio expected returns, historical and market participants' implied volatility.  Then, you'll approximate portfolio excess returns using capital asset pricing model (CAPM), Fama-French-Carhart factors model and arbitrage pricing theory model (APT).

Next, you'll hedge portfolios' market risks with index replicating funds using financial options and measure Hedge Funds index performance. After that, you'll calculate maximum historical portfolio leverage and assess returns and risks amplification.

Later, you'll build global portfolios following asset allocation strategies from well-known investment managers and compare them using risk adjusted metrics such as Jensen's Alpha, Sharpe, Treynor, Sortino and Kelly ratios. Next, you'll diversify specific risks through portfolios' asset allocation strategies through mean and variance Markowitz optimization.

Finally, you'll test market efficiency in its weak and semi-strong forms and asses investment costs impact on portfolio performance.