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

    May 31, 2011, 11:37 PM
    Income statement and worksheet
    You only have to look at the last 2 sheets which are problem 7C given information and the required sheets I have done most of the work just having trouble with income statement and worksheet thanks so much

    Tracy
    Attached Files
  1. File Type: xls accfinal.xls (151.0 KB, 151 views)
  2. Just Looking's Avatar
    Just Looking Posts: 1,610, Reputation: 480
    Ultra Member
     
    #2

    Jun 1, 2011, 09:09 AM

    You have your list of accounts with balances at May 31. You now need to put those balances in your worksheet. For example, Cash at May 31 is a debit of $135,911. The numbers in the "Unadjusted Trial Balance" should be the account balances prior to your adjusting journal entries ("additional information") and your closing entries. For example, your Revenue account on the unadjusted trial balance would show $156,422. I'm guessing this is where you are confused. The worksheet should have been started at the point where your transactions were posted, prior to posting adjusting journal entries and closing entries. The adjustment columns would be those "additional information" entries. After you insert all your balances in your worksheet, add the debit and credit columns. They should be equal. If not, you have a mistake somewhere. If so, you are ready to move on.

    Your adjusted trial balance numbers get spread to the Balance Sheet and Income Statement columns based on which statement they belong, and then your Income Statement would be made based on those Income Statement columns from your worksheet. I didn't check your Income Statement so it may be right, but once you have your worksheet complete you will know if the IS is right.
    baba1234's Avatar
    baba1234 Posts: 2, Reputation: 1
    New Member
     
    #3

    Mar 22, 2012, 07:48 PM
    1) Given the following information for the '09 year, prepare an Income Statement:
    * Annual Volume of 8MM units
    * Sales Price of $.75 per unit
    * Gross Profit Percentage of 10%
    * Sales & General Expense were 8% of Sales
    * Accumulated Depreciation in '08 totaled 600M; in the
    09 year the Total Accumulated Depreciation amount was 650M.
    * Bank debt averaged 250M for the year; interest rate was 8%
    * EPS was .10
    * Tax rate is 40%
    * There are 100M shares of common stock outstanding
    baba1234's Avatar
    baba1234 Posts: 2, Reputation: 1
    New Member
     
    #4

    Mar 22, 2012, 07:48 PM
    1) Given the following information for the '09 year, prepare an Income Statement:
    * Annual Volume of 8MM units
    * Sales Price of $.75 per unit
    * Gross Profit Percentage of 10%
    * Sales & General Expense were 8% of Sales
    * Accumulated Depreciation in '08 totaled 600M; in the
    09 year the Total Accumulated Depreciation amount was 650M.
    * Bank debt averaged 250M for the year; interest rate was 8%
    * EPS was .10
    * Tax rate is 40%
    * There are 100M shares of common stock outstanding

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!

Income statement, retained earnings, balance sheet from a worksheet [ 8 Answers ]

Here is the info I got from a worksheet for preparing statements. 101 Cash 18,800 112 Acct Receive 16,200 126 Supplies 2,300 130 Prepaid Insurance 4,400 151 Office equipment 44,000 152 Accumulated Depreciation office equip. ...

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

Income statement, retained earnings, balance sheet from a worksheet [ 6 Answers ]

Here is the info I got from a worksheet for preparing statements. 101 Cash 18,800 112 Acct Receive 16,200 126 Supplies 2,300 130 Prepaid Insurance 4,400 151 Office equipment 44,000 152 Accumulated Depreciation office equip. 20,000 200 Notes Payable 20,000 201 Accounts Payable 8,000 212...

Complete the worksheet by extending the balances to the financial statement columns [ 1 Answers ]

Account Trial Balance No. Account Titles Dr. Cr. 130 Prepaid Insurance 4,400 151 Office Equipment 44,000 152 Accumulated Depreciation—Office Equipment 20,000 200 Notes Payable 20,000 201 Accounts Payable 8,000 212 Salaries Payable 2,600 230 Interest Payable 1,000 311 Common Stock 30,000


View more questions Search