Spreadsheet Assignment Using Excel
Required
a. Refer to Problem 2-32A. Use an Excel spreadsheet to construct the required financial statements. To complete Requirement b, use formulas where normal arithmetic calculations are made within the financial statements (in particular the statement of changes in stockholders’ equity).
b. It is interesting to speculate about what would happen if certain operating results change for better or worse. After completing Requirement a, change certain account balances for each of the following independent operating adjustments. After each adjustment, notice how the financial statements would differ if the change in operations were to occur. After noting the effect of each adjustment, return the data to the original amounts in Problem 2-28A and then go to the next operating adjustment.
In the following table, note the new amounts on the financial statements for the various operating changes listed.
Original | 1 | 2 | 3 | 4 | 5 |
Net income Total assets Total liabilities Total stockholders’ equity Total liabilities&stockholders’ equity |
|
|
|
|
|
Independent Operating Adjustments
1. Revenue and the related Accounts Receivable increased $10,000.
2. Revenue and the related Accounts Receivable decreased $10,000. ,
3. Operating Expenses and the related Accounts Payable decreased $400.
4. Operating Expenses and the related Accounts Payable increased $400.
5. Dividends paid decreased $500 and cash changed accordingly.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.