Pls solve this showing all the formulas and explanations. Excel would be great. I'll be sure to like if I find your answer helpful. Thank you!

The income statement and additional data of Bryan Travel Products, Inc., follow: (Click the icon to view the income statement.) i. (Click the icon to view the additional data.) Requirements 1. Prepare Bryan's statement of cash flows for the year ended December 31,2021 , using the indirect method. 2. Evaluate the company's cash flows for the year. In your evaluation, mention all three categories of cash flows and give the rationale for your evaluation. More info Data table Additional data: a. Acquisition of plant assets was $132,000. Of this amount, $102,000 was paid in cash and $30,000 was financed by signing a note payable. b. Proceeds from the sale of land totaled $23,000. c. Proceeds from the issuance of common stock totaled $47,000. d. Payment of a long-term note payable was $20,000. e. Payment of dividends was $18,000. f. From the balance sheets