Case C - After attending a recent meeting of The Accounting Society, you were inspired to set a goal to be able to retire with $2,000,000. You will put $6,000 of your savings into a retirement fund on January 1, 2022. After you graduate, you plan to make additional annual deposits into a fund at the BEGINNING of each of the 30 years, starting on January 1, 2025. These deposits will not be $6,000 but they will be in equal amounts each year (annuity due since payments are at the BEGINNING of each year). The fund will eam 7% interest compounded annually for all 33 years. Prepare a schedule to show (1) the year (i.e. 2022, 2023, etc.), (2) the beginning balance each year, (3) the amount of the deposit cach year, (4) the amount of interest each year, and (5) the ending balance each year. Format each of the amounts with two decimals. Please include totals at the bottom of your spreadsheet for the amount of deposits and the amount of interest eamed during the entire 33 year period (3 years without deposits and 30 years with deposits) Case D - Your company has been selling the following furniture products: Furniture Sales Sales Product in 2019 in 2020 Sofas $86,070 $93.402 Loveseats 121,492 129,627 Chairs 153,098 96,304 Ottomans 42,449 33,608 Beds 63,208 85,966 Dressers 56,294 67,201 Tables 31.648 55,023 TOTALS you figure you figure Prepare a table of ALL of the above information, including totals at the bottom of each column which is measured in dollars: 1. Sorted alphabetically by product (then print the information) 2. Sorted from highest to lowest based on sales in 2020 (then print the information). Prepare the following charts: 3. With the list sorted alphabetically and the amounts in dollars (from part 1), prepare a clustered column chart of the 2019 sales and 2020 sales shown side by side for each product. Please format this chart so that the dollar amount appears at the top of each column in the chart With the list sorted from highest to lowest based on sales in 2020 (from part 2), prepare apie chart of the 2020 sales with the amounts for each product shown in percentages of the total for the year, rather than dollars