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

Accounting
1.2K views

owner made a cash investment into the company $3,000bought supplies on account $100paid salaries...owner...

Finance
1.2K views

A mining company is deciding whether to open a strip mine, which costs $2 million. Cash...

Physics
1.2K views

What are the advantages and disadvantages of radiation delivered through radiopharmaceutical or via an external source

Advance Math
1.2K views

1. Using the following table of relation between X & Y (Y is the independent Variable): xi...

Biology
1.2K views

ks S Home Schoology TEXT NEWinter and Om Match the following terms with their appropriate...

Statistics
1.2K views

In 5 card poker played with a standard 52 card deck 52 C5 or 2...

Calculus
1.2K views

The graph below is the function f x 5 4 3 2 1 21 2...

Algebra
1.2K views

8 For the function f x x 4 find f What is the range of...

Accounting
1.2K views

Outdoor Luggage, Incorporated, makes high-end hard-sided luggage for sports equipment. Data concerning three...

Accounting
1.2K views

Clonex Labs, Inc., uses the weighted-average method in its process costing system. The following data...

Accounting
1.2K views

The following information, about Parker Hannifin Corporation's shareholders' equity as of June 30, 2023, is...

Accounting
1.2K views

Langley Corporation has 42,300 shares of $13 par value common stock outstanding. It declares a...