Accounts Payable and Receivable Templates - Excel

Document Sample
Accounts Payable and Receivable Templates - Excel Powered By Docstoc
					                                                                       Student Name:
                                                                               Class:
                                                                                        Problem 04-03

Requirement 1:

                                           DELL, INC.
                                      Adjusted Trial Balance
                                        February 3, 2009

Account Name                                                  Debits       Credits
Cash
Accounts Receivable
Inventories
Property, Plant & Equipment
Accumulated Depreciation
Other Assets
Accounts Payable
Accrued Liabilities
Long-term Debt
Other Liabilities
Dell Owners' Capital
Sales Revenue
Interest Revenue
Cost of Goods Sold
Selling, General, and Administrative Expenses
Research and Development Expense
Other Expenses
    Totals


Is the Dell Owners' Capital balance of $9,174 the amount that would be reported on
the balance sheet as of February 3, 2009?




Requirement 2:
                                                   DELL, INC.
                                                  Closing Entries

                                                                                           Debit        Credit
         CE1 Sales Revenue
             Interest Revenue
               Income Summary

         CE2 Income Summary
               Cost of Goods Sold
               Selling, General, and Administrative Expense
               Research and Development Expense
               Other Expenses

         CE3 Income Summary
               Dell Owners' Capital
                                                                   Student Name:
                                                                           Class:
                                                                                    Problem 04-03


Requirement 3:

                                          DELL, INC.
                                   Post-Closing Trial Balance
                                        February 3, 2009

Account Name                                              Debits       Credits
Cash
Accounts Receivable
Inventories
Property, Plant & Equipment
Accumulated Depreciation
Other Assets
Accounts Payable
Accrued Liabilities
Long-term Debt
Other Liabilities
Dell Owners' Capital
Sales Revenue
Interest Revenue
Cost of Goods Sold
Selling, General, and Administrative Expenses
Research and Development Expense
Other Expenses
    Totals
Given Data PA04-03:

                             DELL, INC.
                      Adjusted Account Balances
                       Year Ended February 3

Accounts Payable                                  $    9,840
Accounts Receivable                                    5,452
Accrued Liabilities                                    6,087
Accumulated Depreciation                                 749
Cash                                                   9,807
Cost of Goods Sole (inventory used)                   45,958
Dell Owners' Capital                                   9,174
Interest Revenue                                         227
Inventories                                              576
Long-Term Debt                                           504
Other Assets                                          14,635
Other Expenses                                         1,002
Other Liabilities                                      2,549
 Property, Plant, and Equipment                        2,005
Research and Development Expense                         463
Sales Revenue                                         55,908
Selling, General, and Administrative Expenses          5,140
                                                 Student Name:
                                                         Class:
                                                                  Problem 04-05

                                                                         H-H TOOL

Requirement 1:

                        Cash                                        Accounts Receivable                          Supplies
        Bal.                              b                Bal.                            f      Bal.                              l
          a                               e                  c                                       i
          c                               g
          d                               h
           f                              k
        Bal.                                               Bal.                                   Bal.


                        Land                                             Equipment                       Accumulated Depreciation
        Bal.                                               Bal.                                                                     Bal.
          b                                                                                                                         m


        Bal.                                               Bal.                                                                     Bal.


                     Other Assets                                    Accounts Payable                         Notes Payable
        Bal.                                                 h                             Bal.                                     Bal.
          g                                                                                e                                        a
                                                                                           i

        Bal.                                                                               Bal.                                     Bal.


                    Wages Payable                                     Interest Payable                       Utilities Payable
                                          Bal.                                             Bal.                                     Bal.
                                          o                                                n                                        p


                                          Bal.                                             Bal.                                     Bal.


                 H. Hermann, Capital                                H. Hermann, Drawing                      Income Summary
                                          Bal.             Bal.                                                                     Bal.
                                          d                  k                                    CE2                               CE1
       CE4                                CE3                                              CE4    CE3

                                          Bal.             Bal.                                                                     Bal.


                   Service Revenue                                  Depreciation Expense                     Wages Expense
                                          Bal.             Bal.                                   Bal.
                                          c                 m                              CE2      e
       CE1                                                                                          0                               CE2

                                          Bal.             Bal.                                   Bal.


                   Interest Expense                                  Supplies Expense                        Utilities Expense
        Bal.                                               Bal.                                   Bal.
          n                               CE2                 l                            CE2      p                               CE2


        Bal.                                               Bal.                                   Bal.


               Other Operating Expenses
        Bal.
          e                               CE2


        Bal.
                                                                Student Name:
                                                                        Class:
                                                                                 Problem 04-05

Requirement 2: Transaction Entries
                                               H-H TOOLS
                                              Journal Entries

                                                                                    Debit        Credit
          a.


          b.


          c.




          d.


          e.




           f.


          g.


          h.


           i.


           j.


          k.




Requirement 3:
                       H-H TOOL
                Unadjusted Trial Balance
                  December 31, 2011
                     (in thousands)

Account Name                   Debits      Credits
Cash
Accounts Receivable
Supplies
Land
Equipment
Accumulated Depreciation
Other Assets
Accounts Payable
Notes Payable
Wages Payable
Interest Payable
Utilities Payable
H. Hermann, Capital
H. Hermann, Drawing
Service Revenue
Depreciation Expense
Wages Expense
Interest Expense
Supplies Expense
Utilities Expense
Other Operating Expenses
    Totals


