Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

تمرين 4

WHAT-IF ANALYSIS
The following selected transactions and events occurred during 2013:
a. Issued 200 shares of preferred stock for $20,000.
b. Sold 800 shares of treasury stock for $2,800.
c. Declared and issued a 4% common stock dividend. The market value on the date of declaration was $5 per share.
d. Generated a net loss for the year of $16,000.
e. Declared and paid the full year's dividend on all the preferred stock and a dividend of $15 per share on common stock outstanding at the end of the year.
Enter beginning balances for 2013 on STOCKEQ2. Then erase all 2012 entries and enter the transactions for 2013. Save the results as STOCKEQ4. Print the results.