fill into excel blanks for solution please

Directions: A) Using the information below and the template on the next tab, prepare a statement of cash flows (indirect method). B) Also using the template on the next tab, compute free cash flow. c) Respond to the analysis question at the bottom of the template using the information prepared in A) and B). Helpful tip: If you need a refresher on how to complete this project, watch M2 Part 2: Excel Example from Professor C. and review your M2 Discussion & Post-Assignment materials. Cash, Bucka & Dough, Co. Cash, Bucks & Dough, Co. Comparative Balance Sheet Income Statement December 31 For the Year ended December 31, 2021 2021 2020 Assets Cash Accounts Receivable Inventory Property, plant & equipment.net Total Assets $75,300 27,000 47,000 294,400 $443,700 $46,600 21,500 45,400 199,000 $312,500 Sales revenue Cost of goods sold Gross profit Operating expenses income from before pain and taxes Loss on sale of equipment income tax expense Net Income $265,000 70,000 195,000 60,000 135,000 10,000 12,000 3100,000 Liabilities and Stockholders' Equity Accounts payable Accrued wages payable Accrued utilities payable Bonds payable Total liabilities Common stock Retained earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity $23,800 26,000 22,500 51,000 123,300 115,000 205,400 320,400 $443.700 $27,100 19,100 32,700 41,000 119,900 115,000 77,600 192.600 $312,500 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. Cash, Bucks & Dough, Co. Statement of Cash Flow For the year ended December 31, 2021 In order to get full points for this project 10 Rows in blue should accurately reflect financial content worth 1 point each cells in green on the template should utilize formulas worth 1 point each Calls in yellow show the proper format and order of the statement worth 1 point each cells in arance provides a correct response to the analysis question 36 Total Points available Free Cash Flow