Docstoc

Proforma

Document Sample
Proforma Powered By Docstoc
					                                     Office of the State Controller
                                     2005 Proprietary Proforma
                                        Instructions and Index

Header Information
Fill in the agency and preparer information below. This information will be carried to the header
of each individual worksheet.

             Agency number:                               0A
             Agency name:                      NC Housing Finance Agency
             Preparer:                                 John Doe
             Phone:                                 (919) 123-4567

Printing Instructions
To print all worksheets at one time, choose File, Print, and print "Entire workbook".

General Instructions
Enter numbers on the Proforma as you would for financial statement presentation, using
negative numbers only in the Net Assets section on Statement of Net Assets to represent a
deficit balance and in the Nonoperating Revenues (Expenses) section on the operating statement
to represent expenses.
The MD&A sheet may be used to determine variances by statement caption, and significant
changes should be explained on the MD&A worksheet in the year end package.

Index
To go directly to a specific worksheet, click on the corresponding link below. To return to this
Index worksheet, press Ctrl i.




   Sheet                                                Worksheet Title

Proforma            Statement of Net Assets and Statement of Revenues, Expenses and Changes in Net Assets
MD&A                Management Discussion & Analysis - Worksheet for computing differences
File revision date: 8/9/2005                                      0A NC Housing Finance Agency
NC Housing Finance Agency                                                                                                              GASB 2611
Statement of Net Assets - Format for CAFR Compilation                                                                                  John Doe
June 30, 2005                                                                                                                          (919) 123-4567


ASSETS
Current Assets:
Cash and cash equivalents ...............................................................................................              $                —
Pooled cash......................................................................................................................                       —
Restricted cash and cash equivalents ..............................................................................                                     —
Restricted pooled cash......................................................................................................                            —
Short-term investments ....................................................................................................                             —
Restricted short-term investments ....................................................................................                                  —
Pooled investments...........................................................................................................                           —
Receivables:
   Accounts receivable, net...............................................................................................                              —
   Intergovernmental receivables.......................................................................................                                 —
   Interest receivable.........................................................................................................                         —
   Other receivables, net...................................................................................................                            —
Due from State of NC component units.............................................................................                                       —
Due from primary government...........................................................................................                                  —
Notes receivable................................................................................................................                        —
Inventories.........................................................................................................................                    —
Prepaid items....................................................................................................................                       —
Total Current Assets..........................................................................................................                          —

Noncurrent Assets:
Restricted/designated cash and cash equivalents ............................................................                                            —
Restricted/designated pooled cash....................................................................................                                   —
Investments.......................................................................................................................                      —
Restricted investments......................................................................................................                            —
Pooled investments...........................................................................................................                           —
Receivables:
   Intergovernmental receivables.......................................................................................                                 —
   Interest receivable.........................................................................................................                         —
   Other receivables, net...................................................................................................                            —
Notes receivable................................................................................................................                        —
Deferred charges...............................................................................................................                         —
Capital assets - nondepreciable.........................................................................................                                —
Capital assets - depreciable, net.......................................................................................                                —
Total Noncurrent Assets....................................................................................................                             —

Total Assets......................................................................................................................                      —




3/11/2010 9:52 PM                                             235c4152-20a3-4797-8cf5-7840ed3696f9.xls
NC Housing Finance Agency                                                                                                              GASB 2611
Statement of Net Assets - Format for CAFR Compilation
June 30, 2005


LIABILITIES
Current Liabilities:
Accounts payable and accrued liabilities:
   Accounts payable..........................................................................................................                          —
   Accrued payroll..............................................................................................................                       —
   Intergovernmental payables..........................................................................................                                —
   Claims payable..............................................................................................................                        —
   Other payables..............................................................................................................                        —
Due to State of NC component units.................................................................................                                    —
Due to primary government...............................................................................................                               —
Obligations under reverse repurchase agreements...........................................................                                             —
Deferred revenue...............................................................................................................                        —
Interest payable.................................................................................................................                      —
Deposits payable...............................................................................................................                        —
Funds held for others.........................................................................................................                         —
Notes payable - current.....................................................................................................                           —
Capital leases payable - current........................................................................................                               —
Bonds payable, net - current..............................................................................................                             —
Arbitrage rebate payable - current.....................................................................................                                —
Accrued vacation leave - current.......................................................................................                                —
Total Current Liabilities......................................................................................................                        —

Noncurrent Liabilities:
Accounts payable and accrued liabilities:
   Intergovernmental payables..........................................................................................                                —
   Other payables..............................................................................................................                        —
