Function: SUM; Formula: Add, Subtract; Cell Referencing Using Excel to Calculate Operating Cash Flows PROBLEM The comparative balance sheets for Gale Company show these changes in noncash current asset accounts and net income for the period. Accounts receivable decrease Prepaid expenses increase Inventories increase Net income $80,000 28,000 40,000 186,000 Student Work Area 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. Compute net cash provided by operating activities using the indirect method. Net income Adjustments to reconcile net income to net cash provided by operating activities Net cash provided by operating activities $186,000
Function: SUM; Formula: Add, Subtract; Cell Referencing Using Excel to Calculate Operating Cash Flows PROBLEM The comparative balance sheets for Gale Company show these changes in noncash current asset accounts and net income for the period. Accounts receivable decrease Prepaid expenses increase Inventories increase Net income $80,000 28,000 40,000 186,000 Student Work Area 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. Compute net cash provided by operating activities using the indirect method. Net income Adjustments to reconcile net income to net cash provided by operating activities Net cash provided by operating activities $186,000
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter11: The Statement Of Cash Flows
Section: Chapter Questions
Problem 39E: Reporting Net Cash Flow from Operating Activities The following information is available for...
Related questions
Question
PLEASE USE EXCEL AND SHOW THE FORMULAS USED. FOR EXAMPLE, IF SUM FUNCTION IS USED, PLEASE SHOW THE EXACT EXCEL FUNCTION TO SOLVE THE PROBLEM.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning