Ask Question, Ask an Expert


Ask Basic Finance Expert

1) Rate of Return
Year   Asset A    Asset B   Market Index
1        8.0%       19.0%       9.0%
2      -11.0%      12.0%     14.0%
3       18.0%      19.0%       4.0%
4       -2.0%     -14.0%      -4.0%
5       12.0%      13.0%      17.0%

i) Compute Average Rate of Return on two Assets and = Market Index (Use the =Average function)

ii) Determine the Standard Deviation of Returns for two Assets and = Market Index? (Use the =STDEV function)

ii) Determine Correlation of Returns for Asset A and B, Asset A with Market Index and Asset B with the Market Index? (Use the =correl function)

iv) Compute Expected Return and Standard Deviation of Returns for Porfolios with given composition:

% Asset A                % Asset B
Expected Return   Std Dev of Returns
     0                       100%
   25%                     75%
   50%                     50%
   75%                     25%
  100%                     0%

v) Design a curve for Feasable Set of Portfolio outcomes by using data from (iv) with Portfolio Std Dev on X-Axis and Portfolio Expected Returns on the Y-Axis
(Use Insert and then Scatter Plot under the Chart functions)

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M914202

Have any Question? 

Related Questions in Basic Finance

State and explain two reasons why firms hedgea major bread

State and explain two reasons why firms hedge? A major bread maker is planning to purchase wheat in the near future. Identify and explain the appropriate hedging strategy? Explain how the implied repo rate on a spread tr ...

Suppose the ceo of your company owns 500000 shares of stock

Suppose the CEO of your company owns 500,000 shares of stock in the company and is granted 10,000 non-transferable European options as a bonus. The expiration date of the options is two years, the strike price is $100 an ...

There are 1000 students in a high school among the 1000

There are 1000 students in a high school. Among the 1000 students, 150 students take AP Statistics, and 300 students take AP French. 100 students take both AP courses. Let S be the event that a randomly selected student ...

Mountain minerals pays a constant annual dividend one year

Mountain Minerals pays a constant annual dividend. One year ago, when you purchased shares of that stockat $40 a share, the dividend yield was 6.5 percent. Over this past year, the inflation rate has been 3.2 percent.Tod ...

Abc publishing sells maps for 700 each the company is

ABC Publishing sells maps for $7.00 each. The company is currently breaking even with sales of 200,000 maps per year. ABC's variable cost per map is currently $5.00. Management has estimated that if production costs are ...

A companys dec 31st year-end balance sheet showed 72000 of

A company's Dec. 31 st year-end balance sheet showed $72,000 of inventory. The company uses the perpetual inventory system. After reviewing the company's records, the auditor noted the following items which had not been ...

Get a copy of your communitys hazard mitigation plan from

Get a copy of your community's hazard mitigation plan from your local office of emergency management. Create a mitigation plan for yourself that addresses the hazards identified in the community plan as they affect you o ...

Company checkpoint issued bonds at a discount where each

Company Checkpoint issued bonds at a discount where each $1,000 face(par) bond was issued for $900. The coupon rate is stated as 3.75%. Company Delta issued its bonds at par (each $1,000 of bond was issued for $1,000) wi ...

A recent study that examined bone strength collected data

A recent study that examined bone strength collected data from cadaveric femurs from subjects in three age groups. The data are below. Does mean bone strength differ for the three age groups? Use a 5% level of significan ...

Principles of financecorporations often use different costs

Principles of Finance Corporations often use different costs of capital for different operating divisions. Using an example, calculate the weighted cost of capital (WACC). What are some potential issues in using varying ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen