Schedule of Expected Cash Collections
Schedule of expected cash collections from customers shows the budgeted cash collections on sales during a period. It is a component of master budget and it is prepared after the preparation of sales budget and before the preparation of cash budget.
The calculation of expected cash collections is based on the total sales figure obtained from sales budget. The management estimates the proportion in which sales are expected to be collected in the current and following periods. This is used to determine how much sales are expected to be collected during a period.
Format and Example
The master budget of Company A continues here with the preparation of schedule of expected cash collections. The sales figures are obtained from the sales budget of the company. 70% of sales are expected to be collected in the quarter in which sales are made and the rest are expected to be collected in the next period. Bad debts are negligible.
a) Q1 Sales = $120,120
Collections in Q1 = $120,120 × 70% = $84,084; Collections in Q2 = $120,120 × 30% = $36,036
b) Q2 Sales = $87,768
Collections in Q2 = $87,768 × 70% = $61,438; Collections in Q3 = $87,768 × 30% = $26,330
c) Q3 Sales = $106,991
Collections in Q3 = $106,991 × 70% = $74,894; Collections in Q4 = $106,991 × 30% = $32,097
d) Q4 Sales = $197,792
Collections in Q4 = $197,792 × 70% = $138,454
Company A | |||||
Schedule of Expected Cash Collections | |||||
For the Year Ending December 30, 2010 | |||||
Quarter | |||||
1 | 2 | 3 | 4 | Year | |
Beginning AR | $62,130 | $62,130 | |||
Quarter 1 Sales (a) | 84,084 | $36,036 | 120,120 | ||
Quarter 2 Sales (b) | 61,438 | $26,330 | 87,768 | ||
Quarter 3 Sales (c) | 74,894 | $32,097 | 106,991 | ||
Quarter 4 Sales (d) | 138,454 | 138,454 | |||
Total Collections | $146,214 | $97,474 | $101,224 | $170,551 | $515,463 |
by Irfanullah Jan, ACCA and last modified on