ACTG$382$ Excel Assignment #$3$

Required: Using the data below, calculate the eight required items and answer the one question related to EPS and diluted EPS.

Tips: This spreadsheet contains macros which will provide realtime feedback on EACH cell in the blue shaded area. Your score on the assignment will be

calculated based upon the percentage of the $9$ cells that are completed correctly. Use cell referencing where you can and work in order $($i$.$e$.$ start with

required #$1).$

The information below pertains to Hood Company for $2026.$

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:

Formulas and Methodologies:

Basic Earnings Per Share Net income $-$ Preferred Dividends Paid