HPR CAPM Performa BGN Return Value END Value Weight Didividend Cash Flow nce Stock Portfolio Analysis Please complete the calculations for columns with titles highlighted in yellow Mkt Return 8% Rf return 2.25% Price Name Price Shares EPS Dividend Beta 7/1/2017 7/1/2018 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 S53.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 S79.72 $2.44 $2.65 1 Visa, Inc. 125 $53.17 cos S67.85 $2.42 $0.48 os 0.85 PACCAR eco 200 $63.78 2 S64.59 $4.47 $0.96 1.32 Microsoft 100 $41.87 S44.45 $1.48 $1.44 0.87 Rangold 100 $84.59 S65.03 $2.23 $0.60 0.11 Pioneer Nat Res www 200 S228.75 $136.23 $3.40 $0.08 0.52 vo Amgen 150 $120.31 $154.99 $7.55 $3.16 1.01 2011 Coca-Cola 400 We $42.29 $39.49 $1.71 $1.32 12 0.96 Bristol-Meyers Squibb 475 $48.12 $67.67 $1.07 $ $1.48 1.06 125 $42.85 S66.14 $2.37 $0.18 3.66 W.10 Starwood 200 200 $81.50 $82.00 $3.29 362.00 Wie $1.50 . 0.91 J2 Global 200 $52.03 S68.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 Maximus 04 Portfolio Analysis Portfolio Actual Return Portfolio Beta Portfolio CAPM Return Portfolio Performance Portfolio BGN and END Value in these Portfolio Dividend Cash Flow - two cells