Excel SIM: Cash Budget with Supporting Cash Collections and Disbursements Schedules 1. Prepare a sales budget including a schedule of expected cash collections. 2. Prepare a direct moteriala budget, including a schedule of expected cosh disbursements for purchases of materists. 3. Prepore a cash budget. Excel SIM: Cash Budget with Supporting Cash Collections and Disbursements Schedul 1. Prepere o soles budget, including a achedule of expected cash collections. 2. Prepore o direct moterials budget, including a schedule of expecied cash disbursements for purchoses of moteriah. 3. Prepare a cash budget. fiE HOME MGERT AMGELAVOUT POPMUUS DATA TEVIEW VIEW Formating" Table" Styes" Font 5 syles 33 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 foliowing: 1. Schedule of expected cash coliections 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 unti the following month