Preparing a financial budget—budgeted income statement and balance sheet Ball Company has the following post-closing trial balance on December 31, 2018:

The company’s accounting department has gathered the following budgeting information for the first quarter of 2019:

Budgeted total sales, all on account $ 121,800 Budgeted purchases of merchandise inventory, all on account 60,400 Budgeted cost of goods sold 60,900 Budgeted selling and administrative expenses:

Commissions expense 6,090 Salaries expense 7,000 Rent expense 4,100 Depreciation expense 600 Insurance expense 400 Budgeted cash receipts from customers 125,840 Budgeted cash payments for merchandise inventory 67,775 Budgeted cash payments for salaries and commissions 14,822 Budgeted income tax expense 5,400 Additional information: Rent and income tax expenses are paid as incurred. Insurance expense is an expiration of the prepaid amount.

Requirements

  1. Prepare a budgeted income statement for the quarter ended March 31, 2019.
  2. 2. Prepare a budgeted balance sheet as of March 31, 2019.

Short Answer

Expert verified
  1. The net income is $37,310.
  2. The total of balance sheet is $146,235

Step by step solution

01

Preparation of Income statement

Ball Company

Income Statement

For the quarter ended March 31, 2019

March Quarter

Net sales revenue

$121,800

Cost of goods sold

$60,900

Gross profit

$60,900

Selling and administrative expenses

$18,190

Operating income

$42,710

Income tax

$5,400

Net income

$37,310

02

Preparation of Balance sheet

Ball Company

Budgeted Balance Sheet

For the quarter ended March 31, 2019

Assets

Current Assets:

Cash

$56,743

Accounts Receivables

$27,960

Raw material inventory

$12,132

Total current assets

Property, plant, and equipment

Equipment

$60,000

Less: Accumulated depreciation

($10,600)

$49,400

Total Assets

$146,235

Liabilities

Current Liabilities:

Accounts payable

$16,625

Stockholder’s Equity

Common stock, no par

$18,000

Retained earnings

$111,610

Total stockholder’s equity

$129,610

Total liabilities and stockholder’s equity

$146,235

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

What is the formula used to determine the amount of merchandise inventory to be purchased?

Preparing a financial budget

This problem continues the Piedmont Computer Company situation from Chapter 21. Assume Piedmont Computer began January with \(15,000 cash. Management forecasts that cash receipts from credit customers will be \)48,000 in January and \(51,000 in February. Projected cash payments include equipment purchases (\)20,000 in January and \(41,000 in February) and selling and administrative expenses (\)2,000 each month).

Piedmont Computer Company’s bank requires a \(26,000 minimum balance in the firm’s checking account. At the end of any month when the account balance falls below \)26,000, the bank automatically extends credit to the firm in multiples of \(5,000. Piedmont Computer Company borrows as little as possible and pays back loans each month in \)1,000 increments, plus 12% interest on the entire unpaid principal. The first payment occurs one month after the loan.

Requirements

1. Prepare Piedmont Computer Company’s cash budget for January and February 2020.

2. How much cash will Piedmont Computer Company borrow in February if cash receipts from customers that month total \(41,000 instead of \)51,000?

Preparing an operating budget—sales budget

Trailers sells its rock-climbing shoes worldwide. Trailers expects to sell 6,500 pairs of shoes for \(185 each in January and 4,000 pairs of shoes for \)220 each in February. All sales are cash only. Prepare the sales budget for January and February.

Question: Meeks Company has the following sales for the first quarter of 2019:

January February March Cash sales \( 5,000 \) 5,500 \( 5,250 Sales on account 15,000 14,000 14,500 Total sales \) 20,000 \( 19,500 \) 19,750 Sales on account are collected the month after the sale. The Accounts Receivable balance on January 1 is $12,500, the amount of December’s sales on account. Calculate the cash receipts from customers for the first three months of 2019.

Preparing a financial budget—schedule of cash receipts and schedule of cash payments

Agua Cool is a distributor of bottled water. For each of the items, compute the amount of cash receipts or payments Agua Cool will budget for September. The solution to one item may depend on the answer to an earlier item.

a. Management expects to sell equipment that cost \(14,000 at a gain of \)7,000. Accumulated depreciation on this equipment is \(5,000.

b. Management expects to sell 7,100 cases of water in August and 9,000 cases in September. Each case sells for \)14. Cash sales average 20% of total sales, and credit sales make up the rest. Three-fourths of credit sales are collected in the month of the sale, with the balance collected the following month.

c. The company pays rent and property taxes of $4,500 each month. Commissions and other selling expenses average 30% of sales. Agua Cool pays one-half of commissions and other selling expenses in the month incurred, with the balance paid the following month.

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