The Tennessee Scooter Company produces several types of scooters. The controller has gathered information from the company’s general ledger data for the past fiscal year and has performed some analysis in Excel. Screenshots containing samples from the Excel file follow in Boxes A, B, and C.

1. In Box A, a sample of the general ledger data is displayed. What information from this general ledger data is needed to prepare the company’s operating cash flows section on the statement of cash flows using the indirect method?
2. What Excel feature was used to create the information displayed in Columns A and B in Box B? What Excel feature was used to create the information displayed in Columns C, D, and E in Box B? Describe the steps that were taken to create the information displayed in Box B.
3. What information is being displayed in Box C? How would this information be used in preparing the company’s operating cash flows section on the statement of cash flows using the indirect method?

Transcribed Image Text:

CAWN Box A A ACCT # Classification Line item Cash Cash Cash Cash Accts Receivable Accts Receivable Accts Receivable Accts Receivable 1010 Current Asset 1020 Current Asset 1030 Current Asset 1040 Current Asset 2010 Current Asset 2020 Current Asset 2030 Current Asset 9 2040 Current Asset 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 Change 700,042 $ 1,399,229 $ 788,508 $ 413,849 $ 387,288 $ 1,229,203 $ 1,190,881 $ 1,559,012 $ 533,620 $ 1,429,651 $ 754,666 $ 355,609 $ 762,511 $ 1,251,222 $ 1,223,180 $ 1,474,676 $ 166,422 (30,422) 33,842 58,240 (375,223) (22,019) (32,299) 84,336