A A B D G || K L M N 1 Functions: DAYS360, SUM; Formulas: Multiply, Divide; Cell Referencing 5 3 Using Excel to Calculate Weighted Average Number of Shares Student Work Area 4 Outstanding Required: Provide input into cells shaded in yellow in this template. Use cell 5 PROBLEM references with a mathematical formula to the Problem area and work area as Franklin Corporation had common shares on January 1, 2024. indicated. Use the SUM function to total amounts and the DAYS360 function to during the year, shares were repurchased and additional shares calculate months between dates. 8 were issued. Information concerning the common shares is 9 presented here. 10 Common shares outstanding, January 1, 2024 20,000 Calculate the weighted average number of shares for the year ended December Shares repurchased, March 1 31,2024. Shares issued, June 1 5,000 Shares issued, September 3010,000 calculate Calculate 31, 2024. 6,000 Year end date Start Date January 1, 2024 March 1, 2024 June 1,2024 September 30, 2024 Weighted average number of shares outstanding