Portfolio analysis You have been given the expected return data shown in the first table on three assets-F, G, and H-over the period 2016-2019: Using these assets, you have isolated the three investment alternatives shown in the following table: a. Calculate the average return over the 4-year period for each of the three alternatives. b. Calculate the standard deviation of returns over the 4-year period for each of the three alternatives. c. Use your findings in parts a and b to calculate the coefficient of variation for each of the three alternatives. d. On the basis of your findings, which of the three investment alternatives do you think performed better over this period? Why? a. The expected return over the 4-year period for alternative 1 is %. (Round to two decimal place.) i Data Table - X - X Data Table (Click on the icon here O in order to copy the contents of the data table below into a spreadsheet.) Alternative Investment Expected Return Asset G 21% 1 100% of assetF Year Asset F Asset H 2 50% of asset F and 50% of asset G 50% of asset F and 50% of asset H 2016 2017 20% 18% 3 21% 22% 20% 19% 19% 2018 20% 2019 23% 18% 21% Print Done Print Done

Portfolio analysis You have been given the expected return data shown in the first table on three assets-F, G, and H-over the period 2016-2019: Using these assets, you have isolated the three investment alternatives shown in the following table: a. Calculate the average return over the 4-year period for each of the three alternatives. b. Calculate the standard deviation of returns over the 4-year period for each of the three alternatives. c. Use your findings in parts a and b to calculate the coefficient of variation for each of the three alternatives. d. On the basis of your findings, which of the three investment alternatives do you think performed better over this period? Why? a. The expected return over the 4-year period for alternative 1 is %. (Round to two decimal place.) i Data Table - X - X Data Table (Click on the icon here O in order to copy the contents of the data table below into a spreadsheet.) Alternative Investment Expected Return Asset G 21% 1 100% of assetF Year Asset F Asset H 2 50% of asset F and 50% of asset G 50% of asset F and 50% of asset H 2016 2017 20% 18% 3 21% 22% 20% 19% 19% 2018 20% 2019 23% 18% 21% Print Done Print Done

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter7: Types And Costs Of Financial Capital

Section: Chapter Questions

Problem 5EP

See similar textbooks

Similar questions

