If possible, please put answer into template shown above.

8 You work in the finance department for Cash, Bucks & Dough, Co. and are 9 preparing the yearly Statement of Cash Flows for the company. You will use the 10 following information below to complete the statement 11 12 Directions: 13 A) Using the information below and the template on the next tab, prepare a statement of cash flows (indirect method). 14 B) Also using the template on the next tab, compute free cash flow. 15 C) Respond to the analysis question at the bottom of the template using the information prepared in A) and B). 16 Cash, Bucks & Dough, Co. Cash, Bucks & Dough, Co. 17 Comparative Balance Sheet Income Statement 18 December 31 For the Year ended December 31, 2021 19 20 2021 2020 Sales revenue $265,000 21 Assets Cost of goods sold 70,000 22 Cash $75,300 $46,600 Gross profit 195,000 23 Accounts Receivable 27,000 21,500 Operating expenses 60,000 24 Inventory 47,000 45,400 Income from before gain and taxe 135,000 25 Property, plant & equipment, net 294,400 199,000 Loss on sale of equipment 10,000 26 Total Assets $443,700 $312,500 Income tax expense 17,000 27 Net income $108,000 28 Liabilities and Stockholders' Equity 29 Accounts payable $23,800 $27,100 30 Accrued wages payable 26,000 19,100 31 Accrued utilities payable 22,500 32,700 32 Bonds payable 51,000 41,000 33 Total liabilities 123,300 119,900 34 Common stock 115,000 115,000 35 Retained earnings 205,400 77,600 36 Total Stookholders' Equity 320,400 192,600 37 Total Liabilities and Stockholc $443,700 $312,500 38 39 40 Additional data: 41 1. Depreciation expense of $8,900 is included in the Operating Expenses on the Income Statement. 42 2. Equipment was sold for $5,500 cash. The loss on this sale is recorded on the Income Statement. 43 3. During 2021, the company purchased a building for cash at a cost of $91,000 44 4. The company declared and paid dividends of $9,000 during the year. 1 A) 2 Cash, Bucks & Dough, Co. Statement of Cash Flows For the year ended December 31, 2021 In order to get full points for this project: 18 Rows in blue should accurately reflect financial content worth 1 point each. 9 Cells in green on the template should utilize formulas worth 1 point each. 6 Cells in yellow show the proper format and order of the statement worth 1 point each. 3 Cells in Orange provides a correct response to the analysis question. 36 Total Points arailable 4 5 6 7 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 B) Free Cash Floy: 31 32 34 35 36 37 38 40 41 42 c) You are in top management at Cach, 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