Need help with Case D. Thank You Case A - You have decided to start planning for your retirement. You already have $11,000in your investment account. You plan to put an additional $4,000 into the account at theBEGINNING of each year for the next 10 years and then put $6,000 into the account at theBEGINNING of each of the following 30 years. Your account is expected to grow at 6.5%interest (tax free) annually.Prepare a schedule to show (1.) the year (1 through 40), (2.) the beginning balance eachyear, (3.) the amount of interest earned each year, (4.) the deposit each year, and (5.) theending balance each year.Format each of the dollar amounts with two decimals.Please include totals at the bottom of your spreadsheet for (1) the amount of interest and (2)the amount of deposits during the entire 40 year (10 + 30) year time.Case B - You estimate that you will have $43,000 of school loans by the time you graduate.Your school loan is to be paid off over 10 years but you plan to pay it off over a 4 yearperiod with payments being made at the END of each MONTH for the 4 years followinggraduation. Assume your school loans charge 6% interest compounded MONTHLY.Prepare a schedule to show (1) the month number (i.e. #1 - #48), (2) the beginning loanbalance each month, (3) the payment each month, (4) the amount of interest in each monthlypayment, (5) the amount of principal in each monthly payment, and (6) the ending balanceeach month.Format each of the amounts with two decimals.Please include totals at the bottom of your spreadsheet for (1) the amount of payments, (2) theamount of interest, and (3) the amount of principal which was paid during the 48 month term ofthe loan. Case C - After attending a recent meeting of The Accounting Society, you were inspired to seta goal to be able to retire with $2,000,000. You will put $6,000 of your savings into aretirement fund on January 1, 2022. After you graduate, you plan to make additional annualdeposits 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 sincepayments are at the BEGINNING of each year). The fund will earn 7% interest compoundedannually for all 33 years.Prepare a schedule to show (1) the year (i.e. 2022, 2023, etc.), (2) the beginning balanceeach year, (3) the amount of the deposit each 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 theamount of interest earned during the entire 33 year period (3 years without deposits and 30years with deposits).Case D - Your company has been selling the following furniture products:FurnitureProductSofasSalesin 2019$86,070121,492153,09842,44963,20856,29431.648you figureSalesin 2020$93,402129,62796,30433,60885,96667,20155,023you figureLovescatsChairsOttomansBedsDressersTablesТОTALSPrepare a table of ALL of the above information, including totals at the bottom of each columnwhich is measured in dollars:Sorted alphabetically by product (then print the information)Sorted from highest to lowest based on sales in 2020 (then print the information).1.2.Prepare the following charts:With the list sorted alphabetically and the amounts in dollars (from part 1), prepare aclustered column chart of the 2019 salces and 2020 sales shown side by side for eachproduct. Please format this chart so that the dollar amount appears at the top of eachcolumn in the chart.With the list sorted from highest to lowest based on sales in 2020 (from part 2), preparea pie chart of the 2020 sales with the amounts for cach product shown in percentages ofthe total for the year, rather than dollars.3.4.

Question

Accepted Answer

1.
Alphabetically sorted info:

2.
Information sorted based on highest to lowest sales value in…