Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Use the information in Exercise 20-25 and the following additional information to prepare a budgeted income statement for the month of July and a budgeted balance sheet for July 31.

a. Cost of goods sold is 55% of sales.

b. Inventory at the end of June is \(80,000 and at the end of July is \)60,000.

c. Salaries payable on June 30 are \(50,000 and are expected to be \)60,000 on July 31.

d. The equipment account balance is \(1,600,000 on July 31. On June 30, the accumulated depreciation on equipment is \)280,000.

e. The \(6,600 cash payment of interest represents the 1% monthly expense on a bank loan of \)660,000.

f. Income taxes payable on July 31 are \(30,720, and the income tax rate is 30%.

g. The only other balance sheet accounts are: Common Stock, with a balance of \)600,000 on June 30; and Retained Earnings, with a balance of $964,000 on June 30.

Short Answer

Expert verified

The budgeted income statement and the budgeted balance sheetfor Acco Company will be made afteradjusting the balances of additional information.

Step by step solution

01

Budgeted income statement

Acco Company

Budgeted income statement

For the month of July

Particulars

Amount

Sales

$1,400,000

Cost of goods sold

$770,000

Gross profit

$630,000

Operating expenses:

Salaries

$285,000

Depreciation

$36,000

Other cash expenses

$200,000

Bank loan interest

$6,600

Total operating expenses

$527,600

Income before income taxes

$102,400

Income tax expense

$30,720

Net Income

$71,680

02

Budgeted balance sheet

Acco Company

Budgeted balance sheet

For the month of July

Assets

Amount

Cash

$122,400

Accounts receivables

$1,220,000

Inventory

$60,000

Total current assets

$1,402,000

Equipment

$1,600,000

Accumulated depreciation

$316,000

Net equipment

$1,284,000

Total assets

$2,686,400

Liabilities and Equity

Amount

Liabilities

Accounts payable

$300,000

Salaries payable

$60,000

Income taxes payable

$30,720

Total current liabilities

$390,720

Bank loan payable

$660,000

Total liabilities

$1,050,720

Stockholder’s Equity

Common stock

$600,000

Retained earnings

$1,035,680

Total stockholder’s equity

$1,635,680

Total liabilities and equity

$2,686,400

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Use the following information to prepare a cash budget for the month ended on March 31 for Gado Company. The budget should show expected cash receipts and cash payments for the month of March and the balance expected on March 31.

a. Beginning cash balance on March 1, \(72,000.

b. Cash receipts from sales, \)300,000.

c. Budgeted cash payments for direct materials, \(140,000.

d. Budgeted cash payments for direct labor, \)80,000.

e. Other budgeted cash expenses, \(45,000.

f. Cash repayment of bank loan, \)20,000.

Lexi Company forecasts unit sales of 1,040,000 in April, 1,220,000 in May, 980,000 in June, and 1,020,000 in July. Beginning inventory on April 1 is 280,000 units, and the company wants to have 30% of next month’s sales in inventory at the end of each month. Prepare a merchandise purchases budget for the months of April, May, and June.

Question: Aztec Company sells its product for \(180 per unit. Its actual and budgeted sales follow

All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 28% in the second month after the sale, and 2% proves to be uncollectible. The product’s purchase price is \)110 per unit. 60% of purchases made in a month is paid in that month and the other 40% is paid in the next month. The company has a policy to maintain an ending monthly inventory of 20% of the next month’s unit sales plus a safety stock of 100 units. The April 30 and May 31 actual inventory levels are consistent with this policy. Selling and administrative expenses for the year are \(1,320,000 and are paid evenly throughout the year in cash. The company’s minimum cash balance at month-end is \)100,000. This minimum is maintained, if necessary, by borrowing cash from the bank. If the balance exceeds \(100,000, the company repays as much of the loan as it can without going below the minimum. This type of loan carries an annual 12% interest rate. On May 31, the loan balance is \)25,000, and the company’s cash balance is \(100,000. (Round amounts to the nearest dollar.)

Required

1. Prepare a schedule that shows the computation of cash collections of its credit sales (accounts receivable) in each of the months of June and July.

2. Prepare a schedule that shows the computation of budgeted ending inventories (in units) for April, May, June, and July.

3. Prepare the merchandise purchases budget for May, June, and July. Report calculations in units and then show the dollar amount of purchases for each month.

4. Prepare a schedule showing the computation of cash payments for product purchases for June and July.

5. Prepare a cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month.

Analysis Component

6. Refer to your answer to part 5. The cash budget indicates the company will need to borrow more than \)18,000 in June. Suggest some reasons that knowing this information in May would be helpful to management.

X-Tel budgets sales of \(60,000 for April, \)100,000 for May, and \(80,000 for June. In addition, sales commissions are 10% of sales dollars and the company pays a sales manager a salary of \)6,000 per month. Sales commissions and salaries are paid in the month incurred. Prepare a selling expense budget for April, May, and June.

Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of \(25 per unit. Sales (in units) are forecasted at 45,000 for January, 55,000 for February, and 50,000 for March. Cost of goods sold is \)14 per unit. Other expense information for the first quarter follows. Prepare a budgeted income statement for this first quarter. (Round expense amounts to the nearest dollar.)

Commissions . . . . . . . . . . . 8% of sales dollars

Rent . . . . . . . . . . . . . . . . . . \(14,000 per month

Advertising . . . . . . . . . . . . . 15% of sales dollars

Office salaries . . . . . . . . . . \)75,000 per month

Depreciation . . . . . . . . . . . . \(40,000 per month

Interest . . . . . . . . . . . . . . . . 5% annually on a \)250,000 note payable

Tax rate . . . . . . . . . . . . . . . . 30%

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free