Worksheet. Suppose that the $54,000 "Additional paid-in capital" balance at December 31,
2011, comes from two ledger accounts: $42,000 from Paid-in capital in excess of par and
$12,000 from Paid-in capital from treasury stock transactions. Revise the STOCKEQ2
worksheet to show a column for each of these accounts instead of the single column for
Additional paid-in capital. Then redo the 2012 transactions using the new columns. Preview the
printout to make sure that the worksheet will print neatly on one page, and then print the
worksheet. Save the file as STOCKEQT.
Chart. Using the STOCKEQ4 file, prepare a column chart showing the dollar amount of each
of the stockholders' equity account balances at December 31, 2013. Treasury stock can be
shown as a negative value. Enter your name somewhere on the chart. Save the file again as
STOCKEQ4. Print the chart.