Calculate the projected portfolio return

Assignment Help Finance Basics
Reference no: EM131945449

Question: In 900 to 1,000 words in APA manuscript format please complete the below.

Assume you are considering a portfolio containing two assets, L and M. Asset L will represent 40% of the dollar value of the portfolio, and asset M will account for the other 60%. The projected returns over the next six years, 2018-2023, for each of these assets are summarized in the following table.


Projected Return (%)

Year

Asset L

Asset M

2018

14%

20%

2019

14%

18%

2020

16%

16%

2021

17%

14%

2022

17%

12%

2023

19%

10%

1. Use an Excel spreadsheet to calculate the projected portfolio return, rp, for each of the six years.

2. Use an Excel spreadsheet to calculate the average portfolio return, rp, over the six-year period.

3. Use an Excel spreadsheet to calculate the standard deviation of expected portfolio returns, sp, over the six-year period.

4. How would you characterize the correlation of returns of the assets L and M?

5. Discuss any benefits of diversification achieved through creation of the portfolio.

Reference no: EM131945449

Questions Cloud

Find the payback in years for the cash flow : Find the payback in years (to the nearest tenths place) for the following cash flow with a WACC of 4%:
Analyze the value of the crm approach suggested by nguyen : Critically analyze the value of the CRM approach suggested by Nguyen and Mutum.Compare the approach to other approaches you are familiar with.
Describe the sequence of events that lead to the production : A bacterial pathogen has just entered the body of a person. Describe the sequence of events that lead to the production of enzymes that will hydrolytically
Perform an economic analysis of the given phenomenon : Perform an economic analysis of this phenomenon and its welfare implications. Include in your answer scope of government intervention in tackling this issue.
Calculate the projected portfolio return : Use an Excel spreadsheet to calculate the projected portfolio return, rp, for each of the six years. Use an Excel spreadsheet to calculate the average portfolio
Susceptible for coral bleaching : 1. Corals, an animal, are susceptible for coral bleaching. Describe what this is and what causes it. Can it be reversed?
Assess the literature on marketing new products : Research at least seven peer-reviewed articles related to marketing newly developed products or services.
Difference between front fanged snake and rear fanged snake : What is the difference between front fanged snake and rear fanged snake (be very specific and include the name of family representing each)
Analyse legal issues in relation to relevant laws : Identify and analyse each legal issues in relation to the relevant laws - Identify and analyse each legal issues in relation to the relevant laws

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd