Additional data: 1 Net income for the year 2021,$79,800. 2 Depreciation on plant assets for the year, $13,335. 3 Sold the long-term investments for $29,490. 4 Paid dividends of $36,750. 5 Purchased machinery costing $27,825, paid cash. 6 Purchased machinery and gave a $63,000 long-term note payable. 7 Paid a $42,000 long-term note payable by issuing common stock. Attached is an Excel file with Balance Sheets and additional data for Bairn Company. On this file, create a Statement of Cash Flows. If you're comfortable with Excel, use formulas, but if not, you can do the calculations separately and just type them into the spreadsheet. If you'd like, you can add tabs to show other calculations for problems 16-18. Just be sure to label them if you do so. You can also use that spreadsheet to do any other calculations you need for the multiple choice problems if you like. When you are done, save the file with your name and upload it here