Requirement 4: Adjusting Entries

           l.


         m.


          n.


          o.


          p.
                                                     Student Name:
                                                             Class:
                                                                      Problem 04-05


Requirement 5:
                       H-H TOOL
                 Adjusted Trial Balance
                  December 31, 2011
                     (in thousands)

Account Name                      Debits   Credits
Cash
Accounts Receivable
Supplies
Land
Equipment
Accumulated Depreciation
Other Assets
Accounts Payable
Notes Payable
Wages Payable
Interest Payable
Utilities Payable
H. Hermann, Capital
H. Hermann, Drawing
Service Revenue
Depreciation Expense
Wages Expense
Interest Expense
Supplies Expense
Utilities Expense
Other Operating Expenses
    Totals


Requirement 6:
                       H-H TOOL
                  Income Statement
        For the Year Ended December 31, 2011
                     (in thousands)

Operating Revenues:
 Service Revenue
   Total operating revenues
Operating Expenses:
 Depreciation Expense
 Wages Expense
 Supplies Expense
 Utilities Expense
 Other Operating Expenses
   Total operating expenses
Operating Income
Other Items
 Interest Expense
 Net Income

                       H-H TOOL
             Statement of Owner's Equity
        For the Year Ended December 31, 2011
                     (in thousands)

H. Hermann, Capital (beginning)
Additional investments by owner
Net income
H. Hermann, Drawing
H. Hermann, Capital (ending)

                      H-H TOOL
             Statement of Owner's Equity
                At December 31, 2011
                    (in thousands)

Assets
Current Assets:
 Cash
 Accounts Receivable
 Supplies
   Total current assets
Land
Equipment
Other Assets
Total Assets

Liabilities
Current Liabilities
  Accounts Payable
  Notes Payable
  Wages Payable
  Interest Payable
  Utilities Payable
    Total current liabilities
Owner's Equity
  H. Hermann, Capital
Total Liabilities and Owner's Equity
                                                     Student Name:
                                                             Class:
                                                                      Problem 04-05


Requirement 7: Closing Entries

        CE1




        CE2




        CE3


        CE4




Requirement 8:
                      H-H TOOL
              Post-Closing Trial Balance
                 December 31, 2011
                    (in thousands)

Account Name                     Debits    Credits
Cash
Accounts Receivable
Supplies
Land
Equipment
Accumulated Depreciation
Other Assets
Accounts Payable
Notes Payable
Wages Payable
Interest Payable
Utilities Payable
H. Hermann, Capital
H. Hermann, Drawing
Service Revenue
Depreciation Expense
Wages Expense
Interest Expense
Supplies Expense
Utilities Expense
Other Operating Expenses
    Totals


Requirement 9:




Requirement 10:

Net Profit Margin Calculation:
Net Income
Sales (or Operating) Revenues
Net Profit Margin
Given Data PA04-05:

                               H-H TOOL
                              Trial Balance
                           On January 1, 2011
                             (in thousands)

Cash                               3
Accounts Receivable                5
Supplies                          12
 Land                              -
Equipment                         60
Accumulated Depreciation
Other Assets                       4
Accounts Payable
Notes Payable
Wages Payable
Interest Payable
Utilities Payable
H. Hermann, Capital
H. Hermann, Drawing                -
Service Revenue
Depreciation Expense               -
                                                                Student Name:
                                                                        Class:
                                                                                 Problem 04-06

Requirement 1:

                                                                                       ANDERSON PLUMBING SUPPLY
                                                                                 Worksheet for the year ended December 31, 2010
                                                                                                                                                           Financial Statements
                                   Unadjusted Trial                         Adjusting                     Adjusted Trial                   Income                Owner's                   Balance
                                        Balance                              Entries                          Balance                    Statement                Equity                    Sheet
          Account Titles          Debit         Credit                Debit          Credit             Debit         Credit         Debit        Credit   Debit          Credit   Debit             Credit
Cash                          $    13,000
Accounts Receivable                22,000
Supplies                            1,200                                                600 (a)
Interest Receivable                                       (b)             300
Long-Term Note Receivable           9,000
Equipment                          80,000
Accumulated Depreciation                         35,000                               10,000 (c)
Accounts Payable                                 10,000
Short-Term Note Payable                          12,000
Interest Payable                                                                          720 (d)
Accrued Liabilities Payable                                                             3,620 (e)
J. Anderson, Capital                             55,000
J. Anderson, Drawing               20,000
Service Revenue                                  72,000
Interest Revenue                                                                         300 (b)
Expenses (not detailed)            38,800                 (a)             600
Depreciation Expense                                      (c)          10,000
Interest Expense                                          (d)             720
Other Operating Expenses                                  (e)           3,620
  Totals                      $   184,000   $   184,000           $    15,240    $    15,240



                                                                                                    J. Anderson, Capital--------->
                                 Student Name:
                                         Class:
                                                  Problem 04-06



Requirement 2:
a.




b.




c.




d.




e.




Requirement 3: Closing Entries

                          CE1



                          CE2




                          CE3


                          CE4
ANDERSON PLUMBING SUPPLY
       Partial Worksheet
 Year Ended December 31, 2010

      Unadjusted Trial
           Balance
     Debit
 $    13,000
      22,000
       1,200

       9,000

				
DOCUMENT INFO
Description: Accounts Payable and Receivable Templates document sample