Chat with AI
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Edition 4ISBN: 978-1111581565Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Edition 4ISBN: 978-1111581565 Exercise 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.
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.
Explanation
Verified
Verified
Using ending balances of 2012 as the beg...
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
