Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Beginning cash balance on July 1: $30,000. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and

  1. Beginning cash balance on July 1: $30,000.
  2. 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,032,000; June (actual), $720,000; and July (budgeted), $840,000.
  3. Payments on merchandise purchases: 60% in the month of purchase and 40% in the month following purchase. Purchases amounts are: June (actual), $258,000; and July (budgeted), $600,000.
  4. Budgeted cash payments for salaries in July: $126,600.
  5. Budgeted depreciation expense for July: $7,200.
  6. Other cash expenses budgeted for July: $90,000.
  7. Accrued income taxes due in July: $80,000.
  8. Bank loan interest paid in July: $3,960.

Additional Information:

  1. Cost of goods sold is 44% of sales.
  2. Inventory at the end of June is $48,000 and at the end of July is $278,400.
  3. Salaries payable on June 30 are $30,000 and are expected to be $24,000 on July 31.
  4. The equipment account balance is $960,000 on July 31. On June 30, the accumulated depreciation on equipment is $168,000.
  5. The $3,960 cash payment of interest represents the 1% monthly expense on a bank loan of $396,000.
  6. Income taxes payable on July 31 are $99,456, and the income tax rate is 40%.
  7. The only other balance sheet accounts are: Common Stock, with a balance of $328,000 on June 30; and Retained Earnings, with a balance of $643,200 on June 30.

Prepare a budgeted income statement for the month of July and a budgeted balance sheet for July 31.

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

Calculation of Cash Receipts From Sales Collected in-- Total Sales May June July 31 Accounts Rec. July Credit sales from: May $ June 1,032,000 720,000 840,000 2,592,000 July Totals $ EA 0 $ 0 $ 0 $ 0 Calculation of Cash Payments for Merchandise --Paid in July 31 Total Purchases June July Accounts Pay. Purchases from: June $ July 258,000 600,000 858,000 Totals $ $ 0 $ 0 $ 0 ACCO CO. Budgeted Income Statement For Month Ended July 31 Operating expenses: Total operating expenses 0 $ Budgeted Balance Sheet As of July 31 Assets 0 Liabilities and Equity Liabilities Liabilities and Equity Liabilities Stockholders' Equity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Auditing Issues And Cases

Authors: Michael Chris Knapp

3rd Edition

0538891173, 9780538891172

More Books

Students also viewed these Accounting questions

Question

What is the relationship between ordering costs and setup costs?

Answered: 1 week ago

Question

=+1. What is the brand's character or personality?

Answered: 1 week ago

Question

=+3. Who is the audience?

Answered: 1 week ago

Question

=+4. What do they (audience members) currently think?

Answered: 1 week ago