Advance from primary government....................................................................................                                    —
Deposits payable...............................................................................................................                        —
Funds held for others.........................................................................................................                         —
Notes payable...................................................................................................................                       —
Capital leases payable......................................................................................................                           —
Bonds payable, net............................................................................................................                         —
Arbitrage rebate payable...................................................................................................                            —
Accrued vacation leave.....................................................................................................                            —
Total Noncurrent Liabilities................................................................................................                           —
Total Liabilities...................................................................................................................                   —

Net Assets:
Invested in capital assets, net of related debt....................................................................                                    —
Restricted for:
  Nonexpendable:
     Higher education ........................................................................................................                         —
  Expendable:
     Higher education.........................................................................................................                         —
     Health and human services ........................................................................................                                —
     Economic development ..............................................................................................                               —
     Other purposes............................................................................................................                        —
Unrestricted.......................................................................................................................                    —
Total Net Assets................................................................................................................       $               —

Statement of Net Assets verification .................................................................................                       In Bal.

3/11/2010 9:52 PM                                             235c4152-20a3-4797-8cf5-7840ed3696f9.xls
(Total assets less total liabilities = Total net assets)




3/11/2010 9:52 PM                             235c4152-20a3-4797-8cf5-7840ed3696f9.xls
NC Housing Finance Agency                                         GASB 2611
Statement of Revenues, Expenses and Changes in Fund Net Assets - Format for CAFR Compilation
For the fiscal year ended June 30, 2005


Operating Revenues:
Sales and services, net.....................................................................................................             $             —
Federal grants and contracts.............................................................................................                              —
State and local grants and contracts..................................................................................                                 —
Nongovernmental grants and contracts.............................................................................                                      —
Interest earnings on loans.................................................................................................                            —
Rental and lease earnings.................................................................................................                             —
Fees, licenses and fines....................................................................................................                           —
Miscellaneous....................................................................................................................                      —
Total operating revenues...................................................................................................                            —
Operating Expenses:
Personal services..............................................................................................................                        —
Supplies and materials......................................................................................................                           —
Services............................................................................................................................                   —
Cost of goods sold.............................................................................................................                        —
Claims and benefits...........................................................................................................                         —
Interest..............................................................................................................................                 —
Depreciation/amortization..................................................................................................                            —
Insurance and bonding......................................................................................................                            —
Other.................................................................................................................................                 —
Total operating expenses..................................................................................................                             —
Operating income (loss)....................................................................................................                            —
Nonoperating Revenues (Expenses):
State aid............................................................................................................................                  —
Noncapital grant revenue...................................................................................................                            —
Noncapital gifts, net...........................................................................................................                       —
Interest and fees expense.................................................................................................                             —
Gain on sale of property & equipment...............................................................................                                    —
Loss on sale of property & equipment...............................................................................                                    —
Investment earnings..........................................................................................................                          —
Insurance recoveries.........................................................................................................                          —
Grants, aid and subsidies expense....................................................................................                                  —
Miscellaneous nonoperating revenue................................................................................                                     —
Miscellaneous nonoperating expense................................................................................                                     —
Total nonoperating revenues (expenses)...........................................................................                                      —
Income before other revenues, expenses, gains, or losses...............................................                                                —
State capital aid.................................................................................................................                     —
Capital grants....................................................................................................................                     —
Capital gifts, net.................................................................................................................                    —
Special items.....................................................................................................................                     —
Extraordinary items............................................................................................................                        —
Increase (Decrease) in Net Assets....................................................................................                                  —
Net assets—July 1............................................................................................................                          —
Restatements....................................................................................................................                       —
Net assets—June 30.........................................................................................................              $             —

Net assets between Stmt of Net Assets and O/S verification                                                                                   In Bal.




3/11/2010 9:52 PM                                               235c4152-20a3-4797-8cf5-7840ed3696f9.xls
NC Housing Finance Agency                      GASB 2611                                                      John Doe
Statement of Net Assets - Format for CAFR Compilation                                                         (919) 123-4567
Worksheet for Management's Discussion and Analysis (MD&A)
                                                FY2004-2005                                     FY2003-2004       Difference       % Diff

ASSETS
Current Assets:
Cash and cash equivalents ............................................              $   —   $            —                     —     0.00%
Pooled cash....................................................................         —                —                     —     0.00%
Restricted cash and cash equivalents ............................                       —                —                     —     0.00%
Restricted pooled cash...................................................               —                —                     —     0.00%
Short-term investments ..................................................               —                —                     —     0.00%
Restricted short-term investments .................................                     —                —                     —     0.00%
Pooled investments.........................................................             —                —                     —     0.00%
Receivables:                                                                            —                —                     —     0.00%
   Accounts receivable, net.............................................                —                —                     —     0.00%
   Intergovernmental receivables....................................                    —                —                     —     0.00%
   Interest receivable.......................................................           —                —                     —     0.00%
   Other receivables, net.................................................              —                —                     —     0.00%
