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. 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 (actual), $1,310,000; and July (budgeted), $1,590,000. Payments on merchandise purchases: 90% in the month of purchase and 10% in the month following purchase. Purchases amounts are: June (actual), $420,000; and July (budgeted), $700,000. Budgeted cash payments for salaries in July: $300,000. Budgeted depreciation expense for July: $14,000. Other cash expenses budgeted for July: $120,000. Accrued income taxes due in July: $70,000. Bank loan interest paid in July: $9,500.

Solutions

Expert Solution

Solution:

Calculation of Cash Receipts from sales in the month of July

Particulars

Amount ($)

For Sales in May (25%)

487,500

For Sales in June (50%)

655,000

For Sales in July (25%)

397,500

Total Cash Receipts from Sales in the month of July

1,540,000

Calculation of Cash Payments for purchases in the month of July

Particulars

Amount ($)

For Purchases in June (10%)

42,000

For Purchases in July (90%)

630,000

Total Cash Payments for Purchases in the month of July

672,000

Cash Budget for the month of July

Particulars

Amount ($)

Amount ($)

Beginning Cash Balance

66,000

Cash Receipts from Sales

1,540,000

Total Cash available

1,606,000

Cash Payments:

          For Purchases

672,000

          Salaries

300,000

          Other Cash expenses

120,000

          Accrued Income taxes

70,000

          Bank Loan Interest

9,500

Total Cash Payments

1,171,500

Ending Cash Balance

434,500


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: $68,000. 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...
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