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

What are the two types of manufacturing overhead? How do they affect the manufacturing overhead budget calculations?

What is the formula used to determine the number of units to be produced?

Match the following statements to the appropriate budgeting objective or benefit: developing strategies, planning, directing, controlling, coordinating and communicating, and benchmarking.

1. Managers are required to think about future business activities.

2. Managers use feedback to identify corrective action.

3. Managers use results to evaluate employees’ performance.

4. Managers work with managers in other divisions.

Preparing a financial budget—schedule of cash receipts, sensitivity analysis

Marcel Company projects the following sales for the first three months of the year: \(11,200 in January; \)12,300 in February; and $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar.

Requirements

1. Prepare a schedule of cash receipts for Marcel for January, February, and March. What is the balance in Accounts Receivable on March 31?

2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31?

11. Kendall Company projects 2019 first quarter sales to be $10,000 and increase by 5% per quarter. Determine the projected sales for 2019 by quarter and in total. Round answers to the nearest dollar.

12. Friedman Company manufactures and sells bicycles. A popular model is the XC. The company expects to sell 1,500 XCs in 2018 and 1,800 XCs in 2019. At the beginning of 2018, Friedman has 350 XCs in Finished Goods Inventory and desires to have 10% of the next year’s sales available at the end of the year. How many XCs will Friedman need to produce in 2018?

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