0

    Documentation

    Illustrated Excel 2019 | Module 7: SAM Project 1a
    Chastain Group
    EXCHANGE DATA WITH OTHER PROGRAMS
    Author: Ruby Rawls
    Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

    Merger Options

    Merger Options

    Hola

    BrandUp

    D&M

    Revenue Comparison

    365 Marketing D&M Group
    Revenues 2017 2018 2019 2020 2021 Revenues 2017 2018 2019 2020 2021
    Q1 $ 68,000 $ 80,400 $ 81,750 $ 91,050 $ 94,000 Q1 $ 41,000 $ 53,300 $ 54,050 $ 64,150 $ 63,900
    Q2 77,800 81,750 90,500 95,500 95,500 Q2 50,200 50,750 63,600 68,100 67,800
    Q3 83,575 90,675 93,750 100,500 99,350 Q3 56,275 56,675 62,750 73,200 70,150
    Q4 85,850 90,750 91,775 100,500 102,500 Q4 63,150 61,075 63,675 78,800 77,300
    Total $ 319,225 $ 344,575 $ 363,775 $ 392,550 $ 401,350 Total $ 210,625 $ 221,800 $ 244,075 $ 284,250 $ 279,150
    BrandUp Hola
    Revenues 2017 2018 2019 2020 2021 Revenues 2017 2018 2019 2020 2021
    Q1 $ 53,000 $ 75,400 $ 76,750 $ 80,050 $ 82,300 Q1 $ 38,500 $ 38,400 $ 39,950 $ 41,020 $ 44,000
    Q2 68,700 70,750 80,100 89,200 81,200 Q2 47,220 47,750 48,500 48,750 48,800
    Q3 68,575 70,675 73,750 77,820 70,950 Q3 50,175 50,675 53,750 50,775 51,350
    Q4 68,850 71,750 77,715 79,300 82,500 Q4 59,850 60,050 60,775 60,990 82,500
    Total $ 259,125 $ 288,575 $ 308,315 $ 326,370 $ 316,950 Total $ 195,745 $ 196,875 $ 202,975 $ 201,535 $ 226,650

                                                                                                                                      Order Now