Due from State of NC component units...........................                         —                —                     —     0.00%
Due from primary government.........................................                    —                —                     —     0.00%
Notes receivable.............................................................           —                —                     —     0.00%
Inventories......................................................................       —                —                     —     0.00%
Prepaid items..................................................................         —                —                     —     0.00%
Total Current Assets.......................................................             —                —                     —     0.00%

Noncurrent Assets:
Restricted/designated cash and cash equivalents ..........                              —                —                     —     0.00%
Restricted/designated pooled cash.................................                      —                —                     —     0.00%
Investments....................................................................         —                —                     —     0.00%
Restricted investments....................................................              —                —                     —     0.00%
Pooled investments.........................................................             —                —                     —     0.00%
Receivables:                                                                            —                —                     —     0.00%
   Intergovernmental receivables....................................                    —                —                     —     0.00%
   Interest receivable.......................................................           —                —                     —     0.00%
   Other receivables, net.................................................              —                —                     —     0.00%
Notes receivable.............................................................           —                —                     —     0.00%
Deferred charges............................................................            —                —                     —     0.00%
Capital assets - nondepreciable......................................                   —                —                     —     0.00%
Capital assets - depreciable, net.....................................                  —                —                     —     0.00%
Total Noncurrent Assets.................................................                —                —                     —     0.00%
Total Assets....................................................................   —            —                 —    —

NC Housing Finance Agency                      GASB 2611
Statement of Net Assets - Format for CAFR Compilation
Worksheet for Management's Discussion and Analysis (MD&A)
                                                FY2004-2005                            FY2003-2004   Difference       % Diff

LIABILITIES
Current Liabilities:
Accounts payable and accrued liabilities:
   Accounts payable........................................................        —            —                 —     0.00%
   Accrued payroll...........................................................      —            —                 —     0.00%
   Intergovernmental payables........................................              —            —                 —     0.00%
   Claims payable...........................................................       —            —                 —     0.00%
   Other payables............................................................      —            —                 —     0.00%
Due to State of NC component units...............................                  —            —                 —     0.00%
Due to primary government.............................................             —            —                 —     0.00%
Obligations under reverse repurchase agreements.........                           —            —                 —     0.00%
Deferred revenue............................................................       —            —                 —     0.00%
Interest payable..............................................................     —            —                 —     0.00%
Deposits payable............................................................       —            —                 —     0.00%
Funds held for others......................................................        —            —                 —     0.00%
Notes payable - current...................................................         —            —                 —     0.00%
Capital leases payable - current......................................             —            —                 —     0.00%
Bonds payable, net - current...........................................            —            —                 —     0.00%
Arbitrage rebate payable - current...................................              —            —                 —     0.00%
Accrued vacation leave - current.....................................              —            —                 —     0.00%
Total Current Liabilities...................................................       —            —                 —     0.00%


Noncurrent Liabilities:
Accounts payable and accrued liabilities:
   Intergovernmental payables........................................              —            —                 —     0.00%
   Other payables............................................................      —            —                 —     0.00%
Advance from primary government.................................                   —            —                 —     0.00%
Deposits payable............................................................       —            —                 —     0.00%
Funds held for others......................................................        —            —                 —     0.00%
Notes payable.................................................................     —            —                 —     0.00%
Capital leases payable....................................................         —            —                 —     0.00%
Bonds payable, net.........................................................        —            —                 —     0.00%
Arbitrage rebate payable.................................................          —            —                 —     0.00%
Accrued vacation leave...................................................          —            —                 —     0.00%
Total noncurrent Liabilities..............................................          —   —   —   0.00%
Total Liabilities................................................................   —   —   —   0.00%
Net Assets:                                                                            FY2004-2005         FY2003-2004     Difference       % Diff
Invested in capital assets, net of related debt.................................                 —                   —                  —     0.00%
Restricted for:
  Nonexpendable:
     Higher education.......................................................                       —                   —                —     0.00%
  Expendable:
     Higher education.......................................................                       —                   —                —     0.00%
     Health and human services.......................................                              —                   —                —     0.00%
     Economic development.............................................                             —                   —                —     0.00%
     Other purposes.........................................................                       —                   —                —     0.00%
Unrestricted....................................................................                   —                   —                —     0.00%
Total Net Assets.............................................................      $               —   $               —                —     0.00%


Statement of Net Assets verification ..............................                      In Bal.             In Bal.
(Total assets less total liabilities = Total net assets)
NC Housing Finance Agency                     GASB 2611
Statement of Revenues, Expenses and Changes in Fund Net Assets - Format for CAFR Compilation
Worksheet for Management's Discussion and Analysis (MD&A)
                                               FY2004-2005           FY2003-2004           Difference       % Diff

