Complete the statement of cash flows (indirect method) shown below by using formulas that reference data...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Complete the statement of cash flows (indirect method) shown below by using formulas that reference data from the income statement and balance sheet (found by clicking the tabs at the bottom of this worksheet. Note: Blank cells may be included in calculations. INNOVATION ELECTRONICS, INC. Statement of Cash Flows For the Year Ended December 31, 20X2 Cash Flows from Operating Activities: ONet income 18 Prepaid insurance 19 Accounts payable 20 Interest payable 21 Income tax payable 1 Adjustments to reconcile net income to net cash 2 provided by operating activities: 3 Depreciation expense 4 Gain (on sale of land) 15 Changes in current assets and current liabilities: 16 Accounts receivable 17 Inventory 22 Net cash provided by (used in) operating activities 23 24 Cash Flows from Investing Activities: TOSOLL ONL $ 177,500 B D 1 Note: To complete the assignment, go to the worksheet tab labeled Cash Flow 2 and complete the statement of cash flows. 6 7 Net sales 8 9 10 11 12 13 14 15 16 17 18 19 20 72235 21 24 INNOVATION ELECTRONICS, INC. Income Statement For the Year Ended December 31, 20X2 $ Gain on sale of land Total revenues Expenses: Cost of goods sold Operating expenses Depreciation expense Interest expense Income tax expense Total expenses Net income $ 1,565,000 *598,000 16,000 17,000 63,000 $ 2,430,000 6,500 2,436,500 2,259,000 177,500 E G C 1 Note: To complete the assignment, go to the worksheet tab labeled Cash Flow 2 and complete the statement of cash flows. 3 Note: Additional information is included at the bottom of the statement. 4 INNOVATION ELECTRONICS, INC. 5 Balance Sheet 6 At December 31 7 8 Assets Current assets: Cash 9 10 11 Accounts receivable 12 Inventory 13 Prepaid insurance 14 Long-term assets: 15 Investments 16 Land Equipment Accumulated depreciation 17 18 19 20 21 22 23 Liabilities and Stockholders' Equity 24 Current liabilities: 25 Accounts payable 3 Total assets READY AM *** Income Statement 20X2 $ 184,420 S 68,700 134,500 2,980 211,000 208,500 203,000 (117,500) $ 895,600 $ Balance Sheet 26,500 $ Cash Flow *** 20X1 25,740 83,000 128,000 4,560 120,000 255,000 203,000 (101,500) 717,800 81,000 D E Clipboard A25 26 27 1 Font Retained earnings 22 23 Liabilities and Stockholders' Equity 24 Current liabilities: 25 Accounts payable Interest payable Income tax payable 28 Long-term liabilities: 29 Notes payable 30 Stockholders' equity: 31 Common stock X A READY Attempt(s) fx Total liabilities and stockholders' equity Accounts payable $ Income Statement B 26,500 $ 3,400 30,200 255,000 273,000 307,500 39 2. Land costing $46,500 was sold, resulting in a gain of $6,500. No other 40 long-term assets were sold. 32 33 34 35 36 Additional Information for 20X2: 37 1. Assume that all increases and decreases in long term assets, long term liabilities, 38 and common stock are a result of cash transactions. 895,600 $ 41 3. Additional long-term investments were purchased. 42 4. An additional long-term note payable was signed. No repayments on 43 notes were made. 44 5. Additional common stock was issued. 45 46 Balance Sheet Cash Flow C *** 81,000 2,300 32,500 242,000 230,000 130,000 717,800 D E 3 E F G 100% Complete the statement of cash flows (indirect method) shown below by using formulas that reference data from the income statement and balance sheet (found by clicking the tabs at the bottom of this worksheet. Note: Blank cells may be included in calculations. INNOVATION ELECTRONICS, INC. Statement of Cash Flows For the Year Ended December 31, 20X2 Cash Flows from Operating Activities: ONet income 18 Prepaid insurance 19 Accounts payable 20 Interest payable 21 Income tax payable 1 Adjustments to reconcile net income to net cash 2 provided by operating activities: 3 Depreciation expense 4 Gain (on sale of land) 15 Changes in current assets and current liabilities: 16 Accounts receivable 17 Inventory 22 Net cash provided by (used in) operating activities 23 24 Cash Flows from Investing Activities: TOSOLL ONL $ 177,500 B D 1 Note: To complete the assignment, go to the worksheet tab labeled Cash Flow 2 and complete the statement of cash flows. 6 7 Net sales 8 9 10 11 12 13 14 15 16 17 18 19 20 72235 21 24 INNOVATION ELECTRONICS, INC. Income Statement For the Year Ended December 31, 20X2 $ Gain on sale of land Total revenues Expenses: Cost of goods sold Operating expenses Depreciation expense Interest expense Income tax expense Total expenses Net income $ 1,565,000 *598,000 16,000 17,000 63,000 $ 2,430,000 6,500 2,436,500 2,259,000 177,500 E G C 1 Note: To complete the assignment, go to the worksheet tab labeled Cash Flow 2 and complete the statement of cash flows. 3 Note: Additional information is included at the bottom of the statement. 4 INNOVATION ELECTRONICS, INC. 5 Balance Sheet 6 At December 31 7 8 Assets Current assets: Cash 9 10 11 Accounts receivable 12 Inventory 13 Prepaid insurance 14 Long-term assets: 15 Investments 16 Land Equipment Accumulated depreciation 17 18 19 20 21 22 23 Liabilities and Stockholders' Equity 24 Current liabilities: 25 Accounts payable 3 Total assets READY AM *** Income Statement 20X2 $ 184,420 S 68,700 134,500 2,980 211,000 208,500 203,000 (117,500) $ 895,600 $ Balance Sheet 26,500 $ Cash Flow *** 20X1 25,740 83,000 128,000 4,560 120,000 255,000 203,000 (101,500) 717,800 81,000 D E Clipboard A25 26 27 1 Font Retained earnings 22 23 Liabilities and Stockholders' Equity 24 Current liabilities: 25 Accounts payable Interest payable Income tax payable 28 Long-term liabilities: 29 Notes payable 30 Stockholders' equity: 31 Common stock X A READY Attempt(s) fx Total liabilities and stockholders' equity Accounts payable $ Income Statement B 26,500 $ 3,400 30,200 255,000 273,000 307,500 39 2. Land costing $46,500 was sold, resulting in a gain of $6,500. No other 40 long-term assets were sold. 32 33 34 35 36 Additional Information for 20X2: 37 1. Assume that all increases and decreases in long term assets, long term liabilities, 38 and common stock are a result of cash transactions. 895,600 $ 41 3. Additional long-term investments were purchased. 42 4. An additional long-term note payable was signed. No repayments on 43 notes were made. 44 5. Additional common stock was issued. 45 46 Balance Sheet Cash Flow C *** 81,000 2,300 32,500 242,000 230,000 130,000 717,800 D E 3 E F G 100%
Expert Answer:
Answer rating: 100% (QA)
Note Cash Flow Statement is prepared to know the movement of cash between two points of time Cash Fl... View the full answer
Related Book For
Accounting What the Numbers Mean
ISBN: 978-0078025297
10th edition
Authors: David H. Marshall, Wayne W. McManus, Daniel F. Viele
Posted Date:
Students also viewed these accounting questions
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
To prepare the statement of cash flows, accountants for Percy Electric Company have summarized 2016 activity in two accounts: Percy Electric's 2016 income statement and balance sheet data follow:...
-
2 1 Complete client engagement acceptance form. Review correspondence files, prior year audit workpapers, permanent files, financial statements and NA auditor's reports. 3 Apollo Shoes, Inc. AUDIT...
-
A study anticipates that subjects treated with drug A will have substantial improvement in their neuropathy symptoms. If the study measures neuropathy symptoms as present or not present, what level...
-
Determine the cumulative distribution function for the distribution in Exercise 4-4.
-
Garneau Manufacturing Ltd. produces and distributes a special type of chemical compound called Compound WX. The information below about Garneau's operations has been assembled to assist budget...
-
Compute the present value of an investment at 10% per year, which has a 3,000 return only at the end of Years 3, 4 and 5. a. $11,372.37 b. $6,165.72 c. $16,578.99 d. $13.066
-
Solutions Plus is an industrial chemicals company that produces specialized cleaning fluids and solvents for a wide variety of applications. Solutions Plus just received an invitation to submit a bid...
-
Horizontal Analysis of Income Statements Consolidated income statements for Cooper Manufacturing follow. Cooper Manufacturing Consolidated Income Statements (in thousands except per share amounts)...
-
The whistleblowing aspects of this case were first discussed in the text. What follows is a more comprehensive discussion of accounting and auditing issues. In 2005, Tony Menendez, a former Ernst &...
-
5 Check my work nts Book Hint Print rences Division A manufactures electronic circuit boards. The boards can be sold either to Division B of the same company or to outside customers. Last year, the...
-
Cost accounting can be assembled in a variety of ways for a variety of reasons. What are three ways that cost accounting information is assembled, and what is the reason for the assembly?
-
Consider the importance of ethics in a business organization and reflect for a moment on the ethical culture of an organization that you have worked for in the past. How would you describe this...
-
Comparisons of a region/country infrastructure by and education China vs Indonesia
-
You are the Controller of a medium-sized oil exploration company in Texas. It is time to make a forecast of the company's annual earnings. You know that some additional losses will be recognized...
-
Identify two examples in which marketers do notwant consumers to perceive a just noticeable difference between their product and a competitor's, or between an old product and a new one. Consider not...
-
Explain the difference between equity and equal. How does this concept relate to financing special education services? (.5 point) Equality denotes how people are treated, such as providing students...
-
Refer to the Conservation Ecology (Dec. 2003) study of the causes of forest fragmentation, presented in Exercise 2.166 (p. 97). Recall that the researchers used advanced high-resolution satellite...
-
Petro Motors, Inc. (PMI), produces small gasoline-powered motors for use in lawn mowers. The company has been growing steadily over the past five years and is operating at full capacity. PMI recently...
-
You have accumulated $12,000 and are looking for the best rate of return that can be earned over the next year. A bank savings account will pay 5%. A one-year bank certificate of deposit will pay 8%,...
-
Calculate NPVrank projects using present value ratios. The following capital expenditure projects have been proposed for managements consideration at Scott, Inc., for the upcoming budget year:...
-
Explain revenue management drivers in relation to Kimes and Chases four quadrants model.
-
Within an environment with which you are familiar (hospitality, tourism or events) analyse how revenue management could be applied.
-
Why does revenue maximisation not always lead to profit maximisation?
Study smarter with the SolutionInn App