Cash Budget with Supporting Cash Collections and Disbursements Schedules

I don’t know how to handle this Accounting question and need guidance.

1. Prepare a sales budget, including a schedule of expected cash collections.
2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of materials.
3. Prepare a cash budget.

You have two excel sheets, Budget Data & Schedules & Cash Budget. You will be required to use data in the Budget Data sheet when developing formulas to create information in the Schedules & Cash Budget.

In order to use data in one sheet and transfer the result into another sheet, your formula will need to be modified to include the sheet reference.

Let’s assume you want to use the information in the Budget Data sheet (take B6*B12 in the Budget Data sheet and include the result in B4 in the Schedules & Cash Budget sheet) the formula to do that in cell B4 in the Schedules & Cash Budget sheet is:

=’Budget Data’!B6*’Budget Data’!B12.

If you don’t use the sheet reference, your answer will be marked wrong.