PLEASE HELP. I NEED STEP BY STEP. *PLEASE DO ON EXCEL*

Dividend Discount vs. Total Payout Project Part 1: 1. Choose 1 firm from each category below. 2. Obtain the dividend and repurchase information from WRDS Compustat 3. Compute the average dividend and total payout growth rate for the past 30 years, prior to the Financial Crisis, and post Financial Crisis. 4. Examine any trends in total dividends, repurchases, and total payout by graphing the data. Dividend Aristocrats Mixed payout Stocks AMERICAN AIRLINES GROUP INC ABBOTT LABORATORIES AT&T INC AUTOMATIC DATA PROCESSING BECTON DICKINSON & CO CATERPILLAR INC CHEVRON CORP CLOROX CO/DE COCA-COLA CO APPLE INC AES CORP (THE) ALLERGAN PLC ALASKA AIR GROUP INC AMGEN INC DELTA AIR LINES INC DOLLAR GENERAL CORP FREEPORT-MCMORAN INC COLGATE-PALMOLIVE CO CONSOLIDATED EDISON INC DOVER CORP EMERSON ELECTRIC CO EXXON MOBIL CORP GENUINE PARTS CO GILEAD SCIENCES INC GENERAL MOTORS CO JACOBS ENGINEERING GROUP INC JUNIPER NETWORKS INC KANSAS CITY SOUTHERN LEIDOS HOLDINGS INC LAM RESEARCH CORP MGM RESORTS INTERNATIONAL NETAPP INC NVIDIA CORP PULTEGROUP INC GRAINGER (WW) INC JOHNSON & JOHNSON KIMBERLY-CLARK CORP LEGGETT & PLATT INC PENTAIR PLC PPG INDUSTRIES INC SMITH (A.O.) STANLEY BLACK & DECKER INC UNITED TECHNOLOGIES CORP VF CORP CONSTELLATION BRANDS SKYWORKS SOLUTIONS INC SYMANTEC CORP THERMO FISHER SCIENTIFIC INC WESTERN DIGITAL CORP Dividend Discount vs. Total Payout Project Part 1: 1. Choose 1 firm from each category below. 2. Obtain the dividend and repurchase information from WRDS Compustat 3. Compute the average dividend and total payout growth rate for the past 30 years, prior to the Financial Crisis, and post Financial Crisis. 4. Examine any trends in total dividends, repurchases, and total payout by graphing the data. Dividend Aristocrats Mixed payout Stocks AMERICAN AIRLINES GROUP INC ABBOTT LABORATORIES AT&T INC AUTOMATIC DATA PROCESSING BECTON DICKINSON & CO CATERPILLAR INC CHEVRON CORP CLOROX CO/DE COCA-COLA CO APPLE INC AES CORP (THE) ALLERGAN PLC ALASKA AIR GROUP INC AMGEN INC DELTA AIR LINES INC DOLLAR GENERAL CORP FREEPORT-MCMORAN INC COLGATE-PALMOLIVE CO CONSOLIDATED EDISON INC DOVER CORP EMERSON ELECTRIC CO EXXON MOBIL CORP GENUINE PARTS CO GILEAD SCIENCES INC GENERAL MOTORS CO JACOBS ENGINEERING GROUP INC JUNIPER NETWORKS INC KANSAS CITY SOUTHERN LEIDOS HOLDINGS INC LAM RESEARCH CORP MGM RESORTS INTERNATIONAL NETAPP INC NVIDIA CORP PULTEGROUP INC GRAINGER (WW) INC JOHNSON & JOHNSON KIMBERLY-CLARK CORP LEGGETT & PLATT INC PENTAIR PLC PPG INDUSTRIES INC SMITH (A.O.) STANLEY BLACK & DECKER INC UNITED TECHNOLOGIES CORP VF CORP CONSTELLATION BRANDS SKYWORKS SOLUTIONS INC SYMANTEC CORP THERMO FISHER SCIENTIFIC INC WESTERN DIGITAL CORP