Book Belongs to Template by okb64521

VIEWS: 95 PAGES: 21

More Info
									                      Welcome to Record Book Version 2003
                                        General Instructions
1   This is a template that runs on Microsoft Excel. Save the file on a hard drive, network, or floppy
    disk. Be sure to name files and use folders so that others will not copy over them. This template
    can be copied as many times as necessary for individual students. Save information before exiting.
    Use the "Tab" button to go to the next cell for input.

2   To begin using this recordbook, input the following:
    A. Information on the cover page. This includes name, starting and ending dates, and naming of
    each enterprise. Other information is useful in completing reports and awards.
    B. Current and Non-Current inventory sheets. Inventory should be taken at the beginning of each
    record book period and should match the previous recordbook ending values. Each entry needs to
    be assigned to an enterprise. If an item belongs to two or more enterprises, input the value for
    each enterprise on a separate line.
    C. Net Worth. Insert beginning values for the following (all items will be rounded off to the nearest
    dollar)
            Lines 1 a, b, c Cash assets
            Line 1 f Non-productively invested personal assets
            Line 2 b Non-productively invested personal non-current/capital assets.
            Lines 6 a, b, d Current/Operating liabilities
            Lines 8 a, b, c, e Non-Current/Capital liabilities

3   Input expenses and income using the ledger sheet. A blank ledger sheet for each enterprise and
    activities pages (NB Print) can be printed and kept in your ag notebook or at home to keep track of
    expenses, income and activities.
    For Ag income/expenses not part of the SAE, Non Ag income/expenses, gifts, inheritances, and
    educational expenses, use the Non Prod Inc sheet.

4   To close out the recordbook:
    A. Complete the ending values for current and non-current inventories. Remember to assign each
    entry to an enterprise.
    B. Net Worth. Insert the following values for the end of the recordkeeping period (all items will be
    rounded off to the nearest dollar)
           Lines 1 a, b, c Cash assets
           Line 1 f Non-productively invested personal assets
           Line 2 b Non-productively invested personal non-current/capital assets.
           Lines 6 a, b, d Current/Operating liabilities
           Lines 8 a, b, c, e Non-Current/Capital liabilities
    C. Be certain all entries have been made in the ledger and activities sheet.
    D. Print pages needed for a hard copy. Use print preview to select pages needed to print and
    identify those not needed or used. In the ledger sheet, only two pages are selected to print. For
    more or less pages, redo print area.
    *Note* Balance Sheet and Summary pages automatically round off to the nearest dollar.
             Calculations are automatic on the Summary and Balance Sheets.

5   Begin new record book.

                            Send comments, problems encountered to:
                                    dennis.bushong@gilbertschools.net
   FFA Chapter                                 Chapter #



 FFA ID Number



      Name                  SAMPLE             Birthdate



    Beginning               1/1/2006            Ending        12/31/2006
      date                                       date



   Social Sec #           000-00-0000               Age



    Year in Ag                               Year in School

Greenhand Degree                             Chapter Degree

   State Degree



     Address                                        Phone



       City

    State Zip



     Parents

      name


                                                              Type of SAE

  Enterprise #1                         1

  Enterprise #2                         2

  Enterprise #3                         3

  Enterprise #4                         4

  Enterprise #5                         5


c255d814-925b-48eb-9fea-4a37ee77e8fc1       Cover                           Page 2
    Net Worth                                                                     SAMPLE

 1. CURRENT/OPERATING ASSETS                                                       1/1/2006   12/31/2006
     a. Cash on-hand, checking and savings                                           $0          $0
     b. Cash value --bonds, stocks, life insurance                                   $0          $0
     c. Notes & accounts receivable                                                  $0          $0
     f. Non-productively invested current personal assets
           (assets not in SAE current inventory)
  Itemize:




                                                                                     $0          $0
                                                                          Total      $0          $0

 2. b. Non-productively invested non-current personal assets
             (assets not in SAE non-current inventory)
  Itemize:




                                                                                     $0          $0
                                                                          Total      $0          $0


 6. CURRENT/OPERATING LIABILITIES
    a. Accounts and notes payable                                                    $0          $0
    b. Current/operating portion of non-current/capital debt                         $0          $0
    d. Current/operating liabilities associated with
          non-productive personal assets                                             $0          $0


 8. NON-CURRENT/CAPITAL LIABILITIES:
    a. Notes & chattel mortgage (total notes & chattel                               $0          $0
          mortgage minus current portions)
    b. Real estate mortgages, contracts (total real                                  $0          $0
          estate mortgages; contracts - current portions)
    c. Other non-current/capital liabilities (total other                            $0          $0
          non-current/capital liabilities - current/operating portions)
    e. Non-current/capital liabilities associated with                               $0          $0
          non-productive personal assets.




