ࡱ > z
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y { | } ~ R o o t E n t r y F 6w W o r k b o o k l M s o D a t a S t o r e 3w6w U V 3 A C Y E J 4 A = = 2 3w6w I t e m
P r o p e r t i e s ^ N Q X K F L L A = = 2 3w6w I t e m
& P r o p e r t i e s
S u m m a r y I n f o r m a t i o n (
D o c u m e n t S u m m a r y I n f o r m a t i o n 8 H C o m p O b j - l ZO \ p KWillia7 B a =
= K8 L@ " 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l M T 1 -A r i a l 1 -A r i a l 1 -A r i a l M T 1 -A r i a l 1 -A r i a l 1 -A r i a l 1 -A r i a l M T 1 -A r i a l 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 4 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 , 8 C a l i b r i 1 8 C a l i b r i 1 8 C a l i b r i 1 > 1 4 1 < C a l i b r i 1 ? C a l i b r i 1 h 8 C a m b r i a 1 C a l i b r i 1
C a l i b r i "$"#,##0_);\("$"#,##0\) ! "$"#,##0_);[Red]\("$"#,##0\) " "$"#,##0.00_);\("$"#,##0.00\) ' " "$"#,##0.00_);[Red]\("$"#,##0.00\) 7 * 2 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_) . ) ) _(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_) ? , : _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_) 6 + 1 _(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)
mmmm\-yy
"$"#,##0 = 8 _("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_) 9 4 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_) "$"#,##0;[Red]"$"#,##0 "$"#,##0.00 0.0
0.00000000 $ [$-409]dddd\,\ mmmm\ dd\,\ yyyy [$-409]h:mm:ss\ AM/PM % [$-F800]dddd\,\ mmmm\ dd\,\ yyyy ff + ) , * , , ! P " P # # $ % ` & ' ( ) a > * ( 8 8 8 8 < * @ * `@ @ * x@ @ * p * h@ @ * x@ @ * x @ * x@ @ * |@ @ * x@ @ * h@ @ * # \ * |@ @ * |@ @ * H * H * ! x@ @ * # |@ @ * " x@ @ *
" |@ @ * # |@ @ *
x@ @ *
H *
" |@ @ * H *
! x@ @ * " |@ @ * ) X * ! x@ @ * " |@ @ * ) x@ @ * P * x@ @ * ( P *
L * x * ! p * x *
x * ) x * + | * |@ @ * ! x@ @ *
# |@ @ * ! x *
|@ @ * ! x@ @ * x * x@ @ * x@ @ * x@ @ * x@ @ * ! p@ @ * # | * x"@ @ *
# | * ! x@ @ * ! x!@ @ * x * " P * " x * " p * ` @ * ` * ` * D * d@ @ *
l @ *
l *
l * P * d@ @ * D * D * d!@ @ * d@ @
d@ @
d!@ @
d@ @
d@ @
d!@ @
d@ @ 7 l@ @ 7 d@ @ 7 h@ @ 7 |@ @ , # |@ @ ,
# |@ @ 7 # |!@ @ , # |!!@ @ 7 # |!"@ @ 7 # |@ @ 7
|@ @ 7 x@ @ , h@ @ , " |@ @ , ) P , # |@ @ 7
" |@ @ 7 " |@ @ 7 ) |@ @ 7 ! x@ @ , ( x @ * T * T * t * d * x@ @ * |@ @ * | * t * p * P * p@ @ * t@ @ * t@ @ * |@ * ! x@ @ * |@ @ * p @ * x@ @ , p@ @ , t@ @ , t@ @ , t@ @ 7 t@ @ 7 t@ @ , t@ @ 7 p * ! x@ @ , # x@ @ * x@ @ * |@ @ 7 |@ @ * x @ * l * h * ! x@ @ * p * | * p@ @ * p@ @ * t@ @ * t@ @ * P * x@ @ * x@ @ * p@ @ * ( | * x * x * | * | * | * | * | * l * h * l * l * ( x@ * P * ( x@ @ * | * |@ @ * l@ @ * |@ @ , # |@ @ , # |@ @ * |@ @ 7
# |@ @ 7 # |@ @ 7 L * L * h@ @ * x@ @ , | * | * \ * \ * | * l * h * H * x@ @ * |@ @ * |@ @ * |@ @ * |@ @ * X * ( | * |@ @ 7 ! x * ! p@ @ , ! x@ @ * |@ @ , , |@ @ , |@ @ 7 , |@ @ 7 |@ @ 7 ! x@ @ * ! x@ @ * ) x@ @ * ) |@ @ 7 H * `@ @ , ! |@ @ * " p@ @ * # x@ * ( |@ @ * ( x@ @ * `a@ @ , l@ @ , l@ @ * la@ @ , l@ * h@ @ , ( |@ @ * # |!@ @ , x@ @ * |@ @ , " |@ @ , d!@ @ d!@ @ d!!@ @ t@ @ * t@ @ , |@ @ 7 t@ @ * |@ @ * |@ @ * |@ @ * |@ @ * |@ @ * t@ * t@ * t@ * t * t * | * t * t * | * | * | * | * t * t * | * t @ * | @ * t@ @ * t @ * t @ * | @ * | @ * t@ * | @ * | * t * | * | * t * X * |@ @ * p@ @ * ( x@ @ * ) x@ @ * p@ @ * t@ @ * t@ @ * * | * x@ @ * x@ @ * p@ @ * | * x@ @ * ! |@ @ , ! |@ @ , | *
| *
| *
| * " |@ @ * " | @ * " | @ * * x@ @ * * x!@ @ * # |@ @ * # | @ * # | @ * ! |@ @ * ! | @ * ! | @ * " |@ @ * " | @ * " | @ * # |@ @ * # |@ @ * " |@ @ * " | @ * " | @ * * | @ * |@ @ * | @ * | @ * | *
| * ) |@ @ , ! |@ @ , x *
x * " x@ @ * " x @ * ) P , P * ( x@ @ , ( x @ , ( x @ , " x * " p * " p@ @ * " p @ * " p @ * x * " X * " X * " P * ) x@ @ , | | 1}- }
yyyy_(" }- }
yyyy_(" }- }
yyyy_(" }- }
yyyy_(" }A }
yyyy_(" ef (@_)_) }A }
yyyy_(" ef (@_)_) }- }
yyyy_(" }A }
yyyy_(" L (@_)_) }- }
yyyy_(" }- }
yyyy_(" }A }
yyyy_(" L (@_)_) }- }
yyyy_(" }- }
yyyy_(" }A }
yyyy_(" 23 (@_)_) }- }
yyyy_(" }- }
yyyy_(" }A }
yyyy_(" 23 (@_)_) }- } !
yyyy_(" }- } "
yyyy_(" }- } #
yyyy_(" }- } $
yyyy_(" }- } %
yyyy_(" }A } &
yyyy_(" (@_)_) }A } '
yyyy_(" (@_)_) }- } ( _(" }} } )
} _(" (@_)_)
} } *
_(" (@_)_) ??? ??? ???
??? }- } 1
_(" }A } 2
a _(" (@_)_) } } 3 }- } 4 ? _(" } } 5 } } 6 } } 7
??v? _(" ̙(@_)_)
}A } 8
} ? _(" (@_)_) }A } 9
e ? _(" (@_)_) }x } : ? _(" (@_
}} } ;
???? _(" ???(@_ ??? ???
??? } } = }- } >
? _(" }- } ?
? _("
20% - Accent1A
2 0 % - A c c e n t 1 %
20% - Accent2A "
2 0 % - A c c e n t 2 %
20% - Accent3A &
2 0 % - A c c e n t 3 %
20% - Accent4A *
2 0 % - A c c e n t 4 %
20% - Accent5M .
2 0 % - A c c e n t 5 ef %
20% - Accent6M 2
2 0 % - A c c e n t 6 ef %
40% - Accent1A
4 0 % - A c c e n t 1 %
40% - Accent2M #
4 0 % - A c c e n t 2 L渷 %
40% - Accent3A '
4 0 % - A c c e n t 3 %
40% - Accent4A +
4 0 % - A c c e n t 4 %
40% - Accent5M /
4 0 % - A c c e n t 5 L %
40% - Accent6A 3
4 0 % - A c c e n t 6 %
60% - Accent1A
6 0 % - A c c e n t 1 %
60% - Accent2M $
6 0 % - A c c e n t 2 23ږ %
60% - Accent3A (
6 0 % - A c c e n t 3 %
60% - Accent4A ,
6 0 % - A c c e n t 4 %
60% - Accent5M 0
6 0 % - A c c e n t 5 23 % !
60% - Accent6A 4
6 0 % - A c c e n t 6 % " Accent15 A c c e n t 1 % # Accent25 ! A c c e n t 2 % $ Accent35 % A c c e n t 3 % % Accent45 ) A c c e n t 4 % & Accent5A - A c c e n t 5 K % ' Accent6A 1 A c c e n t 6 F % ( Bad- B a d % ) Calculationu C a l c u l a t i o n } % *
Check Cell
C h e c k C e l l % ??? ??? ??? ??? + C o m m a ,( C o m m a [ 0 ] -& C u r r e n c y .. C u r r e n c y [ 0 ] /
Currency 2*
C u r r e n c y 2 0 Currency 2 2. C u r r e n c y 2 2 1 Explanatory TextG 5 E x p l a n a t o r y T e x t % 2 Good; G o o d a % 3 Heading 1( H e a d i n g 1 4 Heading 2; H e a d i n g 2 % ? 5 Heading 3( H e a d i n g 3 6 Heading 4( H e a d i n g 4
7 Inputu I n p u t ̙ ??v% 8 Linked CellK L i n k e d C e l l } % 9 NeutralA N e u t r a l e % " N o r m a l : Noteb
N o t e ; Outputk O u t p u t ???% ??? ??? ??? ??? <$ P e r c e n t
= Title T i t l e
> Total1 T o t a l % ? Warning Text? W a r n i n g T e x t % X T a b l e S t y l e M e d i u m 9 P i v o t S t y l e L i g h t 1 6 8 d q: F 3f f f f ̙ ̙ 3f 3 f ff 3f 3f 3 33 3 3f 33 333 \ ` Beg Inv. End Inv. 3 Beg Balance Sh. M End Balance Sh. )i
Family Living x Income Stmt Projections 6 Scorecard Instructions 8 _xlfn.SINGLE ; 8 ; }
; 8 ; }
;
; j ; * ; w ; ( 5 f April May June July August September October November December TOTAL Food
House Repairs Clothing Entertainment and Recreation Education & Reading Materials Medical Care & Drugs Utilities (non-farm) Rent (non-farm) Transportation & Auto (non-farm) Medical and Disability Insurance Life Insurance! Household Equipment & Furnishings Gifts Charitable Contributions! Additions to Personal Investments Additions to Retirement Accounts GROSS FAMILY LIVING WITHDRAWLS: FAMILY LIVING BUDGET) Personal & Recreational Vehicle Purchases EXPENSES Total Nonfarm Liabilities NOTE: VALUE AND DEPRECIATION IN THIS FORM ARE NOT NECESSARILY THE SAME AS YOU WILL USE ON YOUR TAXES: THIS FORM IS FOR BUSINESS PLANNING AND PROFITIBILITY ANALYSIS PURPOSES NOTE: Current Year Depreciation Value may need to be manually adjusted if item was purchased during the current year, to reflect only the months it was owned. + Nonfarm Income
Maturity DateD ** Capital sales should not include livestock sales in rows 13 & 14., + Capital Contributions (loan, grant, etc)/ + Capital Sales** (equipment, livestock, etc)' - Loan Payments (Principle & Interest) Fair Market Value: In order to determine the value of your assets, list all your assets and the year you acquired them. Consider if you could sell them today, what would you be able to sell them for? List this as your Fair Market Value. Purchase Price (when acquired): Depreciation should be based on the price you paid for item. List this separately from the fair market value. Vehicles Property Other nonfarm assets (describe) Loan principle balance$ Other nonfarm liabilities (describe) Total Nonfarm Assets7 Intermediate Liabilities (portion due beyond 12 months) 4 Long-term Liabilities (portion due beyond 12 months) Credit card balance(s) Stocks & bondsM Marketing supplies on hand now minus marketing supplies on hand 12 months ago Market/cull livestock sold Breeding livestock sold Calves sold
Chemicals Conservation expense8 Freight & trucking (incl. all milk check deductions)0 Labor hired (incl. FICA, workers comp, etc.)! Veterinary & medicine expense NOTES) NET EARNINGS (to be reinvested or saved): Actuals Dairy Production Information Number of cows Pounds of milk per cow per year Quantity of milk sold (lbs/year) Average price per cwt$ NET AFTER CAPITAL RESERVE ALLOCATION - Family Living Allocation - Capital Expenditures - Capital Reservec Rate of Return on Farm Equity = (net farm income - family living withdrawls)/average farm net worth Term-Debt Coverage Ratio = (net farm operating income + net nonfarm income + scheduled interest on term debt + depreciation - family living withdrawls)/scheduled principal & interest payments on term debt LOAN DETAILS Creditor
Interest Rate Montly Payment - Loan Principal PaymentsA END INVENTORY ASSET LISTING (for End of the Year Balance Sheet) *F BEGINNING INVENTORY ASSET LISTING (for Beginning Year Balance Sheet) * Actual (Non-Tax) Depreciation January February March Current Life Span Remaining is the amount of years of life each asset has left calculated from the total expected life span less the amount of years that have passed since it was put into service. Current Life Span Remaining is useful because it signals when an asset should be removed from your asset list and replaced, or whether its existing useful life and fair market value should be re-evaluated, and the data updated with new projected lifespan and current fair market value. Annual Depreciation Value is the annual expense rate for useage of each asset. To calculate annual depreciation, divide the assets fair market value when acquired by its expected life span in years.! Net Asset Value is the current value of the asset based on the original fair market value less the annual useage expense accumulated to date. This figure will be used for the balance sheet. To calculate net asset value calulcate current remaining lifespan by annual depreciation value. Annual Instructions: 1. Update the Current Year All formula calculations for current year depreciation, net current year asset value, and lifespan remaining will recalculate based on this update! 2. Add any new assets to the listg 3. Review list and update any changes - assets that have been sold, or are no longer of use on the farm 4. For any assets that have 0 life span years remaining reassess their current useful life left on the farm and add the additional years onto the original expected life span, reasses and update current fair market value for the asset. Farm cash/checking accounts Farm savings account *Marketing supplies on hand Current Fair Market Value Purchase Price when acquired Other Total Other5 CURRENT YEAR (for calculation of life span remaining)
; Depreciation-Expense Ratio = depreciation/gross farm income REVENUE ASSUMPTIONS (list): EXPENSE ASSUMPTIONS (list):! - Family Living and Income Taxes} Capital-Replacement Margin = net farm operating income - family living withdrawls - scheduled principal payments on term debt Net Farm Income from Operations Other: * courtesy of ̽̽ Extension Y (developed by K. Becker, D. Kauppila, G. Rogers, R. Parsons, D. Nordquist, and R. Craven;= adapted for use in the VT Farm Viability Enhancement Program) For the period of (dates): Place Name Here Place Date Here- * courtesy of and developed by Rosalie Wilson Item Quantity
Year Acquired Expected Life in Years Current Life span Remaining Previous Year Depreciation Value Current Year Depreciation Value Current Year Net Asset Value Current Assets (1 year)# Crop Inventory (growing and stored) Total Crop Inventory# Feed Inventory (growing and stored) Total Feed Inventory1 Market Livestock (raised and purchased) inventory Total Market Livestock Farm Supplies On Hand Total Farm Supplies On Hand Prepaid Expenses Total Prepaid Expenses$ Other Farm Products On Hand for Sale* Total Other Farm Products On Hand for Sale% Farm Products Stored for Personal Use+ Total Farm Products Stored for Personal Use Marketing Supplies On Hand Total Marketing Supplies On Hand Intermediate Assets (1-10 Years) Raised Breeding Livestock Total Raised Breeding Livestock Purchased Breeding Livestock" Total Purchased Breeding Livestock Farm Machinery Total Farm Machinery Farm Equipment Total Farm Equipment Long Term Assets (+10 years) Farm Buildings & Improvements# Total Farm Buildings & Improvements Expected Life in Years refers to how long you expect each asset to be of use on your farm. Consider each asset and list in years how long you think it will be of value to your farm.9 Net Farm Income Ratio = net farm income/gross farm income[ Farm Equity-to-Asset Ratio = (total farm assets - total farm liabilities)/total farm assetsC Farm Debt-to-Asset Ratio = total farm liabilities/total farm assets Farmer/Farm Name: As of (date): Directions for the Scorecard: (1) The scorecard will calculate all indicators and ratios if all four financial statements (including both balance sheets) have been completely filled out. The calculations used are based on available data in these spreadsheets. & (2) If you have not completed either A) the Prior Year Balance Sheet, or B) Accrual adjustments and/or depreciation in the Income Statement, then the following ratios will not correctly calculate, as they either use an average from the two balance sheets or the NFIFO from the Income Statement: < Rate of Return on Farm Assets (uses average farm assets)< Rate of Return on Farm Equity (uses average farm equity)( Operating Profit Margin (uses NFIFO)3 Asset-Turnover Ratio (uses average farm assets)r (3) The first column (base) is set to automatically input figures from the income statement. However, some line items are not found in the income statement and still need to be filled in; and if the cash flow projection is for months or quarters instead of years, you will need to delete this automatic info< rmation as it is yearly data rather than monthly or quarterly.1 (4) You can edit the line items to suit the farm. (2) Ensure that columns are well labeled with dates and whether the cash flow is done in months, quarters or years. We encourage cash flow projections done on a monthly or quarterly basis.% (3) Accrual adjustments will automatically be calculated based if the two balance sheets are completed. You can edit the line items to suit the farm, but remember to choose categories that will be useful for financial analysis and that will correspond to asset categories on the balance sheet. Nonfarm Liabilities (optional) ! Total Assets Adjusted for Nonfarm& Total Liabilities Adjusted for NonfarmE CONSOLIDATED NET WORTH: ADJUSTED ASSETS MINUS ADJUSTED LIABILITIES =/ Directions for Completing Cash Flow Projection: CASH FLOW PROJECTION
Projection #1
Projection #2
Projection #3
Projection #4 Year/mo: yr/mo:
Cash Receipts TOTAL CASH RECEIPTS
Cash Expenses Total Fixed Expenses TOTAL CASH EXPENSES RECEIPTS MINUS EXPENSES$ NET RETAINED CASH EARNINGS (DEFICIT) LIQUIDITY
Current Ratio Working Capital SOLVENCY Farm Equity-to-Asset Ratio Farm Debt-to-Asset Ratio Farm Debt-to-Equity Ratio
PROFITABILITY Rate of Return on Farm Assets Rate of Return on Farm Equity Operating Profit Margin REPAYMENT CAPACITY Term-Debt Coverage Ratio Capital-Replacement Margin FINANCIAL EFFICIENCY Asset-Turnover Rate Operating-Expense Ratio Depreciation-Expense Ratio Interest-Expense Ratio Net Farm Income Ratio6 Vulnerable ---------------------------- Strong Farm Finance Scorecard *! Farm products personally consumed Auto & truck CALCULATIONSG Current Ratio = total curent farm assets/total current farm liabilities@ Farm Debt-to-Equity Ratio = total farm liablities/farm net worthL W o r k i n g C a p i t a l = t o t a l c u r r e n t f a r m a s s e t s t o t a l c u r r e n t f a r m l i a b i l i t i e s Net Farm Income = gross cash farm income - total cash farm expense + inventory changes + depreciation & other capital adjustmentsp Rate of Return on Farm Assets = (net farm income + farm interest - family living withdrawls)/average farm assetsa Operating Profit Margin = (NFIFO + farm interest expense - family living withdrawls)/gross income; Asset-Turnover Rate = gross farm income/average farm assetsZ Operating-Expense Ratio = (total farm operating expense - farm interest)/gross farm income8 Interest-Expense Ratio = farm interest/gross farm income (9) You may provide schedule level information to explain both assets and liabilities in further detail on additional pieces of paper.q (10) Line items marked with an asterisk correspond to line items for accrual adjustments on the income statement.) Directions for Completing Balance Sheets:
BALANCE SHEET FARM ASSETS FARM LIABILITIES( Current Assets (liquid within 12 months) * Current Liabilities (due within 12 months) *Accounts payable *Accounts receivable- *Accrued (unpaid) interest not included above- *Crop and feed inventory (growing and stored)/ *Income taxes and Social Security taxes payable0 *Market livestock (raised & purchased) inventory *Farm supplies on hand. Principal due within 12 mos. on long-term debt *Prepaid expenses Operating loan principal balance% *Other farm products on hand for sale& *Farm products stored for personal use! Short-term loan principal balance1 Principal due within 12 mos. on intermediate debt Other current assets (describe)$ Other current liabilities (describe) Total Current Assets Total Current Liabilities- Intermediate Assets (held 1 to 10 years avg.) *Raised breeding livestock# Intermediate loan principal balance Purchased breeding livestock Farm machinery Farm equipment
Farm vehicles Book value of capital lease(s)2 Capital lease payments due (discount for interest)$ Other intermediate assets (describe)) Other intermediate liabilities (describe) Total Intermediate Assets Total Intermediate Liabilities Long-term Assets Farmland Long-term loan principal balance Farm buildings and improvements Farmhouse! Other long-term assets (describe)& Other long-term liabilities (describe) Total Long-term Assets Total Long-term Liabilities TOTAL FARM ASSETS TOTAL FARM LIABILITIESA FARM NET WORTH: TOTAL FARM ASSETS MINUS TOTAL FARM LIABILITIES = Nonfarm Assets (optional) (5) A farmhouse should be considered a farm asset to the extent it provides housing for a farm family, provides office space for the farm business, or provides farm-related income for the farm business. Other houses should also be included as farm assets, to the extent they are used to house farm workers. If the farm is a part-time farm, the value of the farm residences may be pro-rated (use a footnote to explain). (6) Nonfarm assets and liabilities are important for lenders. They may also be important to an understanding of the farm's financial status and management. Use your discretion in listing these, or add footnotes for explanation. (7) For current liabilities, include accounts currently payable, and accrued unpaid (overdue) interest. For income and Social Security taxes payable include only those taxes that will be payable during the 12 months following the date of the balance sheet. In addition, under current liabilities, it is preferred that you list the principal balance on short term debt, plus any principal that will be due within 12 months on intermediate and long term debt. If you follow this recommendation, make sure you don't count principal twice! Deduct any intermediate and long term principal you list as a current liability from the principal balances for intermediate and long term. (Study a FINPACK balance sheet to see how this is done.)0 (8) Capital leases are leases that provide for eventual ownership of a capital item, such as a tractor, a dairy cow, or equipment shed. Do not include operating leases, such as for real estate. On the asset side, estimate the book value of the leased item as of the date of the balance sheet. On the liability side, compute the number of remaining lease payments, including final buyout payment, but you should deduct from this an estimate of hypothetical interest that would be paid if the item had been purchased with a loan for the same period as the lease. (4) Please note that raised breeding livestock (such as dairy cattle), for the purposes of this form, are not treated as capital assets, since the cost of raising them has been expensed and since selling excess breeding livestock is a common income-producing practice on farms. Sales of raised breeding livestock should be listed on the income statement as cash farm income. Purchases and sales of purchased breeding livestock, on the other hand, should be treated as capital transactions, and should therefore not be listed on the income statement, except under depreciation. (See #5, #6, and #10 below.) Sales of market livestock, whether raised or purchased for resale, are cash transactions. (10) In the Accrued Expense Adjustments, for accounts payable, include only accounts that currently due, such as feed bills, etc. Do not include principal on debts unless such amounts are currently due. For accrued interest include only interest that is currently due. For taxes payable include only tax bills that are currently due. Asterisks correspond to items on the balance sheet. TOTAL CASH FARM INCOME Total Variable Expenses: Variable Expenses: Fixed Expenses: Total Fixed Expenses:
Other:( NET CASH FARM INCOME (income - expenses) NET FARM INCOME FROM OPERATIONS (NFIFO): Tot. Adj. Income - Tot. Adj. Expenses ( TOTAL CASH FARM EXPENSE+ Directions for Completing Income Statement:0 Instructions for Completing Financial Statements" (2) Always date the balance sheet. (3) You can edit the line items to suit the farm, but remember to choose categories that will be useful for financial analysis and for maki< ng accrual adjustments to income statements.S (4) Enter best estimate of fair market value for all assets. Do not use cost value! (13) Net Farm Income from Operations (NFIFO) is the profit or loss from the operation of the farm during one 12-month period. Thus, it represents income from operations that is available for family living expense, capital investment, savings, or reserves, after accrual adjustments and depreciation have been accounted for. On a separate sheet NFIFO can be adjusted for capital gains or losses to yield Net Farm Income. However NFIFO is the more useful figure, since it is used as the basis for profitability ratio analysis.A *Accounts receivable now minus accounts receivable 12 months ago H *Crop and feed inventory now minus crop and feed inventory 12 months agoP *Market livestock (raised and purchased) on hand now minus on hand 12 months agoD *Farm supplies on hand now minus farm supplies on hand 12 months ago: *Prepaid expenses now minus prepaid expenses 12 months agoN *Other farm products on hand for sale now minus on hand for sale 12 months agoV *Farm products stored for personal use now minus stored for personal use 12 months ago\ *Raised breeding livestock on hand now minus raised breeding livestock on hand 12 months agoK *Current accounts payable now minus current accounts payable 12 months ago : *Accrued interest now minus accrued interest 12 months agoZ *Income taxes and Social Security taxes payable now minus same taxes payable 12 months ago) Market livestock purchased for resale (8) Do not include nonfarm expenses. You may need to separate the farm portion from expenses that are shared between farm and nonfarm activities; this can be based on specific records or based on a factor, such as is used in filing the farm's income taxes. " (9) In order to accurately enter accrual adjustments, you will need two balance sheets, one as of the beginning date of the income statement, and one as of the end date of the income statement. In the absence of two balance sheets, estimate adjustments based on farmer interview or records. Cash Farm Income Cash Farm Expenses2 Accrued Income Adjustments (from 2 balance sheets) 2 Accrued Expense Adjustments(from 2 balance sheets) Total Accrued Income Adjustments! Total Accrued Expense Adjustmentsq (11) For depreciation, estimate actual depreciation for the 12-month period of the income statement. Actual depreciation is not necessarily equivalent to a farmer's IRS depreciation, which can be accelerated to create a tax deduction. The most significant tax depreciation to avoid on farm income statements is the IRS Section 179 deduction, which allows a tax filer to expense significant amounts of capital purchases in one tax year, to offset income. Putting a Section 179 deduction on a farm income statement will skew actual depreciation. Instead, estimate annual depreciation over the expected useful life of the asset. (12) Do not enter the value of unpaid family labor or "owner's draw" unless the farm is set up as a corporation with salaries paid to stakeholders, in which case these salaries can be reported under labor hired. If this is the case, please make a note at the bottom of the form.* Vermont Farm Viability Enhancement Programq (1) Please identify the farm, always using one or more farmers' names; the name of the farm may be included too. Farmer/Farm Name:P (2) Always state the calendar year or 12-month period that the statement covers.! ACCRUAL ADJUSTED INCOME STATEMENT Dairy products sold Field crops sold Vegetable products sold Custom farm work done for hire Other farm income received: Co-operative distributions Government program payments Bedding Breeding Custom hire Feed purchased Fencing Fertilizer Fuel and oil Repairs, maintenance Seeds Supplies Interest, farm share Insurance, farm share Property tax, farm share R e n t s p a i d l a n d , b u i l d i n g s # R e n t s p a i d e q u i p m e n t , l i v e s t o c k Utilities, farm share+ Advertising, web site, internet expense- Depreciation Expense (actual, see directions) ) Purchased (not raised) breeding stock Farm machinery and equipment# Farm buildings and improvements Total Depreciation Expense TOTAL ADJUSTED INCOME TOTAL ADJUSTED EXPENSES; (5) Do not enter sales of capital assets as income. When a capital asset is sold it can generate a capital gain or a loss, but technically speaking, selling off assets does not generate income from the operation of the farm, hence capital gains and losses are not to be computed in Net Farm Income from Operations. / 9 I (6) Do not include purchases of capital assets as expenses. Instead, when a capital asset is purchased, its value is depreciated each year of its useful life. The amount of this annual depreciation is the only figure that should be entered on the income statement as an expense related to that capital investment. (See #9 below.)y (7) Do not include nonfarm income. The income statement is designed to show the profitability of the farm as a farm only. j -M sM R M N HP ' R /T ;U EV $ 'W
X U] 4 _ ` b ` -c ,d e =f g i m D p M
q q x ~r 9 Is ^t mw (
+y ez
{ I | : } C h~ # S i $ U N H d ( c c B
ZO ( M : |
d MbP?_ * + % ~ & ?' ?( ?) ? " O XX ? ? & U } 7G } } . } t } .
} } t } .
} }
E
} t } . }
. } G @ @ @ @ ) @ ) @ @ H _ h
h @ @
@ @ @ V @ @ @ @ @ @ V @ @ @ @ @ @ V @
^? " ^^^^^^f f f f G G G G
_P " ______f f f f G G G G
`s " ``````f f f f G G G G $ aaaaaaaf f f f G G G G
\q \\\\\f f f f G G G G
]r ]]]]]f f f f G G G G $ VVVVVf f f f f f G G G G
Z ZZZZZZN
[
[N
e ~
\@ [[
t
I u
a
-b
.v
.w
/x
/Q
-y
-z
0{
|
(B@@@@AAH
} (C555566I
t ) D888744J
t
)
D888744J
t ) D888744J
t ) D888744J
~ # *
% r E:::999K (C555566I
(C555566I
t ) D888744J
t ) D888744J
t ) D888744J
t ) D888744J
# *
% r E:::999K (C555566I
(C555566I
t ) D888744J
t ) D888744J
t ) D888744J
t ) D888744J
# * %
% r E:::999K (C555566I D Y
l4 4 4 ( @ @ ( B @ , . @ @ @ @ a " . @ @ @ @ a " . @ @ @ @ a @ ! @ " @ # @ $ @ % V & @ ' @ ( @ ) @ * @ + @ , V - @ . @ / @ 0 @ 1 @ 2 @ 3 V 4 @ 5 6 @ 7 @ 8 @ 9 @ : V ; < = @ > @ ? @
(C555566I
! t ! ) ! D888744J
" t " ) " D888744J
# t # ) # D888744J
$ t $ ) $ D888744J
% % # % * ,
%! $ r % E:::999K & +D888744J
' ' +D888744J
( t ( ) ( D888744J
) t ) ) ) D888744J
* t * ) * D888744J
+ t + ) + D888744J
, , # , * 3
%( + r , E:::999K - +D888744J
. . +D888744J
/ t / ) / D888744J
0 t 0 ) 0 D888744J
1 t 1 ) 1 D888744J
2 t 2 ) 2 D888744J
3 3 # 3 * :
%/ 2 r 3 E:::999K 4 +D888744J
5 5 +D888744J
5
6 t 6 ) 6 D888744J
7 t 7 ) 7 D888744J
8 t 8 ) 8 D888744J
9 t 9 ) 9 D888744J
: : # : * A
%6 9 r : E:::999K ; +D888744J
;
< < +D888744J
<
= t = ) = D888744J
> t > ) > D888744J
? t ? ) ? D888744J D \
l. @ @ @ @ a " . @ @ @ @ a " . @ @ @ @ a " < @ @ @ @ a 0 < @ @ @ @ A V B C D @ E @ F @ G @ H V I J K h L M @ N @ O @ P @ Q V R S T @ U @ V @ W @ X V Y Z [ @ \ @ ] @ ^ @ _ V
@ t @ ) @ D888744J
A A # A * H
%= @ r A E:::999K B +D888744J
B
C c C +D888744J
C
D t D ) D D888744J
E t E ) E D888744J
F t F ) F D888744J
G t G ) G D888744J
H d H # H * Q
%D G r H E:::999K I +D888744J
I
J +D888744J
J
K K ,F ; <<L
K
L L (C558566J
L
M t M ) M D888744J
N t N ) N D888744J
O t O ) O D888744J
P t P ) P D888744J
Q Q # Q * T
%M P r Q E:::999K R (G==>=??M
R
S S 12232 1
S
T t $ T \@ ? ( T ? T
DT D DT ! T T DT DT ~
T T U DT " T
X
DT DT T
U t $ U \@ ? ( U ? U
DU D DU ! U U DU DU ~
U U V DU " U
U DU DU U
V t $ V \@ ? ( V ? V DV D DV ! V V
DV DV ~
V V W DV " V
V DV DV V
W t $ W \@ ? ( W ? W
DW D DW ! W W DW DW ~
W W X DW " W
W DW DW W
X X # X X
%T W r # X X
%T W r X # X m
%T W # X [
%T W # X v
%T W # X
T
%T W
X Y
Y
Z Z
Z
[ t $ [ \@ ? ( [ ? [
D[ D D[ ! [ [ D[ D[ ~
[ [ _ D[ " [
_
D[ D[ [
\ t $ \ \@ ? ( \ ? \
D\ D D\ ! \ _ D\ D\ ~
\ \ ] D\ " \
\ D\ D\ \
] t $ ] \@ ? ( ] ? ]
D] D D] ! ] ] D] D] ~
] ] ^ D] " ]
] D] D] ]
^ t $ ^ \@ ? ( ^ ? ^
D^ D D^ ! ^ ^ D^ D^ ~
^ ^ _ D^ " ^
^ D^ D^ ^
_ _ # _ _
%[ ^ r # _ _
%[ ^ r _ # _ \
%[ ^ # _ b
%[ ^ # _ \
%[ ^ # _
[
%[ ^
_ D g l@ a 0 < @ @ @ @ a 0 0 < < @ @ @ @ a 0 < $0 < ` @ a @ b @ c @ d @ e @ f V g @ h @ i @ j @ k @ l @ m V n @ o @ p h q @ r @ s @ t @ u @ v V w @ x @ y @ z @ { @ | @ } V ~ e @ `
a a
b t $ b \@ ? ( b ? b Db D Db ! b b
Db Db ~
b b } Db " b
c Db Db b
c t $ c \@ ? ( c ? c
Dc D Dc ! c c Dc Dc ~
c c d Dc " c
c Dc Dc c
d t $ d \@ ? ( d ? d Dd D Dd ! d d
Dd Dd ~
d d b Dd " d
e Dd Dd d
e t $ e \@ ? ( e ? e
De D De ! e e De De ~
e e f De " e
e De De e
f f # f f
%b e r # f f
%b e r f # f X
%b e # f i
%b e # f
%b e # f
}
%b e
f g
h c h
i t $ i \@ ? ( i ? i
Di D Di ! i i Di Di ~
i i j Di " i
i Di Di i
j t $ j \@ ? ( j ? j
Dj D Dj ! j j Dj Dj ~
j j m Dj " j
j Dj Dj j
k t $ k \@ ? ( k ? k
Dk D Dk ! k k Dk Dk ~
k k l Dk " k
k Dk Dk k
l t $ l \@ ? ( l ? l
Dl D Dl ! l l Dl Dl ~
l l m Dl " l
l Dl Dl l
m d m # m m
%i l r # m m
%i l r m # m f
%i l # m r
%i l # m k
%i l # m
X
%i l
m n o
p " p
q q
r t $ r \@ ? ( r ? r
Dr D Dr ! r r Dr Dr ~
r r s Dr " r
r Dr Dr r
s t $ s \@ ? ( s ? s
Ds D Ds ! s s Ds Ds ~
s s t Ds " s
s Ds Ds s
t t $ t \@ ? ( t ? t
Dt D Dt ! t t Dt Dt ~
t t u Dt " t
t Dt Dt t
u t $ u \@ ? ( u ? u
Du D Du ! u u Du Du ~
u u v Du " u
u Du Du u
v v # v v
%r u r # v v
%r u r v # v d
%r u # v y
%r u # v v
%r u # v
f
%r u
v w
x c x
y t $ y \@ ? ( y ? y
Dy D Dy ! y y Dy Dy ~
y y z Dy " y
}
Dy Dy y
z t $ z \@ ? ( z ? z
Dz D Dz ! z z Dz Dz ~
z z { Dz " z
z Dz Dz z
{ t $ { \@ ? ( { ? {
D{ D D{ ! { { D{ D{ ~
{ { | D{ " {
{ D{ D{ {
| t $ | \@ ? ( | ? |
D| D D| ! | | D| D| ~
| | } D| " |
| D| D| |
} d } # } }
%y | r # } }
%y | r } # } m
%y | # } f
%y | # } v
%y | # }
y
%y |
} ~
W' PPPPPPPP D 8 l" . $" . $" " 4 . $ , $$ e @
@ @ @ q @ 6 6 v @ @ + @
W( PPPPPPPP
X PPPPPPPP
XU YYYYYYYY
OV PPPPPPPP
OW PPPPPPPP
X
QY PPPPPPPP
RZ PPPPPPPP
Q[ PPPPPPPP
Q\ PPPPPPPP
Q] SSTUUUUT 2 2 2 2 (
( ( ( (
" , 3 T A ~ E X X bef b te f ark f for] f
ts.X m se X m
e! % v t Fd v e f } tiot }
) i> < d 3 2 A
g g CD hr h T W
[ ^
b e
i l
r u
y |
Current Year Net Asset Valueh< h Titlesh h ! $ ( + / 2 6 9 = @ M P T W [ ^ b e r u y | D G i l
Line Itemshb h T W [ ^ b e r u y | D G i l Datahf h T W [ ^ b e i l r u y | Current Year Dep @ <
ZO ( g , / /
d MbP?_ * + % ~ & ?' ?( ?) ? " O XX ? ? & U } 7G } } . } t } .
} } t } .
} }
E
} t } . }
. } G @ @ @ @ ) @ ) @ @ H _ h
h @ @
@ @ @ V @ @ @ @ @ @ V @ @ @ @ @ @ V @
^? " ^^^^^^f f f f G G G G
_O " ______f f f f G G G G
`s " ``````f f f f G G G G $ aaaaaaaf f f f G G G G
! \ [ Place Name Here \\\\\f f f f G G G G
! ] [ Place Date Here \\\\\f f f f G G G G $ VVVVVf f f f f f G G G G
Z ZZZZZZN
[
[N
e ~
\@ [[
t
I u
a
-b
.v
.w
/x
/Q
-y
-z
0{
|
(B@@@@AAH
} (C555566I
t ) D888744J
t
)
D888744J
t ) D888744J
t ) D888744J
~ # *
% r E:::999K (C555566I
(C555566I
t ) D888744J
t ) D888744J
t ) D888744J
t ) D888744J
# *
% r E:::999K (C555566I
(C555566I
t ) D888744J
t ) D888744J
t ) D888744J
t ) D888744J
# * %
% r E:::999K (C555566I D
l4 4 4 ( m m ( B @ , . @ @ @ @ a " . @ @ @ @ a " . @ @ @ @ a @ ! @ " @ # @ $ @ % V & @ ' @ ( @ ) @ * @ + @ , V - @ . @ / @ 0 @ 1 @ 2 @ 3 V 4 @ 5 6 @ 7 @ 8 @ 9 @ : V ; < = @ > @ ? @
(C555566I
! t ! ) ! D888744J
" t " ) " D888744J
# t # ) # D888744J
$ t $ ) $ D888744J
% % # % * ,
%! $ r % E:::999K & +D888744J
' ' +D888744J
( t ( ) ( D888744J
) t ) ) ) D888744J
* t * ) * D888744J
+ t + ) + D888744J
, , # , * 3
%( + r , E:::999K - +D888744J
. . +D888744J
/ t / ) / D888744J
0 t 0 ) 0 D888744J
1 t 1 ) 1 D888744J
2 t 2 ) 2 D888744J
3 3 # 3 * :
%/ 2 r 3 E:::999K 4 +D888744J
5 5 +D888744J
5
6 t 6 ) 6 D888744J
7 t 7 ) 7 D888744J
8 t 8 ) 8 D888744J
9 t 9 ) 9 D888744J
: : # : * A
%6 9 r : E:::999K ; +D888744J
;
< < +D888744J
<
= t = ) = D888744J
> t > ) > D888744J
? t ? ) ? D888744J D \
l. @ @ @ @ a " . @ @ @ @ a " . @ @ @ @ a " < @ @ @ @ a 0 < @ @ @ @ A V B C D @ E @ F @ G @ H V I J K h L M @ N @ O @ P @ Q V R S T @ U @ V @ W @ X V Y Z [ @ \ @ ] @ ^ @ _ V
@ t @ ) @ D888744J
A A # A * H
%= @ r A E:::999K B +D888744J
B
C c C +D888744J
C
D t D ) D D888744J
E t E ) E D888744J
F t F ) F D888744J
G t G ) G D888744J
H d H # H * Q
%D G r H E:::999K I +D888744J
I
J +D888744J
J
K K ,F ; <<L
K
L L (C558566J
L
M t M ) M D888744J
N t N ) N D888744J
O t O ) O D888744J
P t P ) P D888744J
Q Q # Q * T
%M P r Q E:::999K R (G==>=??M
R
S S 12232 1
S
T t $ T \@ ? ( T ? T DT D DT ! T T
DT DT ~
T T U DT " T
T DT DT T
U t $ U \@ ? ( U ? U DU D DU ! U U DU DU ~
U U V DU " U
d DU DU U
V t $ V \@ ? ( V ? V DV D DV ! V V
DV DV ~
V V W DV " V
V DV DV V
W t $ W \@ ? ( W ? W DW D DW ! W W DW DW ~
W W X DW " W
U
DW DW W
X X # X X
%T W r # X X
%T W r X # X
%T W # X [
%T W # X X
%T W # X
_
%T W
X Y
Y
Z Z
Z
[ t $ [ \@ ? ( [ ? [
D[ D D[ ! [ _ D[ D[ ~
[ [ \ D[ " [
[ D[ D[ [
\ t $ \ \@ ? ( \ ? \ D\ D D\ ! \ \
D\ D\ ~
\ \ ] D\ " \
\ D\ D\ \
] t $ ] \@ ? ( ] ? ]
D] D D] ! ] ] D] D] ~
] ] _ D] " ]
] D] D] ]
^ t $ ^ \@ ? ( ^ ? ^ D^ D D^ ! ^ ^
D^ D^ ~
^ ^ _ D^ " ^
^ D^ D^ ^
_ _ # _ _
%[ ^ r # _ _
%[ ^ r _ # _ [
%[ ^ # _ b
%[ ^ # _ ^
%[ ^ # _
t
%[ ^
_ D g l@ a 0 < @ @ @ @ a 0 0 < < @ @ @ @ a 0 < $0 < ` @ a @ b @ c @ d @ e @ f V g @ h @ i @ j @ k @ l @ m V n @ o @ p h q @ r @ s @ t @ u @ v V w @ x @ y @ z @ { @ | @ } V ~ e @ `
a a
b t $ b \@ ? ( b ? b Db D Db ! b b
Db Db ~
b b f Db " b
f
Db Db b
c t $ c \@ ? ( c ? c
Dc D Dc ! c c Dc Dc ~
c c d Dc " c
c Dc Dc c
d t $ d \@ ? ( d ? d Dd D Dd ! d d
Dd Dd ~
d d b Dd " d
e Dd Dd d
e t $ e \@ ? ( e ? e
De D De ! e e De De ~
e e f De " e
e De De e
f f # f f
%b e r # f f
%b e r f # f m
%b e # f i
%b e # f f
%b e # f
c
%b e
f g
h c h
i t $ i \@ ? ( i ? i
Di D Di ! i i Di Di ~
i i m Di " i
m
Di Di i
j t $ j \@ ? ( j ? j
Dj D Dj ! j j Dj Dj ~
j j k Dj " j
j Dj Dj j
k t $ k \@ ? ( k ? k Dk D Dk ! k k Dk Dk ~
k k k
Dk " k
l Dk Dk k
l t $ l \@ ? ( l ? l
Dl D Dl ! l l Dl Dl ~
l l m Dl " l
l Dl Dl l
m d m # m m
%i l r # m m
%i l r m # m v
%i l # m r
%i l # m j
%i l # m
i
%i l
m n o
p " p
q q
r t $ r \@ ? ( r ? r Dr D Dr ! r r Dr Dr ~
r r v Dr " r
v
Dr Dr r
s t $ s \@ ? ( s ? s Ds D Ds ! s s
Ds Ds ~
s s t Ds " s
s Ds Ds s
t t $ t \@ ? ( t ? t Dt D Dt ! t t Dt Dt ~
t t u Dt " t
r
Dt Dt t
u t $ u \@ ? ( u ? u Du D Du ! u u
Du Du ~
u u v Du " u
u Du Du u
v v # v v
%r u r # v v
%r u r v # v X
%r u # v y
%r u # v s
%r u # v
W
%r u
v w
x c x
y t $ y \@ ? ( y ? y Dy D Dy ! y y Dy Dy ~
y y } Dy " y
z Dy Dy y
z t $ z \@ ? ( z ? z Dz D Dz ! z z Dz Dz ~
z z z
Dz " z
{ Dz Dz z
{ t $ { \@ ? ( { ? { D{ D D{ ! { { D{ D{ ~
{ { {
D{ " {
}
D{ D{ {
| t $ | \@ ? ( | ? | D| D D| ! | | D| D| ~
| | |
D| " |
} D| D| |
} d } # } }
%y | r # } }
%y | r } # } }
%y | # } X
%y | # } y
%y | # }
|
%y |
} ~
W' PPPPPPPP D 8 l" . $" . $" " 4 . $ , $$ e @
@ @ @ q @ 6 6 v @ @ + @
W( PPPPPPPP
X PPPPPPPP
XU YYYYYYYY
OV PPPPPPPP
OW PPPPPPPP
X
QY PPPPPPPP
RZ PPPPPPPP
Q[ PPPPPPPP
Q\ PPPPPPPP
Q] SSTUUUUT 2 2 2 2 (
( ( ( (
" T ~ , r 3 | : A Yev U
[f X e \ X y X
G _ O _
Li f ) iJ f fit% v fro} v rat^ v e f } g o> < d A
g g GD hg h T W
[ ^
b e
i l
r u
y |
Current Year Datah6 h Titles_5hb h T W [ ^ b e r u y | D G i l Datah4 h Titles @ <
ZO @ 4 A ]J
d MbP?_ * + % & ?' ?( ?) ? " a XX333333?333333? & 43 U } $G } .
} $G } .
} tG } G } G } . G }
EG } tG } .G }
G } G @ @ @ ) @ ) @ @ @ @ @ @
@ @
^? yyyf f f f f f
z zzzf f f f f f
! { [ Place Name Here {{f f f f f f
! { [ Place Date Here {{f f f f f f uuuuf f f f f f
g
g J J J J J J
J vwwxJ J J J J J
P
P J J J J J J
eK
e"
eL
eM
N ^ ~
N ~
J J J J J J ffff
N _ ~
N J J J J J J
N ~
N ~
J J J J J J
Q % Z Z
N ~
J J J J J J
N
Z H J J J J J J
Q
Z %
N ~
J J J J J J
N Z ,
N ~
J J J J J J
Q Z 3
N ~
J J J J J J
Q Z :
N ~
J J J J J J
N ` Z A
N ~
J J J J J J
H
N ~
J J J J J J
N ~
N ~
J J J J J J N N J J J J J J
K # *
%
K #
% d bccd
K
K / h
Q Z Q
Q ~
Q Z X
Q ~
Q Z _
Q ~
Q % Z f
Q ~
Q ~
Q ~
Q ~
Q ~
Q ~
Q ~
Q Q D l* * c c L v ` 6 N i I s s s s a @ N j : ] ] ] ] J J 8 ! @ " # $ % & ' ( ) @ * + @ , - @ . / 0 1 2 3 4 5 @ 6 7 @ 8 9 : ; < = > ?
K #
%
K # *
% ! jkkl
" K "
" K 0 "
# Q ~
#
# Q ~
# #
$ Q ~
$
$ Q ~
$ $
% Q
% ( Z v
% Q ~
% %
& Q ~
&
& Q
~
& ' Q Q
( K # (
%# '
( K # ( 4
%# ' ) mnno
* K + * , D D D(
* K + * 6 D D D( + H H
, p
, qq ! , 6 D* D* - rsst
. K .
. K .
/ Q 2 ~
/
/ Q 1 ~
/
0 Q ) ~
0
0 Q , ~
0
1 Q * ~
1
1 Q - ~
1
2 Q + ~
2
2 Q - ~
2 3 Q Q
4 K . # 4 4
%/ 3 o
4 K # 4
%/ 3 5 H H
6 K % 6 8 D* D4 n
6 K % 6 ( D* D4 7 bccd
8 g
8 hi ! 8 D6 D6 9 : ; < = > ? D g lj 0 J J ] 8 j z A 0 8 8 8 8 j n A
x ? 3 M H yf G v ( * Da
4 6 8 > < d - - 7 7
8 8 ! ! ) ) , , g g CD hG h
# % Loan Infohy h / 2 / 2 # & # & Line Titleshj h / 2 / 2 # & # & Datah4 h Titlesg g hG h ( ( 4 4 4 4 @ <
ZO @ O
\ d
d MbP?_ * + % & ?' ?( ?) ? " a XX333333?333333? & 43 U } $G } .
} $G } .
} tG } G } G } . G }
EG } tG } .G }
G } G @ @ @ ) @ ) @ @ @ @ @ @
@ @
^? yyyf f f f f f
z zzzf f f f f f
! { [ Place Name Here {{f f f f f f
! { [ Place Date Here {{f f f f f f uuuuf f f f f f
g
g J J J J J J
J vwwxJ J J J J J
P
P J J J J J J
eK
e"
eL
eM
N ^ ~
N ~
J J J J J J ffff
N _ ~
N J J J J J J
N ~
N ~
J J J J J J
Q % Z Z
N ~
J J J J J J
N Z H J J J J J J
Q
Z %
N ~
J J J J J J
N Z ,
N ~
J J J J J J
Q Z 3
N ~
J J J J J J
Q Z :
N ~
J J J J J J
N ` Z A
N ~
J J J J J J
H
N ~
J J J J J J
N ~
N ~
J J J J J J N N J J J J J J
K # *
%
K # *
% bccd
K
K / h
Q Z Q
Q ~
Q Z X
Q ~
Q Z _
Q ~
Q % Z f
Q ~
Q ~
Q ~
Q ~
Q ~
Q ~
Q ~
Q Q D l* * c c L v ` 6 N i I s s s s a @ N j : ] ] ] ] J J 8 ! @ " # $ % & ' ( ) @ * + @ , - @ . / 0 1 2 3 4 5 @ 6 7 @ 8 9 : ; < = > ?
K #
%
K # (
% ! jkkl
" K "
" K 0 "
# Q ~
#
# Q ~
# #
$ Q ~
$
$ Q ~
$ $
% Q
% ( Z v
% Q ~
% %
& Q ~
&
& Q
~
& ' Q Q
( K # (
%# ' s
( K # ( 4
%# ' ) mnno
* K + * 6 D D D(
* K + * D D D( + H H
, p
, qq ! , D* D* - rsst
. K .
. K .
/ Q 2 ~
/
/ Q 1 ~
/
0 Q ) ~
0
0 Q , ~
0
1 Q * ~
1
1 Q - ~
1
2 Q + ~
2
2 Q - ~
2 3 Q Q
4 K . # 4 4
%/ 3 o
4 K # 4 6
%/ 3 5 H H
6 K % 6 8 D* D4 n
6 K % 6 D* D4 7 bccd
8 p
8 pp ! 8 , D6 D6 9 : ; < = > ? D g lj 0 J J ] 8 j z A 0 8 8 8 8 j n A
? % K
L : #N H a $ tle_ , f P v ( Li * ) i , fit 4
fro_ 6 rat 8 e f> < d
8 8 ! ! ) ) , , - - 7 7 g g CD hW h
# %
# %
Loan Infoh; h
Line Titles_3h4 h
Data_3hC h / 2 / 2
Line Titles_1h< h / 2 / 2 Data_1h4 h TitleshI h
# % Loan Info_2g g h? h ( ( 4 4 4 4 ( ( @ <
ZO Ej v
d MbP?_ * + % & ffffff?' ffffff?( ?) ? " M X 333333?333333? & <3 U } .$G }
t G } G k k k k k k
}? }}}J
~ ~~~J m m l l J
! | [ Place Name Here ||J
! | [ Place Date Here ||J n o n n J
W
R
S
T
#
%
-
l
l
l
#
% L
- L
< ! Y Y W j O O O O O O O O O O O O O O O O O O 0 X
4 > A
" g g cD h8 h
Line Itemsh: h Datah6 h Titles_1 @
ZO k y B 0
d MbP?_ * + % D & ?' ?( ?) ? " d XX ? ? & U } t4k } t
~ } tk } . k } k } ,k } k Column C k
}? }j j J
~C ~l l J m m l l J
! | ] [ Place Name Here ||J
! | [ Place Date Here ||J n o n n J
P 7 p
<
D ~
4 ~
5 ~
6 ~
E ~
F ~
l ~
l ~
l ~
l ~
N T {
N ~
N G ~
N T {
\ H T {
I ~
J ~
~
N r {
W # 3
% s {
W [ {
P 8 p s { J
\ t J {
[ ~
J
K ~
J D M l Y Y & & & & & & & & & & & & & " & & & ? * ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
L ~
J
! 7 ~
!
! J
" 8 ~
"
" J
# M ~
#
# J
$ N ~
$
$ J
% O ~
%
% J
& P ~
&
& J
' 9 ~
'
' J
( Q ~
(
( J
) : ~
)
) J
* 4 ~
*
* J
+ R ~
+
+ J
, S ~
,
, J
- T ~
-
- J
. ; ~
.
. J
/ ~
/
/ J
0 ~
0
0 J
1 ~
1
1 J
2 ~
2
2 J
3 \ # 3 C
% 2
3 J { 4 N T J {
5 \ 5 T J {
6 ~
6
6 J
7 U ~
7
7 J
8 V ~
8
8 J
9 W ~
9
9 J
: X ~
:
: J
; Y ~
;
; J
< Z ~
<
< J
= ~
=
= J
> ~
>
> J
? ~
?
? J D l* * * * * * * * * * * * * * * * * * * C * * * * * * * * * @ A B C D E 6 s F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
@ ~
@
@ J
A \ # A H
%6 @
A J { B N T J {
C W " % C A D3 DA
C J { D W [ J {
E u ! E _ D DC
E W v F W [ s { J
G W 9 G X s { J
H w ) % H V Z
Z
H s J
I w * % I E Z Z I s J
J w + % J ` Z Z J s J
K x , % K P Z
Z
K s J
L x - % L N Z Z L s J
M y . % M L Z Z M s J
N w / % N ^ Z Z N s J
O w 3 % O J Z Z O s J
P w 0 % P Z Z P s J
Q z ; # Q S
%H P Q s { J R W [ s { J
S z a $ S O $Q $ B S s { J T W [ s { J
U W : U X s { J
V x 1 % V W Z Z V
W x 2 % W X Z
Z
W
X x 3 % X Y Z Z X
Y W < # Y I
%V X Y {
Z W X Z {
[ W \ [ X [ {
\ q ] \ Z X \
] q ^ % ] Q Z _ Z f ]
^ N _ ^ K Z v ^
_ N % _ \ Z m Z } _ D M l* C E A G G G G G G G G G E F A A A ? " 9 A 9 ` a b c d & e f g h i j
` W ` # ` b
%\ _ e ` {
a { r a {
b W b ) b d $C $Y $` B b { c | c {
d } ! ! d j DS Db d { e {
f ! ~
f f
g i ~
g ! g
h N ~
h ! h
i i {
j = - j Dd Df Dg Dh j { ? E =
& & & v ' E I d J a K fo_3 L n I: M A N ) } O P 7 S Y m \
Lis ^ ) iX _ fit ` fro d rat j e f> < d f f f * i i g g _D h6 h Titles_1hQ h 6 @ 2 Line Titlesg g h/ h Y Y @ <
ZO x
d MbP?_ * + % * U & ?' ?( ?) ? " ` XX ? ? & U } %G } EG } G x @ @ @ @ @ @ @ @
U
U U U V @ @ @ @ @ @ @ @ @ U U U U U U
}? }}}}}
~ ~~~~~
A ! [ Place Name Here
p ! [ Place Date Here H
I >
I >
I
I
K
K
L ?
M
L
M
M
K
K
@ *
B
! D D ! D D ! D D ! D D
A ! D D ! D D
C %
D D d %
D D d
N H O O O O O
L S R R R R R N Z Dairy products sold~
Z % D D d % D D d % D D d % D D d
N
Z Market/cull livestock sold~
Z
N Z Breeding livestock sold~
Z N Z Field crops sold~
Z N Z Vegetable products sold~
Z N Z
Other:~
Z
N Z Other:~
Z N Z Other:~
Z N Z Other:~
Z N T T T T T T N Z ! Custom farm work done for hire~
Z N T T T T T T N Z Other farm income received: T T T T T T N Z ! Co-operative distributions~
Z N Z
Other:~
Z N T T T T T T
W
- O D D D D D Y Z Z Z Z Z Z
K [ [ [ [ [ [
\ [ [ [ [ [ [ D I l$ $ ] ] ^ b < z $ Y $ U ! U " U # U $ U % U & U ' ] ( U ) U * U + U , U - U . U / U 0 U 1 U 2 U 3 U 4 U 5 U 6 U 7 ] 8 U 9 V : V ; V < V = _ > V ? _ N Z . + Advertising, web site, internet expense~
! Z ! N ! Z Bedding~
! ! " Z ! " N " Z Breeding~
" " # Z " # N # Z # Custom hire~
# # $ Z # # $ N $ Z $ Feed purchased~
$ $ % Z $ $ % N % Z % Fencing~
% % & Z % % & N & Z & Fertilizer~
& & ' Z & & ' N ' Z ' ; 8 Freight & trucking (incl. all milk check deductions)~
' ' ( Z ' ' ( N ( Z ( Fuel and oil~
( ( 3 Z ( ( ) N ) Z ) 3 0 Labor hired (incl. FICA, workers comp, etc.)~
) ) * Z ) ) * N * Z * , ) Market livestock purchased for resale~
* * + Z * * + N + Z + Repairs, maintenance~
+ + , Z + + , N , Z , Seeds~
, , - Z , , - N - Z - Supplies~
- - . Z - - . N . Z . $ ! Veterinary & medicine expense~
. . / Z . . / N / Z /
Other:~
/ / 0 Z / / 0 N 0 Z 0
Other:~
0 0 1 Z 0 0 1 N 1 Z 1
Other:~
1 1 2 Z 1 1 2 N 2 Z 2
Other:~
2 2 3 Z 2 2
3 \ 3 B 3 3 3
- 3 ) 3 3 3 3 3 3 3 3 3 3 3 6 3 4 N [ [ [ [ [ [
5 \ 5 [ [ [ [ [ [ 6 N 6 Z 6 Auto & truck~
6 6 @ Z 6 6 7 N 7 Z 8 Insurance, farm share~
7 7 8 Z 8 7 8 N 8 Z 9 Property tax, farm share~
8 8 9 Z 9 8 9 N 9 Z : ? R e n t s p a i d l a n d , b u i l d i n g s ~
9 9 : Z : 9 : N : Z ; I # R e n t s p a i d e q u i p m e n t , l i v e s t o c k ~
: : ; Z ; : ; N ; Z < Utilities, farm share~
; ; < Z < ; < N < Z =
Other:~
< < = Z = < = N = Z >
Other:~
= = > Z > = > N > Z ?
Other:~
> > ? Z ? > ? N ? Z @
Other:~
? ? @ Z @ ? D l $ @ _ A _ B _ C b D E F _ G _ H _ I _ J K L M N O P _ Q _ R _ S T U V W X Y Z [ \ ] ^ _
@ ` @ @ @ @ @
- e @ B @ @ B @ @ @ @ @ @ @ @ B @ A ` ^ ^ ^ ^ ^ ^
B W B D B B B L L B 7 B B @ B B B B B B B B B C W a a a a a a
D W D N D D D L L D N D D N D D N D D N D D N D E W a a a a a a
F "$ * F # # # # # #
G "% * G # # # # # #
H & * H $ $ $ $ $ $
I & * I $ $ $ $ $ $
J & * J
K E * K
L F * L M c d d d d d d
N e N R N + N N ! L - - N R N N R N N R N N R N N R N O c d d d d d d
P G * P Q d d d d d d
R D R 3 R R R L L R R R R R R R
R R R S U
T _ # T U U _ U U
V V g V U W X Y Z [ \ ] ^ _ D
l < < < < < < < <
` a b c d e f g h i j k l m n o p q r s t u v w ` a b c d e f
g V h h i j k l m n o p q r s t u v w 4 H f m B l6 R t o> < d A
v v w w k k q q r r s s t t u u f f h h i i j j b b c c d d e e Y Y Z Z ` ` a a W W X X g g D hU h Production Infoh4 h Titleshj h
P P 2 J L 6 ? Datah9 h V Assumptionsh4 h F G Data_1h6 h H I Data_1_1g g h/ h h/ h @ <
ZO ( V
d MbP?_ * + % & ?' ?( ?) ? " ` XX333333?333333? & 43 U } t G } G } EG } E G } G } E G } G } G } tG }
G ( @ 6
?
m
n
o $ & ! [ Farmer/Farm Name: ! e [ Place Name Here " ! & [ As of (date): ! f
[ Place Date Here
V
V
V
% Z Z ? ~
@e@ %
G %
Z Z
i
V V
G % % Z * Z *
~
N@ ~
>@ &
G
G . G # Z * Z * Z *
~
D@ ~
Q@ &
G
G % G Z * Z ,
~
? ~
E@ &
G
V V
_ k Z d
G
G D . Z d Z 7 Z g Z * Z * ~
@ ~
@ &
G
G < G & Z d Z g Z , Z , ~
@ ~
$@ &
_ H
G 6 _ Z d Z 7 Z g Z ~
.@ ~
? &
G
V V
G Z D Z d Z f Z 7 Z ` Z g ;
Z 7 ? ~
a@ &
_ I
G 5 Z d Z g ;
_ j D l, & & & 6 * : [ , , Q 6
!
"
#
$
%
&
'
! V ! ! ! V " "
# G 6 # : Z * Z * # ~
# >@ # ~
# F@ # &
# G
$ G . $ G Z C Z 7 Z $ ~
$ T@ $ ~
$ N@ $ &
$ G
% G % % G Z ` Z % ~
% .@ % ~
% @ % &
% G f
& G % & G ' Z 7 Z & ~
& $@ & ~
& @ & &
& G
' G % ' G $ Z E Z ' ~
' $@ ' ~
' 4@ ' '
' G 6 x ` , Z *
j , #
_ $
Z b % I & D ' > < d B g g D h6 h Titles_3g g hO h # $ ' h' h @ <
ZO ,
d MbP?_ * + % & ?' ?( ?) ? " ` X 333333?333333? & 43 U } R@ } 2@ } @ ,
A ? A
F $
E E E E
B @ D D D
B % B B B
B & B B B
B ' B B B
B B B B
B B B B
B
B B B
B B B B
B B B B
B
B B B B B B B
E # C C C
B @ B B B
B B
B E E E
B D D D
B c B B B
B d B B B
B e B B B
B 5 B B B
B 6 B B B
B B B B
B = B B B
C > B B B
B ( B B B
E B B B B B B B B B B
B @ B B B B B B B B B B
@ D , ! " $ % & ' ( ) * +
@
! @
" B
$ E
% B
& @
' @
( @
) @
* @
+ @ v > < d B B % % % g g D @ <
This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision.
ng">
! " # $ % & ' ( ) * + , . DocumentLibraryFormDocumentLibraryFormDocumentLibraryFormschemaRef ds:uri="http://schemas.micr
s:schemaRef ds:uri="http://schemas
ackage/2006/metadata/core-properties"/>DocumentLibraryFormDocumentLibraryFormDocumentLibraryForm
Oh +'0 H P d x
Ethan Parke KWillia7 Microsoft Excel @ =!N@ D=@ Oү[k
՜. +,D ՜. +,
X ` p
I VHCB Document Beg Inv. End Inv. Beg Balance Sh. End Balance Sh. Family Living Income Stmt Projections
Scorecard
Instructions 'Beg Balance Sh.'!Print_Area 'Beg Inv.'!Print_Area 'End Balance Sh.'!Print_Area 'End Inv.'!Print_Area 'Family Living'!Print_Area 'Income Stmt'!Print_Area Instructions!Print_Area Projections!Print_Area Scorecard!Print_Area Worksheets
Named Ranges x : B ContentTypeId , 0x01010085D6C3DF5805E541AD819B10363E88AF
F Microsoft Excel 2003 Worksheet Biff8 Excel.Sheet.8 9q