Financial and Managerial Accounting (Looseleaf) (Custom Package)
Financial and Managerial Accounting (Looseleaf) (Custom Package)
6th Edition
ISBN: 9781259754883
Author: Wild
Publisher: MCG
bartleby

Concept explainers

Question
Book Icon
Chapter 20, Problem 25E
To determine

Budgeted Income Statement:

It is the statement which presents the budgeted sales and expenses of an entity of a particular period. It is an estimated income statement of future period.

To Prepare: Budgeted Income Statement and Budgeted balance sheet.

Expert Solution & Answer
Check Mark

Explanation of Solution

    Company A
    Budgeted Income Statement
    Particulars July Amount ($)
    Sales (Given) 1,400,000
    Less: Cost of goods sold (working note 1) 770,000
    Gross profit [ A ] 630,000
    Less: Expenses:
    Salaries (working note 2) 285,000
    Depreciation (Given) 36,000
    Other expenses (Given) 200,000
    Interest on loan (Given) 6,600
    Total expenses [ B ] 527,600
    Income before taxes 102,400
    Less: Income tax@30% (Working Note 3) 30,720
    Net income after taxes 71,680
    Table (1)

Working Note 1:

Formula to calculate cost of goods sold,

    Cost of goods sold=Sales×55%

Sale is $1,400,000(given).

Substitute $1,400,000 for sales,

    Cost of goods sold=$1,400,000×55% =$770,000

Working Note 2:

Calculation of salaries,

Given,
Cash paid for salaries is $275,000.
Salary of June is $50,000.
Salary of July is $60,000.

    Salaries for July=( Salaries paid+closing balance of salary opening balance of salary ) =$275,000+$60,000$50,000 =$285,000

Working Note 3:

Calculation of income tax,

Given,
Income before tax is $102,400.
Rate of income tax is 30%.

    Income tax=Net income before taxes×rate of tax =$102,400×30%. =$30,720
    Company A
    Balance sheet for the month ended 31st July
    Particulars Amount ($) Amount ($)
    Assets:
    Cash (working note 4) 122,400
    Account receivable (working note 5) 1,220,000
    Merchandise inventory (given) 60,000
    Total current assets 1,402,000
    Equipment (given) 1,600,000
    Less: Accumulated depreciation 316,000 1,284,000
    Total Assets 2,686,400
    Liabilities and Equities:
    Account payable (working note 8) 300,000
    Salaries payable (given) 60,000
    Income tax payable (Working Note 3) 30,720
    Total Current liabilities 390,720
    Bank loan (given) 660,000
    Total liabilities 1,050,720
    Common stock (given) 600,000
    Retained earnings (working note 9) 1,035,680
    Total stakeholder’s equity 1,635,680
    Total Liabilities and Equities 2,686,400
    Table (2)

Working Note 4:

    Company A
    Cash
    Particulars July Amount ($)
    Beginning cash balance 50,000
    Add: Cash receipts (working note 7) 1,364,000
    Total cash available [ A ] 1,414,000
    Less: Cash disbursement
    Payments for purchases (working note 6) 730,000
    Salaries 275,000
    Other expense 200,000
    Accrued taxes 80,000
    Interest on loan 6,600
    Total Cash disbursement [ B ] 1,291,600
    Ending cash balance [ AB ] 122,400
    Table (3)

Working Note 5:

Calculation of account receivables,

    Account receivable=( Previous month sale×20% )+( Current month sale ×70% ) =( $1,200,000×20% )+( $1,400,000×70% ) =$240,000+$980,000 =$1,220,000

Working Note 6:

    Payments for purchases
    Particulars July Amount ($)
    June purchases ( 700,000×40% ) 280,000
    July purchases ( 750,000×60% ) 450,000
    Total 730,000
    Table (4)

Working Note 7:

    Cash receipts from sales
    Particulars July Amount ($)
    May sales ( 1,720,000×20% ) 344,000
    June sales ( 1,200,000×50% ) 600,000
    July sales ( 1,400,000×30% ) 420,000
    Total 1,364,000
    Table (5)

Working Note 8:

Calculation of account payables,

    Account payable=Current month purchase×40% =$750,000×40% =$300,000

