Docstoc

Financial Statements

Document Sample
Financial Statements Powered By Docstoc
					Company Name          XYZ Corporation Inc.


Reports Ending Date


Calender Year


Month Year End             4
4
Worksheets List
11 - General Details
12 - Worksheets List
13 - Parametrs & Calculations
14 - Months Lists
15 - BS, IS Level
16 - Notes List
21 - Trial Balances Data
31 - Balance Sheet
41 - Income Statement
51 - Cash Flow
61 - Notes
91 - Trial Balance (Original)
92 - Trial Balance Adjustments
93 - Final Trial Balance
94 - Trial Balance Audit
          ComboBox Link & Name Defined in Cells in
Datails      Formulas           Column B
Formula in Cells in Column B
                                                                  Quarter # -
 Month   ComboBox, TB_Table Month Quarter Number Quarter Number   Calander or
Number             List            Calander year   Fiscal year    Fiscal Year
   1     January 31, 1998
   2     February 28, 1998
   3     March 31, 1998
   4     April 30, 1998
   5     May 31, 1998
   6     June 30, 1998
   7     July 31, 1998
   8     August 31, 1998
   9     September 30, 1998
  10     October 31, 1998
  11     November 30, 1998
  12     December 31, 1998
  13     January 31, 1999
  14     February 28, 1999
  15     March 31, 1999
  16     April 30, 1999
  17     May 31, 1999
  18     June 30, 1999
  19     July 31, 1999
  20     August 31, 1999
  21     September 30, 1999
  22     October 31, 1999
  23     November 30, 1999
  24     December 31, 1999
  25     January 31, 2000
  26     February 29, 2000
  27     March 31, 2000
  28     April 30, 2000
  29     May 31, 2000
  30     June 30, 2000
  31     July 31, 2000
  32     August 31, 2000
  33     September 30, 2000
  34     October 31, 2000
  35     November 30, 2000
  36     December 31, 2000
  37     January 31, 2001
  38     February 28, 2001
  39     March 31, 2001
  40     April 30, 2001
  41     May 31, 2001
  42     June 30, 2001
  43     July 31, 2001
  44     August 31, 2001
  45     September 30, 2001
  46     October 31, 2001
  47     November 30, 2001
  48     December 31, 2001
 49   January 31, 2002
 50   February 28, 2002
 51   March 31, 2002
 52   April 30, 2002
 53   May 31, 2002
 54   June 30, 2002
 55   July 31, 2002
 56   August 31, 2002
 57   September 30, 2002
 58   October 31, 2002
 59   November 30, 2002
 60   December 31, 2002
 61   January 31, 2003
 62   February 28, 2003
 63   March 31, 2003
 64   April 30, 2003
 65   May 31, 2003
 66   June 30, 2003
 67   July 31, 2003
 68   August 31, 2003
 69   September 30, 2003
 70   October 31, 2003
 71   November 30, 2003
 72   December 31, 2003
 73   January 31, 2004
 74   February 29, 2004
 75   March 31, 2004
 76   April 30, 2004
 77   May 31, 2004
 78   June 30, 2004
 79   July 31, 2004
 80   August 31, 2004
 81   September 30, 2004
 82   October 31, 2004
 83   November 30, 2004
 84   December 31, 2004
 85   January 31, 2005
 86   February 28, 2005
 87   March 31, 2005
 88   April 30, 2005
 89   May 31, 2005
 90   June 30, 2005
 91   July 31, 2005
 92   August 31, 2005
 93   September 30, 2005
 94   October 31, 2005
 95   November 30, 2005
 96   December 31, 2005
 97   January 31, 2006
 98   February 28, 2006
 99   March 31, 2006
100   April 30, 2006
101   May 31, 2006
102   June 30, 2006
103   July 31, 2006
104   August 31, 2006
105   September 30, 2006
106   October 31, 2006
107   November 30, 2006
108   December 31, 2006
Level1   Level2   Level3
Notes #   Notes Title   Notes Title   Balance Sheet, P&L
Account                 Balance Sheet,Income   Balance Sheet,Income
Number    Accout Name   Statement, Level 3     Statement, Level 2
Balance
Sheet,Income
Statement, Level 1   January 1998 February 1998 March 1998 April 1998 May 1998 June 1998
July 1998 August 1998   September 1998 October 1998 November 1998 December 1998
January 1999 February 1999 March 1999 April 1999 May 1999 June 1999 July 1999 August 1999
September 1999 October 1999 November 1999 December 1999 January 2000 February 2000
March 2000 April 2000 May 2000 June 2000 July 2000 August 2000   September 2000
October 2000 November 2000 December 2000 January 2001 February 2001 March 2001
April 2001 May 2001 June 2001 July 2001 August 2001   September 2001 October 2001
November 2001 December 2001 January 2002 February 2002 March 2002 April 2002 May 2002
June 2002 July 2002 August 2002   September 2002 October 2002 November 2002
December 2002 January 2003 February 2003 March 2003 April 2003 May 2003 June 2003
July 2003 August 2003   September 2003 October 2003 November 2003 December 2003
                                  BALANCE SHEET



                                            Notes
   ASSETS