Operating Revenues:
Sales and services, net...................................................             $   —   $   —    —     0.00%
Federal grants and contracts..........................................                     —       —    —     0.00%
State and local grants and contracts...............................                        —       —    —     0.00%
Nongovernmental grants and contracts...........................                            —       —    —     0.00%
Interest earnings on loans...............................................                  —       —    —     0.00%
Rental and lease earnings..............................................                    —       —    —     0.00%
Fees, licenses and fines.................................................                  —       —    —     0.00%
Miscellaneous.................................................................             —       —    —     0.00%
Total operating revenues................................................                   —       —    —     0.00%
Operating Expenses:
Personal services............................................................              —       —    —     0.00%
Supplies and materials....................................................                 —       —    —     0.00%
Services..........................................................................         —       —    —     0.00%
Cost of goods sold..........................................................               —       —    —     0.00%
Claims and benefits........................................................                —       —    —     0.00%
Interest............................................................................       —       —    —     0.00%
Depreciation/amortization...............................................                   —       —    —     0.00%
Insurance and bonding....................................................                  —       —    —     0.00%
Other...............................................................................       —       —    —     0.00%
Total operating expenses................................................                   —       —    —     0.00%
Operating income (loss)..................................................                  —       —    —     0.00%
Nonoperating Revenues (Expenses):                                                        FY2004-2005       FY2003-2004   Difference       % Diff
State aid.........................................................................                 —                 —                —     0.00%
Noncapital grant revenue................................................                           —                 —                —     0.00%
Noncapital gifts, net........................................................                      —                 —                —     0.00%
Interest and fees expense...............................................                           —                 —                —     0.00%
Gain on sale of property & equipment.............................                                  —                 —                —     0.00%
Loss on sale of property & equipment.............................                                  —                 —                —     0.00%
Investment earnings........................................................                        —                 —                —     0.00%
Insurance recoveries.......................................................                        —                 —                —     0.00%
Grants, aid and subsidies expense.................................                                 —                 —                —     0.00%
Miscellaneous nonoperating revenue..............................                                   —                 —                —     0.00%
Miscellaneous nonoperating expense.............................                                    —                 —                —     0.00%
Total nonoperating revenues (expenses)........................                                     —                 —                —     0.00%
Income before other rev, exp, gains, or losses...............................                      —                 —                —     0.00%
State capital aid..............................................................                    —                 —                —     0.00%
Capital grants..................................................................                   —                 —                —     0.00%
Capital gifts, net..............................................................                   —                 —                —     0.00%
Special items..................................................................                    —                 —                —     0.00%
Extraordinary items.........................................................                       —                 —                —     0.00%
Increase (Decrease) in Net Assets..................................                                —                 —                —     0.00%
Net assets—July 1..........................................................                        —                 —                —     0.00%
Restatements..................................................................                     —                 —                —     0.00%
Net assets—June 30.......................................................            $             —   $             —

Net assets between Stmt of Net Assets and O/S                                              In Bal.           In Bal.
      A      B                              C                          D                      E
 1        Agency
 2        Number                     Agency Name                    GASB No.           Functional Class
 3
 4    1    69      USS NC Battleship Commission                     GASB 2517      Economic Development
 5    2    0A      NC Housing Finance Agency                        GASB 2611      Economic Development
 6    3    ZA      NC State Ports Authority                         GASB 2612      Economic Development
 7    4    10      NC Agricultural Finance Authority                GASB 2614      Economic Development
 8    5    Z3      NC Global TransPark Authority                    GASB 2615      Economic Development
 9    6    ZB      State Education Assistance Authority             GASB 2620          Higher Education
10    7    Z7      NC Partnership for Children                      GASB 2621     Health and Human Services
11    8    ZC      Western NC Regional Economic Dev Comm            GASB 2622      Economic Development
12    9    ZD      Northeastern NC Regional Econ Dev Comm           GASB 2623      Economic Development
13   10    ZE      Southeastern NC Regional Econ Dev Comm           GASB 2624      Economic Development
14   11    ZH      NC Railroad Company                              GASB 2627      Economic Development
15   12    48      Rex Healthcare                                   GASB 2637     Health and Human Services
16   13    ZI      The Golden LEAF, Inc.                            GASB 2640      Economic Development
17   14    ZJ      NC Phase II Tobacco Certification Entity, Inc.   GASB 2641      Economic Development
18   15    15      NC Turnpike Authority                            GASB 2642           Transportation




     3/11/2010 9:52 PM                                              235c4152-20a3-4797-8cf5-7840ed3696f9.xls