Need help to solve the Cash flow statement below. Thank you

2. Using the information below, construct the 2020 Statement of Cash Flows for the Illini Tap. Some of the items may not be used, a few are completed for you as examples, and other items may require intermediate calculations before entering on the CFS. Remember, you need to calculate Family Living Withdrawals on the SOE, and then use the same value on the Cash Flow Statement. Record which section each item is recorded on the SCF worksheet (Operating, Investing, or Financing). Note any assumptions that you make in the notes section of the SCF worksheet. Section on CFS 2020 Transactions Notes a Land and building purchase Investing Land Cost 140,000 Investing Building Cost 300,000 25% Cash Down Payment 110,000 Financing Remainder financed on 30-year loan ??? Bar Equipment Purchase Investing Cost of new equipment 70,000 Down Payment 15,000 Financing Remainder financed on 5-year loan ??? C Sold equipment Investing Sale price 10,000 Tax basis of equipment sold 6,000 d Investment in local brewery Original cost 50,000 Current value 68,000 Operating Dividends received in 2017 2,500 Other items: Financing Principal paid on short-term loans 10,000 Operating Interest paid on short-term loans 1,500 Operating Family Living Withdrawals ??? Operating Total Cash Sales 910,000 Operating inflow Financing Principal paid on long-term loans 13,000 Investing Transfer from mutual funds to checking/cash 18,000 Operating Total Cash Operating Expenses 660,000 Operating outflow Operating Interest paid on long-term loans in cash 15,000 m Operating Cash Tax Expenses 67,000 Investing Deposit to Savings Account 25,000 O Financing Cash received from short-term loans 15,000 Other: Beginning Cash Balance 35,000 Beginning Cash BalanceSection on CFS 2020 Transactions Notes a Land and building purchase Investing Land Cost 140,000 Investing Building Cost 300,000 N/A 25% Cash Down Payment 110,000 Financing Remainder financed on 30-year loan 330,000 b Bar Equipment Purchase Investing Cost of new equipment 70,000 investing outflow N/A Down Payment 15,000 Not on cash flow, already part of investing outflow Financing Remainder financed on 5-year loan 55,000 financing inflow C Sold equipment Investing Sale price 10,000 investing inflow Tax basis of equipment sold 6,000 Not on CFS d Investment in local brewery Original cost 50,000 Current value 68,000 Operating Dividends received in 2017 2,500 Other items: Financing Principal paid on short-term loans 10,000 Operating Interest paid on short-term loans 1,500 Operating outflow Operating Family Living Withdrawals ??? - 5 0 - Operating Total Cash Sales 910,000 Operating inflow Financing Principal paid on long-term loans 13,000 finance outflow Investing Transfer from mutual funds to checking/cash 18,000 660,000 Operating outflow - -. Operating Total Cash Operating Expenses Operating Interest paid on long-term loans in cash 15,000 Operating outflow m Operating Cash Tax Expenses 67,000 operating outflow Investing Deposit to Savings Account 25,000 0 5 Financing Cash received from short-term loans 15,000 financing inflow Other: Beginning Cash Balance 35,000 Beginning Cash Balancefor Illini Tap For the period: January 1, 2020 to: December 31, 2020 Item Subtotal Total CASH FLOWS FROM OPERATING ACTIVITIES Inflows Cash received from business sales/receipts 910,000 Cash received from net nonbusiness income Total cash inflows from operating activities 910,000 > > $ 910,000 Outflows Cash paid for operating expenses 660,000 Cash paid for operating & s.t. loan interest 1,500 Cash paid for long-term loan interest 15,000 Cash paid for purchased inputs Cash paid for other items purchased for resale 67,000 Cash paid for income and social security taxes Cash withdrawals for owner/family living Total cash outflows from operating activities 743,500 > > S 743,500 Net cash flows provided by operating activities 166,500 CASH FLOWS FROM INVESTING ACTIVITIES Inflows Cash received on sale of machinery/equipment/real estate Cash received from sale of internally transferred capital Cash received from withdrawals of savings Cash received from sale of personal assets/retirement accts. Total cash inflows from investing activities > > Outflows Cash paid to purchase machinery/equipment/real estate 70,000 Cash paid to purchased productive capital items Cash paid for deposits to savings accounts Cash paid to purchase marketable securities Cash paid to purchase personal assets/retirement accts. Total cash outflows from investing activities 70,000 >> $ 70,000 Net cash flows provided by investing activities $ (70,000) CASH FLOWS FROM FINANCING ACTIVITIES Inflows Proceeds from operating loans and short-term notes 15,000 Proceeds from term debt financing Cash received from capital contributions Total cash inflows from financing activities 15,000 >> $ 15,000 Outflows Cash repayment of operating and short-term loans Cash repayment of term debt-scheduled 13,000 Cash repayment of term debt-unscheduled Cash repayment of capital leases Cash payments of dividends and other capital distributions Total cash outflows from financing activities 13,000 > > $ 13,000 Net cash flows provided by financing activities 2,000 Net increase (decrease) in cash flows 98,500 Beginning of year cash balance 35,000 End of year cash balance 133,500