Template Balancesheet

Document Sample
Template Balancesheet Powered By Docstoc
					Instructions for the Microsoft Excel Templates

Be advised, the worksheet and workbooks are not protected.

Extensive detail and information is contained within the manual.

Striking the "F1" key or following the path "Windows>Excel Help" will invoke the Office Assistant and bring up one
of several help menus.

You should enter your name, course ID, and date name into the cells at the top of the page.

Each page contains a page footer with a Page # of Page ## as well as time and date to assist in assembly of
multiple pages.

Each worksheet contains the identification of the problem or exercise.

All formatting should have been accomplished to provide satisfactory presentation. See the text for additional
assistance in formatting.

There should be no need to insert columns or rows into the workbooks.

If more than one page is required by the problem, the page breaks are preset.

In general, the yellow highlighted cells are the cells which work and effort should be presented.

Place the proper account title in the cell where the word "Account title" appears on the template.

Place the value in the cell where the word "Value" or "Amount" appears on the template. A formula may be placed
in some of these cells.

Write a formula into cells where the word "Formula" appears. In these cells, an amount calculated can be
entered. An amount can be placed in these cells.

Place the explanation for the entry in the cell where the word "Text Explanation" appears on the template.

Insert the account number where "Acct Nbr" appears on the template during posting.

Insert the journal reference where "JOURN #" appears on the template during posting.

Insert the title in the cell where "TITLE" appears on the template.

The print area is defined to fit onto 8 1/2" X 11" sheets in portrait or landscape mode as required.

The gray filled cells define the perimeter of the problem and the print area.

The problem is formatted for whole dollars with comma separations (no cents) except where required.

The display may have "Freeze Pane" invoked so column titles remain visible during data entry.

Negative values may be shown as ($400) or -$400.
Consider using "Split" panes to assist in copy and paste of data.

Much of the exercises and problems can have data entered by the "look to" or "=A34" type formula where cell
A34 contains the data to be entered. This precludes typing and data entry errors.
Name:
Problem:              P3-11, Worksheet, Balance Sheet, Adjusting and Closing Entries
Course:
Date:
Note: This sheet is formatted to print out in landscape.
Cooke Company has a fiscal year ending on September 30. Selected data from the September 30 worksheet are presented below.
Instructions:
(a) Prepare a complete worksheet.
                                                                     COOKE COMPANY
                                                                         Worksheet
                                                           For The Year Ended September 30, 2010
                                         Trial Balance           Adjustments        Adjusted Trial Balance    Income Statement        Balance Sheet
                                        Debit       Credit     Debit     Credit        Debit       Credit     Debit       Credit     Debit     Credit
Cash                                    37,400                                         37,400
Supplies                                18,600                                          4,200
Prepaid Insurance                       31,900                                          3,900
Land                                    80,000                                         80,000
Equipment                              120,000                                        120,000
Accumulated Depreciation                            36,200                                         42,000
Accounts Payable                                    14,600                                         14,600
Unearned Admissions Revenue                          2,700                                            700
Mortgage Payable                                    50,000                                         50,000
Cooke, Capital                                     109,700                                        109,700
Cooke, Drawing                          14,000                                         14,000
Admissions Revenue                                 278,500                                        280,500
Salaries Expense                       109,000                                        109,000
Repair Expense                          30,500                                         30,500
Advertising Expense                      9,400                                          9,400
Utilities Expense                       16,900                                         16,900
Property Taxes Expense                  18,000                                         21,000
Interest Expense                         6,000                                         12,000
  Totals                               491,700     491,700
Insurance Expense                                                                      28,000
Supplies Expense                                                                       14,400
Interest Payable                                                                                    6,000
Depreciation Expense                                                                    5,800
Property Taxes Payable                                                                              3,000
  Totals                                                      Formula    Formula      506,500     506,500     Formula      Formula   Formula    Formula
Net income or loss                                                                                            Formula                           Formula
Totals                                                                                                        Formula      Formula   Formula    Formula




                                                      Problem 3-11, Page 3 of 5, 8/15/2011, 10:49 AM
(b) Prepare a classified balance sheet. (Note:

                                                                          COOKE COMPANY
                                                                            Balance Sheet
                                                                          September 30, 2010
                                 Assets                                                                          Liabilities and Owner’s Equity
Current assets                                                                           Current liabilities
  Account Title                                        Amount                              Account Title                                        Amount
  Account Title                                        Amount                              Account Title                                        Amount
  Account Title                                        Amount                              Account Title                                        Amount
    Total current assets                                             Formula               Account Title                                        Amount
Property, plant, and equipment                                                             Account Title                                        Amount
  Account Title                                        Amount                                Total current liabilities                                   Formula
  Account Title                          Amount                                          Long-term liabilities
    Account Title                        Amount       Formula        Formula               Account Title                                                 Formula
                                                                                             Total liabilities                                           Formula
                                                                                         Owner’s equity
                                                                                           Cooke, Capital                                                Formula
  Total assets                                                       Formula                 Total liabilities and owner’s equity                        Formula

(c) Journalize the adjusting entries using the worksheet as a basis.

  Sep 30                Account Title                                          Amount
                         Account Title                                                         Amount

  Sep 30                Account Title                                          Amount
                         Account Title                                                         Amount

  Sep 30                Account Title                                          Amount
                         Account Title                                                         Amount

  Sep 30                Account Title                                          Amount
                         Account Title                                                         Amount

  Sep 30                Account Title                                          Amount
                         Account Title                                                         Amount

  Sep 30                Account Title                                          Amount
                         Account Title                                                         Amount

(d) Journalize the closing entries using the worksheet as a basis.                                      (e) Prepare a post-closing trial balance.

  Sep 30    Account Title                                            Amount                                                   COOKE COMPANY



                                                           Problem 3-11, Page 4 of 5, 8/15/2011, 10:49 AM
Sep 30
          Account Title                        Amount                              Post Closing Trial Balance
                                                                                     September 30, 2010
Sep 30   Account Title          Formula                                                                   Debit     Credit
          Account Title                        Amount              Account Title                           Amount
          Account Title                        Amount              Account Title                           Amount
          Account Title                        Amount              Account Title                           Amount
          Account Title                        Amount              Account Title                           Amount
          Account Title                        Amount              Account Title                           Amount
          Account Title                        Amount              Account Title                                    Amount
          Account Title                        Amount              Account Title                                    Amount
          Account Title                        Amount              Account Title                                    Amount
          Account Title                        Amount              Account Title                                    Amount
                                                                   Account Title                                    Amount
Sep 30   Account Title           Amount                            Account Title                                    Amount
          Account Title                        Amount              Account Title                                    Amount
                                                                    Totals                               Formula    Formula
Sep 30   Account Title           Amount
          Account Title                        Amount




                          Problem 3-11, Page 5 of 5, 8/15/2011, 10:49 AM

				
DOCUMENT INFO
Description: Template Balancesheet document sample