Question: here is all the info given and all the things ive put in so far. right now im stuck on what else i put in




Auto the matthew, proje 2- Search Alto Home Inn Draw Page Layout Forlas Data Review View Help RE Contact Feedback Show What's Support Training New lp f Community cel Blog Commy D E C Statement of Cash Flows For the year ended December 31, 2021 cash flows from operating activities net income net cash provided by operating activities depreciation expense S 8.900 increase in accounts receivable (5,500) Increase in inventory 1.600 5 108,000 Increase in ap loss on disposal of plant assets 3,300) 10,000 net cash provided by operating activities cash flows from investing activities sale of land sale or purchase of equipment net cash used by investing activities Excel Project 2 Template exy 4 W E R LR LIL LAS DEL 17 G Save o ham, matthew.project 2 Search to Home Insert DrawPage Layout Formulas Data Review View Help 26 POR Contact Feedbad Show What's Support Training Neve Hely Community Excel Blog Community Utfo D net cash provided by operating activities cash flows from investing activities sale of land sale or purchase of equipment net cash used by investing activities cash low from financing activities payment of cash dividends netcash used by financing activities net increase in cash cash at the beginning of period cash at the end of the period B) Free Cash Flow! Excel Project 2 Template ER OLD 64 3 4 W WEBLL MASOLELO J JDE zl|xl|cvl x G Z het, mathew.pro2 Search Altea Home Insert Draw Page Layout Formulas Data Review View Help Confectback Show What's Support TagN Community Bic Blog cash at the beginning of period cash at the end of the period ) Free Cash Flow C) You are in top management at Cinh, Bucks & Dough. Co Others in top management want to give MORE in cash dividends to Investors. Based on the results of the Free Cash Flow calculation do you agree that the company has the cash available to increase dividends to the investors right away Provide an Excel Project 2 Template hp 4 5 6 W R A SOLELO D F G Der 21500 D Cash, Bucks & Dough, Co. Comparative Balance Sheet December 31 11 Cash, Bucks & Dough, Co. coment for the Year ended Dr.2001 2021 2020 20 21 22 5265.000 70.000 195.000 Assets Cash Accounts Receivable Inventory Property, plant & equipment, net Total Assets 24 25 $75,100 27,000 47,000 294,400 $643,700 546,600 21500 45.400 399,000 $312.500 Sales revenue Cost of goods sold Grosspolit Operating expenses Income from before gain and are Loss on sale of equipment Income tax pense Net income 135.000 10,000 17.000 27 20 10 11 12 Labilities and Stockholders' Equity Accounts payable Acerued wages payable Accrued utilities payable Bonds partyle Total liabilities Common stock Retained earning Total Stockholders' Equity Excel Project 2 Template She $23.800 26,000 22,500 51.000 123,100 115,000 205400 320400 527,100 19.100 32,700 41000 119.900 115.000 7800 197.600 14 25 35 Hely OL POCO Hulp Blog Community E28 fx 21500 A B Accrued utilities payable Bonds payable Total liabilities Common stock Retained earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity D 22,500 51,000 123 300 115,000 205 400 320 400 $443.700 32,700 41,000 119.900 115,000 77600 192.800 $312,500 31 2 13 14 35 30 37 38 89 -10 41 12 -13 44 45 46 47 48 49 SO 51 Additional data: 1. Depreciation expense of $8,900 is included in the Operating Expenses on the income Statement 2. Equipment was sold for $5,500 cash. The loss on this sale is recorded on the Income Statement 3. During 2021, the company purchased a building for cash at a cost of $91,000 4. The company declared and paid dividends of $9,000 during the year. Excel Project 2 Template
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
