How do I input the information from the top screen shot into the statement of ca
ID: 2545277 • Letter: H
Question
How do I input the information from the top screen shot into the statement of cash flows on the second screen shot? Please and Thank you!
Excel File Edit View Insert Format Tools Data Window Help 100% E Sat 7:28 PM aE Accounting Project-Saved to my Mac Search Sheet Homc Insert Page Layout FormulasData Review View Share -Insert Calibri (Body) , 111 A-A- Wrap Text General -- Delete B 1 U, ii, , A, Merge & Center, $, 96 , *.0.00 Conditional Format Cell Sort & Filter Formatting as Table Styles Format G40 28 Panel 8-Statement of Cash Flows 29 CashFlows from o 30 Net Income Act cies 34 Increase in Iw 35 Increase in Accounts Payable 36 Increase in Notes Payable-short-teem 37 Net Cash Provided by 0 sh Flows from Inves ctivities Net Cash Used for 41 Cash Flows from Financing Actries ol 42 Cash 44 Net Cash Provided by Financine Activit 45 | Net Increase Decrease, in cash 46 Total 81,200 81,200 51 CL1:E26 Use cel references to appropriate values on Instractions and ENTERASWERS1 worksheets for calculations. 52 E16 1 Note that accumulated depreciation of plant assets should be a negatve value for total assets caloalation 3 C17 D17, C22 D22 | Do not calculate total assets and liabilities for debit and credit columns.Leave these cells blank 54 C26:D26 Use the function-SUMI to calculate total dabit and credit transactions s d abesfor debit C30 D43 I Use an equelsign (l and the appropriete cels from the spreadsheet for statemet of cash flows. Place cash outflows in column Cand cash inflows in column D. 56 | C32 Depreciation Expens should be entered as a positive value in This ce 57 039 | Use cell references to the Transaction Data table inInstructions worksheet to calculate cash paid for acquisition of plant assets. CAS:DS Calulata tha net change incash using values in PanelB If there is a decrease in cash, onter it as a negative value in colamn C If there is an increase in cash, 53 enter t as a postive value in column D. | Instructions | ENTERANSWERS1 ENTERANSWERS2+ Ready ® 87% 7Explanation / Answer
STATEMENT OF CASH FLOWS Cash Flow Statement by indirect Method Detail Credit Debit Cash Flow from Operating activities:- Net Income during the year $2,600 Adjustment to Reconcile net income to net cash provided by operating activities Add: Depreciation for the year $6,000 Changes in Current Operating Asset and Libilities Increase in Account Receivable $12,000 Increase in Inventory $4,400 Increase in Account Payable $5,500 Increasein Short Term Note Payable $10,000 Net Cash Provided by Operating activities (A) $7,700 $24,100 $24,100 Cash flow from investing activities Acquisition of Plant Asset 11000 Net Cash provided by Investing activities (B) 11000 $11,000 $11,000 Cash Generated from Finance Activities Issue of Common Stock $100,000 Dividend Paid $1,000 Net Cash provided by Financiang Activities ( C ) $99,000 $100,000 $100,000 Net Increase and decrease in Cash( $7700 Dr. -$11000 Cr. +$99000 Dr. $95,700
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.