Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please use excel to answer part 4 and 5 ...

please use excel to answer part 4 and 5 ...

60.1K

Verified Solution

Question

Finance

please use excel to answer part 4 and 5
image
image
0.03583 0.01888 -0.00762 0.003632 1.036 1.019 0.992 1.004 1.038 0.03768 0.943 1.028 -0.0574 0.02842 0.04655 0.002505 1.047 1.003 48 Average 49 Variance 50 St. Dev. 51 Alternative 0.00995 0.000944 0.03072 0.03072 =AVERAGE(B36 B45) =VAR S(836 845) =STDEV S(B36:345) =(B32*2*827-C32"2"C27+2*832"C32*328)*0.5 IB Attempt 2/10 for 8 pts Part 4 Still assume that you create a portfolio of 30% stock A and 70% stock B. However after the initial allocation, you do not rebalance the portfolio at all. What is the holding period return over the 10 weeks for the portfolio? 3+ decimals Submit Part 5 Attempt 3/10 for 10 pts What is the standard deviation of weekly returns for such a portfolio if you do not rebalance at all? 4+ decimals Submit Intro The following table shows historical end-of-week adjusted close prices (including dividends) for two stocks. Week 0 1 6 4 Stock A Stock B 30.41 2665 31.05 2,607 33.98 2,635 33.35 2,727 30.99 2.780 33.29 2.706 35.06 2,790 30.14 2.729 30.47 | 2,827 31.35 2.980 32.52 2.943 75 8 6 12 10

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

What are the critiques against the culture of poverty perspective? What do women get paid less...

Psychology
Q

What is different about SL(2,Z) and GL(2,Z) with regard to its action on the Farey treeing...

Advance Math
Q

Multiple steps are requried for this question Adger Corporation is a service company that measures its...

Accounting
Q

ng spheres A and B are kept very near to each other A is positively...

Physics
Q

20x10 4 Two different instruments say guitar ar harmonium playing same music the sound appears...

Physics
Q

22 14 39

Basic Math
Q

In the triangle shown we can find the angle as follows a 8 sin 1...

Algebra
Q

On January 1, Puckett Company paid $1.85 million for 92,500 shares of Harrisons voting common...

Accounting
Q

Which of the following is not a disciplinary proceedings under Circular 230 A: Administrative Law...

Accounting
Q

Axel Corp. engaged in the trade of goods will begin activities early next year, as...

Accounting
Q

Davidson Industries, a sole proprietorship, sold the following assets in 2019: Asset Warehouse Truck Computer...

Accounting
Q

Ariana and John, who file a joint return, have two dependent children, Kai and Angel....

Accounting