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...
-
For each of the accounts listed, indicate whether it is an asset (A), a liability (L), or an owners equity (OE) account. If it is an account that affects owners equity, indicate whether it is a...
-
The general ledger of Pipers Plumbing at January 1, 2021, includes the following account balances: The following is a summary of the transactions for the year:1. January 24 Provide plumbing services...
-
Briefly discuss the auditing implications of using computer service centers.
-
The actual demand for the patients at Omaha Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 ............ 65 2 ............ 62 3 ............ 70 4...
-
I am working on an assignment in class that involves creating and managing databases using sql server. I have been researching methods that can be used to create and manage tables such as GUI and...
-
Refer to Fig. 4.40. 8,0 in Semicircular hatch 10 in 26 in 20-in radius Ethylene glycol sg = 1.10 10 in Tank is symmetrical 30
-
A direction vector for a line is any vector that joins two points on that line. Find a direction vector for 2x + 5y = 8. It is not certain that you and your classmates will get exactly the same...
-
White et al. (2009) propose a social network as a one-stop shop solution for global information dissemination and communication during all stages of an emergency. How feasible is this? What...
-
Information systems are crucial management tools during crisis, but for small or medium-size organizations they can be costly. What factors should an organization consider in justifying the cost of a...
-
Discuss how reliability models are used to provide information to support decisions regarding systems availability.
-
Discuss how improper maintenance policies lead to business continuity problems.
-
Explore the uses of regression analysis as a tool for risk and business continuity management.
-
Real World" Applications of Operations Analytics". Search Google and find a recent (within the last year or so) "real world" applications where the use of optimization (Linear / Integer / Mixed /...
-
How much more interest will be earned if $5000 is invested for 6 years at 7% compounded continuously, instead of at 7% compounded quarterly?
-
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:...
-
Calculate the static deflection in a linear spring of stiffness \(4000 \mathrm{~N} / \mathrm{m}\) when a mass of \(20 \mathrm{~kg}\) is hanging from it.
-
What is the kinetic energy of the system of Figure SP2.40 at an arbitrary instant in terms of \(x\), which is the downward displacement of the block of mass \(m_{1}\) ? Include an approximation of...
-
A spring of unstretched length of \(10 \mathrm{~cm}\) has a linear density of \(2.3 \mathrm{~g} / \mathrm{cm}\). The spring is attached between a fixed support and a block of mass of \(150...
Study smarter with the SolutionInn App