Current Assets
    Cash                                            L
    Accounts Receivable                             e   Level3 -
    Inventories                                     v   Accounts Types
                                                    e
    Prepaid Expenses
      Total Current Assets                              Level 2 -Accounts Groups

Property and Equipment (at Cost)
    Land & Building                                 L
    Machinery and Equipment                         e
    Furniture and Fixtures                          v   Level3 -
    Total Property and Equipment                    e   Accounts Types
    Less: Accumulated Depreciation
     Net Book Value                                     Level 2 -Accounts Groups

Other Assets
    Investment in Revenue Bond                      L Level3 -
    Patents, Trademarks and Goodwill                e Accounts Types
      Total Other Assets                              Level 2 -Accounts Groups

      TOTAL ASSETS                                      Level 1 -Category

 LIABILITIES AND STOCKHOLDER'S EQUITY

Current Liabilities
    Line of Credit
    Current Portion of Long-Term Debt
    Accounts Payable
    Accrued Expenses
    Other Payables
      Total Current Liabilities

Long-Term Liabilities
    Note Payable
    Equipment Leases Payable
    Less: Current Portion Shown Above
     Total Long-Term Liabilities

      TOTAL LIABILITIES

Stockholder's Equity
    Capital Stock
    Retained Earnings
     Total Stockholder's Equity

      TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY
                                       Income Statement


                                                Notes
Revenue
  Sales
  Services
  Total Revenue

Cost of Goods Sold
  Materials
  Labor & Subcontractors Costs
  Other Cost of goods sold
  Increase / Decrease in Inventories
  Total Cost of Goods Sold

Gross Income

Operating Expenses
  Selling
  General & Administrative
  Other Operating Expense
  Depreciation
  Total Operating Expenses

Net Income before Operations

Operating Income (Loss)
  Other income (expense)
  Interest expense
  Total Operating Income

Income (Loss) Before Income Taxes
   Provision (benefit) for income taxes
Net Income (Loss) for the year
   Retained Earnings beginning of the year
Retained Earnings
                                   Cash Flow Report Year End December 31

                                                              Notes
Cash from Operating Activities

   Net Income
     Adjusted by:
        Depreciation
Net cash provoded by operating activities

   Changes in Working Capital:
    (Increase) Decrease in Current Assets:
        Accounts receivable
        Inventories
        Prepaid expenses
    Increase (Decrease) in Current Liabilities:
        Line of Credit
        Current Portion of Long-Term Debt
        Accounts Payable
        Accrued Expenses
        Other Payables
   Net changes in Working Capital

Net cash provided before investments & financing activities

Long Term Assets
       (Increase) Decrease in fixed assets
       (Increase) Decrease in other assets
Cash used (from) Long Term Assets

Long Term Liablilities
        Increase (Decrease) in long term debts
        Increase (Decrease) in capital
Cash from (used) liablilities and capiatal

Net Increase (Decrease) in Cash
        Cash at the beginning of the year
Cash at the end of the year
Year End December 31
                          91 - Trial Balance (Original)



Account
Number    Accout Name   Debit           Credit            Adjusted TB - Debit




                                    33 ‫עמוד‬
                                        91 - Trial Balance (Original)




Adjusted TB - Credit   Adjusted TB Balance




                                                  34 ‫עמוד‬
                                92 - Trial Balance Adjustments



Account Number   Account Name               Adjustment #    Debit   Credit




                                           35 ‫עמוד‬
          92 - Trial Balance Adjustments



Details                             Adjustment #   Debit




                     36 ‫עמוד‬
                      92 - Trial Balance Adjustments



Credit   Difference




                                 37 ‫עמוד‬
                        Trial Balance                 Adjustments
                Debit                Credit   Debit              Credit
Total
Difference

Profit & Loss
Net Income
Adjusted Trial Balance
Debit             Credit

				
DOCUMENT INFO
Description: bank reconcilation statement,circular flow of income, closing enteries, coefficient of correlation, concepts of National income, Consumption Functions, Determination of National income,Financial statement, Flow of Funds accounts, Index numbers, Introduction to statistics,investment, macro economics, measures of central tendency, measure of depersion, measure of shape distribution, merchandise inventory, micro macro economics, Micro Economics, multiplier and accelerator, probability, public finance, random variable,regression,sample distribution theory, statistics dynamics and comparative, theofy of employment, trade cycle