Investment Portfolio Analysis with Excel
Size: 1.58GB | Duration: 7h 21m | Video: AVC (.mp4) 1280x720 30fps | Audio: AAC 44.1KHz 2ch
Genre: eLearning | Level: Appropriate for all | Language: English
Learn investment portfolio analysis main concepts from basic to expert level through a practical course with Excel.
Learn investment portfolio analysis through a practical course with Excel using historical data for back-testing. It explores main concepts from basic to expert level which will help you achieve better grades, review concepts and polish skills for your new finance career or take decisions as DIY investor. All of this while exploring best academic and industry research together with Nobel Prize winners’ wisdom.
Become an Investment Portfolio Analysis Expert in this Practical Course with Excel
* Compare main asset classes’ returns-risks tradeoffs.
* Evaluate returns-risks relationship among main asset classes and the market.
* Diversify specific risks through portfolios’ asset allocation strategies.
* Hedge portfolios’ market risks by using stock options.
* Calculate maximum historical portfolio leverage and asses returns-risks amplification.
* Estimate portfolios expected returns based on market, technical, fundamental and macroeconomic factors.
* Test market efficiency and deduct investment costs to outperforming portfolios.
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 historical data for back-testing and achieving greater effectiveness.
Content and Overview
This practical course contains over 40 lectures and more than 7.5 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 compare main asset classes’ returns-risks tradeoffs with cash, bonds, stocks, commodities, real estate and currencies. Then, you’ll evaluate returns-risks relationship among those main asset classes and each of them with the market.
After that, you’ll diversify specific risks by building portfolios based on naïve, Kelly criterion and Markowitz optimization asset allocation strategies. Next, you’ll value these portfolios’ performance with Jensen’s alpha, Sharpe and Treynor ratios metrics.
Next, you’ll hedge portfolios’ market risks by constructing those using stock options for which prices are calculated through Black and Scholes formula. After that, you’ll calculate maximum historical portfolio leverage and assess how returns and risks are amplified.
Later, you’ll estimate portfolios expected returns based on market, technical, fundamental and macroeconomic factors using capital asset pricing model (CAPM), Fama-French-Carhart factors models and arbitrage pricing theory (APT).
Finally, you’ll test market efficiency in its weak, semi-strong and strong forms together with deducting investment costs when portfolios outperform overall market benchmark.