c255d814-925b-48eb-9fea-4a37ee77e8fc1                 NetWorth                                             3
                                                                       SAMPLE

           Leadership Activities, CDEs, other FFA
  Date                                                  Chapter Level    District   State   National
                   Activities and Awards




             Offices, Major Committees, Public
  Date                                                  Chapter Level    District   State   National
               Speaking, Parli Pro Activities




           Leadership Activities in the School and
  Date                                                   Local Level     District   State   National
                       Community




c255d814-925b-48eb-9fea-4a37ee77e8fc1                Activities                                        Page 4
 Current Inventory Statement                                            SAMPLE
A. Investment in harvested and growing crops:                   Beginning     Ending          Enterprise
                  Description                     Quantity        Value        Value           Number




                                                     TOTAL                 $0            $0
B. Investment in feed, seed, fertilizer, chemicals, supplies, prepaid
   expenses, and other current assets:                           Beginning      Ending        Enterprise
                  Description                       Quantity       Value         Value         Number




                                                   TOTAL                   $0            $0




c255d814-925b-48eb-9fea-4a37ee77e8fc1                     Current                                          Page 5
 Current Inventory Statement                                         SAMPLE
C. Investment in merchandise, crops and livestock purchases for resale:
                                                            Beginning      Ending         Enterprise
                 Description                    Quantity      Value         Value          Number




                                                TOTAL                  $0            $0
D. Investment in raised market livestock and poultry:
                                                           Beginning        Ending        Enterprise
                   Description               Quantity        Value           Value         Number




                                              TOTAL                    $0            $0




c255d814-925b-48eb-9fea-4a37ee77e8fc1                Current                                           Page 6
Non-Current Inventory                                                                  SAMPLE
E. Investment in non-depreciable draft, pleasure, or breeding livestock
    and poultry:                                                                                                 Enterprise
                                                                  Beginning Value            Ending Value
                  Description                        Quantity                                                     Number




                                                      TOTAL                             $0                  $0
F. Investment in depreciable draft, pleasure or breeding livestock:
                                         Acquisition    Depreciation                                             Enterprise
                                                                           Beginning Value   Ending Value
               Description                  Cost       Claimed to Date                                            Number




                                               $0.00               $0.00                $0                  $0



c255d814-925b-48eb-9fea-4a37ee77e8fc1                     Non-Current                                                     Page 7
Non-Current Inventory                                                                 SAMPLE
G. Investment in machinery, equipment, and fixtures:
                                        Acquisition   Depreciation                                              Enterprise
                                                                          Beginning Value   Ending Value
               Description                 Cost       Claimed to Date                                            Number




                                              $0.00               $0.00                $0                  $0
H. Investment in depreciable land improvements, buildings, and fences:
                                        Acquisition   Depreciation                                              Enterprise
                                                                          Beginning Value   Ending Value
               Description                 Cost       Claimed to Date                                            Number




                                              $0.00               $0.00                $0                  $0



c255d814-925b-48eb-9fea-4a37ee77e8fc1                     Non-Current                                                    Page 8
Non-Current Inventory                                              SAMPLE

I. Investment in land:                                                                       Enterprise
                                                       Beginning Value   Ending Value
                   Description          Quantity                                              Number




                                        TOTAL                       $0                  $0




c255d814-925b-48eb-9fea-4a37ee77e8fc1    Non-Current                                                  Page 9
                              Ledger sheet for :                 SAMPLE
              Account Codes for Expenses                           Account Codes for Income
                                                                  Cash profit or loss to Paid    Unpaid
                      Enterprise
                                                                         date            Hours   Hours
   #1                     1                                               $           -   0.0     0.0
   #2                     2                                               $           -   0.0     0.0
   #3                     3                                               $           -   0.0     0.0
   #4                     4                                               $           -   0.0     0.0
   #5                     5                                               $           -   0.0     0.0

                                                                 Account                Paid     Unpaid
  Date                Description                   Enterprise             $ Amount
                                                                  Code                  Hours    Hours




c255d814-925b-48eb-9fea-4a37ee77e8fc1              Ledger                                        Page 10
                              Ledger sheet for :            SAMPLE




