In this course, we will discuss fundamental principles of trading off risk and return, portfolio optimization, and security pricing. We will study and use risk-return models such as the Capital Asset Pricing Model (CAPM) and multi-factor models to evaluate the performance of various securities and portfolios. Specifically, we will learn how to interpret and estimate regressions that provide us with both a benchmark to use for a security given its risk (determined by its beta), as well as a risk-adjusted measure of the security’s performance (measured by its alpha). Building upon this framework, market efficiency and its implications for patterns in stock returns and the asset-management industry will be discussed. Finally, the course will conclude by connecting investment finance with corporate finance by examining firm valuation techniques such as the use of market multiples and discounted cash flow analysis. The course emphasizes real-world examples and applications in Excel throughout. This course is the first of two on Investments that I am offering online (“Investments II: Lessons and Applications for Investors” is the second course). The over-arching goals of this course are to build an understanding of the fundamentals of investment finance and provide an ability to implement key asset-pricing models and firm-valuation techniques in real-world situations. Specifically, upon successful completion of this course, you will be able to: • Explain the tradeoffs between risk and return • Form a portfolio of securities and calculate the expected return and standard deviation of that portfolio • Understand the real-world implications of the Separation Theorem of investments • Use the Capital Asset Pricing Model (CAPM) and 3-Factor Model to evaluate the performance of an asset (like stocks) through regression analysis • Estimate and interpret the ALPHA (α) and BETA (β) of a security, two statistics commonly reported on financial websites • Describe what is meant by market efficiency and what it implies for patterns in stock returns and for the asset-management industry • Understand market multiples and income approaches to valuing a firm and its stock, as well as the sensitivity of each approach to assumptions made • Conduct specific examples of a market multiples valuation and a discounted cash flow valuation This course was previously entitled “Financial Evaluation and Strategy: Investments” and was part of a previous specialization entitled "Improving Business and Finances Operations", which is now closed to new learner enrollment. “Financial Evaluation and Strategy: Investments” received an average rating of 4.8 out of 5 based on 199 reviews over the period August 2015 through August 2016. You can view a detailed summary of the ratings and reviews for this course in the Course Overview section. This course is part of the iMBA offered by the University of Illinois, a flexible, fully-accredited online MBA at an incredibly competitive price. For more information, please see the Resource page in this course and onlinemba.illinois.edu.
ASSIGNMENT 2 (Lesson 1-8): Calculating More Efficient Portfolios
Loading...
Из курса от партнера University of Illinois at Urbana-Champaign
Investments I: Fundamentals of Performance Evaluation
281 оценка
University of Illinois at Urbana-Champaign
281 оценка
Курс 3 из 7 — Specialization Financial Management
Из урока
Module 1: Investments Toolkit and Portfolio Formation
In Module 1, we will build the fundamentals of portfolio formation. After providing a brief refresher of basic investment concepts (our toolkit), a summary of historical patterns of stock returns and government securities in the U.S. is provided. We then consider general examples of portfolio choice to highlight the tradeoffs between “risk” and return. We end the module with a discussion of dominated assets and efficient portfolio formation, emphasizing real-world examples and practice in Excel solving for the optimal portfolio given certain constraints (such as the amount of volatility we will accept in our portfolio).
Познакомьтесь с преподавателями
Scott WeisbennerWilliam G. Karnes Professor of Finance
Department of Finance, College of Business
All right. Lesson 1.8 aka assignment two.
So, remember I said module one is building up the fundamentals so this will be
the only module where we have two assignments involved.
In this lesson two parts and as we talked about with assignment one,
the first part is just actually giving you
the questions for assignment two which you're going
to give the old college try to first then after giving it your best attempt,
see my discussion, see the answer key for assignment two.
What's the key point of this assignment?
Getting a measure of how important is it to add other assets to your portfolio
and in particular looking at from a US investor perspective.
Is there much benefit to adding gold if you're already holding US large-cap stocks,
if you're invested in the US stock market,
is there much benefit to
international diversification are the two key points of this assignment
and I think give valuable lesson for real-world investment practices.
We talked about this before.
I think it's worth highlighting again for this assumption.
Bill Sharpe here design capital asset,
one of the people who wrote about the capital asset pricing model in the '60s.
It provides a nice reality check before we
get into doing this work and coming up with these portfolios.
It's always perilous paraphrasing him to assume that
future will be like the past but it's at
least instructive to find out what the past is like.
So that's the purpose of us doing these analysis.
We're taking assumptions, we're basing
our assumptions on return distributions that we've measured in
the past and seeing what that predicts for our portfolio
assuming these return distributions will continue into the future.
If you don't like the assumptions for the return distribution,
the great thing about the spreadsheet is you can go in and make different changes and see
how the portfolio or optimal portfolios change and then talk further
about these assumptions that when we're historical data are pretty useful,
are quite useful and we're looking at standard deviations reasonably useful for
looking at correlations and virtually useless for expected returns.
Now one thing just,
maybe a little caveat to that,
if you're looking at average returns over
a very small time period where there's a big bull market or big bear market,
of course the average return there is going to be far
different and from what we've observed historically.
I'm going to be looking at averages and
return distributions obtained over wide samples of data.
So it still might be the case that
the past doesn't really predict what these average returns are
like to the future but at least it's not going to be based on like one or two years,
it's going to be based on 20,
40 years worth of data.
So, this assignment is going to have two parts,
two portfolio allocations, six questions total.
So when we're looking asset allocation we first start out with small and large,
small large value and growth was another example we consider.
Now let's expand it up to five assets.
So we're maximizing the optimization routine or spreadsheet that I put in.
Remember I created rows and columns for five different outlets so
we're using all of them and now we're adding gold to the mix here.
So it doesn't make sense to add gold to the portfolio.
So we're going back 40 years,
40 years worth of monthly data and
this data to use for your assignment is contained in the spreadsheet.
The name says what it is, Efficient Frontier- LargeSmall-ValueGrowth-Gold.
So use a spreadsheet to do the first part of assignment two.
We get our data on stock returns,
large stocks, small stocks,
value stocks, growth stocks.
Again from the Ken French Data Library which he generously posted online, large,
small or looking at the top 10 percent and bottom
10 percent of firms raised on the size of the market value of
their equity value and growth or look at the top 10 percent and
bottom 10 percent of firms ranked by their book to market ratio.
So the top 10 percent,
think of this cement company,
high book to market value where there's a lot of
tangible assets in place for the growth stocks.
Bottom 10 percent of book to market,
think of the Internet startup with a great idea that investors are
excited about but there aren't actually any tangible assets in
place except for maybe a computer server or
just an intangible little property or like that.
But most assets are intangible in nature for the growth stocks and we add to this now
gold price data from which we can calculate the return on
golds from the Deutsche Bundesbank Data Repository.
So, we have monthly data over 40 years,
so I guess that's 480 monthly observations or returns
from these five asset classes where you can calculate average returns,
standard deviations, correlations across these assets.
So let's look at the questions that I'd like you to tackle given
the assumptions that I gave you in the spreadsheet.
Remember those assumptions are derived from
the historical distributions over the 40 year period,
1975 to 2014 for these asset classes.
Question one. Suppose that you are currently
100 percent invested in large stocks and you cannot short,
so portfolio weights cannot be negative,
so your current situation 100 percent in large stocks.
You like the risk of large stocks so you may change
your portfolio but you don't want to change your standard deviation of the portfolio,
what portfolio maximizes expected return subject
to having the same risk level of large stocks?
What's the expected return in this case,
and what are the portfolio weights?
What is the new portfolio and then how much are returns expected to
increase if you switch from large stocks to this new portfolio?
Another way of saying this is how dominated is large stocks in this Efficient Frontier?
Question two. Suppose you can short assets now,
so it's just like question one only question one difference.
Let's highlight that here.
Now, you can short assets,
so the exact same question we had before,
but now you can short assets.
You like the risk of large stocks.
So, what is the optimal portfolio given you can
short where you maintain the same risk as large stocks.
What's that portfolio allocation?
When you put a portfolio together,
which asset do you short?
When you're allowed to short and come up with a portfolio that gives
the highest return subject to having the same risk as the large-cap fund,
what asset do you short in this portfolio?
What asset has the biggest increase in
portfolio weight when you go from this scenario of you cannot short?
When you go to this scenario you can short?
That's a second part of the question here,
which says the biggest increase in portfolio weight,
when you go from CANNOT short to CAN short examples.
So, what's the benefit at the end of
the day when you go from question one to question two,
what's the benefit in terms of higher expected returns?
By being allowed to short and then given this benefit in higher expected returns,
is it worth allowing the investor to short.
So, do you have a big increase in expected return of the portfolio
by being allowed to short or is there a small increase when you're allowed to short,
what asset do you short?
What asset increases a lot positively in terms of portfolio weight?
Why is that the case?
Question three, let's go back to suppose you CANNOT short,
what's the expected return portfolio standard deviation and portfolio composition
of the portfolio that maximizes the Sharpe Ratio?
Excess return of the portfolio divided by the portfolio standard deviation.
Does GOLD have any part in this portfolio?
If it does, why is gold apart of the maximum-Sharpe Ratio portfolio?
If GOLD is nowhere to be seen,
its portfolio weight is zero,
given you can't short.
Why is Gold not a part of it?
So, that's the first half of the assignment,
the first three of the six questions.
The second part is the great thing about this course is students from around the world.
So, let's consider, is there a benefit to international diversification?
When it comes to traveling and meeting folks the answer's definitely yes,
but how about in terms of financial investments here.
So, asset allocation with international stocks,
here we're going to refer to this spreadsheet EfficientFrontier-US-International.
That spreadsheet you're going to use for the second part of assignment two,
that has the average return, standard deviations,
correlations between US index fund,
Japan valuated stock market,
Asia Pacific excluding Japan and Europe.
This data's available on the Kenneth R. French Data Library starting July 1990,
so the weird starting date is just because that's
the first month we had the data through 2014,
so well this almost 24-25 years worth of data that we have here,
monthly data to do the correlations in stock returns,
calculate standard deviations, averages across these three regions of the world.
All right. So, question four on the assignment,
this is a first question regarding
international exposure but question four on assignment two.
So, it's well known that there's a home bias in investing,
people tend to invest in stocks and assets in the country where they're from.
So let's say, we're from the US and we have 100 percent in
the US stock market and we like comfortable with the risk of investing in US stocks,
but we're open to an alternative portfolio as
long as a portfolio standard deviation is the same as US stocks.
So, this is asking,
given a portfolio standard deviation is the same as US stocks,
what portfolio can we put together with
international exposure that gives us the highest possible return?
So maximize the return given the risk of the US stock portfolio.
What are the components of that portfolio?
What is the return?
We know the standard deviation is the same as the US stocks and then the key question is,
does this portfolio offer us much higher return
than the scenario where we're 100 percent in US stocks?
Question five, again suppose you cannot short.
What's expected return and standard deviation of
the portfolio that maximizes the Sharpe Ratio?
What are the portfolio weights?
Does Japan have any part in this portfolio that maximizes the Sharpe Ratio?
If yes, why is Japan part of the portfolio?
If no, why is Japan not?
So, what's a portfolio that gives us the biggest bang for the buck,
the biggest Sharpe Ratio,
does Japan have any part in it?
Question six, again suppose you CANNOT short,
Japan has not performed well over the last 25 years,
so when you look at their assumptions for returns they're very low.
What if we change that assumption so Japan has
the same projected expected returns as Asia Pacific?
So, we bump that monthly return for Japan up to 0.96 percent per month,
the same as Asia Pacific.
What's the maximum Sharpe Ratio now with this change assumption?
What is the portfolio that gives us this maximum Sharpe Ratio,
expected return, and the standard deviation?
Hey, let's talk a bit about the initial portfolio weights in Excel Solver,
I know this is a topic you can't wait to get into.
The two Excel spreadsheets to use for assignment 2 and less than 18 are;
Efficient Frontier, large, small, value,
growth, goal and EfficientFrontier-US-International.
When you open them up,
you will notice that both of these spreadsheets start out with mixed portfolios.
They are not starting out with 100 percent invested in one asset,
like a 100 percent in US stocks,
indeed both initial portfolios have
the portfolio weights equally split across the assets.
There is a reason for this,
sometimes an optimization algorithm,
like that used by Excel Solver,
can have a hard time finding
an optimal solution that is a constrained maximum or minimum.
If the search starts at a corner, that is,
a portfolio allocation is 100 percent in one asset.
Thus, please start out using my initial portfolio weights already in
the spreadsheet when using Solver to answer the problems in assignment two.
So, as we talked about with assignment one,
it's always good to be curious but not so much in this case, what's our rule?
Do the assignment first,
give it the college try.
After you do the assignment,
you're free to go in,
look at my discussion of the assignment,
if you want to change your answers after seeing my discussion,
that's fine but try it on your own first, right?
It's in your own interests to see,
to give you knowledge of the material,
then reviewing the answers is fine.
Before you grade or review other people's work,
please look at my discussion so you get
a better sense of what answers to look for and what the correct responses are.
Hopefully, your first attempt and my answers are perfectly correlated with each other.
Ознакомьтесь с нашим каталогом
Присоединяйтесь бесплатно и получайте персонализированные рекомендации, обновления и предложения.
Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.
© Coursera Inc., 2018 Все права защищены.
