Riverview Marine Company makes a variety of boating supplies. The controller is preparing its statement of cash
Question:
Riverview Marine Company makes a variety of boating supplies. The controller is preparing its statement of cash flows for the most recent calendar year. A sample of the pivot table the controller prepared using Excel with the company’s general ledger data follows.
This pivot table lists each specific general ledger account and the change in its balance from January 1 to December 31.
Requirement:
1. Using the file provided in MyLab Accounting, create a pivot table that summarizes the information by “Line item” (Rows box) and “Change” (Values box). Fill in the following change totals from the pivot table.
a. Accrued expenses
b. Accts Payable
c. Accts Receivable
d. Accum. Depreciation
e. Cash
f. Common stock
g. Current portion LT debt
h. Goodwill
i. Income tax payable
j. Interest payable
k. Inventory
l. Investments
m. LT bonds payable
n. LT notes payable
o. Preferred stock
p. Prepaid expenses
q. Property, Plant, Equip
r. Retained earnings
s. Wages payable
2. Add a slicer based on “Classification” to the pivot table you created for Requirement 1. Use the slicer to get the following change totals.
a. Current Assets
b. Current Liabilities
c. Long-Term Assets
d. Long-Term Liabilities
e. Stockholders’ Equity
Step by Step Answer:
