Question

Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31,...

Prepare Cash Budget from Budgeted Transactions

Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $97,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements:

1. For May, budgeted cash sales are $73,000 and budgeted credit sales are $513,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance collected in the month following sale.

2. Budgeted merchandise purchases for May are $293,000. (Merchandise purchases in April were $240,000.) In the month of purchase, 70% of merchandise purchases are paid for, and the balance is paid for in the following month.

3. Budgeted cash disbursements for salaries and operating expenses for May total $178,000.

4. During May, $25,000 of principal repayment and $4,000 of interest payment are due to the bank.

5. A $20,000 income tax deposit is due to the federal government during May.

6. A new delivery truck will be purchased during May for $7,800 cash and an $8,000 note payable. Depreciation for May will be $560.

Prepare a cash budget for Campton Company for the month of May 2019.

Campton Company
Cash Budget
For the Month Ended May 31, 2019
Beginning cash balance Answer
Cash receipts:
Cash sales Answer
Collections on credit sales Answer
Cash available Answer
Cash disbursements:
Payments for merchandise Answer
Salaries and operating expense payments Answer
Principal and interest payment Answer
Income tax deposit Answer
Payment on truck Answer
Total cash disbursements Answer
Ending cash balance Answer
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution Campton company Cash Budget for the Month Ended May 31, 2019 Amount ( 97,000 73,000 475, doo 645,200 277,100 BeginniWooking Notes 0 Collection on credit sale - to be LAPSERS Budgeted Credit sales (May) = $513,000 40% of credit sales collectother points> = - that Depreciation is a non cash expense is not included in cash budget. Payment on truck will be made only

Add a comment
Know the answer?
Add Answer to:
Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31,...

    Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $91,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements: 1. For May, budgeted cash sales are $67,000 and budgeted credit sales are $507,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance...

  • Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash...

    Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $77,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements: 1. For May, budgeted cash sales are $53,000 and budgeted credit sales are $493,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance collected in the month following sale....

  • Deacon Company is a merchadising company that is preparing a budget for the three-month period ended june 30th. The fol...

    Deacon Company is a merchadising company that is preparing a budget for the three-month period ended june 30th. The following information is available Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity...

  • 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. a. Beginning cash balance on July 1: $68,000 b. Cash receipts from sales: 35% is collected in the month of sale, 50% in the next month and 15% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual)...

  • 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: $50,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,720,000; June...

  • Prepare a cash budget for the month ended on March 31 for Gado Company. The budget should show expected cash receipts and cash disbursements for the month of March and the balance expected on March 31.

    Use the following information:a. Beginning cash balance on March 1, $80,000.b. Cash receipts from sales, $303,000.c. Budgeted cash payments for direct materials, $135,000.d. Budgeted cash payments for direct labor $75,000.e. Other budgeted cash expenses, $36,000.f. Cash repayment of bank loan, $16,000.Prepare a cash budget for the month ended on March 31 for Gado Company. The budget should show expected cash receipts and cash disbursements for the month of March and the balance expected on March 31.

  • 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. a. Beginning cash balance on July 1: $65,000. b. 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),...

  • Purchases Budget in Units and Dollars Budgeted sales of Wirtz Music Shop for the first six...

    Purchases Budget in Units and Dollars Budgeted sales of Wirtz Music Shop for the first six months of 2017 are as follows: Month Unit Sales Month Unit Sales January 155,000 April 240,000 February 185,000 May 205,000 March 225,000 June 265,000 Beginning inventory for 2017 is 35,000 units. The budgeted inventory at the end of a month is 40 percent of units to be sold the following month. Purchase price per unit is $5. Prepare a purchases budget in units and...

  • Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...

    Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 62,000 43,600 46,000 107,000 $ 258,600 $ 63,600 70,000 125,000 $ 258, 600 Budgeted Income Statements April Sales $120,000 Cost of goods...

  • Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...

    Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available $ Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity 65,200 38,800 43,300 125,000 272,300 $ $ 66,200 70,000 136,100 272,300 $ Budgeted Income Statements April Sales $111,000 Cost of goods sold...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT