/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q53PGB Preparing a financial budget—b... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

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 91Ó°ÊÓ!

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

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

Match the budget types to the definitions.

Budget Types Definitions

5. Financial a. Includes sales, production, and cost of goods sold budgets

6. Flexible b. Long-term budgets

7. Operating c. Includes only one level of sales volume

8. Operational d. Includes various levels of sales volumes

9. Static e. Short-term budgets

10. Strategic f. Includes the budgeted financial statements

Preparing a financial budget—schedule of cash receipts

Berry expects total sales of \(359,000 in January and \)405,000 in February. Assume that Berry’s sales are collected as follows:

80% in the month of the sale

10% in the month after the sale

6% two months after the sales

4% never collected

November sales totaled \(350,000, and December sales were \)325,000. Prepare a schedule of cash receipts from customers for January and February. Round answers to the nearest dollar.

Preparing an operating budget—sales budget; inventory, purchases and COGS budget; and S&A expense budget Ballard Office Supply’s March 31, 2018, balance sheet follows:

The budget committee of Ballard Office Supply has assembled the following data.

a. Sales in April are expected to be \(160,000. Ballard forecasts that monthly sales will increase 2% over April sales in May. June’s sales will increase by 4% over April sales. July sales will increase 20% over April sales.

b. Ballard maintains inventory of \)7,000 plus 25% of the cost of goods sold budgeted for the following month. Cost of goods sold equal 50% of sales revenue.

c. Monthly salaries amount to \(3,000. Sales commissions equal 5% of sales for that month.

d. Other monthly expenses are as follows: • Rent: \)3,400 • Depreciation: \(800 • Insurance: \)300 • Income tax: $1,500

Requirements

1. Prepare Ballard’s sales budget for April and May 2018. Round all calculations to the nearest dollar.

2. Prepare Ballard’s inventory, purchases, and cost of goods sold budget for April and May.

3. Prepare Ballard’s selling and administrative expense budget for April and May.

Using sensitivity analysis in budgeting Riverbed Sporting Goods Store has the following sales budget:

Suppose June sales are expected to be \(81,000 rather than \)65,000. Revise Riverbed’s sales budget.

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.