Question

ew History Bookmarks People Tab Window Help 75% Mon 10:27 PM Molly Theme ons L x D Assignments: FIN-32000-1 X Chapter 9 HW X Tutor.com Career Tutoring x My Drive - Google Drive nect.mheducation.com/flow/connect.html DU Student Life Quiz: Fifth Quiz: C. M Gmail o YouTube Maps Saved Help Save & Exit Submit Check my work If you own 400 shares of Alaska Air at $45.28, 450 shares of Best Buy at $53.72 and 200 shares of Ford Motor at $8.61, what are the portfolio weights of each stock? (Round your answers to 3 decimal places.) Portfolio Weights Alaska Air Best Buy Ford Motor

Answer 1

SUMIE А р i Stock XV fx =B2*C2 B Market Value of stock held Price ($) Number of Share held = Price * Number of shares 45.280 400 = B2 * C2 53.72 450 24174.00 8.61 200 1722.00 Total 44008.00 2 Alaska Air 3 Best Buy 4 Ford Motor

SUMIE A A i Stock W X fx =SUM(D2:04) B Market Value of stock held Price ($) Number of Share held = Price * Number of shares 45.28 400 18112.00 53.72 450 24174.00 200 1722.00 =SUM D2:04) 2 Alaska Air 3 Best Buy 4 Ford Motor 8.61 Total

SUMIF - X fx =D2/$D$5 ДА В Market Value of stock held Weightage in portfolio 1 Stock Price ($) Number of Share held = Price * Number of shares )= Market Value Held / Total 2 Alaska Air 45.28 400 18112.00 = D2/$D$5 3 Best Buy 53.72 450 24174.00 54.93% 4 Ford Motor 8.61 200 1722.00 3.91% Total 44008.00 100.00%|

Stock	Weightage in portfolio = Market Value Held / Total
Alaska Air	41.16%
Best Buy	54.93%
Ford Motor	3.91%