On December 31, 2021, Tea Company had 100,000 shares of common stock outstanding and 30,000 shares of 7%, $100 par, cumulative preferred stock outstanding. On February 28, 2022, Tea company purchased 24,000 shares of common stock on the open market as treasury stock paying $45 per share. On September 30, 2022, Tea sold 6,000 of the treasury shares for $47 per share. On November 30, 2022, Tea issued a 5% stock dividend on their common shares.

Required: Prepare a calculation on excel to determine weighted average shares outstanding for Tea Company for 2022. The spreadsheet must also show the number of outstand common shares at year-end December 31, 2022.