Working Note 9:

    Company A
    Retained earnings
    Particulars July Amount ($)
    Beginning retained earnings (Given) 964,000
    Add: Net income 71,680
    Ending retained earnings 1,035,680
    Table (6)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 20 Solutions

Financial and Managerial Accounting (Looseleaf) (Custom Package)

Ch. 20 - How does budgeting help management coordinate and...Ch. 20 - Why is the sales budget so important to the...Ch. 20 - What is the selling expense budget? What is the...Ch. 20 - Budgeting promotes good decision making by...Ch. 20 - GOOGLE Google prepares a cash budget. What is a...Ch. 20 - Prob. 11DQCh. 20 - Prob. 12DQCh. 20 - Prob. 13DQCh. 20 - Prob. 14DQCh. 20 - Prob. 1QSCh. 20 - Prob. 2QSCh. 20 - Prob. 3QSCh. 20 - Prob. 4QSCh. 20 - Prob. 5QSCh. 20 - Prob. 6QSCh. 20 - Prob. 7QSCh. 20 - Prob. 8QSCh. 20 - Prob. 9QSCh. 20 - Prob. 10QSCh. 20 - Prob. 11QSCh. 20 - Prob. 12QSCh. 20 - Prob. 13QSCh. 20 - Prob. 14QSCh. 20 - Prob. 15QSCh. 20 - Manufacturing: Production budget P1 Atlantic Surf...Ch. 20 - Prob. 17QSCh. 20 - Prob. 18QSCh. 20 - Prob. 19QSCh. 20 - Cash receipts, with uncollectible accounts P2 The...Ch. 20 - Cash receipts, with uncollectible accounts P2 Well...Ch. 20 - Prob. 22QSCh. 20 - Prob. 23QSCh. 20 - Prob. 24QSCh. 20 - Prob. 25QSCh. 20 - Prob. 26QSCh. 20 - Prob. 27QSCh. 20 - Prob. 28QSCh. 20 - Prob. 29QSCh. 20 - Prob. 30QSCh. 20 - Prob. 31QSCh. 20 - Prob. 32QSCh. 20 - Prob. 1ECh. 20 - Prob. 2ECh. 20 - Prob. 3ECh. 20 - Prob. 4ECh. 20 - Exercise 20-5 Manufacturing: Direct labor budget...Ch. 20 - Prob. 6ECh. 20 - Prob. 7ECh. 20 - Prob. 8ECh. 20 - Prob. 9ECh. 20 - Prob. 10ECh. 20 - Prob. 11ECh. 20 - Prob. 12ECh. 20 - Prob. 13ECh. 20 - Prob. 14ECh. 20 - Prob. 15ECh. 20 - Prob. 16ECh. 20 - Prob. 17ECh. 20 - Prob. 18ECh. 20 - Prob. 19ECh. 20 - Prob. 20ECh. 20 - Prob. 21ECh. 20 - Prob. 22ECh. 20 - Prob. 23ECh. 20 - Prob. 24ECh. 20 - Prob. 25ECh. 20 - Prob. 26ECh. 20 - Prob. 27ECh. 20 - Prob. 28ECh. 20 - Prob. 29ECh. 20 - Prob. 30ECh. 20 - Prob. 31ECh. 20 - Prob. 32ECh. 20 - Prob. 33ECh. 20 - Prob. 34ECh. 20 - Prob. 1PSACh. 20 - Prob. 2PSACh. 20 - Prob. 3PSACh. 20 - Prob. 4PSACh. 20 - Prob. 5PSACh. 20 - Prob. 6PSACh. 20 - Prob. 7PSACh. 20 - Prob. 8PSACh. 20 - Prob. 1PSBCh. 20 - Prob. 2PSBCh. 20 - Prob. 3PSBCh. 20 - Prob. 4PSBCh. 20 - Prob. 5PSBCh. 20 - Prob. 6PSBCh. 20 - Prob. 7PSBCh. 20 - Prob. 8PSBCh. 20 - Prob. 20SPCh. 20 - Prob. 1BTNCh. 20 - Prob. 2BTNCh. 20 - ETHICS CHALLENGE C1 BTN 20-3 Both the budget...Ch. 20 - Prob. 4BTNCh. 20 - Prob. 5BTNCh. 20 - Prob. 6BTNCh. 20 - Prob. 7BTNCh. 20 - Prob. 8BTNCh. 20 - Prob. 9BTN
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education