Hi, please do it in a clear table format and not hand written stating the value for each of the following. Please answer both the parts as they are part of one question.

P5-2 Preparing the Statement of Cash Flows (Indirect Method) LO5-1, 5-2,5-3,5-5, 5-7 Selected financial information for Frank Corporation is presented below. Selected 2020 transactions are as follows: a. Purchased investment securities for $5,400 cash. b. Borrowed $15,800 on a two-year, 8 percent interest-bearing note. c. During 2020, sold machinery for its carrying amount; received $11,600 in cash. d. Purchased machinery for $50,800; paid $9,400 in cash and signed a four-year note payable to the dealer for $41,400. e. Declared and paid a cash dividend of $10,400 on December 31, 2020. Selected account balances at December 31, 2019 and 2020 are as follows: Cash Accounts receivable Inventory Accounts payable Accrued wages payable Income taxes payable December 31 2020 2019 $78,800 $21,400 17,400 12,200 52,400 60,800 7,400 10,800 1,000 1,400 5, 400 3,200 One-fourth of the sales and one-third of the purchases were made on credit. FRANK CORPORATION Statement of Earnings For the Year Ended December 31, 2020 Sales revenue $ 408,000 Cost of sales 272,000 Gross profit 136,000 Expenses Salaries and wages $51,400 Depreciation 9,600 Rent (no accruals) 6,200 Interest (no accruals) 12,600 Income tax 12,200 Total expenses 92,000 Net earnings $ 44,000 Required: 1. Prepare a statement of cash flows for the year ended December 31, 2020 by using the indirect method. (Negative answers should be indicated by a minus sign.) 44.000 FRANK CORPORATION Statement of Cash Flows For the Year Ended December 31, 2020 Cash flows from operating activities: Net earnings $ Add (deduct) items not affecting cash: Depreciation expense Decrease in inventory Increase in income tax payable Increase in accounts receivable Decrease in accounts payable Decrease in wages payable 9,600 8,400 2,200 (5,200) (3,400) (400) $ 55,200 Net cash flow from operating activities Cash flows from investing activities: Purchase of investments Purchase of machinery Sale of machinery Net cash flow from investing activities 0 Cash flows from financing activities: Borrowing on long-term note Payment of cash dividend 0 55,200 Net cash inflow from financing activities Net increase in cash during 2020 Cash, beginning of 2020 Cash, end of 2020 $ 55,200 2. This part of the question is not part of your Connect assignment. 3. Compute the quality of earnings ratio and the capital expenditures ratio. (Enter your answers in numbers and not in percentages. Round the final answers to 2 decimal places.) Quality of earnings ratio Capital expenditures ratio