Excel File Edit View Insert Format Tools Data Window Help AutoSave Template-ACC 213 Lab 10 for Chapter 12 pre Home Insert Draw Page Layout Formulas Review Data View Conditional Formatting Arial A A 10 General Format as Table Paste B I U Aw +8 Cell Cell Styles f G104 A. E F 1 Lab #10-Chapter 12 Satement of Cash Flows Name 3 Instructions 1, Calouate the yearoveryear dferenoe in column D, then whether the change was an "norease" or "deoreaseee Cash exanple) 2. Using the indirect Method for Operating Activites, complete the Statement of Cash Flows at the boton of the fie 7 Additonal Deta: 8 Assume all transactions ae for cash unless otherwise noted 9 Equipment in PPE is sold for $8200 cash. No purchases of PPE are made 10 Cost of equipment sold: 11 Accumulated depreciation on equipment sold 12 Dvidends declared and paid in cunent year 10,000 5,000 8300 13 14 Balance Sheets as of Dec. 31st Current Previous Dierence Increase or Income statement Current Year 15 Year Year Decrease? 16 Assets 17 Current Assets 18 Cashr 19 Accounts Receivable 20 Inteest Recevable 21 Merchandise Inventory Sales Revenue Cost of goods soid Gress Margin 270,000 145,000 36,000 23,000 100 50,000 4.000 inoease 125,000 38,000 Operating expenses Salates expense Rent expense Insurance experse Depeciation expense Total exgenses Income from operations Other revenuelexpense Plus Gain on sale of Equipment PPE Plus nterest venue Less Inteest expense Total Net Income 5,000 48,000 11.000 T8,000 22 Prepaid Rent 12,000 165,000 14,000 6.200 Total current assets 23 118,500 20.000 25 Long-term Assets 26 Notes Receivable (nontrade) 27 Property, Plant & Equipment (PPE) 28 Less: Accumulated Depreciation 29 Total long-term assets 118,2001 6.800 7,500 100,000 (20,000) 90,000 (05,000) 55,000 3.200 87,500 200 600 2.800 9,800 Total Assets 220,000 205,600 32 33 Liabilities and Shareholder's Equity 34 Curent Liabilities 35 Accounts Payable merchandise suppliers 18,000 20,000 Sheet 26 MacBook D F3 F4 & % lil 1 Formulas Data Review View Draw Page Layout Insert Home A A Gene 10 Arial Paste I G104 D F A Name Lab #10-Chapter 12 Statement of Cash Flows 1 2 Instructions: 1. Calculate the year-over-year difference in column D, then whether the change was an "increase" or "decrease 2. Using the Indirect Method for Operating Activities, complete the Statement of Cash Flows at the bottom of the 3 4 5 6 7 Additional Data: 8 Assume all transactions are for cash unless otherwise noted. 9 Equipment in PPE is sold for $8200 cash. No purchases of PPE are made. 10 Cost of equipment sold: 11 Accumulated depreciation on equipment sold 12 Dividends declared and paid in current year 10,000 5,000 9,300 13 14 Balance Sheets as of Dec. 31st Previous Difference Increase or Decrease? Current Year 15 Year 16 Assets 17 Current Assets 18 Cash 19 Accounts Receivable 20 Interest Receivable 21 Merchandise Inventory 22 Prepaid Rent 23 Total current assets 50,000 36,000 23,000 100 48,000 14,000 increase 38,000 0 65,000 12,000 165,000 11,000 118,100 24 25 Long-term Assets 26 Notes Receivable (nontrade) 27 Property, Plant & Equipment (PPE) 28 Less: Accumulated Depreciation 29 Total long-term assets 30 0 7,500 100,000 (20,000) 87,500 90,000 (35,000) 55,000 31 Total Assets 220,000 205,600 32 33 Liabilities and Shareholder's Equity 34 Current Liabilities 35 Accounts Payable- merchandise suppliers 20,000 18,000 Sheet1 + NOV11 A 26 +A E G H ame se" or "decrease (see Cash example). he bottom of the file. Increase or Income statement Current Decrease? Year Sales Revenue Cost of goods sold Gross Margin 270,000 145,000 125,000 increase Operating expenses Salaries expense 78,000 14,000 Rent expense Insurance expense Depreciation expense Total expenses Income from operations Other revenue/lexpense Plus: Gain on sale of Equipment (PPE) 6,200 20,000 8,200 6,800 3,200 200 Plus: interest revenue Less: Interest expense Total Net Income 600 2,800 9,600 Tools Window View Insert Format Data Excel File Edit Template - ACC AutoSave OFF Formulas Data Review View Page Layout Insert Draw Home A A Arial 10 Gen I U A- $ Paste fx G104 A C E 25 Long-term Assets 26 Notes Receivable (nontrade) 27 Property, Plant & Equipment (PPE) 28 Less: Accumulated Depreciation 29 Total long-term assets 0 7,500 100,000 (20,000) 87,500 90,000 (35,000) 55,000 30 31 Total Assets 205,600 220,000 32 33 Liabilities and Shareholder's Equity 34 Current Liabilities 35 Accounts Payable -merchandise suppliers 36 Salaries Payable 37 Uneamed Revenue 38 Interest payable 20,000 5,800 8,100 600 18,000 2,100 12,500 200 32,800 39 Total current liabilities 34,500 40 41 Long-term liabilities 42 Notes Payable (due in 5 years) 43 Bonds Payable (due in 10 years) 44 Total long-term liabilities 45 Total liabilities 46 Shareholder's equity 47 Common stock $10 par 48 Additional Paid in Capital 49 Retained Eamings 50 Total stockholder's equity 51 Total Liabilities plus stockholder's equity 3,700 5,500 9,200 43,700 21,300 0 21,300 54,100 64,500 100,000 11,800 176,300 50,000 90,000 11,500 151,500 220,000 205,600 Good Student Company Statement of Cash Flow (Indirect Method) December 31, 20XX 57 Operating Activities: Sheet1 +A G104 A 53 Good Student Company Statement of Cash Flow (Indirect Method) December 31, 20XX 54 55 56 57 Operating Activities: 58 59 60 61 62 63 64 65 66 67 68 69 70 71 Net Cash Flow from Operating Activities 72 73 Investing Activities: 74 75 76 77 Net Cash Flow from Investing Activities 78 79 Financing Activities: 80 81 82 83 84 85 Net Cash Flow from Financing Activities 86 87 Reconciliation: Sheet1 NOV A 26 Paste fx G104 A 68 69 70 71 Net Cash Flow from Ope rating Activities 72 73 Investing Activities: 74 75 76 77 Net Cash Flow from Investing Activities 78 79 Financing Activities: 80 81 82 83 84 85 Net Cash Flow from Financing Activities 86 87 Reconciliation: 88 Net Change in Cash 89 Add: Beginning Cash Balance 90 Ending Cash Balance 91 92 93 94 95 96 97 98 99 100 101 Sheet1 >