Preparing a Cash Budget with Supporting Schedules using Excel's Multi-Tab Cell Referencing and Basic Math Functions. PLEASE SHOW EXCEL FUNCTIONS! The first two photos are just the directions. The second two are the problems.

24 Other budgeted cash disbursements in March \begin{tabular}{|l|l|r|} \hline 25 & Equipment purchases & $14,000 \\ \hline 26 & Dividends to be paid & $2,000 \\ \hline 27 & & $10,000 \\ \hline 28 & Minimum cash balance to be maintained & $11,500 \\ \hline 29 & March 1 cash balance & $0 \\ \hline 30 & March 1 outstanding borrowings & $0 \\ \hline 31 & March 1 interest due & $ \\ \hline \end{tabular} The company has a line of credit available to bolster the cash balance as needed. When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. Click the Schedules and Cash Budget tab to prepare the following: 1. Schedule of expected cash collections for March. 2. Schedule of expected cash disbursements for inventory purchases for March. 3. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be paid until the following month. \begin{tabular}{|l|l|l|l} \hline 24 & Selling and administrative expenses & & \\ \hline 25 & Equipment purchases & & \\ \hline 26 & Dividends paid & & \\ \hline 27 & Total disbursements & \\ \hline 28 & Excess (deficiency) of cash available over disbursements & \\ \hline 29 & Financing: \\ \hline 30 & Borrowings & & \\ \hline 31 & Repayments & \\ \hline 32 & Interest & & \\ \hline 33 & Total financing & & \\ \hline 34 & Cash balance, March 31 & \\ \hline \hline \end{tabular}