Please do all required and provide formula view for solution. Thank you!

1 S\&P Enterprises needs a cash budget for March. The following information is available. \begin{tabular}{|c|c|c|} \hline 2 & Expected cash collections: & \\ \hline 3 & March cash collections & \multirow{5}{*}{\begin{tabular}{l} F \\ T \end{tabular}} \\ \hline 4 & March collections on account: & \\ \hline 5 & January sales & \\ \hline 6 & February sales & \\ \hline 7 & March sales & \\ \hline 8 & Total cash collections & \\ \hline \multicolumn{3}{|l|}{9} \\ \hline 10 & Payments to suppliers: & \\ \hline 11 & Accounts payable for inventory purchases, beginning balance & \multirow{2}{*}{r} \\ \hline 12 & March purchases & \\ \hline 13 & Total cash payments & \\ \hline \multicolumn{3}{|l|}{14} \\ \hline 15 & S\&P Enterprises & \\ \hline 16 & Cash Budget & \\ \hline 17 & For the Month of March & \\ \hline 18 & Cash balance, March 1 & r \\ \hline 19 & Add cash receipts: & \\ \hline 20 & Collections from customers & r \\ \hline 21 & Total cash available & r \\ \hline 22 & Less disbursements: & \multirow{5}{*}{r} \\ \hline 23 & Payments to suppliers & \\ \hline 24 & Selling and administrative expenses & \\ \hline 25 & Equipment purchases & \\ \hline 26 & Dividends paid & \\ \hline 27 & Total disbursements & F \\ \hline 28 & Preliminary cash balance & r \\ \hline 29 & Financing: & \\ \hline 30 & Additional loan & r \\ \hline 31 & Loan repayments & r \\ \hline 32 & Interest & r \\ \hline 33 & Total financing & \\ \hline 34 & Cash balance, March 31 & 1 \\ \hline \end{tabular} 1 S\&P Enterprises needs a cash budget for March. The following information is available. 36 Required: 37. Click the Schedules and Cash Budget tab to prepare the following: 38 1. Schedule of expected cash collections for March. 39 2. Schedule of expected cash disbursements for inventory purchases for March. 40 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 41 month. 42 (Use cells A4 to D7 and A10 to B30 from the given information, as well as A3 to C34 from the Schedules and Cash Budget to complete this question.) 36 Required: 37. Click the Schedules and Cash Budget tab to prepare the following: 38 1. Schedule of expected cash collections for March. 39 2. Schedule of expected cash disbursements for inventory purchases for March. 40 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 41 month. 42 (Use cells A4 to D7 and A10 to B30 from the given information, as well as A3 to C34 from the Schedules and Cash Budget to complete this question.)