c255d814-925b-48eb-9fea-4a37ee77e8fc1              Ledger            Page 11
                       Non SAE Income and Expenses
   Code                                          Total             Code                                       Total
     4.1   Non SAE / Ag Expenses             $           -           5.1   Non SAE / Ag Income           $            -
     4.2   Non Ag Expenses                   $           -           5.2   Non Ag Income                 $            -
     4.3   Educational Expenses              $           -           5.3   Gifts, Inheritances, Awards   $            -
     4.4   Non SAE Inventory Purchases       $           -           5.4   Non SAE Inventory Sales       $            -
     4.5   Taxes & FICA                      $           -           5.7   Unpaid Hours - Non Ag              0.0


                      Use only to row 247                                       Total Paid Hours               0
                                            SAMPLE                             $ Amount or                   Paid
 Date                          Item                          Code              Unpaid Hours                  Hours




c255d814-925b-48eb-9fea-4a37ee77e8fc1                    Non SAE                                                   Page 12
                                 SAMPLE              $ Amount or    Paid
 Date                    Item                 Code   Unpaid Hours   Hours




c255d814-925b-48eb-9fea-4a37ee77e8fc1     Non SAE                      Page 13
Income and Expense Summary of Entrepreneurship Supervised
   Agricultural Experience Program            SAMPLE
                                                                  Enterprises
                                                   #1    #2           #3        #4   #5        Total
1. Current/Operating Income
 a. Closing Current/ Operating Inventory           $0        $0        $0       $0   $0         $0
 b. Beginning Current/ Operating Inventory         $0        $0        $0       $0   $0         $0
 c. Change in Current/ Operating Inventory (a
                                                   $0        $0        $0       $0   $0         $0
    minus b)
 d. Cash Sales (3.1)                               $0        $0        $0       $0   $0         $0
 e. Value of Products Used at Home (3.2)           $0        $0        $0       $0   $0         $0
 f. Value of Production Transferred or Bartered
                                                   $0        $0        $0       $0   $0         $0
    (3.3)
 g. Value of Ag Labor Exchanged for Non-Cash
                                                   $0        $0        $0       $0   $0         $0
    Operating Expenses(3.4)
 h. Total Current/Operating Income                 $0        $0        $0       $0   $0         $0

2. Current/Operating Expenses
 a. Current/ Operating Inventory Purchased (2.1)   $0        $0        $0       $0   $0         $0
 b. Cash Current/ Operating Expenses-Feed (2.2)    $0        $0        $0       $0   $0         $0
 c. Non-Cash Current/ Operating Expenses-Feed
                                                   $0        $0        $0       $0   $0         $0
    (2.3)
 d. Cash Current/ Operating Expenses-Other (2.4)   $0        $0        $0       $0   $0         $0
 e. Non-Cash Current/ Operating Expenses-Other
                                                   $0        $0        $0       $0   $0         $0
    (2.5)
 f. Total Current/ Operating Expenses (add a
                                                   $0        $0        $0       $0   $0         $0
    thru e)
3. Net Current/Operating Income                    $0        $0        $0       $0   $0         $0



4. Non-Current/Capital Transactions
 a. Closing Non-Current/Capital Inventory          $0        $0        $0       $0   $0         $0
 b. Non-Current/Capital Sales (3.5)                $0        $0        $0       $0   $0         $0
 c. Beginning Non-Current/Capital Inventory        $0        $0        $0       $0   $0         $0
 d. Non-Current/Capital Purchases (2.6)            $0        $0        $0       $0   $0         $0
 e. Net Capital Transactions (a+b minus c minus    $0        $0        $0       $0   $0         $0
    d)


5. RETURN TO CAPITAL LABOR
  & MANAGEMENT (3 + 4e)                            $0        $0        $0       $0   $0

6. TOTAL RETURN TO CAPITAL
  LABOR & MANAGEMENT                                          Year Total                  $0




  c255d814-925b-48eb-9fea-4a37ee77e8fc1            Summary                                      Page 14
                                                                     SAMPLE

Income and Expense Summary of Placement Supervised
   Agricultural Experience Program

                                              1/1/2006        to        12/31/2006


                                             Total Hours Worked

                                          Unpaid    Paid     Total    Gross     Total Expenditures     Net
                                            A        B       (A+B)   Earnings
                                                                                                     Earnings


# 1                   1                    0.0       0.0      0.0       $0             $0               $0


# 2                   2                    0.0       0.0      0.0       $0             $0               $0


# 3                   3                    0.0       0.0      0.0       $0             $0               $0


# 4                   4                    0.0       0.0      0.0       $0             $0               $0


