Question
Grimpen Ltd is preparing a cash budget for September to December. Budgeted sales receipts and budgeted cash outflows for inventories purchases are shown below:
Grimpen Ltd is preparing a cash budget for September to December. Budgeted sales receipts and budgeted cash outflows for inventories purchases are shown below: (click here to view financial information) The opening bank balance on 1 September is 12,547, and monthly expenses (other than depreciation) will continue at the August level of 100,133 per month for all months except November when they will increase to 400,552. All expenses are payable in the month following the expenditure. Required: Prepare Grimpen Ltd's cash budget for September to December. ?(Fill in the relevant cells with its corresponding figures. Negative figures should be entered in brackets.) Complete the information in the following table: (Fill in the relevant cells with its corresponding figures. Negative figures should be entered in brackets. Some information for September has already been inserted) Sales receipts (A) Inventories purchased Expenses Total payments (B) Cash surplus or (deficit) (A - B) Opening bank balance Closing bank balance September October 188.205 (37,841) 12.547 November December More info Budgeted sales receipts: September October November December Sales receipts () 188,205 79,110 81,438 338,604 Budgeted cash outflows for inventory purchases: September October November December Inventories purchased (E) (37,641) (15,822) (54,495) (45,515) Print Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started