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