Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $74,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 $50,000 and budgeted credit sales are $490,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 $270,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 $155,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 $4,000 cash and an $8,000 note payable. Depreciation for May will be $450. 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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

not graded... please help Prepare Cash Budget from Budgeted Transactions 

Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $74,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 $50,000 and budgeted credit sales are $490,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 $270,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 $155,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 $4,000 cash and an $8,000 note payable. Depreciation for May will be $450.

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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education