The companion website for this book contains a spreadsheet with IBM stock prices and dividends from February 1990 through August 2004.

Part of this spreadsheet is given below; note that column D of the spreadsheet shows the stock return for the period over which the dividend is paid (usually this period is a quarter). Use SumIf to find the total of all dividends paid during periods when the stock return was greater than 25%.

Transcribed Image Text:

A B D E IBM IBM Stock 12 -23456789 Date Dividends Stock price return Feb-90 103.87 May-90 1.21 120.00 15.53%