Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to solve the first row and yellow cells? Just the first row on the top is good. HPR CAPM Perform Return ance BGN Value

How to solve the first row and yellow cells? Just the first row on the top is good.

image text in transcribed

HPR CAPM Perform Return ance BGN Value END Value Weight Didividend Cash Flow Stock Portfolio Analysis Please complete the calculations for columns with titles highlighted in yellow Mkt Return 8% Rf return 2.25% Price Price Name Shares EPS Current Capital Dividend Beta 7/1/2017 7/1/2018 Yield Gain/Loss Progressive Corp. 300 $25.48 $28.44 $2.24 $0.69 0.87 Medtronic 250 $63.91 $74.08 $2.15 $1.52 1.44 Starbucks 600 $39.10 $53.89 $1.78 $0.64 0.87 Berkshire Hath -B 100 $127.24 $137.52 $7.28 $0.00 0.29 Procter & Gamble 200 $79.28 $79.72 $2.44 $2.65 1 Visa, Inc. 125 $53.17 $67.85 $2.42 S0.48 0.85 PACCAR 200 $63.78 $64.59 $4.47 $0.96 1.32 Microsoft 100 $41.87 $44.45 $1.48 $1.44 0.87 Rangold 100 $84.59 $65.03 $2.23 $0.60 0.11 Pioneer Nat Res 200 S228.75 $136.23 $3.40 S0.08 0.52 Amgen 150 $120.31 $154.99 $7.55 $3.16 1.01 Coca-Cola 400 $42.29 $39.49 $1.71 $1.32 0.96 Bristol-Meyers Squibb 475 $48.12 $67.67 $1.07 $1.48 1.06 Maximus 125 $42.85 $66.14 $2.37 $0.18 3.66 Starwood 200 $81.50 $82.00 $3.29 $1.50 0.91 J2 Global 200 $52.03 $68.01 $2.50 $1.23 1.44 Walmart 300 $75.28 $71.88 $4.79 $1.96 0.87 General Mills 150 $52.90 $57.09 $2.11 $1.76 0.71 Apple 250 $93.52 $126.60 $8.65 $2.08 1.09 04 Portfolio Analysis Portfolio Actual Return Portfolio Beta Portfolio CAPM Return Portfolio Performance Portfolio BGN and END Value in these two cells Portfolio Dividend Cash Flow

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied International Finance

Authors: Thomas J O'Brien

1st Edition

1606497340, 9781606497340

More Books

Students also viewed these Finance questions

Question

Multiply or divide as indicated. 57.116 100

Answered: 1 week ago

Question

Did you add the logo at correct size and proportion?

Answered: 1 week ago

Question

Did you ask for action?

Answered: 1 week ago