please include excel formulas

fx S\&P Enterprises needs a cash budget for March. The following information is available. S\&P Enterprises needs a cash budget for March. The following information is avallable 8 D G Data \begin{tabular}{|r|r|r|} \hline January & February & \multicolumn{1}{c|}{ March } \\ \hline$1,600 & $3,750 & $5,100 \\ \hline 25,000 & 30,000 & 40,000 \\ \hline$26,600 & $33,750 & $45,100 \\ \hline \end{tabular} Actual January and February and expected March sales: Cash sales Sales on account Total Sales: \begin{tabular}{|r|r|r|} \hline January & February & March \\ \hline$1,600 & $3,750 & $5,100 \\ \hline 25,000 & 30,000 & 40,000 \\ \hline$26,600 & $33,750 & $45,100 \\ \hline \end{tabular} Accounts Receivable Collections: Month of sale Month following sale Second month following sale Uncoliectible. 14 Accounts pavable for inwentory purchases, March 1 balance 15 Budgeted inventory purchases in March 16. Irventory payments: 17 Month of purchase 18 Month following purchase 21 Budgeted depreciation in March (ineluded in total seling and admin exp) $12,500 23. Other budgeted cash disbursements in March Equipment purchases Dividends to be paid $3,200 Minimum cosh balance to be maintained $14,000 $2,000 March 1 cash batance $10,000 March 1 outstanding borrowings $11,500 March 1 interest doe so 31. 12. The company has a line of credit available to bolster the cash balance as needed. 13 When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. When preparine budgets, the company maintains their data on a sel B Budget Data 8 schedules and Cash Budget Giculabon Mode Automatic Wonbook Suatines Expected roth coliections: Marstrcash collections March coliections on zcciount: lanuary sates Februaryales Marchsales: Total cash collections Boyments to suppliert Accounts paryable for inventnry purchases, beginning bahacep Marth purchases total cash parments Gash Budget Far the Monsh of March Cash tialance, March 1 Mod cash receipti. Colinction from custamers Teqalcash availabie Les dishurements fayments to wipplen Syling and adminutrative expentes Equipment parchates Divisends paid 27. Total disburements 24 Freliminary cashbalkhts financine Addtionalioan tous fepayments interent 3) Total financine if Cavh batance. Marca i] Budget Data 8 schedules and Cash budget