ࡱ>  f2ɀ\prbetz Ba=  =N9!8@"15Courier15Arial15Arial15Arial15Arial1 5Courier1$5Courier1.5Times New Roman1.5Times New Roman1Q5Tahoma1 5Courier1. 5Times New Roman15Arial15Arial15Arial15Arial15Arial15Arial1,5Arial1 5Arial15Arial1. 5Times New Roman1. 5Times New Roman15Arial1h8Cambria1,8Calibri18Calibri18Calibri1Calibri1Calibri1<Calibri1>Calibri1?Calibri14Calibri14Calibri1 Calibri1 Calibri1Courier1Calibri1Calibri1 Calibri1Calibri"$"#,##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\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off" "$"#,##0.00#,##0.0_);\(#,##0.0\) "$"#,##0                *  *  *  *  *  *  *  *  *  *  *  *  )  )  )  )  )  )  )  )  )  )  )  )    "   $ ff + ) , * '     P  P        # `   &    !    ( a> %      (   ,`   (`   @ @ *          @ @ *   @ @ *     !  *   !  #         !  !  %                *   ww@ @ *  `*  h*   h*   h*  % ww@ @ *   ww@ @   ww@ @ *  h*   h*    "  #        ||tV-}-}= 00\);_(*}A}2 00\);_(*;_(@_) }A}3 00\);_(*?;_(@_) }A}4 00\);_(*23;_(@_) }-}5 00\);_(*}A}1 a00\);_(*;_(@_) }A}( 00\);_(*;_(@_) }A}9 e00\);_(*;_(@_) }}7 ??v00\);_(*̙;_(@_)    }}; ???00\);_(*;_(@_) ??? ??? ??? ???}}) }00\);_(*;_(@_)    }A}8 }00\);_(*;_(@_) }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}? 00\);_(*}x}:00\);_(*;_(??? ??? ???}-}/ 00\);_(*}U}> 00\);_(*;_( }A}" 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*L;_(}A} 00\);_(*23;_(}A}# 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*L;_(}A} 00\);_(*23;_(}A}$ 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*L;_(}A} 00\);_(*23;_(}A}% 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*L;_(}A} 00\);_(*23;_(}A}& 00\);_(*;_(}A} 00\);_(*ef;_(}A} 00\);_(*L;_(}A}  00\);_(*23;_(}A}' 00\);_(* ;_(}A} 00\);_(*ef ;_(}A} 00\);_(*L ;_(}A}! 00\);_(*23 ;_(-  !%-  !% 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`'Introduction & acknowledgments +Pork Cash FlowExisting LoansSheet1\p:\p:!_Regression_Int  ;' Print_Area_MI;' Print_Area_MI;l4 6H 6b6cU^\Qq?5n5cU^\Qq?PNG  IHDRl5#0PLTE   $ - &&* % ,&/#! 1%'+!!)!-))%)(%4VcA9*cmii/}w)s-){1t91=6*X,6 {? =B =B"7*6=#57296d3@FM/Er92PXO {LxOO!J!R){VOJ!ZO!J!J!R!V1HN)N)Z)JD]N@M_dKrmM)R)R1R5RARRJVPfP,f`-ZKT\Yz[)^5\G\dZJeknrjMmjkbv}gtbqmr|ƠȭƥȵʵȽƱγίƽõƽȷ˺ؽֽйҳѽƽ׽tz^bKGDH cmPPJCmp0712Hs2\IDATx^}{םg'dQE[ MI##4\W Ja@^1AleS]MXS'q!q׋?-澟zfHiS`?_Q@j #օ~f h3+/_pw\^}}wGeO~O?>${4xwtǯQn0`OLp(é@8 @ku xqS;Y^W)3.]}ם3ã3Mg?iPށd-Hy;3;gmtbv0Sp"߮2O$BK.33]>F`mw0V/§ڒF dL+ c= 2x}"욞g3Pu&mVF,]3Ov`"Ј8EK;r݉[ ?}%\!%t[6{kl.{v ۜ*2T&B&r]mfdMn9 v'r]nf\Uaذ A{hke=  8P=P5F%ֻ4庻^D_"֢@ά9V*ٚL_z^ aVc׹vv7" i3\7t9&IМqimxAm `MU-vg᮫`ƒ}և~v \_Y аs'9:ލh$<ܸ;kn߾Sc*(ee;.0EB0"vB4is*dp'Q@GIvN=\;9~\/3-陑leg=e85@ /@!V+J*Iv`kn1VuwZle5"ҒT9={ی"LtN4?y Dz d+5KEOΆAM4BB"j)H{߭GLuG1PϵxZ %݉+;QM=RkwHdk>Nl}"Y*%k!Y`4&G.l9f$02l@E9#aF$zG5;KI#;[T,>Gv,tC/$;sWՕM|`L$H~l ѪMbCE`+$UYl6#s a rU-}Yo; {"Z[S/5J]v%5krbƃ;G@#? $a[U&r6b4>y$v+m3.?ӕNQ|6%>e6b[>VR~7 豑s0B\#t2FZVrPҶ 0r-$7~T;gOTi佝:b}qqV eJlNTFPo2% Rn!W:KA9Rww3&F~?hS̀LZE 3=ЇܭBvvT`p%$ A=pjo*v9<'mۈG"0 Y#`>gO1r0F]!<9[7qyKZ !ȼX9'ۻ4;lr7iꈮpxvNF=|҈fbyd42_j"-!iۮg݈HI'>Nfi=d-aW$|ɾJV;Rƀ|k+gb ̀M^XߴFԹT8u;n /nsߧJ*0"lB3} -$\޽ t81+jE$%a+Dm`k&ʭƯkJG!M9 It=jյ5?LVVXĺ⭶lW~dIma{_Xbdtpvkl5kwj΀mY#1p# GƴF<1P<ЂaNiDd o{\^kY!o\o]n ٝZպr}V4\:dq rC!>g\ FίL_Giu깰ι2AtI6N8 X KZ{M/krjm老HtM-v}jwb!G 2sLL2dz ?jPTˬVKUۨ5\Yǡt^jzMd6*X4s3:H໷7MH|,JB"4|iM{0Q''ǧ9Ij~_͛DĿ }ƃZ#pwuBMT:ђ.i9MHVu~h`4ϟx^o=T۠C$i!O=[_ ;d l؍1Ž qG[`7 ;b / m/-0(wvc#'sL'O w'_g&< 7/paQWS~}_m5ࢷղ< f5huTl(RV8-+h`D ۖd`מy3F>fS>c#䍱 IDwh4 ]=`X[T,&k:EwYU<jV&>42:DOրeEA۬Ubs9+ZF;O@Amc ~{Ds^"CRSze[[#m~]1>"ޙ%y;jEleb|{^mvm;yu˝|EsZtVԶdj ŭG#>Mk"Xc4vCNL;m/k(٫{9uC[t+[5mS׮-5:y8j}(S+IGm#-[Pޛi,٫1FonbNUe4?U7^*s XlFZLn7I{Ho4v_Cn!ϩ0F`%UiC^mr6Xs%=]k/ek{C l`YW7HXsخHCQno{*^xڵwfȦ])/׸C,1:*Ȧh϶Vr;K i'7"u={c? E]_{͂¹8gV&$;QLƒؗ>,=RiĶY .icP_=Wτ*4O ( |L&dvzs۞cֻS4I#Fĭ V7p.d}{ ٮ;ڨeʆ/ le۳w`$@E[}f=E¹&$^^܁Շ9ozZ$(;};e[Y `!Ɏrh̽?q\ȶfl!B_PeaIXϷ=R-p3hO͜ gk1ya4ⱻi:W~l~\__\!z0 0zx/`Se퐔2ƏH ~}]Mx}Ȃzʂn쟝p!jO0!X؏p\~`o~7 W ʾ"_ab㵫uZ݈F?R7EMcU"&-ZnTW82 ku萵R{no\źU}Vizwa#/j+ٞ@joij/hm7FKcw`#rLهűXvt?7H_߈ЗFQ釶47Z{mK7nܸ|_뿦nl߿h`K>}ؖXy}㧶QW浆5.cg4 Z_5mrV1SKKO?U6T1)]$tp,w3GK˓wA6+M{Z{'O?'>+||a_*|% Ap]o#D^jK~,Wlta p֥P&Ϫ!I uW!ķ66{u etԿ[y}9$|~k)PidL(We<}EY.JbQ,K,V)ՔXK4ϻJ\wyP0rAwPH yG* BrW8>#.]B:L'w=WCV)QO.̹+S^{+cqd7!-7f=8i55MVrU*K!| d%m%\* w;.=L~,apTXUqN*D!#i꫞1b)ϧ^\H^:Lr =^Ne)ӛ'r ۙLSѣHbPRTŝyㅑȽ+<7jiQtvx+ ӌP+\ɖ!{ޱKsom*cbT -/볳جŞ:p$D|GKf=hS:oc-#<(uܜL ,&ZBoazɗ_paWae13{ w&m%3=5ġRt^r 3ykۧw6&JՒ< d%qɬP+W'wK&M'S2 xR8) ƒ\M\`L3,p #%xkU-\9`+.AAn ]=')XdW,^0zPem6_J/s Ī,=?>xS s{DLQ1K9ܰ[b+b,wb#sÀ|pltOl2[ ,(ʯA\*n`C輦ϴ\.r$f@,Ȃ!ɪTtL2sxr%cIIzx51)S-%ˮ t)5针3BԱB,Wy /ܷ1[,%$>u7DI]H,}x<$h0Xw\OJxЍTR NJ,,`e_IFs@@IlY{Z_GV,8|.u^pvÐjI#%OZG0wXϜ8hOҳ͂=Cx x^iiYp._A2GA2L $fUILw!=]<ͳNC}Ng,%k J pʦ Us_7$XlчHTvOm|I,54tcQz]!:T xQV3#hfj҆Z )E ү)Kij.%a(o1e'zl\6:M`eZd"vw ֦8 5ٲg,r,gX9N#)>)LMe?IBa'fPGlFm{$$KA0~ hD &LO;aod Δ<qM%L47X\@ B\1Rr V >9 +ٗ2P J, !=+ 5D42geIn@# =) <%yXIi-lL#WY>t 7XG_VqQɇAyzgN4| le&Mޅ2|aju\EX*$[7VKB5q#M[>ESfJ#z;I&Gn;"gk:LAXrq&F˚ û!%/lcOJps덢X`Z)x*TY>1 ɦfE$[Q򧪕rٜYl`/Hb9`.l4h}5Rie @@]j# &_s18z3UL{aF6ć{ $Ư,uY'g}q^z) 4(54=)XbW)ʒiK"VL1Q> J aNTGPT 銠vK+=kg&m4BYAvӒ*M4(HL$9gol ©1=A?9}s/ʘʦd`V%p~5D1$c\V23dBR+ɣ{e%g_JC9M8+Dzhb*a9FIluۓEH*p!2{c)c0UJqۋ 7NxeAPERE7ږw9JV/JիWس2$jDTΆ͟E$ 9og"4g(I1AP,O'2υQ:ca(;&q 쿣Z@ ,|R>QXBHr ~lٞ '1=?:5b-h4F+YhĈ4 q*!a̻>gF`X7xtJE6fZ=iѵW2RZ&G DIry Iu0D(~m`p4CtD,y CYb|b}i13"7 ^T>w"F2~@O/J^IMx @4vĂARsV2R>՝V 69}7s\ousR&z(<2ۓM"?Lⷔ]O9DIX6') J X!y¹a6pL7CQCN~73߳1IгMIqH6GmN-z5f8Hu@ Gz\pQd3s^&[(Bcx6p6, FnHXnM>Ioel(Ŀ![ɜ=+JA=u<ցP䫸I*vk$ oX>SD0 Cp4( m\RP%[y#U-5cfW $`ldʹp4Rz`C`])2GkxMu_/Iܸ vG`I0(zeK:Z{DMl"*Odt1 [vΦȸUŢe;HJvI#봾+].˓ A] ]-{ lˠ%"M Tp1ͧd­ H`C+fyy3(=H=?6~9sA#x޴{twsGqdGbM>SvpXVA3<{SI? Bb%`(d5t  켒tcMIYAD4T;f1*x1PoGAoc1:dW3DuP!ͥջ;DST6= z8dN#le{̯fJؑ#[mvFEs4k_Ն >g)*r<<,,cuurTı4'%Ӟ)*>Q O Jra1;ToFza42#-y(HD%1]!Dj]Z)(05 yf4lPp.U)Z)dÓ˙Rl*jd5c*)DDqWbԢKϘ$x[D'ͩ&ҪC,<c"=nb*1,]A"gܔ5+5jCtr}(q+1EC9gҭ?r;+!#jEN1`cyT }HȪ? ({`ÃKYx=H/z:B=Qn>4KbA!<6ⰨFaFVO342H$=Z䲽`-n-Fy59A$ $'F+tvݵ'yImportant! The "Existing Loans" worksheet has example loans that need to be replaced with your specific loan information. ]Black text cells are protected and blue text cells can receive input but also have a formula.#2|Use the "Existing Loans" worksheet to input your existing Operating, Intermediate and Long Term principal amounts that will  Market Hogs SoldExpected price per 100 wtMARKET HOG INCOMEPATDIV GASTAXREFUNDGovernment ProgramsMISCINCLBRSERVICE SOLDOtherOther Income 8Other Income 9MACHSOLDLaborAdvanceService WithheldSocial Security Tax LBR OtherRPRRPRMRPRCARRPRBFEED FEED TestFertCstCSTLSCSTMCSTTRKSUPSPRAYWINSECTBEDDINGSUPOFFSUPLSTOOLSUPSHIOGASFUELSTORAGELICE CARLICETRKLICETRLLICE UNEMPLOYMENTTAX02INSFWWORKCOMP INSMEDICALINSCARINSTRKELECPHONEGASDRYGASHEATRENTMRENTLTrucking Marketing AdvertisingMISCDUESMEALREGPUBACCOUNTADVTRAVELCONSULTMEETMILEAGEROOMBREEDVETDRUGMARGIN FEEDERPIG SWINEPURCHASEIncome 2Income 3Income 4Income 5Income 6Income 7Income 1Total Hogs SoldTotal CWT SoldAverage Price/CWTSwine Farm Cash Flow Budget CFS SWINE CASH FLOW BUDGET forOther Capital ExpenseTotal Cash Operating ExpenseTOTAL CASH AVAILABLE Other Operating Expenses#Interm. + L.T. payments - principal interest all loans Inflows from savings Cash position before borrowing Amount toAllocate 1/12th per MonthPrincipal on New Borrowings 1Principal on New Borrowings 2Principal on New Borrowings 3 NONPATDIV MACHPURCH IMPRPURCHuInterest rate on "new borrowed money" is based upon the weighted interest rate calculated from the "Existing Loans" This interest is automatically calculated and paid monthly in the interest line. Enter only the Principal portion on new Borrowings payments. Cull Sows and BoarsEnding Operating Loan------>Ending Cash Balance-->Sale Weight per Hog (lbs)Average Weight Repair GeneralzGreen shaded cells require input on market hogs sold per month, average weight and price to generate income for the year. June 18, 2011Line 157 "ending cash balance" will be 0 in a negative cash position (line 145) because operating money will automatically be borrowed (line 148).cThe "new operating loan" monthly balance or accumulated cash deficit (in red) is shown on line 161.HORMONESFeed2Feed3&Version 7-28 Roger Betz, MSU ExtensionJbe carried over to the "Pork Cash Flow" and used in lines 135,136 and 137. Pork ProducerThe Pork Cash Flow Budget was originally a cash flow projection paper spreadsheet as part of the Coordinated Financial Statements, Roger Betz, Senior District Farm Management Educator, Michigan State University Extension converted it to this to an Excel electronic spreadsheet.k allocate 1/12th evenly to each month. Enter lump sum payments, like rents, in the months when they occur.A weighted average interest percent is calculated and entered on the cash flow worksheet on line 136.This is used to calculate the interest expense in line 137.VThe "Existing Loans" information is linked and used in the "Pork Cash Flow" worksheet.j 7kuk.llmVnLn6opTqs 6ut u u1 3vq uv v wN Zw w w$ Kx 0yny,q{Q} KccPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VRv`dDJ| W%9ߘo41a%$g9 7,k2=p9Ѭ3ІMM!}rBq>8>o?MI\]12ol 鎑)Rhs Wth8j  XjulABd7yFۥom ^ejc{m8w6ۃpס7D~w~m(,9ݠs%\G]w9 Pf1*bB14!'%ZtNd3Ɉ@)|CA1eyY YRX{o_}/߼ӛ>{򏖗3IՉ_g|?E=}V~?_ۗOk$Uɧ,1=ND یc\LیiD3D]z"ut:x>\ptDrX'Q B:Ut,e:C8-Sfu<$QdAN;H\:>a Gu/KYˇT8;Y9eR,wpJEx]辅}H1EUl.Qw}2}g_s(KE$ Ͻ_T=!paAxN{|r9/ꡘㄧVhQɖRyju7ƽ)oɔjABÒxR*@4bXq0؁l/>#pFmLok0e:a O2G*L]ì]%V=|1pW! 0`.Wlj9HV3rq44K`fzV mV ,Sw\j-bmX)C7-`8HL^xu*N/43 z6H;8Cdm2iVֵy뤽V,ַr/9[kvxm:;k;v%y117e,1{@`VAz,96ؘpRXwa nְ lIhTSepRf3EX &$"JPp!'!{EQX?ݭh>m9nKLB<>JBs0\8z ibiORoB}($.(]0    PH 0(  >@7ggD f2ɀ 0b:j7k  dMbP?_*+%\015v&?'?(?)?M\\PENTIUM III\HP4R4C odXXLetterDINU"4:ܜ"X&cU} @}  @}  @}  @}  @########## # # # # ################### oT8='D @O M/ NN  L os)-Z@ D PaeD Pork Producer aO M NN  @ WBW @a b Q Q Q Q Q Q Q  Q  Q  Q  Q  Q Q nQQQQQQQQQQQQ"R PF~ h@@T =' LTD'T ='T 'TR='T@' T@='  T@'  TR'  T'  T '  Q n PRRRRRRRRRRRR" P"TTTTTTTTTTTTTTR @Rhhhhhhhhhhhh #Y %  TR @hhhhhhhhhhhh &YhD Dd T R @% X DDd X    LLd X   X   X   X   X   X   X   X   X   X  # X %   T R @S jjjjjjjjjjjj " ijp D D  T R @T" X  D D  r   LL r  r   r   r   r   r   r   r   r   r  # r  %  7 r R" UUUUUUUUUUUUUT R O S   L  S  S  S  S  S  S  S   S   S   S   S   Tm  & -7 cR OS S S S S S S  S   S   S   S   S  T] cR OS S S S S S S  S   S   S   S   S  Tt cR OS S S S S S S  S   S   S   S   S  T cR OS S S S S S S  S   S   S  S   S  T  cR OS S S S S S S  S   S   S   S   S  T cR OS S S S S S S  S   S   S   S   S  T cR OUS S S S S S S  S   S   S   S   S  T cR OVS S S S S S S  S   S   S   S   S  T cR OWS S S S S S S  S   S   S   S   S  T cR OWS S S S S S S  S   S   S   S   S  T cR OXS S S S S S S  S   S   S   S   S  T cR OYS  L SSSSSS S  S  S S   L  S  T  cR O[S  L S S SSSS S  S  S  S   S  T c PRRRRRRRRRRRR"R O\SSSSSSS S  S  S  S   S  T  c PRRRRRRRRRRRR"R OSSSSSSS S  S  S  S   S  T c PRRRRRRRRRRRR"R OGSSSSSS D S D  S D  S D  S D  S   S  T  c PRRRRRRRRRRRR" P"SSSSSSSSSSSSTSR OS ! $ L S S S S S S  S  S  S  S  S T c PRRRRRRRRRRRR"DJ,l-k&4orn04 !"#$%&'()*+,-./0123456789:;<=>? R @] S! S! S! S! S! S! S! S!  S!  S!  S!  S!  T  c!R !OG!S#!S#!S#!S#!S#!S#!S#! S# ! S# ! S# ! S# ! S# !T !c "P""SSSSSSSSSSSSTS#R #P#S$##& 0 L #S$##S$##S$##S$##S$##S$## S$ ## S$ ## S### S$ ## S$ ##T$  #c$R $P$S%#$S%#$S%#$S%#$S%#$S%#$S%#$ S% #$ S% #$ S% #$ S% #$ S% #$T! $c%R %OG%S&#%S&#%S&#%S&#%S&#%S&#%S&#% S& #% S& #% S& #% S& #% S& #%T  %c&R &OG&S#&S&#&S*#&S*#&S*#&S*#&S*#& S* #& S* #& S* #& S* #& S* #&T* &c 'V'p@@u''' ,-B'p =''pD''p = ''p  ''pR=''p@'' p@='' p@ '' pR '' p '' p  '('p8= $% &B'S(S )P")TTTTTTTTTTTTTS*P *O^*S+**if L *S+**3 n L *S+**S+**S+**S+**S+** S+ ** S+ ** S+ ** S+ ** S+ *#*Tf %** *c+P +O_+S+*+S,*+S,*+S,*+S,*+S,*+S,*+ S, *+ S, *+ Su *+ Su *+ S, *+T,++]3 -+c,P ,O`,S-*,S-*,S-*,S-*,S-*,Su*,S-*, Su *, S- *, S- *, S- *, Su *,T%+,c-P -Oa-S.*-S.*-S.*-S.*-S.*-S.*-S.*- S. *- S. *- S. *- S. *- S. *-T +-c.P .Ob.S/*.S/*.S/*.S/*.S/*.S/*.S/*. S/ *. S/ *. S/ *. S/ *. S/ *.T-+.c/P /Oc/S/*/S0*/S0*/S0*/S0*/S0*/S0*/ S0 */ S0 */ S0 */ S0 */ S0 */T0+/c0P 0Od0S1*0S0*0S1*0S1*0S1*0S1*0S1*0 S1 *0 S1 *0 S1 *0 S1 *0 S1 *0T1+0c1P 1Oe1S2*1S2*1S2*1S2*1S2*1S2*1S2*1 S2 *1 S2 *1 S2 *1 S2 *1 S2 *1T.+1c2P 2Of2S3*2S3*2S3*2S3*2S3*2S3*2S3*2 S3 *2 S3 *2 S3 *2 S3 *2 S3 *2T1+2c3P 3O3S3*3S4*3S4*3S4*3S4*3S4*3S4*3 S4 *3 S4 *3 S4 *3 S4 *3 S4 *3T4+3c4P 4Og4S5*4S4449 B L 4S544S544S544S544S544 S5 44 S5 44 S5 44 S5 44 S5 44T5+4c5P 5Oh5S6*5S645S645S645S645S645S645 S6 45 S6 45 S6 45 S6 45 S6 45T2+5c6P 6O6S7*6S746S746S746S746S746S746 S7 46 S7 46 S7 46 S7 46 S7 46T5+6c7P 7O7S7*7S847S847S847S847S847S847 S8 47 S8 47 S8 47 S8 47 S8 47T8+7c8P 8O8S9*8S848S948S948S948S948S948 S9 48 S9 48 S9 48 S9 48 S9 48T9+8c9P 9Oi9S:*9S:49S:49S:49S:49S:49S:49 S: 49 S: 49 S: 49 S: 49 S: 49T6+9c:P :Oj:S;*:S;::C L :S;::S;::V L :S;::S;::S;:: S; :: S; :: S; :: S; :: S; ::T9+:c;P ;Ok;S;*;S<:;S<:;S<:;S<:;S<:;S<:; S< :; S< :; S< :; S< :; S< :;T<+;c<P <Ol<S=*<S<:<S=:<S=:<S=:<S=:<S=:< S= :< S= :< S= :< S= :< S= :<T=+<c=P =Om=S>*=S>:=S>:=S>:=S>:=S>:=S>:= S> := S> := S> := S> := S> :=T:+=c>P >On>S?*>S?:>S?:>S?:>S?:>S?:>S?:> S? :> S? :> S? :> S? :> S? :>T=+>c?P ?Oo?S?*?S@:?S@:?S@:?S@:?S@:?S@:? S@ :? S@ :? S@ :? S@ :? S@ :?T@+?cDC5l4 4@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@P @Op@SA*@S@:@SA:@SA:@SA:@SA:@SA:@ SA :@ SA :@ SA :@ SA :@ SA :@TA+@cAP AOqASB*ASB:ASB:ASB:ASB:ASB:ASB:A SB :A SB :A SB :A SB :A SB :AT>+AcBP BOrBSC*BSC:BSC:BSC:BSC:BSC:BSC:B SC :B SC :B SC :B SC :B SC :BTA+BcCP COsCSC*CSD:CSD:CSD:CSD:CSD:CSD:C SD :C SD :C SD :C SD :C SD :CTD+CcDP DOtDSE*DSD*DSE*DSE:DSE:DSE:DSE:D SE :D SE :D SE :D SE :D SE :DTE+DcEP EOuESF*ESF*ESF*ESF:ESF:ESF:ESF:E SF :E SF :E SF :E SF :E SF :ETB+EcFP FOvFSG*FSG*FSG*FSG:FSG:FSG:FSG:F SG :F SG :F SG :F SG :F SG :FTE+FcGP GOwGSG*GSH*GSH*GSH:GSH:GSH:GSH:G SH :G SH :G SH :G SH :G SH :GTH+GcHP HOxHSI*HSH*HSI*HSI:HSI:HSI:HSI:H SI :H SI :H SI :H SI :H SI :HTI+HcIP IOyISJ*ISJ*ISJ*ISJ:ISJ:ISJ:ISJ:I SJ :I SJ :I SJ :I SJ :I SJ :ITF+IcJP JOzJSK*JSK*JSK*JSK:JSK:JSK:JSK:J SK :J SK :J SK :J SK :J SK :JTI+JcKP KO{KSK*KSL*KSL*KSL:KSL:KSL:KSL:K SL :K SL :K SL :K SL :K SL :KTL+KcLP LO|LSM*LSL*LSM*LSM:LSM:LSM:LSM:L SM :L SM :L SM :L SM :L SM :LTM+LcMP MO}MSN*MSN*MSN*MSN:MSN:MSN:MSN:M SN :M SN :M SN :M SN :M SN :MTJ+McNP NO~NSO*NSO*NSO*NSO:NSO:NSO:NSO:N SO :N SO :N SO :N SO :N SO :NTM+NcOP OOOSO*OSP*OSP*OSP:OSP:OSP:OSP:O SP :O SP :O SP :O SP :O SP :OTP+OcPP POPSQ*PSP*PSQ*PSQ:PSQ:PSQ:PSQ:P SQ :P SQ :P SQ :P SQ :P SQ :PTQ+PcQP QOQSR*QSR*QSR*QSR:QSR:QSR:QSR:Q SR :Q SR :Q SR :Q SR :Q SR :QTN+QcRP RORSS*RSS*RSS*RSS:RSS:RSS:RSS:R SS :R SS :R SS :R SS :R SS :RTQ+RcSP SOSSS*SST*SST*SST:SST:SST:SST:S ST :S ST :S ST :S ST :S ST :STT+ScTP TOTSU*TST*TSU*TSU:TSU:TSU:TSU:T SU :T SU :T SU :T SU :T SU :TTU+TcUP UOUSV*USV*USV*USV:USV:USV:USV:U SV :U SV :U SV :U SV :U SV :UTR+UcVP VOVSW*VSW*VSW*VSW:VSW:VSW:VSWVV] S L V SW VV SW VV SW VV SW VV SW VVTU+VcWP WOWSW*WSXVWSXVWSXVWSXVWSXVWSXVW SX VW SX VW SX VW SX VW SX VWTX+WcXP XOXSY*XSXVXSYVXSYVXSYVXSYVXSYVX SY VX SY VX SY VX SY VX SY VXTY+XcYP YOYSZ*YSZVYSZVYSZVYSZVYSZVYSZVY SZ VY SZ VY SZ VY SZ VY SZ VYTV+YcZP ZOZS[*ZS[VZS[VZS[VZS[VZS[VZS[VZ S[ VZ S[ VZ S[ VZ S[ VZ S[ VZTY+Zc[P [O[S[*[S\V[S\V[S\V[S\V[S\V[S\V[ S\ V[ S\ V[ S\ V[ S\ V[ S\ V[T\+[c\P \O\S]*\S\V\S]V\S]V\S]V\S]V\S]V\ S] V\ S] V\ S] V\ S] V\ S] V\T]+\c]P ]O]S^*]S^V]S^V]S^V]S^V]S^V]S^V] S^ V] S^ V] S^ V] S^ V] S^ V]TZ+]c^P ^O^S_*^S_^^f c L ^S_^^S_^^S_^^S_^^S_^^ S_ ^^ S_ ^^ S_ ^^ S_ ^^ S_ ^^T*^^u -^c_P _O_S`*_S`^_S`^_S`^_S`^_S`^_S`^_ S` ^_ S` ^_ S` ^_ S` ^_ S` ^_T^^_cDi9l`abcdefghijklmnopqrstuvwxyz{|}~`P `OZ`Sa*`Sa^`Sa^`Sa^`Sa^`Sa^`Sa^` Sa ^` Sa ^` Sa ^` Sa ^` Sa ^`T,^`caP aOaSb*aSb^aSb^aSb^aSb^aSb^aSb^a Sb ^a Sa^a Sb ^a Sb ^a Sb ^aTb ^acbP bObSc*bSc^bSc^bSc^bSc^bSc^bSc^b Sc ^b Sc ^b Sc ^b Sc ^b Sc ^bT_^bccP cOcSc*cSd^cSd^cSd^cSd^cSd^cSd^c Sd ^c Sd ^c Sd ^c Sd ^c Sd ^cTd^ccdP dOdSe*dSe^dSe^dSe^dSe^dSe^dSe^d Se ^d Se ^d Se ^d Se ^d Se ^dTu^dceP eOeSf*eSf^eSf^eSf^eSf^eSf^eSf^e Sf ^e Sf ^e Sf ^e Sf ^e Sf ^eTb^ecfR fOfSg*fSg^fSg^fSg^fSg^fSg^fSg^f Sg ^f Sg ^f Sg ^f Sg ^f Sg ^fTh^fcgR gOgSg*gShggt L gShggShggShggShggShgg Sh gg Sh gg Sh gg Sh gg Sh ggTh^gchR hOhSi*hSighSighSighSighSighSigh Si gh Si gh Si gh Si gh Si ghTj^hciR iOiSj*iSjgiSjgiSjgiSjgiSjgiSjgi Sj gi Sigi Sj gi Sj gi Sj giTj ^icjR jOjSkjjt L jSkgjSkgjSkgjSkgjSkgjSkgj Sk gj Sk gj Sk gj Sk gj Sk gjTn^jckR kOkSkjkSlgkSlgkSlgkSlgkSlgkSlgk Sl gk Sl gk Sl gk Sl gk Sl gkTl^kclR lOlSmjlSlglSmglSmglSmglSmglSmgl Sm gl Sm gl Sm gl Sm gl Sm glTm^lcmR mOmSnjmSngmSngmSngmSngmSngmSngm Sn gm Sn gm Sn gm Sn gm Sn gmTu^mcnR nOnSojnSognSognSognSognSognSogn So gn So gn So gn So gn So gnTr^ncoR oOZoSojoSpgoSpgoSpgoSpgoSpgoSpgo Sp go Sp go Sp go Sp go Sp goTp^ocpR pOZpSqjpSqgpSqgpSqgpSqgpSqgpSqgp Sq gp Sq gp Sq gp Sq gp Sq gpTu^pcqR qOZqSrjqSrgqSrgqSrgqSrgqSrgqSrgq Sr gq Sqgq Sr gq Sr gq Sr gqTr ^qcrR rOZrSsjrSsgrSsgrSsgrSsgrSsgrSsgr Ss gr Ss gr Ss gr Ss gr Ss grTs^rcsR sOZsStjsStgsStgsStgsStgsStgsStgs St gs St gs St gs St gs St gsT^sctR tOZtSxjtSxgtSxgtSxgtSxgtSxgtSugt Sx gt Su gt Sx gt Sx gt Sx gtT`^tc uV#u]d %*t\#u] %*t#u] %*tu]uuu -u]zuu]-uu]xuu ]- uu ]x uu ], uu ], uu ]- uu]^#u]~ %*tvS w@"wTTTTTTTTTTTTTSxR xOxSyxxz $ L xSyxxSyxxSyxxSyxxSyxxSyxx Sy xx Sy xx Sy xx Sy xx Sy x#xT$ %xx xcyR yOySzxySzxySzxySzxySzxySzxySzxy Sz xy Sz xy Sz xy Syxy Sz x#yTz %yy yczR zOGzSxzSxzSxzSxzSxzSxzSxz S xz S xz S xz S xz S x#zTu %zz zc {P"{SSSSSSSSSSSSTS|R |@|cccccccccccc #|Tx %|| |a}R }@}cccccccccccc #}T| %}} }a~R ~O~cccccccccccc #~T} %~~ ~aPOOOOOOOOOOOO aD/l 44kkk P"SSSSSSSSSSSSTSR PS H L SSSSSS S  S S  S  S T  -cR PSSSSSSS S  S  S  S  S TcR PJSSSSSSS S  S  S  S S #T % cR PSSSSSSS S  S  S  S  S TcR OGSSSSSSS S  S S  S  S T c PTUUUUU{@TUUUUU{@TUUUUU{@TUUUUU{@TUUUUU{@TUUUUU{@TUUUUU{@  TUUUUU{@  TUUUUU{@  TUUUUU{@  TUUUUU{@  TUUUUU{@TP@*qP@ZZ#  PI\P贁N? Z&\P贁N?Z&\P贁N?Z&\P贁N?Z&\P贁N?Z&\P贁N?Z&\P贁N? Z& \P贁N?Z& \P贁N? Z& \P贁N? Z& \P贁N? Z& \P贁N?Z&R P%TWUUUUՄ@ DD T_B{ ń@ LL Ti/@Trq@T{ %@TK@T8x@  T^B{i@  TZ@  TJ@  T^B;@  T+@#T8@ %  S Occcccccccccc #T %  S Occcccccccccc #T %  S Occcccccccccc #T %  S VT0@% - -TK(@T % @T8@ TKh/@T^B{ @Tq@ T@  T%^@  T@  T.@  T^Bې@Xqq@ SS PTY LLTK(T % T8TKh/T^B{ Tq T  T&^  T  T.  T^Bې  TS PS L SSSSSS S  S  S  S  Su#T %  c PTY LLTK(T % T8TKh/T^B{ Tq T  T&^  T  T.  T^Bې  TSS P"TTTTTTTTTTTTTSR PT0@k aL L BLLL LL BT{ %g@Ttk~q@ Tn|@T`E<@T/@ThB(A@ TC!B@  T)Y@  TbNS2@  T䧷$bɠ@  TRbԠ@ #T)-Z@ %  S P cccccccccccc #T  %  SS P!SR P"Ti _L  GLLL , LLLB " BTTTTTT T  T  T  T  T #T %  S P#TUUUUU@ L TUUUUU@TUUUUU@TUUUUU@TUUUUU@TUUUUU@ TUUUUU@  TUUUUU@  TUUUUU@  TUUUUU@  TUUUUU@ TUUUUU@#T@ %  !q@' Z   P\Q?Z \Q?Z \Q?Z \Q?Z \Q?Z \Q?Z \Q? Z  \Q? Z  \Q? Z  \Q? Z  \Q? Z  \Q?Z R P$T:b@  LLL T98hb@Tc2Qc@Tm>z:d@T 02$e@TP$if@THf@ Tgg@  Th@  Tt; i@  T}8j@  TUٽk@#TOGR @ % YSR P%S  L S S S S S S  S  S  S  S  S#T % Bc P&?] =)DDDDDDD]D3 )LLLLLLL] =] ]R=]@]@=  ]@  ]R  ]  ]   ]8=]8=D TT P'"TTTTTTTTTTTTTTR P("TTTTTTTTTTTTTTD'l4aaa  4,a * 4S]0@ LLL]| %@]6?,Z@]6@]8^j"@]1*@]:8W@ ]@  ]kIӟ@  ]@  ]Ɍ@  ])-Z@ TTR P)"TTTTTTTTTTTTTTTj@Z TUUUUu@ LLT@T_@TTUUU@TJ>@Th@TSUUU5@  T@ T@ TRUUU@  TOUUUz@ T@  TTR TE"TTTTTTTTTTTTTT%TOA*ZZ#9mUUUUAA#DDDDDDmj4A- #LLLLLLm&AmTUUUUAm Am?AmSUUUA m*A mA mRUUUA mA mA TTR T*HHHHHHHHHHHH TT\Au LLLmVAm%DpAmaΉAm8Am&eAmnqAmsA m| A  m_m1i&A  m3[AA  m71D\A  m.E[wA TT P+"TTTTTTTTTTTTTTR P,Th@! LLLLT{ %g@Ttk~q@ Tn|@T`E<@T/@ThB(A@ TC!B@  T)Y@  TaNS2@  T䧷$bɠ@  TRbԠ@ TTR P-9Th@#DDDDDDT| %g@ - #LLLLLLTtk~q@Tn|@TaE<@T/@ThB(A@ TC!B@  T)Y@  TaNS2@  T䧷$bɠ@  TRbԠ@  TTR P.T LLTT TTTT  T  T  T  T  T  TT TT TT TT TT TT TT TT TT TT TT TT TT2>>D4 TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TTD@l TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT TT0 T$   - u u  u #   #  B!   N6(  x  6UXPP? g %]4@ J 1;S  \<]You may wish to leave this blank if you wish to determine the cash flow of only the dairy. < = \~  DA??Picture 19]&`# Bill Robb>@<dl j A  7 ? A?? ?A??{+{{+{ggD f2ɀ 'p4  dMbP?_*+%&?')\(?(?)?MRHP DeskJet 950C Series|݀f dcںںRLdͫLPT1:"dcc??&cU} `@}  @}  @}  @}  @';,@      , ,  G= E; @1 @@ @6 @2 @4 @7 @6 @? @@ A: B3 CA C8 [4 [1 [H DN~ Dj@IQ?~ J@@K:b@ LL KUUUUU@  LL^p@ LL ~ D@ DIJKK^~ D@ DIJKK^~ D@ DIJKK ^ ~ D@ DIJ K  K  ^ ~ D@ DIJ _  _  `$ @# Hj@ % # H@@$ % # H:b@  % # HUUUUU@! % # ^p@ %  @ D!Operating - Less than one year% ZQ? D D   @C F> @1 @4 @6 @2 @5 @7 @6 @? @@ A: B3 C9 C8 [4 [1 [H DNDj@I@J@@K@o@LL K@o@ LL^p@LL ~ D@ DIJKK^~ D@ DIJKK^~ D@ DIJKK^~ D@ DIJKK^~ D@ DIJ__`#Hj@# %#H@@  %#H@o@ %#H@o@  %#^p@ %@ D 1.Intermediate - Machinery and Cattle 1-10 years%ZQ?#DD  @C F< @1 @4 @6 @2 @5 @7 @6 @? @@ A: B3 C9 C8 [4 [1 [H DNDj@I@J@K z@"LL Kf@" LL^ @ "LL ~ D@ DIJKK^~ D@ DIJKK ^ D\l*Tb{{{{{{*Tb{{{{{*Tb{ !"#$&~ D@ DIJ K  K! ^"~ !D@ !DIJ!K#!K!!^#~ "D@ "DIJ"_""_"`##Hj@ %"##H@ %"D##H z@" %"D##Hf@ %"D##^ @# %"$@ D0-Long Term - Land & Buildings 10 or more years%$Z?&D#D#  $@C &@D4&ZP贁N?DD#DD# |d{{{  P    u    d f'! # # # p& >@  7ggD f2ɀ   dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U>@ggD Oh+'0HPdt  Bill RobbrbetzMicrosoft Excel@@,H5@;4qM՜.+,0 PX|  \Michigan State University  Introduction & acknowledgments Pork Cash FlowExisting LoansSheet1'Pork Cash Flow'!\p'Pork Cash Flow'!Print_Area'Pork Cash Flow'!Print_Area_MI  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FWorkbookSummaryInformation(DocumentSummaryInformation8