Question: Function: SUM; Formula: Add, Subtract; Cell Referencing Some cells are merged. Using Excel to Calculate Operating Cash Flows Student Work Area PROBLEM Required: Provide input

Function: SUM; Formula: Add, Subtract; Cell Referencing
Some cells are merged.







Using Excel to Calculate Operating Cash Flows
Student Work Area
PROBLEM
Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. Use the SUM function with cell references to this work area for the total.
The comparative balance sheets for Gale Company show these changes in noncash current asset accounts and net income for the period.







Accounts receivable decrease $ 80,000




Prepaid expenses increase 28,000
Compute net cash provided by operating activities using the indirect method.
Inventories increase 40,000
Net income 186,000






Net income






Adjustments to reconcile net income to net







cash provided by operating activities















Net cash provided by operating activities

Step by Step Solution

3.42 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Function SUM Formula Add Subtract Cell Referencing Some cells are merged Using Exc... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

626a7972cf4af_93715.xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!