Assume you are considering a portfolio containing Asset 1 and Asset 2. Asset 1 will represent 37% of the dollar value of the portfolio, and asset 2 will account for the other 63%. Assume that the portfolio is rebalanced at the end of each year. The expected returns over the next 6 years, 2021–2026, for each of these assets are summarized in the following table: Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Projected Return Year Asset L Asset M 2021 −9% 33% 2022 15% 5% 2023 26% −9% 2024 4% 18% 2025 −9% 33% 2026 33% −18% . a. Calculate the expected portfolio return, rp, for each of the 6 years. b. Calculate the average expected portfolio return, rp, over the 6-year period. c. Calculate the standard deviation of expected portfolio returns, sp, over…
Below are the annual returns provided by TSCM. Calculate average annual return experienced by an investor over the last five years. Calculate the standard deviation of the portfolio return over this period. (See sheet "TSCM" in the attached Excel.) Period Return 2021 -51.0% 2020 43.0% 2019 61.0% 2018 -5.0% 2017 -19.0% In the year 2022, TSCM return is 21%. Calculate TSCM's Jensen's Alpha for the year period in annual terms. Use the below data. Beta = 2.3 Risk-free rate = 1% Expected Market Return = 8%
Using the information below to calculate the following monthly returns for the portfolio. a. Time Weighted Return b. Money Weighted Return c. Discuss the usefulness of above returns when evaluating the performance of the investment portfolio over a given time period. Assume all investments/withdrawals are made at the beginning of the month Month Return Investment January 5% 10000 February 3% March 3% April 7% May -6% 5000 June 2% July 2% August -9% September 7% -5000 October -4% November 2% December -2%
Portfolio Management A particular firm’s portfolio is composed of two assets, which we will call" A" and "B." Let X denote the annual rate of return from asset A, and let Y denote the annual rate of return from asset B. Suppose that E(X) = 0.15, E(Y) = 0.20, SD (X) = 0.05, SD (Y) = 0.06, and CORR (X, Y) = 0.30. (a) What is the expected return of investing 50% of the portfolio in asset A and 50% of the portfolio in asset B? What is the variance of this return? (b) Replace CORR (X, Y) = 0.30 by CORR (X, Y) = 0.60, 0, -0.30, and -0.60 and answer the questions in part (a). What is the impact of correlation on the expected returns and its variance? Explain why this is so. (c) Suppose that the fraction of the portfolio that is invested in asset B is f, and so the fraction of the portfolio that is invested in asset A is (1 – f). Let f vary from f = 0.0 to f = 1.0 in increments of 5% (that is, f = 0.0, 0.05, 0.10, 0.15, ...), and compute the mean and the variance of the annual rate of…
Consider a portfolio with two assets and three states of nature at the end of the year. Would it be possible to create a portfolio that is risk-free under these circumstances?
Consider the case of two financial assets and three market conditions (states). The tablebelow gives the respective probability for each market condition and the return of each assetin each one of them. Market Conditions State Recession Normal Expansion Probability of state 30% 40% 30% Return of asset A -30% 20% 55% Return of asset B -10% 70% 0% Consider the portfolio with 50% investment in each of the two assets above. Calculatethe expected return and the standard deviation of the portfolio.
Suppose a potential buyer has offered to buy this company in three years (in 2017). Based on the present value of the company calculated, and being mindful of the need to effectively balance portfolio risk with return, what recommendation should be made about purchasing the company as an investment at that price?
A particular firm’s portfolio is composed of two assets, which we will call" A" and "B." Let X denote the annual rate of return from asset A, and let Y denote the annual rate of return from asset B. Suppose that E(X) = 0.15, E(Y) = 0.20, SD (X) = 0.05, SD (Y) = 0.06, and CORR (X, Y) = 0.30. Use a spreadsheet to perform the following analysis. (a) What is the expected return of investing 50% of the portfolio in asset A and 50% of the portfolio in asset B? What is the variance of this return? (b) Replace CORR (X, Y) = 0.30 by CORR (X, Y) = 0.60, 0, -0.30, and -0.60 and answer the questions in part (a). What is the impact of correlation on the expected returns and its variance? Explain why this is so. (c) Suppose that the fraction of the portfolio that is invested in asset B is f, and so the fraction of the portfolio that is invested in asset A is (1 – f). Let f vary from f = 0.0 to f = 1.0 in increments of 5% (that is, f = 0.0, 0.05, 0.10, 0.15, ...), and compute the mean and the…
Suppose we want to determine the expected return and standard deviation for a portfolio of assets A (60%) and B (40%). The expected returns of assets A and B for each of the next 5 years are given in columns 1 and 2 respectively in the table. Find the expected return and standard deviation for the portfolio.Years A B2018 10% 6%2019 15% 8%2020 12% 10%2021 9% 7%2022 14% 9%
WINNER plans to invest in one of two stocks, each of which requires the same initial investment. The estimated return (cash flow) of these investments for the next year depends on economic conditions and their respective possibilities. State of Economy Probability Rate of Return Stock A Stock B Boom 0.15 0.30 0.25 Normal 0.55 0.12 0.08 Recession 0.30 0.01 -0.05 i) Compute expected rate of return for each asset. ii) Compute variance and standard deviation of rate of return for each asset. iii) Which asset should they purchase?
How do I calculate portfolio return and risk for an equally weighted portfolio using expected returns for the upcoming year using the CAPM model in excel?
You had the following rates of return for on your portfolio for the last four years: 2016: -12.3%2017: 18.4%2018: 5.0%2019: 12.5%Calculate the geometric average return on your portfolio. Enter your answer as a decimal, rounded to four decimal places.