Hello ,

I need help with the calculating the beta for my portfolio.

Can you please check if it is correct?

I cannot find Beta for the options and bonds I have. I calculated percent of each asseet in portfolio and multiplied it by the beta coefficent.

What should I do next? Will the average Beta be the beta of my portfolio ?

A B C D E F 1 Symbol Description G H Quantity Beta 2 AAPL % in portfolio weight in P Betas in P Apple Inc. 150 1.23 3 AMZN 8 0.08 0.0984 Amazon.com Inc. 39 1.52 13.2 4 BA 0.132 0.20064 The Boeing Company 120 1.24 7.9 5 BNDX 0.079 0.09796 Vanguard Group, Inc. - Vanguard Total International Bond 430 0.64 6 BREW 4.8 0.048 Craft Brew Alliance Inc 0.03072 -300 0.98 7 DIS 1 0.01 0.0098 The Walt Disney Company 250 1.02 7.1 8 GE 0.071 0.07242 General Electric Company 1500 1.18 9 GOOG 3.3 0.033 0.03894 Alphabet Inc. 20 1.02 5.2 0.052 0.05304 10 IVV iShares S&P 500 Index Fund 50 1 3.1 0.031 11 MSFT 0.031 Microsoft Corporation 100 1.23 3 0.03 12 NFLX 0.0369 Netflix Inc. 50 1.3 2.9 0.029 13 PG 0.0377 Procter & Gamble Co. 180 0.38 4.4 0.044 0.01672 14 QQQ Invesco QQQ Shs 49 1.14 2 15 WMT 0.02 0.0228 Wal-Mart Stores Inc. 255 0.38 5.9 0.059 16 AMECX 0.02242 AMERICAN FUNDS INC (A) 653.026 1.01 3 17 VFIAX 0.03 0.0303 VANGUARD 500 INDEX FD 71.9243 1 4.1 0.041 18 VGTSX 0.041 VANGUARD GROUP 879.765 3 19 VTIBX 0.03 0.03 Vanguard Total International Bond Index Fund 2147.77 0.63 4.8 0.048 20 AAPL2019F30( Apple Inc 0.03024 65 11.6 0.116 21 SPY1916L315 SSgA Active Trust - SSGA SPDR S&P 500 15 0.8 0.008 22 B-MO-9.95-101 Altria Group Inc - 9.95% - Nov 2038 0.3 0.003 23 B-MSFT-3.000-MICROSOFT CORP 0.2 24 B-T-8.000-1511T-BOND 8.000% 15-Nov-2021 - N HK 0.002 0.4 0.004 ooo o c 25 B-WMT-5.0-25 Wal-Mart Stores Inc - 5.0% - Oct 2040 26 0.043478261 0.03917 27