Efficient Portfolios (Part 2): Excel in Finance
Interactive

Efficient Portfolios (Part 2): Excel in Finance

Intuition Publishing
Updated Sep 25, 2020

We can use Excel to illustrate how to calculate return and risk for a portfolio of risky assets. We explore how to form efficient portfolios that consist of risky assets and risk-free securities. As part of our discussion, we see how a calculation called the Sharpe ratio can help us form efficient portfolios with these assets.