Whole Farm Input Sheets
Description of Input Information


1.       The initial year of the analysis corresponding to the year the input information has been provided. (Ex. 1997 would indicate that 1997 data was entered on the input sheets and is the first year of the analysis) (Back)
2. Total Acres of: (Back)
a.         Cropland including tillable land, land in roads, irrigation ditches, etc.
b.         Pastureland including improved, unimproved , CRP and woodlands.
3. Cropland Acres: (Back)
a.         Acres of cropland owned by the business entity.
b.         Acres of cropland leased by the business entity including cash and share leased or any combination.
c.         Total owned and leased non-tilled land such as roads, homestead, etc.
4. Pastureland Acres: (Back)
a.         Acres of pastureland owned by the business entity.
b.         Acres of pastureland leased including cash and share/gain leases.
5. Beginning cash balance in business checking account as of January 1st of the initial year of the analysis. (Back)
6. Beginning Assets - includes all personal and business assets that are not listed on the machinery list. Note: exclude personal assets if only the farm business is intended to be analyzed. Do not include checking account/short term savings. This will be counted in cash on hand. (Back)
Description - short description of asset such as bank account type, house, land, etc.
Beginning market value - market value of asset or balance of the account January 1st of the first year of the analysis.
Cost basis - remaining basis on purchased assets as of January 1st of year 1.
Asset type - whether the asset is real estate (RE), a regular investment (RI) in which annual gains are taxable, a tax deferred (TD) investment or a tax exempt (TE) investment.
Growth category - what best describes the growth of the asset over time:
       
  •       real estate (RE)
  •        
  •       low risk savings account type (LR)
  •        
  •       higher risk investments such as mutual funds and stocks (HR)
  • Growth rate - expected or actual growth rate for the investment during the first year of the analysis
    Annual contribution - the fixed annual contribution (dollar amount per year) that will be added to the asset.
    Annual dividend - the fixed annual dividend (dollars or percent)that will be received from this asset
    Purchase Date - the year the asset was bought or initiated in terms of an account or the year that you intend to purchase an asset.
    Down Payment - portion of the purchase price that was/will be paid upon asset purchase. Note: for assets such as stocks, etc. this will be 100%.
    7. Outstanding Loans - includes all personal and business loans that are not listed on the machinery list. Note: exclude personal loans if only the farm business is intended to be analyzed. (Back)
    Description - short description of debt such as house, land, etc.
    Beginning loan balance - loan balance as of January 1st of the initial year of the analysis.
    Remaining Years - the number of years left to be repaid on the note. For example, if your home loan was for 30 years and you bought it in 1980 then there would be 11 years remaining on the note in 1998.
    Interest Type - whether the interest rate associated with the note is fixed or variable.
    Interest Rate - the current interest rate associated with the note such as 8.5%.
    Loan Term - all loans are categorized as either short, intermediate or long term.
    Unit Association - if the loan is associated with a particular production unit enter the unit number.
    Origination Year - the year the loan was initiated.
    Advanced Principal Payments - fixed annual advanced principal payments.
    Year Paid Off - the year in which the loan is to be paid off.
    Farm/Non-farm Loan - designate whether the loan is a farm or non-farm expense loan.
            a. Enter '0.0' for a farm expense loan
    b. Enter '1.0' for a non-farm expense loan
    8. Total Labor Costs (Back)
    a.         Number of full-time employees on the operation other than owner/operator.
    b.         Total compensation per full-time employee including wages, social security, health benefits, and in-kind compensation such as housing or beef.
    c.         Annual cost of part-time labor utilized on the operation.
    9. Tax Information (Back)
    a.         Number of personal income tax exemptions taken by the owner-operator.
    b.         Number of children under the age of 18 years.
    c.         Annual federal income tax credits.
    d.         Annual federal income itemized tax deductions taken.
    e.         Annual property taxes on land and buildings
    f.         Annual personal property taxes on items such as vehicles, cattle, and farm equipment. This value is typically zero for Texas.
    g.         Annual cost of other taxes such as irrigation district and road and bridge. Normally zero.
    10. Other Whole Farm Costs - annual costs of specified overhead costs. (Back)
    a.         Annual cost of accounting and legal fees.
    b.         Annual cost of repairs and maintenance and general farm and ranch supplies.
    c.         Annual insurance costs for the operation including vehicles, equipment, grain bins, equipment sheds, and farm liability insurance. Note: Excludes employee health benefits.
    d.         Annual cost of miscellaneous overhead expenses such as license tags, magazine subscriptions, etc.
    e.         Annual feed, shoeing, and veterinary costs for any horses on the operation.
    f.         Annual fuel and labor costs. Note: If you enter this number as a total for the farm, then leave tillage fuel costs blank on the crop unit input sheets.
    g.         Annual business phone (including cellular), utilities, and DTN expenses for the operation. Note: If the number you enter includes irrigation fuel, then leave irrigation fuel costs blank on the crop unit input sheets.
    h.         Annual cost of all other uncategorized farm expenses such as business travel costs.
    11. Form of business such as sole proprietor such as partnership, corporation, etc. (Back)
                Enter a "0" if a Sole Proprietorship
    Enter a "1" if a Partnership
    Enter a "2" if a C-Corp.
    Enter a "3" if a S-Corp.
    a.         Percent of business owned by the primary partner or shareholder.
    b. Total annual fixed dividend paid by the corporation.
    c. Percent of beginning cash reserves paid as dividends at the beginning of each year.
    12. Primary Partner (Back)
    a.         Primary partner's annual guaranteed salary for labor contribution.
    b. Primary partner's annual guaranteed salary for property contribution.
    c. Primary partner's annual bonus calculated as a percent of receipts. Entered as a percent.
    13. Other Partner/Partners (Back)
    a.         Other partner's annual guaranteed salary for labor contribution.
    b. Other partner's annual guaranteed salary for property contribution.
    c. Other partner's annual bonus calculated as a percent of receipts. Entered as a percent.
    14. Operating Loan (Back)
    a.         Total amount of the operating loan granted by lender - regardless of amount accessed.
    b. Interest rate charged on operating loan.
    c. Total number of months the operating loan is at its maximum divided by 12.
    15. Terms for New Debt (Back)
    a.         Number of years a cash flow deficit can be financed over.
    b. Number of years a new or refinanced intermediate term asset can be financed over.
    c. Interest rate charged on intermediate term debt such as equipment loans.
    d. Average minimum down payment required on intermediate term debt. Generally, 20 to 30 percent.
    e. Fee charged by lender to refinance a cash flow deficit.
    f. Interest rate charged on new long term debts such as land.
    g. Interest rate earned on short-term savings such as a passbook savings or checking account.
    16. Annual value of farm income earned from side activities such as custom work, consulting, or cooperative patronage dividends. This number can change from year to year. (Back)
    17. Off-farm Income (Back)
    a.         Annual value of non-taxable income, such as social security which is already taxed.
    b. Annual value of taxable, off-farm salary income for the farm operator.
    c. Annual value of taxable, off-farm salary income for the spouse.
    18. Family Living Expenses (Back)
    a.         Minimum level of annual family living expenses.
    b. Maximum level of annual family living expenses.
    c. Annual family living expenses for the first year of the analysis.
    19. Ending Cash Decision - the user can decide what to do with ending cash in any year above the level indicated in 19a. (Back)
    a.         Ending cash balance above this level will be used as indicated in 19b and 19c.
    b. Prepay inputs such as seed, fertilizer, etc. up to the amount specified.
    c. Expenses prepaid the year prior to the first year of the analysis.
    d. Prepay principle on notes and/or invest in long-term investments up to the limits indicated.
    20. Leased Equipment - consists of any equipment leased under annual or long-term arrangements. Enter the annual fixed lease payment and length of lease if multi-year. (Back)
    21. Summary of Equipment Complement (Back)
    Equipment Name - short description of equipment such as JD4020 or chisel plow.
    Year Purchased - the year that you bought the equipment.
    Current market value - market value of equipment as of January 1st of the first year of the analysis.
    Current replacement cost - the current replacement cost of this particular item. This may be a used equipment price if you would replace this piece of equipment with used equipment. If the equipment is to be replaced with a new rather than used replacement then enter the replacement cost of the new item.
    Economic Life - the number of years you will own and use the equipment. Note: this is not how many years the equipment has left.
    Replace with New or Used - will you replace this particular piece of equipment with a new or used replacement.
    Remaining Basis - remaining tax basis in the equipment.
    Remaining Loan Balance - the amount of principle owned on this piece of equipment as of January 1st of initial year of the analysis. Note: this may be zero.
    Yrs Remaining on Note - the number of years left to be repaid on the note. For example if the loan was set for 5 years on a new tractor and you bought it 1995 then there would be 2 years remaining on the note in 1998.
    Fixed or Variable Int. - is the interest rate associated with the note fixed or variable.
    Interest Rate - the interest rate associated with the note such as 8.5%.
    Percent Down Payment - is the percentage paid down when the equipment was first purchased.