The following information is taken from XYZ Corporation comparative financial statements for the most recent two years:

$\backslash$table$[[,\frac{12}{31}\frac{?}{Y2},\frac{12}{31}\frac{?}{Y1},],[$Earnings available to common shareholders,$$82,800,$$$,103,530],[$Dividends paid to common shareholders,$$23,200,$$$,25,800],[$Number of common shares outstanding,$21,500,23,250,]]$

Then, using Mergent Intellect Search $[$Tor

AnnualReports.com$[`,$ choose a company for your review, specifically its balance sheet breakdown of shareholders' equity for its two most recent years' financial data.

Complete each dividend and payout calculation in the worksheet provided. Do not modify the worksheet and fill in all highlighted cells with your work. Worksheet cells are already formatted for proper number labeling and two decimal places. You must show your work using Excel formulas for the opportunity at full credit. Submit the file via the submit link in Moodle.