Norstar Industries and Berclair Corp are publicly traded companies with complex capital structures. A summary of the results of operations for the years 2017 through 2021 are provided in the data set file. The following stock transactions occurred during the year 2021:

Create an Excel worksheet to display the computation for (a) basic earnings per share for 2021 including weighted-average common shares outstanding and (b) diluted earnings per share for 2021 including weighted-average common shares outstanding for each company. Show all calculations. Format earnings per share using accounting format with 2 decimal places. Label the worksheet EPSCal. 2. Add a new worksheet and based on the results of requirement 1, summarize presentation the basic and diluted earnings per share for 2021 that each company must report on the face of the income statement for 2021 (see page 1136/1137 in textbook). Label the worksheet FinSt. 3. Next, add a new worksheet and create a calculation and produce a bar chart to display dividends payout ratio trend for each company for the 5-year period 2017 through 2021. Label the worksheet DividPayout. Title the bar chart Dividends Payout Ratio The percentage decimal on the y axis should be presented as percentage (%) with 1 decimal place. Place data labels at top of bar carried to 4 decimal places. Based upon your output,