# 5                   5                    0.0       0.0      0.0       $0             $0               $0


      Totals                               0.0       0.0      0.0       $0             $0               $0




  c255d814-925b-48eb-9fea-4a37ee77e8fc1     Summary                                                     Page 15
 ADE SAE Summary                                                             SAMPLE

                                                  1/1/2006            to            12/31/2006

 Summary of Entrepreneurship                 Return to Management                           $0

 Summary of Placement                        Net Income                                     $0

                                             Paid Hours                    0.0

                                             Unpaid Hours                  0.0


 Owners Equity Productively Invested                                                    $0



        Leadership Activities, CDEs,          Chapter     District   State       National
       other FFA Activities and Awards          0            0         0            0


        Offices, Major Committees,            Chapter     District   State       National
     Public Speaking, Parli Pro Activities      0            0         0            0


         Leadership Activities in the          Local      District   State       National
           School and Community                  0           0         0            0




c255d814-925b-48eb-9fea-4a37ee77e8fc1            Summary                                         Page 16
Financial Balance Sheet Statement                                                        SAMPLE
                                                                                Beginning of   Ending of Year
A. Assets:                                                                      Year Value         Value
1. CURRENT/OPERATING ASSETS                                                      1/1/2006       12/31/2006
  a. Cash on-hand, checking and savings                                             $0              $0
  b. Cash value --bonds, stocks, life insurance                                     $0              $0
  c. Notes & accounts receivable                                                    $0              $0
  d. Current/Operating Inventory
     1. Investment in harvesting and growing crops.                                 $0              $0
     2. Investment in feed, seed, fertilizer, chemical, supplies,                   $0              $0
        prepaid expenses, and other current/operating assets.
     3. Investment in merchandise, crops, and livestock purchased                   $0              $0
        for resale.
     4. Investment in raised market livestock & poultry.                            $0              $0
      other Current/Operating
     5. Total current assets Inventory                                              $0              $0
  e. Subtotal-productively invested current/operating assets                        $0              $0
       (1a+1b+1c+1d5)
   f. Non-productively invested personal assets                                     $0              $0
  g.   Total current/operating assets                                               $0              $0

2. NON-CURRENT/CAPITAL ASSETS:
   a. Non-current/capital inventory
       1. Investment in non-depreciable draft, pleasure and breeding                $0              $0
          livestock and poultry.
       2. Investment in depreciable, draft, pleasure, and breeding livestock.       $0              $0
       3. Investment in machinery, equipment and fixtures.                          $0              $0
       4. Investment in depreciable land improvements, building and fences.         $0              $0
       5. Investment in land.                                                       $0              $0
       6. Subtotal-productively invested non-current/capital assets                 $0              $0
  b. Non-productively invested personal non-current/capital assets.                 $0              $0
  c. Total non-current/capital assets                                               $0              $0
3. TOTAL PRODUCTIVELY INVESTED ASSETS                                               $0              $0

4. TOTAL NON-PRODUCTIVELY INVESTED ASSETS                                           $0              $0

5. TOTAL ASSETS                                                                     $0              $0




  c255d814-925b-48eb-9fea-4a37ee77e8fc1                 Balance                                    Page 17
Financial Balance Sheet Statement (continued)                                                             SAMPLE
                                                                                              Beginning of   Ending of Year
B. Liabilities & Equity                                                                       Year Value         Value
6. CURRENT/OPERATING LIABILITIES                                                               1/1/2006       12/31/2006
   a. Accounts and notes payable                                                                  $0                 $0
   b. Current/operating portion of non-current/capital debt                                       $0                 $0
     (the portion of non-current debt during this calendar year)
      Subtotal current/operating liabilities associated with productively invested
   c. Subtotal --current/operating liabilities associated with productively invested assets       $0                 $0
      assets. (a + b)
   d. Current/operating liabilities associated with non-productive personal assets                $0                 $0
7. TOTAL CURRENT/OPERATING LIABILITIES                                                            $0                 $0
8. NON-CURRENT/CAPITAL LIABILITIES:
   a. Notes & chattel mortgage (total notes & chattel mortgage minus current                      $0                 $0
      portions)
   b. Real estate mortgages, contracts (total real estate mortgages; contracts                    $0                 $0
      minus current portions)
   c. Other non-current/capital liabilities (total other non-current/capital liabilities          $0                 $0
      minus current/operating portions)
   d. Subtotal - non-current/capital liabilities associated with productively                     $0                 $0
      invested assets       (a+b+c)
   e. Non-current/capital liabilities associated with non-productive personal                     $0                 $0
      assets.
   f. Total non-current/capital liabilities                         (d+e)                         $0                 $0
9. TOTAL LIABILITY ON PRODUCTIVE ASSETS                                                           $0                 $0
10. TOTAL LIABILITY ON NON-PRODUCTIVE/PERSONAL ASSETS                                             $0                 $0
11. TOTAL LIABILITIES                                                                             $0                 $0

