• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Finance Train

Finance Train

High Quality tutorials for finance, risk, data science

  • Home
  • Data Science
  • CFA® Exam
  • PRM Exam
  • Tutorials
  • Careers
  • Products
  • Login

Constructing an Efficient Frontier

Financial Mathematics, Investment Management, PRM Exam, PRM Exam I

This lesson is part 2 of 8 in the course Understanding Portfolio Math

The concept of Efficient Frontier was first introduced by Harry Markowitz in his paper on Portfolio Selection (1952 Journal of Finance).

The portfolio theory considers a universe of risky investments and explores these possible investments in order to find the optimum portfolio. So, for a given amount of risk, MTP explains how select a portfolio with maximum returns, and with a given amount of return, MTP explains how to select a portfolio with minimum risk.

Suppose you have all the required data (expected returns, volatility, and correlations) for all the investments you are considering. Using this data, you can create various portfolios with different portfolio risk and return profiles.

Among all these portfolios, choose the optimal portfolios in either of the following way:

  1. Identify all the portfolios that have the same risk (volatility). From this sub-set of portfolios, choose the one that has the highest return.
  2. Identify all the portfolios that have the same returns. From this sub-set of portfolios, choose the one that has the lowest risk.

Both the methods will product a set of optimal portfolios. This set of optimal portfolios is called the efficient frontier. (Later in this post, we will learn how to construct an efficient frontier in Excel)

If you plot all the portfolios that you could make using the universe of risky securities that you have, the graph will look something like the one below:

Each red dot represents the mean and standard deviation of a portfolio. The blue line is the efficient frontier. The efficient frontier has all the optimal portfolios we selected above. Portfolios on the efficient frontier have maximum return for a given level of risk or, alternatively, minimum risk for a given level of return. Clearly, a rational investor will select a portfolio on the efficient frontier.

Dominated Portfolio

In the above graph, you see that for the same level of risk there are multiple portfolios providing different levels of return. A portfolio is said to be dominated, if there is atleast one portfolio that has higher return and lower standard deviation. In other words, a portfolio is dominated if there is any other portfolio to its north-west. So, in the above graph, all portfolios other than those on the efficient frontier are dominated.

Typically, the portfolios that make the efficient frontier are the most diversified ones. Less diversified portfolios tend to be closer to the middle of the achievable region.

Constructing an Efficient Frontier in Excel

The attached PDF file shows you how you can construct an efficient frontier using excel.

Constructing Efficient Frontier in Excel
Previous Lesson

‹ Mean, Variance, Standard Deviation and Correlation

Next Lesson

Minimum Variance Hedge Ratio ›

Join Our Facebook Group - Finance, Risk and Data Science

Posts You May Like

How to Improve your Financial Health

CFA® Exam Overview and Guidelines (Updated for 2021)

Changing Themes (Look and Feel) in ggplot2 in R

Coordinates in ggplot2 in R

Facets for ggplot2 Charts in R (Faceting Layer)

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

In this Course

  • Mean, Variance, Standard Deviation and Correlation
  • Constructing an Efficient Frontier
  • Minimum Variance Hedge Ratio
  • What is Serial Correlation (Autocorrelation)?
  • Diversification and Portfolio Risk
  • Value at Risk (VaR) of a Portfolio
  • Probability of One Portfolio Outperforming Another Portfolio
  • Probability of Attaining a Return Goal

Latest Tutorials

    • Data Visualization with R
    • Derivatives with R
    • Machine Learning in Finance Using Python
    • Credit Risk Modelling in R
    • Quantitative Trading Strategies in R
    • Financial Time Series Analysis in R
    • VaR Mapping
    • Option Valuation
    • Financial Reporting Standards
    • Fraud
Facebook Group

Membership

Unlock full access to Finance Train and see the entire library of member-only content and resources.

Subscribe

Footer

Recent Posts

  • How to Improve your Financial Health
  • CFA® Exam Overview and Guidelines (Updated for 2021)
  • Changing Themes (Look and Feel) in ggplot2 in R
  • Coordinates in ggplot2 in R
  • Facets for ggplot2 Charts in R (Faceting Layer)

Products

  • Level I Authority for CFA® Exam
  • CFA Level I Practice Questions
  • CFA Level I Mock Exam
  • Level II Question Bank for CFA® Exam
  • PRM Exam 1 Practice Question Bank
  • All Products

Quick Links

  • Privacy Policy
  • Contact Us

CFA Institute does not endorse, promote or warrant the accuracy or quality of Finance Train. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.

Copyright © 2021 Finance Train. All rights reserved.

  • About Us
  • Privacy Policy
  • Contact Us