Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

Function SUM Formula Add Subtract Cell Referencing Some cells are merged Using Exc... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 1 attachment)

Excel file Icon
626a7972cf4af_93715.xlsx

300 KBs Excel File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Integrated Accounting

Authors: Dale A. Klooster, Warren Allen, Glenn Owen

8th edition

1285462726, 1285462721, 978-1285462721

More Books

Students also viewed these Accounting questions