8. In the previous problem find two portfolios whose standard deviation is 45%. (There is an analytical solution to this problem, but it can also be solved by Solver.) ix 8.1: Adjusting for Dividends When downloading data from Yahoo or other sources, the "adjusted price" includes an adjustment for dividends. In this appendix we discuss two ways of making this adjustment. 10 The first, and simplest, method of adjusting for dividends is to add them to the annual change in price. In the following 10. It might be argued that since the free sources available on the web make these adjustments automatically, the details in this appendix are superfluous. Nevertheless we think they offer some interesting insights. (If you disagree, turn the page!) 8. In the previous problem find two portfolios whose standard deviation is 45%. (There is an analytical solution to this problem, but it can also be solved by Solver.) ix 8.1: Adjusting for Dividends When downloading data from Yahoo or other sources, the "adjusted price" includes an adjustment for dividends. In this appendix we discuss two ways of making this adjustment. 10 The first, and simplest, method of adjusting for dividends is to add them to the annual change in price. In the following 10. It might be argued that since the free sources available on the web make these adjustments automatically, the details in this appendix are superfluous. Nevertheless we think they offer some interesting insights. (If you disagree, turn the page!)