12. OWNER'S EQUITY/NET WORTH
   a. Productively invested                                                                       $0                 $0
   b. Non-productively personally invested                                                        $0                 $0
   c. Total Owners Equity/Net Worth                                                               $0                 $0
13. Change in Productively Invested Owner's Equity
   (Line 12a, column B minus 12a, column A)                                                                          $0
14. Change in Non-Productively/Personal Invested Owner's Equity
   (Line 12b, column B minus 12b, column A)                                                                          $0
15. Gain or Loss in Owner's Equity                                                                                   $0
16. Working Capital                                                                               $0                 $0
   (total current/operating assets minus total current/operating liabilities)
17. Current Ratio                                                                                 $0                 $0
   (total current/operating assets divided by current/operating liabilities)                     to $1              to $1
18. Debt-To-Equity Ratio                                                                        #DIV/0!            #DIV/0!
   (Total liabilities divided by total owner's equity/net worth)                                 to $1              to $1




   c255d814-925b-48eb-9fea-4a37ee77e8fc1                           Balance                                         Page 18
   Summary of Productively Invested Capital                                                      SAMPLE
                                                                                        Ending Value of Current Year
                                                                                               ONLY, ending:
19 Supervised Agricultural Experience Program Equity                                                     12/31/2006
      Total of productively invested
   a. Accounts and notes payable equity                                                                      $0
      Total educational expenses
   b. Current/operating portion of non-current/capital debt                                                  $0
      (ONLY tuition, fees books are allowable on this line item)
      Total productively invested equity
   c. Subtotal - current/operating liabilities associated with productively invested assets                  $0
20. Total Non-Productive/Personally Invested Equity                                                          $0
21. Total Equity                                                                                             $0
22. Non-Supervised Experience Program Income
   a.   Student's earnings and income from agricultural activities not part of an SAE                        $0
   b.   Earnings from non-agricultural activities                                                            $0
   c.   Income other than earnings (gifts, inheritances, awards, etc)                                        $0
   d.   Total non-supervised experience program income                                                       $0
   e.   Taxes and FICA                                                                                       $0
   f.   Net non-supervised experience program income                                                         $0
23. Total Qualifying Productively Invested Equity                                                            $0
24. Value of Unpaid Labor                                                                                    $0
25. Adjusted Qualifying Productively Invested Equity                                                         $0


   D. Summary of Source and Use of Funds:
26. Earnings from Supervised Agricultural Experience Program
   a.   Student's return to capital, labor and management                                                    $0
   b.   Grand total net earnings from wage earnings                                                          $0
   c.   Total SAE Earnings                                                                                   $0
   d.   Value of unpaid labor                                                                                $0
   e    Adjusted total SAE earnings                                                                          $0
27. All Other Earnings and Income
   a.   Student's earnings & income from agricultural activities not part of the SAE                         $0
   b.   Total agricultural related earnings                                                                  $0
   c.   Earnings from non-agricultural activities                                                            $0
   d.   Income other than earnings                                                                           $0
   e.   Total non-agricultural related income                                                                $0
   f.   Total source of funds                                                                                $0
28. Use of Funds
   a. Total educational expenses                                                                             $0
   b. Taxes and FICA                                                                                         $0
   c. Total use of funds for personal expenditures                                                           $0
29. Maximum Possible Increase in Owner's Equity                                                              $0
30. Gain or Loss in Owner's Equity                                                                           $0




   c255d814-925b-48eb-9fea-4a37ee77e8fc1                  Balance                                           Page 19
                                            Ledger Sheet
               Enterprise                                          Student

  Code                                      Total      Code                                     Total
    2.1   Current Inventory Purchases   $                3.1   Cash Sales                  $
    2.2   Cash Feed Expense             $                3.2   Value of Home Use           $
    2.3   Non Cash - Feed Expense       $                3.3   Bartered Income             $
    2.4   Cash - Other Expense          $                3.4   Labor Excange Income        $
    2.5   Non Cash - Other Expense      $                3.5   Non Current Capital Sales   $
    2.6   Capital Purchases             $                3.6   Wages                       $
    2.7   Wage Expenses                 $                3.7   Unpaid Hours
    2.8   Taxes and FICA                $

                                                                      Total Paid Hours
                                                                  $ Amount or                  Paid
Date                        Item                    Code          Unpaid Hours                 Hours
                                       Leadership Activities
                                                                      Student

       Leadership Activities, CDEs and other FFA
Date                                                 Chapter Level   District   State   National
                        Activities




       Offices, Major Committees, Public Speaking,
Date                                                 Chapter Level   District   State   National
                    Parli Pro Activities




Date     Leadership Activities in the School and      Local Level    District   State   National
                     Community

								
To top