In: Accounting
Use the following information to prepare the July cash budget
for Acco Co. It should show expected cash receipts and cash
payments for the month and the cash balance expected on July
31.
Cash budgeted statement were as follows:
Cash Budget | |
For the month of July Month | |
Particulars | Amount |
Beginning Balance as on 1st July | 68,000 |
Add : | |
Collection on May Month Sale | 540,000 |
Collection on June Month Sale | 735,000 |
Collection on July Month Sale | 294,000 |
1,637,000 | |
Less: | |
Payment on June Month Purchase | (247,500) |
Payment on July Month Purchase | (341,000) |
Cash Payment on Salaries | (250,000) |
Cash Payment on Other Expenses | (200,000) |
598,500 |
Workings were as follows
Particulars | Amount | Percentage of Collection on July | Amount of Collection in July |
May Sales | 1,800,000 | 30% | 540,000 |
June Sales | 1,470,000 | 50% | 735,000 |
July sales | 1,470,000 | 20% | 294,000 |
June Purchase | 550,000 | 45% | 247,500 |
July Purchase | 620,000 | 55% | 341,000 |
Salaries | 250,000 | ||
Other Cash Expense | 200,000 |
Depreciation is non cash expenditure will not affect cash balance
Accrured income tax is not paid yet. So not affect the cash transactions
Bank loan interest is banking transaction and question didnt mention that cash deposit is done for the transaction. So this is too ommitt from the statement.