8. The CFO would also like you to prepare some data visualizations that depict monthly trends in the cash balance, current assets, and net income. Accordingly, use Charts to do the following: a. Go to the "Cash Budget" tab and create a bar chart that includes one bar for each of 12 months. Each month’s bar will show the excess (deficiency) of cash available over disbursements for that month and (where appropriate) the borrowings for that month. Use different colors to distinguish the excess (deficiency) of cash available over disbursements from any borrowings. Also, insert a horizontal line within your chart to depict the company’s minimum cash balance of $30,000. b. Which of the following statements are true based on the bar chart that you created in requirement 8a? check all that apply 4 The company's cash collections in February are greater than its cash disbursements during that same month. unanswered The company's excess (deficiency) of cash available over disbursements peaks in December. unanswered The company's excess (deficiency) of cash available over disbursements hits its lowest point in March. unanswered The company needs to borrow money during the year including borrowings in May and June. unanswered