Bayview 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.

Requirements
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

Transcribed Image Text:

1 ACCT # Classification 2 1010 Current Asset 3 1020 Current Asset 4 1030 Current Asset 5 6 7 1040 Current Asset 2010 Current Asset 2020 Current Asset 2030 Current Asset 2040 Current Asset 8 9 Line item Cash Cash Cash Cash Accts Receivable Accts Receivable Accts Receivable Accts Receivable D Acct Name Checking-Chase Money Market Chase 3 month CD-Wells Fargo 6 month CD-Chase Acct Rec-Southwest Acct Rec-Northwest Acct Rec-Southeast Acct Rec-Midwest Balance Jan 1 $ $ $ $ $ $ $ $ Balance Dec 31 551,113 $ 1,449,596 $ 766,670 $ 372,226 $ 773,005 $ 1,271,342 $ 1,247,168 $ 1,493,007 $ G Change 738,236 $ 1,439,507 $ 818,570 $ 448,123 $ 416,746 $ 1,259,128 $ 1,233,613 $ 1,591,101 $ 187,123 (10,089) 51,900 75,897 (356,259) (12,214) (13,555) 98,094