,

Ch 14 Cash flow problem 13-3a template.xlsx (Protected View] - Excel (Unlicensed Product) A Arbai File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share B8 X Problem P13-3A, The income statement of Elbert Company is presented here: A B C E F G H J L - M N P Q R s U T X Y z AB AA AC 1 2 3 4 Name: Course: Date: Problem P13-3A, Prepare the operating activities sectionindirect method. 51 6 7 8 9 10 11 12 13 14 15 Solving Financial Accounting Problems Using Microsoft Excel for Windows Problem P13-3A, The income statement of Elbert Company is presented here: ELBERT COMPANY Income Statement For the Year Ended November 31, 2011 Sales $7.700.000 Cost of Goods Sold Beginning inventory $1.900.000 Purchases 4.400.000 Goods available for sale 6,300,000 Ending inventory 1.400.000 Cost of goods sold 4.900.000 Gross profit $2,800,000 Operating expenses Selling expenses 450,000 Administrative expenses 700,000 1.150.000 Net income $1,650,000 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ###### Additional information: 1. Accounts receivable increased by $250.000 during the year, and inventory decreased 2. Prepaid expenses increased $150,000 during the year. 3. Accounts payable to suppliers of merchandise decreased $340,000 during the year. 4. Accrued expenses payable decreased $100,000 during the year. 5. depreciation expense of $90,000 31 32 33 34 35 36 Insbructions: Prepare the operating activities section of the statement of cash flows for the year ended November 30, 2011, for Elbert Company, using the indirect method. 37 38 39 40 Amount 41 42 43 ELBERT COMPANY Partial Statement of Cash Flows For the Year Ended November 31, 2011 Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities Title Amount Title Amount Title Amount Title Amount Title Amount Title Amount Net cash provided by operating activities 44 45 46 47 48 Formula Formula 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 Ch 14 Cash flow problem 13-3a template.xlsx (Protected View] - Excel (Unlicensed Product) A Arbai File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share B8 X Problem P13-3A, The income statement of Elbert Company is presented here: A B C E F G H J L - M N P Q R s U T X Y z AB AA AC 1 2 3 4 Name: Course: Date: Problem P13-3A, Prepare the operating activities sectionindirect method. 51 6 7 8 9 10 11 12 13 14 15 Solving Financial Accounting Problems Using Microsoft Excel for Windows Problem P13-3A, The income statement of Elbert Company is presented here: ELBERT COMPANY Income Statement For the Year Ended November 31, 2011 Sales $7.700.000 Cost of Goods Sold Beginning inventory $1.900.000 Purchases 4.400.000 Goods available for sale 6,300,000 Ending inventory 1.400.000 Cost of goods sold 4.900.000 Gross profit $2,800,000 Operating expenses Selling expenses 450,000 Administrative expenses 700,000 1.150.000 Net income $1,650,000 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ###### Additional information: 1. Accounts receivable increased by $250.000 during the year, and inventory decreased 2. Prepaid expenses increased $150,000 during the year. 3. Accounts payable to suppliers of merchandise decreased $340,000 during the year. 4. Accrued expenses payable decreased $100,000 during the year. 5. depreciation expense of $90,000 31 32 33 34 35 36 Insbructions: Prepare the operating activities section of the statement of cash flows for the year ended November 30, 2011, for Elbert Company, using the indirect method. 37 38 39 40 Amount 41 42 43 ELBERT COMPANY Partial Statement of Cash Flows For the Year Ended November 31, 2011 Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities Title Amount Title Amount Title Amount Title Amount Title Amount Title Amount Net cash provided by operating activities 44 45 46 47 48 Formula Formula 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66