Worksheet. Open the EPS3 file. Suppose that during 2012, Ponce Towers had incurred an

extraordinary after-tax loss of $50,000 from an earthquake. Revise the worksheet to

accommodate this new item and recompute earnings per share. Preview the printout to make

sure that the worksheet will print neatly on one page, and then print the worksheet. Save the

completed file as EPST

Chart. Using the EPS2 file, create a column chart that plots the total number of common

shares outstanding on a month-by-month basis throughout 2011. Complete the Chart Tickler

Data Table (beginning on row 49 of the Total Income sheet tab) and use it as a basis for

preparing the chart. Enter all appropriate titles, legends, and formats. Enter your name

somewhere on the chart. Save the chart again as EPS2. Print the chart.

Weighted average common shares outstanding Weighted average common shares outstanding