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

Preparing a financial budget—budgeted income statement and balance sheet

Buncomb Companyhas 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,700 Budgeted purchases of merchandise inventory,

all on account 61,200 Budgeted cost of goods sold 60,850 Budgeted selling and administrative expenses: Commissions expense 6,085 Salaries expense 3,000 Rent expense 4,100 Depreciation expense 900 Insurance expense 300 Budgeted cash receipts from customers 126,450 Budgeted cash payments for merchandise inventory 67,925 Budgeted cash payments for salaries and commissions 14,836 Budgeted income tax expense 4,700 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 $41,415.
  2. Total of balance sheet is $97,890

Step by step solution

01

Preparation of Income statement

BUNCOMB Company

Income Statement

For the quarter ended March 31, 2019

March Quarter

Net sales revenue

$121,700

Cost of goods sold

$61,200

Gross profit

$60,500

Selling and administrative expenses

$14,385

Operating income

$46,115

Income tax

$4,700

Net income

$41,415

02

Preparation of Balance sheet

BUNCOMB Company

Budgeted Balance Sheet

For the quarter ended March 31, 2019

Assets

Current Assets:

Cash

$54,989

Accounts Receivables

$16,451

Raw material inventory

$12,132

Prepaid insurance

$2,100

Total current assets

Property, plant, and equipment

Equipment

$30,000

Less: Accumulated depreciation

($20,900)

$9,100

Total Assets

$97,890

Liabilities

Current Liabilities:

Accounts payable

$19,275

Stockholder’s Equity

Common stock, no par

$14,000

Retained earnings

64,615

Total stockholder’s equity

$78,615

Total liabilities and stockholder’s equity

$97,890

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

Preparing an operating budget—sales and production budgets

Lugo Company manufactures drinking glasses. One unit is a package of eight glasses, which sells for $30. Lugo projects sales for April will be 2,000 packages, with sales increasing by 250 packages per month for May, June, and July. On April 1, Lugo has 325 packages on hand but desires to maintain an ending inventory of 20% of the next month’s sales. Prepare a sales budget and a production budget for Lugo for April, May, and June.

Question: One benefit of budgeting is coordination and communication. Explain what this means.

Using sensitivity analysis Rucker Company prepared the following budgeted income statement for 2019:

Requirements

1. Prepare a budgeted income statement with columns for 700 units, 1,300 units, and 1,700 units sold.

2. How might managers use this type of budgeted income statement?

3. How might spreadsheet software such as Excel assist in this type of analysis?

What are the three sections of the cash budget?

Question:Brooks Company expects to sell 8,500 units for \(175 each for a total of \)1,487,500 in January and 2,500 units for \(200 each for a total of \)500,000 in February. The company expects cost of goods sold to average 70% of sales revenue, and the company expects to sell 4,700 units in March for \(280 each. Brooks’s target ending inventory is \)20,000 plus 50% of the next month’s cost of goods sold. Prepare Brooks’s inventory, purchases, and cost of goods sold budget for January and February

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