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

    Apr 1, 2007, 06:49 PM
    Multi-step income statement
    Bug-Off Exterminators provides pest control services and sells extermination products manufacture by other companies. The following table contains the company’s unadjusted trial balance as of December 31, 2005, the end of the company fiscal year.
    BUG-OFF EXTERMINATORS - December 31, 2005
    Unadjusted Trial Balance

    Cash $17,000
    Accounts receivable 4,000
    Allowance for doubtful accounts 828
    Promissory note 30,000
    Merchandise inventory 11,700
    Trucks 32,000
    Accum. Depreciation-Trucks 0
    Equipment 45,000
    Accum. Depreciation - Equipment 12,200

    Accounts payable 5,000
    Estimated warranty liability 1,400
    Unearned services revenue 3,840
    Long-term notes payable 15,000
    Interest payable 0
    Common Stock 10,000
    Retained earnings 71,026
    Dividends 10,000
    Extermination services revenue 60,000
    Interest revenue 872
    Sales (of merchandise) 75,860
    Cost of goods sold 46,300
    Depreciation expense - Trucks
    Depreciation expense - Equipment 0
    Wages expense 35,000
    Interest expense 0
    Rent Expense 9,000
    Bad debts expense 0
    Miscellaneous expense 1,226
    Repairs expense 8,000
    Utilities expense 6,800
    Warranty expense 0
    _______ ________
    Totals $256,026 $256,026


    The following information applies to the company for the month of December, 2005.
    a. The bank reconciliation as of December 31, 2005, includes these facts;
    Balance per bank……………………………………………….. $ 15,447
    Balance per books…………………………………………………17,000
    Outstanding checks……………………………………………….. 1,800
    Deposit in transit………………………………………………….. 2,450
    Interest earned (on bank account)………………………………… 52
    Bank service charges (miscellaneous expense)…………………… 15
    NSF Check(Customer Accounts) 200
    Reported on the bank statement is a canceled check for $740 in payment of an outstanding accounts payable that the company failed to record.

    b. An examination of customers’ accounts shows that accounts totaling $350 should be written off as uncollectible. Using an aging of receivables, the company determines that the ending balance of the Allowance for Doubtful Accounts should be ($1,000).

    c. A truck purchased and placed in service on June 1, 2005. Its cost is being depreciated with the double declining balance method using these facts and estimates:
    Original cost………………….. $ 32,000
    Expected salvage value………. 3,500
    Useful life (years)……………. 5

    d. Two items of equipment (a sprayer and an injector) were purchased and put into service in early January 2004. They are being depreciated with the straight-line method using these facts and estimates:

    Sprayer Injector
    Original Cost $27,000 $18,000
    Expected salvage value 3,000 2,500
    Useful life (years) 5 8

    e. On January 1, 2005, the company was paid $3,840 in advance to provide monthly service for an apartment complex for one year. The company began providing the services on May 1.

    f. The company offers a warranty for the services it sells. The expected cost of providing warranty service is 2% of the extermination services revenue of $61,600 for 2005. No warranty expense has been recorded for 2005. All costs of servicing warranties in 2005 were properly charged to the Estimated Warranty Liability account.

    g. The $15,000 long-term note listed on the trial balance is 8%, five-year, interest-bearing note with interest payable annually on December 31. The note was signed with First National Bank on December 31, 2005.

    h. The ending inventory of merchandise is counted and determined to have a cost of $10,590. Bug-Off uses a periodic inventory system. Hint: The inventory count is performed on Dec. 31, and is the final entry before the closing entries.

    Go to next page



    I. The company purchased the following items, on credit, for its merchandise inventory,
    Terms: 1%/30, n/60:
    12/3 100 cases for $11,900
    12/7 100 cases for $11,700
    12/14 100 cases for $11,400
    12/21 100 cases for $11,300

    j. Sales are as follows, on credit:
    12/5 100 cases for $17,757
    12/12 100 cases for $17,757
    12/19 100 cases for $17,756
    12/28 100 cases for $17,756

    k. The company uses FIFO to record the Cost of Goods sold.

    l. The company, on 12/31 discounts the promissory note at the local bank. The note was created on 06/30/05 with a term of one year, and an interest rate of 8%. The bank’s discount rate is 12%.

    m. The Company on 12/31 pays for the cases purchased on 12/3 and 12/7


    REQUIRED
    1. Prepare a multi-step income statement, a statement of retained earnings (cash dividends declared during 2005 were $10,000), and a classified balance sheet for the Year Ended December 31, 2005.

    2. Determine the following ratios:
    Return on assets
    Debt ratio
    Profit margin (Percent)
    Current ratio
    Acid-test ratio
    Gross margin (Percent)
    Inventory turnover ratio
    Days’ sales in inventory
    A/R turnover ratio
    Days’ sales uncollected
    Reply With Quote
    ineedhelp777's Avatar
    ineedhelp777 Posts: 1, Reputation: 1
    New Member
     
    #2

    Apr 8, 2010, 05:52 PM

    Did u figure this out?
    I was just assigned this same thing
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #3

    Apr 10, 2010, 11:46 AM

    First you need to journalize entries a through m, which are adjusting entries, then you need to prepare an adjusted trial balance, then you can do a multi-step income statement.

    a. You have 4 entries here, interest earned, bank service charges, NSF, and canceled check that was not recorded.

    b. write off the uncollectible amount

    c. & d. compute depreciation expense and journalize

    e. Compute how much unearned revenue has been earned and journalize.

    f. compute warranty expense and journalize

    g. Compute interest expense and journalize

    h. Compute inventory expense and journalize.

    I, j & K. use to compute COGS and journalize

    l. compute interest expense and journalize

    m. compute amounts paid and journalize. Accounts will be Cash and Accounts Payable

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!

Multi-Step Income Statement & Classified Balance Sheet Help! [ 1 Answers ]

Hi I'm new in studying accounting. I have quiz coming up tomorrow and I was wondering how I set up a Certified balance sheet and a multi-step income statement. The example we received was this. On may 1st, 2006 Jane Win began the Jane Win Co. which owns a business selling gift items. She ivested...

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:...

Multi-step Statement [ 2 Answers ]

I am having problems with some of the items and which category to list them under: The problem is listed as follows: Presented below is information related to IVAN Calderon Corp for the year 2007. Net Sales 1,300,000 Cost of Goods 780,000 Selling expenses 65,000 Administrative expenses...

Multiple-step income statement [ 0 Answers ]

Can someone help me with the following problem. The following items were taken from the records of Moonlight Video Inc. for the calendar year 2007: Prior period error $ 40,000 Cash dividends declared 80,000 Cost of sales 300,000 Selling and administrative expenses 350,000 Sales 1,000,000...


View more questions Search