Use the following information to prepare a budgeted balance sheet for Grover Company for the month of June. The budgeted net income for the month of June is $236,000. The beginning cash balance is $62,000; total budgeted cash receipts are $1,660,000; total budgeted cash disbursements are $1,580,000. Budgeted sales for June are $1,700,000. Collections are 40% in the month of sale and 60% in the month following. The projected inventory balance is 10% of the following month's sales. Sales for July are projected to be $1,750,000. Budgeted purchases for June are $900,000 to be paid 80% in the month of purchase and 20% in the month following. The equipment account balance is $1,400,000 on May 31. No equipment purchases or disposals were made during June. On May 31, the accumulated depreciation is $276,000. Depreciation expense for June is estimated to be $24,000. There is an outstanding loan balance of $800,000. Accrued income taxes payable for June 30 are $71,000; and salaries payable are $50,000. The only other balance sheet accounts are: Common Stock, with a balance of $800,000 on May 31, and Retained Earnings with a balance of $300,000 on May 31. No additional common stock was issued and no dividends were paid during June.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter9: Profit Planning And Flexible Budgets
Section: Chapter Questions
Problem 72P: Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for...
icon
Related questions
icon
Concept explainers
Question

Use the following information to prepare a budgeted balance sheet for Grover Company for the month of June.

  1. The budgeted net income for the month of June is $236,000.
  2. The beginning cash balance is $62,000; total budgeted cash receipts are $1,660,000; total budgeted cash disbursements are $1,580,000.
  3. Budgeted sales for June are $1,700,000. Collections are 40% in the month of sale and 60% in the month following.
  4. The projected inventory balance is 10% of the following month's sales. Sales for July are projected to be $1,750,000.
  5. Budgeted purchases for June are $900,000 to be paid 80% in the month of purchase and 20% in the month following.
  6. The equipment account balance is $1,400,000 on May 31. No equipment purchases or disposals were made during June. On May 31, the accumulated depreciation is $276,000. Depreciation expense for June is estimated to be $24,000.
  7. There is an outstanding loan balance of $800,000.
  8. Accrued income taxes payable for June 30 are $71,000; and salaries payable are $50,000.
  9. The only other balance sheet accounts are: Common Stock, with a balance of $800,000 on May 31, and Retained Earnings with a balance of $300,000 on May 31. No additional common stock was issued and no dividends were paid during June.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning