Question

In: Accounting

Use the following information to prepare the July cash budget for Acco Co. It should show...

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.

  1. Beginning cash balance on July 1: $68,000.
  2. Cash receipts from sales: 20% is collected in the month of sale, 50% in the next month, and 30% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are May (actual), $1,800,000; June (actual), $1,470,000; and July (budgeted), $1,470,000.
  3. Payments on merchandise purchases: 55% in the month of purchase and 45% in the month following purchase. Purchases amounts are: June (actual), $550,000; and July (budgeted), $620,000.
  4. Budgeted cash payments for salaries in July: $250,000.
  5. Budgeted depreciation expense for July: $13,000.
  6. Other cash expenses budgeted for July: $200,000.
  7. Accrued income taxes due in July: $100,000.
  8. Bank loan interest paid in July: $6,500.

Solutions

Expert Solution

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.


Related Solutions

Use the following information to prepare the July cash budget for Acco Co. It should show...
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. Beginning cash balance on July 1: $66,000. Cash receipts from sales: 25% is collected in the month of sale, 50% in the next month, and 25% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are May (actual), $1,950,000; June...
Use the following information to prepare the July cash budget for Anker Co. It should show...
Use the following information to prepare the July cash budget for Anker Co. It should show expected cash receipts and cash disbursements for the month and the cash balance expected on July 31. a. Beginning cash balance on July 1: $63,000. b. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual),...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from sales: 21% is collected in the month of sale, 50% in the next month, and 29% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,548,000; June (actual), $1,080,000; and July (budgeted), $1,260,000. Payments on merchandise purchases: 42% in the month of purchase and 58% in the month following purchase. Purchases amounts are: June...
Following information relates to Acco Co. Beginning cash balance on July 1: $35,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $35,000. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,204,000; June (actual), $840,000; and July (budgeted), $980,000. Payments on merchandise purchases: 60% in the month of purchase and 40% in the month following purchase. Purchases amounts are: June...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from sales: 24% is collected in the month of sale, 50% in the next month, and 26% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,548,000; June (actual), $1,080,000; and July (budgeted), $1,260,000. Payments on merchandise purchases: 48% in the month of purchase and 52% in the month following purchase. Purchases amounts are: June...
Following information relates to Acco Co. Beginning cash balance on July 1: $35,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $35,000. Cash receipts from sales: 27% is collected in the month of sale, 50% in the next month, and 23% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,204,000; June (actual), $840,000; and July (budgeted), $980,000. Payments on merchandise purchases: 54% in the month of purchase and 46% in the month following purchase. Purchases amounts are: June...
Use the following information to prepare a cash budget for December. The cash balance on December...
Use the following information to prepare a cash budget for December. The cash balance on December 1 is $53,400. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 77,000 $ 81,200 $ 87,800 Sales on account $ 435,000 $ 538,000 $ 644,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18%...
Based on the following data, prepare a cash budget (in proper form with labels) for July...
Based on the following data, prepare a cash budget (in proper form with labels) for July and August. Forecast sales May $12,000 June $15,000 July $16,000 August $12,000 Cash sales are 30% of total sales. Credit sales are collected as follows: 60% one month after the sale and 40% 2 months after the sale Accounts payable are paid 100% 2 months after the purchase Expected A/P May $4,500 June $6,500 July $7,000 August $8,000 In addition to purchases, there are...
Cross Co is preparing a cash budget for July. The following estimates were made : a....
Cross Co is preparing a cash budget for July. The following estimates were made : a. expected cash balance , July 1, $5,000. b. income tax rate is 40%, based on accounting infomce for the month, payable in the following month. c. Cross Co's customers pay for 50% of their purchases during the month of purchases and the balance during the following month . Bad debt expected to be 2%. d. merchandise is purchased on account for resale, with 25%...
The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is...
The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is available: Projected cash sales:   $10,000 each month Projected credit sales: $ 8,000 each month One half of the credit sales are collected in the month of sale, and the remainder collected in the following month (there are no uncollectible accounts). Accounts receivable on April 1st were $3,000. Operating expenses (paid in cash): $20,000 for April, and $13,000 for each of the following two months....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT