Ask Experts Questions for FREE Help !
Ask
    binnymann's Avatar
    binnymann Posts: 14, Reputation: 1
    New Member
     
    #1

    Jul 14, 2008, 07:44 AM
    Trial balance, income statement, retained earning, BS
    I need help with balancing my trial balance, Incoem statement, retained earnings, Balance sheet and check the journal entries..

    Trail Balance
    Accounts Dr. Cr.
    Cash 29,200
    Accounts Receivable 34,200
    Merchandise Inventory 45,000
    Store supplies 5,500
    Store equipments 85,000
    Accumulated amortization - Store equipment 18,000
    Delivery equipment 48,000
    Accumulated amortization - Delivery equipment 6,000
    Notes payable 41,000
    Accounts payable 58,500
    Common shares 100,000
    Retained earnings 8,000
    Sales 750,200
    Sales returns and allowances 4,200
    Cost of goods sold 497,400
    Salaries expenses 140,000
    Advertising expense 26,400
    Utilities expense 14,000
    Repair expense 12,100
    Delivery expense 16,700
    Rent expense 24,000
    Totals 981,700 981,700

    Adjustment data:
    1. Store supplies on hand totalled $3100.
    2. Amortization is $9000 on the store equipment and $7000 in delivery equip.
    3. Interest of $6000 is accrues on notes payable at Nov 30.

    Other data:
    1. Salaries expense is 70% selling and 30% administrative
    2. Rent expense and utilities expense are 30% administrative
    3. Of the notes payable $30,000 is due for payment next year
    4. Repair expense is 100% admin.

    Instructions:
    a. Enter the trial balance on worksheet and complete the work sheet
    b. Prepare multi steps Incoem statement, retained earnings and BS for Nov 30, 08
    c. Journalize the adjusting entry
    d. Journalize the closing entries
    e. Prepare a post closing trial balance.

    My answers


    1. Adjustments Adjusted Trial Balance
    Accounts Dr. Cr. Dr. Cr.
    Cash 29,200 29,200
    Accounts Receivable 34,200 34,200
    Merchandise Inventory 45,000 45,000
    Store supplies 1,900 3,100
    Store equipments 85,000
    Accumulated amortization - Store equipment 9,000 27,000
    Delivery equipment 48,000
    Accumulated amortization - Delivery equipment 7,000 13,000
    Notes payable 41,000
    Accounts payable 58,500
    Common shares 100,000
    Retained earnings 8,000
    Sales 750,200
    Sales returns and allowances 4,200
    Cost of goods sold 497,400
    Salaries expenses 140,000
    Advertising expense 26,400
    Utilities expense 14,000
    Repair expense 12,100
    Delivery expense 16,700
    Rent expense 24,000
    Totals

    Amortization expense-
    Store equipment 9,000 9,000
    Delivery equipment 7,000 7,000
    Interest receivable 6,000 6,000
    Interest revenue 6,000 6,000
    Store supplies 1,900
    Totals 23,900 23,900 1,001,300 1,003,700


    2. BHOPAL FASHION CENTRE INC.
    Income statement
    For the Year Ended November 30, 2008
    Dr Cr
    Sales 750,200
    Sales return 4,200
    Cost of goods sold 497,000
    Gross profit on sales 501,200
    249,000

    Seling expenses
    Salaries expense 98,000
    Rent expense 19,200
    Utlities expense 11,200
    Advertising expense 14,000
    Delivery expense 16,700
    Total selling 159,100
    Administrative expenses
    Salaries expense 42,000
    Rent expense 4,800
    Utlities expense 2,800
    Repair expense 121,200
    Total administrative expense 170,800
    Total selling and administrative expense 328,000
    Income from operations 577,000
    Other revenues and gains
    Interest revenue 6,000
    Interest expense 583,000
    6,000
    Income before taxes 580,800


    BHOPAL FASHION CENTRE INC.
    Statement of retained earnings
    For the Year Ended November 30, 2008
    Retained earnings 8,000
    Net Loss
    Retained earning Nov 30, 2008

    BHOPAL FASHION CENTRE INC.
    Balance Sheet
    As at November 30, 2008
    Assets
    Current assets
    Cash 29,200
    Accounts receivable 34,200
    Merchandise inventory 45,000
    Store supplies 5,500
    Total current assets 113,900
    Property, plant and equipment
    Store equipment 85,000
    Less: accumulated amortization 27,000
    58,000
    Delivery equipment 48,000
    Less: accumulated amortization 13,000
    35,000

    Total property, plant and equipment 93,000

    Total assets 206,900


    Liabilities and shareholder's equity
    Current liabilities
    Notes payable 41,000
    Less: interest accrued 6,000
    35,000
    Accounts payable 58,500

    Total liabilities 93,500

    Shareholder's equity
    Common shares 100,000
    Retained earnings
    Total shareholder's equity

    Total liability and shareholder's equity

    4. Adjusting entries
    Dr Cr
    a. Store supplies expense 3,100
    Store supplies 3,100

    b
    Amortization expense - store equipment 6,000
    Accumulated amortization - store equipment 6,000


    Amortization expense - delivery equipment 7,000
    Accumulated amortization - delivery equipment 700
    c
    Interest recievable 6,000
    Interest revenue 6,000


    4. (d) Closing entries
    Dr Cr
    a. Salaries expense 140000
    Selling expense 98000
    Administraive expense 42000

    b. Rent expense 24000
    Selling expense 19200
    Administraive expense 4800

    Utilities expense 14000
    Selling expense 11200
    Administraive expense 2800

    c. Notes payable expense 30,000
    Notes payable 30,000

    d. Repair expense 12,100
    Administrative expense 12,100

    5. BHOPAL FASHION CENTRE INC.
    post-closing trial balance November 30, 2008

    Trail Balance
    Accounts Dr. Cr.
    Cash 29,200
    Accounts Receivable 34,200
    Merchandise Inventory 45,000
    Store supplies 3,100
    Store equipments 85,000
    Accumulated amortization - Store equipment 27,000
    Delivery equipment 48,000
    Accumulated amortization - Delivery equipment 13,000
    Notes payable 41,000
    Accounts payable 58,500
    Common shares 100,000
    Retained earnings 8,000
    Sales 750,200
    Sales returns and allowances 4,200
    Cost of goods sold 497,400
    Salaries expenses 140,000
    Advertising expense 26,400
    Utilities expense 14,000
    Repair expense 12,100
    Delivery expense 16,700
    Rent expense 24,000
    Totals 979,300 997,700
    Criado's Avatar
    Criado Posts: 142, Reputation: 15
    Junior Member
     
    #2

    Jul 14, 2008, 08:20 AM
    I just check your adjusting entries.

    For number 1,
    $3,100 is on hand; this means that this figure is the ending balance.

    For number 2,
    Please check your book does it say accumulated amortization and amortization expense. It should be depreciation. By the way, I think you mistyped 9,000 as 6,000.

    For number 3,
    The acrrued interest arise from notes payable, therefore, it should be payable and expense recognition as well.

    I hope this helps. :)
    binnymann's Avatar
    binnymann Posts: 14, Reputation: 1
    New Member
     
    #3

    Jul 14, 2008, 08:37 AM
    It says amortozation, not depreciation. The amount for both amortization are $18000 and $6000 resp. What entry should be done for the notes payable?
    Also, if possible can you please check for my other statement please. I will really appreciate your help.
    Thanks
    Criado's Avatar
    Criado Posts: 142, Reputation: 15
    Junior Member
     
    #4

    Jul 14, 2008, 08:47 AM
    Amortization? Ok, then.

    I mean the 9,000 in your adjusting entry letter B.

    b
    Amortization expense - store equipment 6,000
    Accumulated amortization - store equipment 6,000
    You should debit Interest Expense and credit Interest Payable.
    binnymann's Avatar
    binnymann Posts: 14, Reputation: 1
    New Member
     
    #5

    Jul 14, 2008, 08:09 PM
    Thanks for your reply

    I apologize, the amortization is of $9000. What entry should I do for both ethe amortization for (b) adjusting entry

    For (a). I did the following entry
    Store supplies dr 3100
    Cash dr 3100


    For (c) , is the following entry correct:
    Interest Expense dr 6000
    Interest Payable cr 6000

    Also, can you please check my closing entries and also the post closing trial balance. I want to know what is exactly meant by post closing trail balance and how is it diff than the adjusted trial balance?

    Thanks
    Criado's Avatar
    Criado Posts: 142, Reputation: 15
    Junior Member
     
    #6

    Jul 14, 2008, 10:45 PM
    Your two adjusting entries for amortization are correct (after changing $6,000 to $9,000)

    Your letter (c) adjustment is also correct.

    For letter (a) adjustment, the accounts used are correct but the figures are not. The figure should be Supplies Beginning less Supplies Ending (on hand).
    binnymann's Avatar
    binnymann Posts: 14, Reputation: 1
    New Member
     
    #7

    Jul 15, 2008, 05:50 AM
    Great.. thanks a lot for your help Criado...
    Criado's Avatar
    Criado Posts: 142, Reputation: 15
    Junior Member
     
    #8

    Jul 15, 2008, 08:39 AM
    You're welcome :)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Multiple-step income statement in good form and retained earnings statement [ 1 Answers ]

Hi I would like someone to check to see if I did this correctly, if I did not then please help. Thanks The Problem is: The following pretax amounts pertain to River Corp. for the year ended December 31, 2008. Sales... $400,000 Operating Expenses... 84,000 Extraordinary gain... 30,000...

Retained earning balance [ 1 Answers ]

The fellowing selected amounts are available for Sanders Company Retained earnings beginning $1000 Net loss 100 Cash dividends declared 100 Stock dividends declared 50 What is its ending retained earnings balance? How don't understand how to work this problem. Can someone help me?

Prepare income statement and retained earning statement [ 1 Answers ]

The following information was taken from the 2004 financial statement of pharmecutical giant Merck and CO. All dollar amounts are in millions. Retained earnings, January 1, 2004 34,142.0 Materials and production expense 4,959.8 Marketing and administrative expense 7,346.3 Dividends 3,329.1...

Adjusting Trial Balance for Multi-Step Income Statement [ 1 Answers ]

I have been attempting this problem for about 4 hours, read through the chapter 3 times, and yet I can still not complete this question. :confused: Here is the excel template I looked up to view the format, which also includes the question: Kimmel, Weygandt, Kieso: Financial Accounting:...


View more questions Search