аЯрЁБс>ўџ ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџўџџџўџџџ   !"#$%&')ўџџџ*ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot EntryџџџџџџџџДРF`снзЗМ(@PerfectOffice_MAIN&џџџџџџџџџџџџ ЂLSummaryInformation(џџџџ0PerfectOffice_OBJECTS,џџџџџџџџџџџџ`снзЗМ`снзЗМўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ эЈ  LBћ  %&'( @@рраа0юя№ёђчѓєѕdіїј [љ Xњќ$ ArialЈќьЈ’цTЮЧњ эЈ$ ArialЈќьЈ’цTЮЧњ эЈ  Bћ    ^ ddэЕ їЦА> š™™™™™Љ?З& ќЉёвMb@?  # Ÿ   Ё  f g i2 § ў-./g 0d џџэЈЇ“‚TRсpяЈ6ЪЬASSETS$џбœuˆ<ф7~Ь97рж,ж6,и‚†и ‘…кк65d2[\–B666660/// 0  ™ЁCURRENT FARM ASSETSe.Cash on hand and in checking accounts2Certificates, savings, and other accounts*Accounts and notes to be receivedCrops and feed Livestock to be sold Growing crops & Supplies and prepaid expensesLeasesOther"ЁTOTAL CURRENT FARM ASSETS ЁINTERMEDIATE FARM ASSETS*Accounts and notes to be receivedBreeding livestock:c description     ,Machinery, equipment, and vehiclesCo-op stock0 Cash value, farm related life insurance!Other2#Fertility bank '($ needed to rebuild soil)&$ЁTOTAL INTERMEDIATE FARM ASSETS&ЁLONG TERM FARM ASSETS((Real estate worksheet: OPTIONAL)qtract name * + , - .1Co-op stock2Other3ЩTOTAL LONG TERM ASSETS6‘TOTAL FARM ASSETSйBALANCE SHEET3qdate prepared ˜ ˜ P P no./ head      $P &˜ (p)qac/pasture * + , - . 3P 6Ј ˜ P P PWorksheet price/unit      $P &˜)qac/crop * + , - ./СTotal real estaten 3P 6Ј ˜ P  P  total% ўрџр% ўрџр% ўрџр% ўрџр% ўрџр $P &P)qac/timberY * + , - . /а 3P 6Јqname ЩaddressQ'$ VALUE  {  g+ `Ÿ@ р ˆ   р  ˆ  р  ˆ       "нЩ@Pёџџџ А       "Pџќџџр     ! "#•  рW$C       ђџѓџљџњџћџќџ§џџџ &А)'$ value* €„.A + , - . "/„„.APћџџџ 1 2-3н„„.A  ќџўџџџ-6Ејы.A  нџЩdLM 6™/3Я$ ArialЈPэЈ’цTЮЧ3`эЈЯ$ArialЈPэЈ’цTЮЧ3`эЈЯ$ ArialЈPэЈ’цTЮЧ3`эЈЯ$ ArialЈPэЈ’цTЮЧ3`эЈЯ$ArialЈPэЈ’цTЮЧ3`эЈЯ$ArialЈPэЈ’цTЮЧ3`эЈЯ$ ArialЈPэЈ’цTЮЧ3`эЈш@џџџРРР€€€џџџџџџџџџ€€€€€€€€€цTMonth' 'D', 'YYYYа Normalа Commaа Currencyа Percentа Fixedа DateаHeading 1аHeading 2а Totalа Comma0а Currency0Ю 0ў33@Ю R033@Ю 2033@Ю B033@Ю 033@Ю x033@Ю 033@Ю 033@Ю 0 33@Ю P033@Ю 0033@Ю 0A33@Ю 0033DЮ 033@Ю 033@Ю 0@ 33DЮ 0DЮ 0€033DЮ 033DЮ 0E033DЮ 0€ 33DЮ 20€"33DЮ 833@Ю 0 3DЮ 033DЮ 20@"33DЮ 033@Ю 0Q 33DЮ 0U 33DЮ 0DЮ 0D 03DЮ 833@Ю 0DЮ 0D 30DЮ 20T"33DЮ 033@Ю 0DЮ 2033@Ю 0E 30DЮ 0D 00DЮ 0T 03DЮ 0D 33DЮ 20U"33DЮ 20DЮ 00DЮ 00U"33DЮ 833@Ю 0D030DЮ 20U"33DЮ 2033@Ю 0D033DЮ 20DЮ 20€233DЮ 0T 33DЮ 033@Ю 20E"33DЮ 0E 33DЮ 20D"33DЮ 20T"03DЮ 0Q033DЮ 833@Ю 833@Ю 833@Ю 3Ua33DЮ 23Uc33DЮ 23C33@Ю 833@Ю 3Uq33DЮ 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 0A33@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 833@Ю 0€033D—тdHY!_dо<€ аа “€џџџ? Тњl”YРQ$$€  Aно€ аа  ‡џџџ? РРР€     МЩЭк‹ wY@W џswW H H X (p„Т lwwwwwwwwg™t•№?wwЅ€€€Є€€€€Ђ€€€Є€€€‚GЈ!œpQpСvwwwwwww„€g™t•№?wwЅ€€€Є€€€Є€€€€Ђ€€€€€GЈ!œpQpСvwwwwwwwwwwwwwwwwwwwwwwwgшшC љџ_pxШxШpwwww†,€Р lwwgxЈxЈpwwww†Т lwwwwwwww„Т lwwwwwwwwwwwwwwwww‚Т lww†wwwwwGЈ!œpQpСvwwwww€d€2АX,ww7Ј!œpQpСvww’џџwww‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ‚џ†wXpwwwЃШw ’ † ’ іЮo*КэйШ?чВš5аdwwww„Т lww† ‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚‚wwwwwƒ€w‘ПџwЁППџwџ@wЁџППw‘џ€w џ€w‚w €џw€€џw џџ€wџwƒџ‡џ‡џ”џџ•џ€…П–ПП†П–ПП†€ЄџЄџџЄџЄџџЄџџ„€wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwк‚ЮЫ*мŠС'Ыл"Ым"Ып" ‡ƒџЫр" ‡ƒџЫйЪНП Р ZС лТО$ $€       ”TГq€  d2X, ‡џџџџX1Axisџ? РРР€ –TГs€  d2X, ‡џџџџY1Axisџ? РРР€  —TГt€  d2X, ‡ џџџџY2Axisџ? РРР€ }Гj€  d2X, ‡џџџ1џPaneџLeftWallџRightWallџBaseџSeriesџSeriesLabelџ? РРР€  YЗm€  d2X, ‡џџџ џX1Titleџ? РРР€ ЫvЧ’YЗo€  d2X, ‡џџџ џY1Titleџ? РРР€ wЧ“YЗp€  d2X, ‡џџџ џY2Titleџ? РРР€ =wЧTГl€  d2X, ‡џџџџLegendџ? РРР€ }дХZ  шш ‡ џџџџTitleџ? џџџ€$Arialџџџџ№Arial "]Z  %&'( @@рраа0юя№ёђѓєѕdіїј љ ањќ$ ArialЈќьЈ’цTЮЧњ эЈ$ ArialЈќьЈ’цTЮЧњюџ§џ ˜ ј № №  h  №СField  сName ! " # $ % & ' ( ) * + , - . /,0Total farm fertility credit or debit ˜ P 9Crops and feed worksheet  Crop       & 9Livestock to be sold worksheetqLivestock      ЩGrowing crops worksheet qCrop     "Fertility bank worksheet:r 8 q'$/lbs of P ! " # $ % & ' ( ) * + , - . / ˜ P €  Units ш        @q Units      PqAcres     "ASoil test recommendations q'$/lbs of K ! " # $ % & ' ( ) * + , - . / P H '$per unitY        Total  @q'$ per unit      Total PqCost/acreY      Total ј q'$/t of lime ! " # $ % & ' ( ) * + , - . /  H   Total% @Ÿ@ ўрџр% @ ўрџр% @ ўрџр% @ ўрџр% @ ўрџр" `Ÿ@Pћџџџ  А q Total%  ўрџр%  ўрџр%  ўрџр%  ўрџр%  ўрџр" Pћџџџ  А q Total%  ўрџр%  ўрџр%  ўрџр%  ўрџр%  ўрџр" Pћџџџ  А qfield total" !эP§рџр" "эP§рџр" #эP§рџр" $эP§рџр" %эP§рџр" &эP§рџр" 'эP§рџр" (эP§рџр" )эP§рџр" *эP§рџр" +эP§рџр" ,эP§рџр" -эP§рџр" .эP§рџр" /эP§рџр" 0•Pёџўџ  ˆЫЪЬ LIABILITIES$џбœuˆ<ф7~<‹7рж4,иoи…и…иb†и ‡к45dP[\–<4444442  ЩCURRENT FARM LIABILITIES:qFarm accounts and notes payable in next 12 monthsuqCreditor        . Current portion of Principal due on:, Current portion of Interest due on:*Intermediate liabilities worksheetqloan nameY     ,Long term farm liabilities worksheetqloan nameY e     "Accrued Taxes on:a$Accrued rent and lease(%qAccrued rent and lease worksheet"&Щname and type of contract ' ( ) *0,Other liabilities due payment this year - &.9TOTAL CURRENT FARM LIABILITIES&/ёINTERMEDIATE FARM LIABILITIES 0№"1ёLONG TERM FARM LIABILITIES 2№4‘TOTAL FARM LIABILITIES ˜ pq Due date        iinterestс rate     totaliinterestс rate        total6"Real estate, personal property and asessments.&#Inome tax and social security%ilength&сin years ' ( ) *+total ,№ -( .@ /№ 0№ 1№ 2№ 4 ˜ pqinterest         iannualсprincipalY     "PћџџџiannualсprincipalY      " Pњџџџ%iannual&сpayment ' ( ) *"+Pќџџџ ,№ -( .@/ёLOAN BALANCES0ёOTHERS1ёLOAN BALANCESI2aOTHER 4 ˜qmonthlyqor annual ?         total" Intermediate liabilities: Long term liabilities:" Intermediate liabilities:Long term liabilites:iannualсinterest     "Pћџџџiannualсinterest      " Pњџџџ -  .P 4 € 0q payment        " Pљџџџibalance of loanс after this year     "Pћџџџibalance of loanсafter this year      " Pњџџџ -  .P 4 P  џр  § р  §р  ў р ўр " #( §р , Ь[ - ].ѓж@I        мџнџоџпџрџєџѕџњџўџ/ џчџ 01 џяџ 2 !=4­@ћж@)     ћџќџ§џўџњџ  ` ` ` ` ` ` ` ` `  ` !` "` #` $` %` &` '` (` )` *` +` ,` -И .` /` 0` 1` 2` P P  АЫЪЬ ANALYSIS$џбœuˆ<ф7~$7риь„ињ…и5‡к5dP[\–$ y"ЙANALYSIS OF BALANCE SHEET   1. NET WORTH, FARM ONLY 2. WORKING CAPITALeqwork. capY    3. CURRENT RATIO' €TOTAL FARM ASSETSTOTAL FARM LIABILITIESЙNET WORTH ,FARM ONLY  € •нЩ@ ўр еѓж@ џ!р%• ФР ўџџџ      €енЩ@ ў§џ•ѓж@ џр € И  €    0q'= Total currrent farm assets divided by&q'Total current farm liabilitiesq' equals(qMay be determined by subtracting*qFarm liabilities from farm assets И0 q'=Total current farm assets-Total current q'farm liabilities8 q'Lenders typically prefer working capital to be 4q'positive and be $1.50-2.00 of current assets.q'for every $1.00 of current liabilities<yFor every $1 of current liabilities this operationythis operation has.. p p'ђ„зт? ў§џџр@q'The higher the ratio, the more liquid the bussiness is@q'considered to be. A current ratio between 1.5 and 2.0:1Bqis generally preferred to allow for a liquidity cushion. p p 0eјы.A ў0рe@ћж@ џ-р%e4.A ўџџџ  p p p  ]ђ„зт? џр p p p p p p p  p p p  yin assets. p p p pЫЪ$бœuˆ<ф7~аi7риG„ињ…к[\–$   ЙINCOME STATEMENTЙREVENUE:Crops and feed:$Livestock and poultry sold: Breeding stock sold:8Total cash sales from all livestock and poultrysCustom work: cash4Government payments and patronage dividendsOther Иcash salesinventory changecash sales inventory change cash sales inventory change ИLqprofit is the single most important measure oўџр…ŸђљOhЋ‘+'Гй0 `lx„œ А М Шдјџџџ tmcconnell20@РЯ_vјVМ@€БОVЖЗМQuattro Pro for Windows 7№f bussiness performance №qeither + or - qeither + or - qeither + or -sjј@ ˆ ш  ш  №  ш  ш‹€„.A  ш  №  №  ш ш ш ш шЫ‘”“GŠœžd•d–—8 —-——— ™›’ ѓ Group1Яё4џџGroup1CŠ”й,ВкДJMщАFJDыЈЃнcАFJ:э џџю ~Щя šЩ№ ЖЩъђ