FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

Question

PLEASE USE EXCEL AND SHOW FORMULAS! ALSO, SHOW YOUR WORK.

 

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
expand button
Transcribed Image Text: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
Expert Solution
Check Mark
Still need help?
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

USE MATHEMATICAL FORMULAS SUCH AS THE SUM FUNCTION, YOU CLEARLY DIDN'T SHOW YOU USED ANY FUNCTIONS.

 

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

USE MATHEMATICAL FORMULAS SUCH AS THE SUM FUNCTION, YOU CLEARLY DIDN'T SHOW YOU USED ANY FUNCTIONS.

 

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Knowledge Booster
Background pattern image
Accounting
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.
Similar questions
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education