Note: To complete the assignment, go to the worksheet tab labeled Cash Flow ind complete the statement of cash flows. INNOVATION ELECTRONICS, INC. Income Statement For the Year Ended December 31, 20X2 Net sales $ 2,430,000 Gain on sale of land 6,500 Total revenues 2,436,500 e Expenses: Cost of goods sold Operating expenses Depreciation expense Interest expense 7. $ 1.565,000 598.000 16,000 17,000 63,000 Income tax expense Total expenses 2,259,000 20 21 22 23 Net income 177.500 24 75

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 49E: Preparing a Statement of Cash Flows-Direct Method The controller of Newstrom Software Inc. provides...
icon
Related questions
icon
Concept explainers
Topic Video
Question
困日5.d
Prepare a statement of cash flows using the indirect method - Excel
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Sign in
Calbr
AA
Paste
Conditional Fo mat as Cel
Farmatting Table Styles
BIU-
Alignment Number
Cells
Editing
Clipbcard
Font
Sty es
GI1
A
D.
Note. To complete the assignment, go to the worksheet tab labeled Cash Flow
21
ind complete the statement of cash flows.
INNOVATION ELECTRONICS, INC.
Income Statement
For the Year Ended December 31,20X2
5.
Net sales
Gain on sale of land
$42,430.000
6,500
6.
10
Total revenues
2,436,500
11
12 Expenses:
13
Cost of goods sold
Operating expenses
Depreciation expense
Interest expense
1565,000
598.000
16.000
17.000
63.000
14
15
16
17
Income tax expense
18
19
Total expenses
2.259.X0
20
21
Net income
177.500
22
23
24
25
Income Statement
Balance Sheet
Cash Flow
READY
Attempt(s)
Transcribed Image Text:困日5.d Prepare a statement of cash flows using the indirect method - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Calbr AA Paste Conditional Fo mat as Cel Farmatting Table Styles BIU- Alignment Number Cells Editing Clipbcard Font Sty es GI1 A D. Note. To complete the assignment, go to the worksheet tab labeled Cash Flow 21 ind complete the statement of cash flows. INNOVATION ELECTRONICS, INC. Income Statement For the Year Ended December 31,20X2 5. Net sales Gain on sale of land $42,430.000 6,500 6. 10 Total revenues 2,436,500 11 12 Expenses: 13 Cost of goods sold Operating expenses Depreciation expense Interest expense 1565,000 598.000 16.000 17.000 63.000 14 15 16 17 Income tax expense 18 19 Total expenses 2.259.X0 20 21 Net income 177.500 22 23 24 25 Income Statement Balance Sheet Cash Flow READY Attempt(s)
Prepare a statement of cash flows using the indirect method Excel
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Sign In
Calibri
A A
Paste
Conditional Format as
Formatting Table- Styles-
BIU-
Alignment Number
Cell
Cells
Editing
Clipboard
Font
Sty es
Al
Note: To complete the assignment, go to the worksheet tab labeled Cash Flow
INNOVATION ELECTRONICS, INC.
Balance Sleel
AL December 31
20X2
20X)
Assets
Current assets-
Cash
184.420 S
68.700
134.500
33.540
11
Accounts receivable
3.D00
12
Inventory
2.980
Prepaid insurance
14 Long term assets:
Investments
4.560
211100
208.500
213.0010
120100
Land
255.000
Equipment
Accumulated deprecistion
18
(117.50)
(101.500.
19
20
Tatal assets
395.600
717/506
22
Liabilities and Stockholders Equity
24 Curren! liabiities:
Accounts payable
Interest payable
Income tax payable
28 Long teTm abi ies:
Nates payable
30 Stckhalders equity
23
26.500 S
81000
2.300
32.500
25
3,000
30.200
26
27
29
255J00
242000
230.000
130.000
Comman stack
273.000
32
Retained earmings
33
34
Tatal iabilities and slockholders' euui
595.600
717.800
35
36 Additional Information Ior 20X2:
Assume that all anereases and decreave in long tern asses. lng term liabiiies.
Income Statement
Balance Sheet
Cash Flow
READY
-H
10%
Attempt(s)
Transcribed Image Text:Prepare a statement of cash flows using the indirect method Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri A A Paste Conditional Format as Formatting Table- Styles- BIU- Alignment Number Cell Cells Editing Clipboard Font Sty es Al Note: To complete the assignment, go to the worksheet tab labeled Cash Flow INNOVATION ELECTRONICS, INC. Balance Sleel AL December 31 20X2 20X) Assets Current assets- Cash 184.420 S 68.700 134.500 33.540 11 Accounts receivable 3.D00 12 Inventory 2.980 Prepaid insurance 14 Long term assets: Investments 4.560 211100 208.500 213.0010 120100 Land 255.000 Equipment Accumulated deprecistion 18 (117.50) (101.500. 19 20 Tatal assets 395.600 717/506 22 Liabilities and Stockholders Equity 24 Curren! liabiities: Accounts payable Interest payable Income tax payable 28 Long teTm abi ies: Nates payable 30 Stckhalders equity 23 26.500 S 81000 2.300 32.500 25 3,000 30.200 26 27 29 255J00 242000 230.000 130.000 Comman stack 273.000 32 Retained earmings 33 34 Tatal iabilities and slockholders' euui 595.600 717.800 35 36 Additional Information Ior 20X2: Assume that all anereases and decreave in long tern asses. lng term liabiiies. Income Statement Balance Sheet Cash Flow READY -H 10% Attempt(s)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

How would I input the formulas into excel to get those numbers for the statement of cash flows 

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Financial Statements
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Auditing: A Risk Based-Approach to Conducting a Q…
Auditing: A Risk Based-Approach to Conducting a Q…
Accounting
ISBN:
9781305080577
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
South-Western College Pub