PLEASE read the screenshot.

Tips: Ihis spreadsheet contains macros which will provide realt$$me teedback on EACH cell in the shaded area. Your score on the assignment will be calculated based upon the percentage of the cells that are completed correctly. Use cell referencing where you can and work in order $($i$.$e$.$ start with all of the blanks in the table, then with required #$1).$ There were no changes during the year in the number of common shares, preferred shares, or convertible bonds outstanding. There is no treasury stock. The company also has common stock options $($granted in a prior year$)$ to purchase the following shares of common stock: $()/()$# shares available for purchase via stock options $,120,000$ price of common stock $($per share$),$$$10$ Formulas and Methodologies: Basic Earnings Per Share Net income $-$ Preferred Dividends Paid