ࡱ>  g2ɀ\pbetz Ba==]T08X@"1QArial1QArial1QArial1QArial1$QArial1 QArial1QArial1QArial1QArial1!QArial1 QArial1?QArial1-QArial1QArial1QQTahoma1QArial1 QArial1<QArial1x?QUnivers1xQArial1QArial1QArial1 QArial1 QArial1QQTahoma1!QArial1QArial1QArial1QQTahoma1QArial1QArial1QArial1QArial1-QArial1 QArial1 QArial1-QArial1JCalibri1 JCalibri1JCalibri14JCalibri1 JCalibri1JCalibri1JCalibri1,>JCalibri1>JCalibri1>JCalibri1>JCalibri14JCalibri1<JCalibri1?JCalibri1h>JCambria1JCalibri1 JCalibri"$"#,##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\);_(* "-"??_);_(@_)A<_("$"* #,##0.000_);_("$"* \(#,##0.000\);_("$"* "-"??_);_(@_)C>_("$"* #,##0.0000_);_("$"* \(#,##0.0000\);_("$"* "-"??_);_(@_)E@_("$"* #,##0.00000_);_("$"* \(#,##0.00000\);_("$"* "-"??_);_(@_)GB_("$"* #,##0.000000_);_("$"* \(#,##0.000000\);_("$"* "-"??_);_(@_)ID_("$"* #,##0.0000000_);_("$"* \(#,##0.0000000\);_("$"* "-"??_);_(@_)=8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_) "$"#,##0.00 "$"#,##0 0.0% 0.0000 0.0000.0 0.0000000 0.000000 0.00000"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                &  &  &  &  &  &  &  &  &  &  &  &  '  '  '  '  '  '  '  '  '  '  '  '  (  )   * ff + ) ' ' , * +  ,  - P . P /  /  0   1 ` 2       3   4 5 a 6   (   (  , $ ,  ( , , "8    @  &0   , $    &0  (@   (   xP-   H  H  @ @  H H  @          @ @ + !    8    ! !     !    ( ( !  !  )8  %"  @  @    &  &   ,   "0      # ,  #0 #8    (  L  $   d      $  #  ,    h  h ,  & "  8 #8 "8 ,  !   H  (  &  !8  )  !  0  @ @ +  0  @ @ +   ,#@ @ + ,#0  @ @ + ,    ,    , @ @ +   0       @ @ + , 0 , 4 , < ,  ,  ,  &@ & ,  ,  &0 &0@ , 0   @ @ + , @ @ +   @ @ + ,  # " ,    %" !x  , @ @ +  ,  , p  @ @ +  @ @ +  @ @ +  (@@  0@  8@  8 @ !0@ !p@ !8@  ( ,   ,   (@  0 , 8 , 8 , 8  !p   8  !8@  8  )x@  )x  # ,#    @  (@      (@ , $@  #@  &@ , @  @  0 "4 #0 &0@ #8 "8 ,  "8@ "8 @ ,   (  8 ,  ,  ,  ,    (    #"  (  ,   ,   , @ @  , @ @   ,  !@@  !@  ! @  !  8 "@ @ +  ) +x +x ! "@@ + " @ + !) $)  ) ") "@ + )  )  "@@ + ||Y<\}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}1 00_)}A}3 a00_)[$ -}A}4 00_)[$ -}A}5 00_)?[$ -}A}6 00_)23[$ -}-}7 00_)}}9 ??v00_)̙[$ -##0.  }A}: }00_)[$ -}A}; e00_)[$ -}x}=00_)[$##  }}> ???00_)[$???## ???  ??? ???}-}@ 00_)}U}A 00_)[$## }-}B 00_)}(}00_)}(}00_) 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]- Comma_Area 1. Comma_Area 2/&Currency0. Currency [0]1Explanatory TextG5Explanatory Text %2 : Followed Hyperlink 3Good;Good  a%4 Heading 1G Heading 1 I}%O5 Heading 2G Heading 2 I}%?6 Heading 3G Heading 3 I}%237 Heading 49 Heading 4 I}%8( Hyperlink 9InputuInput ̙ ??v% : Linked CellK Linked Cell }% ;NeutralANeutral  e%"Normal<Normal_Cashrent 1997 =Noteb Note   >OutputwOutput  ???%????????? ????$Percent @Title1Title I}% ATotalMTotal %OOB Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight168̙3ffff̙̙3f3fff3f3f33333f33333\`Example Blank #Data" counties;c  ;Y   ;Y 8 2@  - 1b14mm)v1n14mm)vPNG  IHDR s6gAMAPLTEٟ pHYs\F\FCA IDATx흽쾑1-.B.qAGp@%R`Ïb6pWFMs/ nr{ ?9/Θ =|7/ȴ6/:3RL4f~aPQ,*gòtxj~#{gQG Y~c/dar>C+7lO|u7;fz=(bܑcJrXu|73hw>P9D'*5_{dwS̺Yt'hP~-TGưδ;[)ȯ:,CK->_q_˯_OƯ=_Mv/3{{?};_wwX~.ދu'/̯կwضP~~"~ _' _?W`~M5oo~`~u(WA;Ο2_J}~X~e#kvJ?)9SZ0+oͨkjzX6Nnp9칓_(nů7fk(KЏ(-cwnD5c^2LjXYskO?Jql(| -(Oښlշh>~~.M ?P* C4`v;Oq>^E~KU`,j{~,?qi~z_ٹ_2 }L8BwO)~%~I_OxUD.q[3)&/ VT6ꄖV"Q3/Be蘟X Ueqj|Q9Dbm_zbtW۸es9-[weEd>Y~EaCEѓu9y1҆G$UzȮGqȎԪ;nShhg7z2}Ufձrc~Bky佐W69Sy-ky~q>yh+銱 [C6:R1ZuvE2hPO Fߕt)bWWkj_5p-{ ~%$$ 9*MP^C5Ame[$HYjCP~_E6y~V (rV6$l@~8 a5u/p`w2Xֻk9 0Bį G{*]AÖYrAUpI9?+s4iQY#~݈e~IT s OVҪ  K/q=FM+_p]4]kcTWNk5^vQԪzɏ:z4wI/qÎWגB|e~]J~~Sc /u_Lء1pӁMR?Hk/CcE'v2tq7f]g(> Zj%dwwB- !~MWߚ]rɜ vȏVkD>SʟC jA į.0Bù=B׭槼ʯ_}ɯ_("?'TE˷l_HCr-Nي'ʟW)~TDSB?27׋2rU2~_I@' $*gUx*L/h|uxn_˪LY9?,NbK68n20 ~gKU[~BfC8uuʘ4?qS}`34 V^?ȯ^OtK*Uʘ Jh, k%zg~d31FqCamZ~}YێSEEj c`j?fw!WL,'fҨ./I_W"i~jGC^/x Pߤ`3DkMS3b~S^<ӼwIο1D~Z%}1nЭ.&HS~]Ȣp$?5aJ)(Z0o/[0js숟J*i^,LsKrc ~_XYy~Ј_Ȣ-چ.~rē9q*qK/`_`/Ɣ!W1CZgkPcJxy.\D8IKGFNS گ<'3G5?cw_|\Z$?섽U4,Em"IDUL~cw+eL)*#&_)`Ies℟3e} ?VGs)?퍴灋A MK}(~({_/8R%N)|h5?$?i9cDuF]T*^^)}v/?:k 9~+H(9߯doˀBCꐿ, ۚR)x]C˛f@xG~iPFL2RW~v?XoQ9=rͰ$î|bl-lRLO]'c~%2\r~oǛp1̯t#g6G+Ki'?M-_+p_:ŏrJ 2>~ߧyGWW#0wM^@&9ͯYOwۓ("~Ѝ]1\Xu9 //R燞eK~ﮮ 3`FHɯ>Mr|F5[B~;>} 0\1$*dI4pҌ%1?:S62n4?)@lw~o;=tWK@&7We@,Dž85 {5-P /TZ\Z C9~\~~v×$ڔP =eVgw'_ܭgG (NdSq$~鑣q(O8c~ʓ,d(/,Գ()~A#,+?:aa5.ר,HNU(LBe{ :?mw_|i~ц~_!3ZG|W~ʘ OfI?uıO8)?h6 t;~oc*J>38:fY~2haFTօٕO 3QI~"Ϗ`,'2~.*:*$7ǯ\˯w3tbx) j/p!N#Yԅwp_M+tK73}x.~$6~`5KNN 9cIc>]sde@OȄ}J>p :_?ɏ:@&2.^1/:)n_xbJ~+w ~:7G VPn5:@"ï#ɷo M?y~|,]d~JJ (~!z.k_x I?PZ3o]nQ5_+ٰߊ !qp ʼF< /D4:_|_ TVj˙O $$?Ak~Htd*Ndos_M>Ϯ7WFg{4:.#~|d_ps4w'c:5qZԿN]SեROkc: B%iaCB>3Fp8kf*qg@_c9~6\Qo%~t=^A3^Vj~O}؁þ,? {g%~%?7 zTqg@͏u#iU3/-Ǐ叚~,n_n?+ v፝E}1k~F%qgWW &5&2Z׾җUzk~P3 H2d,ba;5 $)l?֌X ?j%-_3OCga۠LbVYG'_KS%FM&s=R;͏:'rzY#9h/>GR4KL*5CgD5Ϗi8`s4 'kiU%#z_+{1n:W[ly~N~M)2G_7)~nQHȯ" DqmUt(ϖ"E~SL C 7 2e3Fu_'ްaY~tYO>l9՜$F7eůg~&~R⫞W#~Z1 LN$Fή8PSsCՌo, bc(+ׇ-k53MkǕZ~g숟g9]gG_ԆZ^2/G32դg&"F~$v+sW ?\K>~4k:S~^A% lynv:#~" 1]ư٫-SF^t%/N[GO3s__?GPS pxCztצWK#wb^ߝՋ?&E*$?ץC_BOƢW6Yy~%9od,%WBn);ɯQm#i~o7D1fg aBMWsn~6Q5d?EK ~U{(?pn$Tt&m?4:(6Sh_F~n~@?ǯN[z](˺;:X&z̯]om"2?8ȣ?*~/__N`|bM=@W9ڄ_\Mdmс叵MM#;xÝWƏ'9~F~fE& ~XHqb$ˏ˵G _p-,Ѵk8QcklF~쇸__WLk^O `GȈO[ߺ/Y _0Ri~|~s27Z?] zho!uw #sQ,??~=Ǝ6W1~O78Y~F<7o$?q5?rwU3nop'oy~ 6~sjS~?~Zy ~ur:op#{;//\zwCw*&UWSZ?=o4O~$?^kȖ:~"6c~jF+Ao/am CJ{/j+Ӭx'-O\j~G)MMӅOA-{Z캣VMe@cm5*U|(ï7Z-m!Ia7$+o*iOܩ^c~^(XiUŴo;?ad][U+峏_K*~͘_qoRK+sQPX??SpuTS/UUL߽5"5b-~##ǫ&~~Q ?;,qU,v,k?3ff4:# ɯ۴Mp$iq};ˋR'c_ExrWHgwSd7O<8-J>@9#H? o/Έ[56NMM&kV_Mk7kFǏD?N4xz| :J",??ů96b? &kVb^#k3$?ɤk~WnJ~ΛkQ2Oyh?  %zt7}v:WO+}>/V ,Z~ \z{h0D~r ?ie|QaJ)gg7h~F۳N>7:'"NFC2j5jp-@rLXz?/1C~2Yŏ~lD_;ŏ-Ci~.O:е*d4Xnd?,j'ұ1__{m8WĐeŗnWEwF crdS8ygg4N\7.J'rD%G5G"^g/%WůzTFJlCJXCTqrMbV R5?'*~6|WT$+b-JSz?5ȯ_aܳV6+5\A?3Èd'b"*w-!G槗!(Ue=/:P %E~qEln1ӏ%~16'Ep'qҁ{ ?g4pLɐX=y:~ *,Q Y -/ ?:`ЉFJ0F~4hqMRi-O_hLjpT6g¤xuv_؊l_*z!/r:79ߌʢSleuO`_-;ڰOUA^U/*f: *\'AΡAũ\bV_$0GyI|aDzT!N`@P9~<q,Z6F4F6Pc~q&s ;(׬3ѡ@dkf91'1Q %!~2@H5LԸ^URϗY!x*PFaq/a ).=n5)g%bOt!^oLJ%NT\Ēԃ.NxDO@^rɄEjJ#vߋhP+fU\ Zu. }?nf|.G ^6k~V+B,vpZXMa'H5ɏJ3 *^Z/m.Uk#?uK6T.ǯ)spB#[͏¼2P x⣋Ʀ/ukRbNfӽTBn^]\r\[t=Ĵ,Vb:R\Ϊ9e&뻌>Qnon驌&% _^l.y޵6~O+})y'o~o<|%cwO7}K>޲Ivɻ퓷O}]5xzy%oo;o}{Ow7}K}Svɻ'Ny%w;o>y/='Ny%oo;o}{Ow7}K}SvG|X3~U;_z;cwn_=L<82Ϯx\:^]kCv|׬5_*JIDAT?Sȷ9~e෶2G"I5þ_fGM)qsmoQ0VɹeJqs7k'P%7WɯaڟRwP~OcߺLflj|w,>2~[y~9M;`&&~]>Anm [B_E5Yy)?٣S\ȁ5{t__*$q eN_@~yog_[*$r11g=F7`3ˁ__]),o"@:sUrO0]#&~q&X߁w":9W6~wot?0~6~/.#~C,R 7Nzc~4lpX!E"o0ܺ{%p~y^bŏ? ;lᗥ{TFV9f@~MhP~Hz0X([ڀX;}7&6T4>i–acJؤ@u3 a`p8 &ZȾUk 6r6ebaNsq9~@k̯]?W?E~きչ4'>/Y9r&c% vV3i"o~-;ͪ]`[kn_˯A~G%6#uכ" h:I$~-@ 8Ƀ]PAwF׿y{ #Q`} 3.t!.ih S7NCN-9S1v0tzw*5q l\RPHʯ1] v;4;p_O:E~'εA6!4hi}+Y0x;9~U/at;;4~/)oBYE{šfqPCy͏f^MA"?w?pC `i"5Rh~!{gc&:0 OBS?`7X(4^$2?@=OD[.=x+)SCȯ:m d?9ףKSRs+)uFQ㢒P ĸZ@9 ]b 5l<Q;za!l:gUè{BWXd{<{_SJsDZ}`K~8 1:8E !~N|_ж~w7n1͉  /Xw~'*d t]O*/ v0Y4ge..Ç~:m:lE`;k~_Q˴АT~1F IqD8t 8q]$!, nHSh~ >^N/ qF bU'~2b5_|ǐ?hb/2?)3J~wd 8.جp xW1D3>%8=F^̀kɯ>' #J_O{4<\z5&_ s[vj_J1$sU=;)wgOoy + 8Q \W_p 9䇀>G8n|eO< 4.IMe(˛_NoB8gB~-oEї\"9JPߕ+%^>Y~Ka;=yg~Æ8fV\}ï&B%):U5b_Ky$?K%0d'<C 4ͯ#;d!Ϟ_&~_ #?/ac"XQ4 >ww3Ah_,QFs)ҋYl֟r?J']k,`į%- l%r82}li~~^m<'цO_~b}N ~&&O/oz@4?z }_ï ?~y7u1|:m_nN8k~~M8~+y~]p;DG ~8VԿv=4[qOO/כw@so i~~I~>ϯ+b IFLC2 u/K+b _ɯ1hG)5n;q|7gh$>1~$?w ?z~~Ǜ~H~vABO5J8wE!_J$7WL5#~?7ɯ+&u#~(AkaE~9'D..]1ɯgͯR)s& z=>uih1(LoiVR~Ss_?τt?>bu;?^W~I~@䗋c.%A~S{|%loކy~@/>|鿼e_ !?= ~=Z9}~ac|?j^kRٙ$N+~^PַSn";/XY3?— ??Dc~W,?xl4Í)_O}?_5ŏ̊P2̾/}/I_b̯ 'S8{Od)g~珮pUud_WPtkJI=_z+"،B7D~Acx")ݡ4WbSfhBAO2J51 :44g.Y ?|ڔ4 ȏ|aN |~CXͨ2o^Х7C\5K*Wyhg {m׃ '#pHL{Mt;|c 3t\V7pC~5aa=i HeL-O1A,LJ=M0(wB]ܰQp*1Uه9ߙ_h w۫hlfA!PGxEH[^5L.TSVO!0ŰUsZt1i^d`aZӤL.H{(=._a$?:FzsgjU]J/;JZ&6\C\:a#D~mmz2YخfI~F-_ u>v 9&Ձy68Wm>\B>⇏Y,Dm# 0":Ί?k}5:g}c?J+*0E9=& 13w{:EL\ `~E y815jatsn'N 'F^Q *,CI#[iƦ҆QsDkʍgqa<$'o~1?|[ZUѮXUtд[IJ=`.$^+yVx?[Y.q/7vY_n}1~G/}=_:9E]IENDB`3 A@@  |Cash Rental Rate EstimationName: Gross IncomeCornSoybeansxSeedLimeCrop Insurance Custom Hire Fuel, RepairsMachinery OwnershipShare of Gross Income Gross income= $/acre rentTenant's Residualminus tenant's costsYield PotentialPotential yield bu./acre x per bu rentPercent of Land Value per acre xreturn4Ag Decision Maker -- Iowa State University Extension@Place the cursor over cells with red triangles to read comments.(Enter your input values in shaded cells. Date Printed: . . . and justice for allCorn Suitability Rating IndexClay DickinsonEmmetLyonO'BrienOsceola Palo AltoSiouxCalhounHamiltonKossuth PocahontasWebsterWrightButler Cerro GordoFloydFranklinHancockMitchell WinnebagoWorth AllamakeeBremer ChickasawClaytonFayetteHoward Winneshiek Buena VistaCherokeeIdaPlymouthSacWoodburyAudubonCarrollCrawfordGreeneGuthrieHarrisonShelbyBooneDallasGrundyHardinJasperMarshallStoryBenton Black HawkBuchananIowaJohnsonLinn PoweshiekTamaCedarClintonDelawareDubuqueJacksonJones MuscatineScottAdairAdamsCassFremontMills MontgomeryPage PottawattamieRinggoldTaylor AppanooseDecaturMadisonMahaskaMarionUnionWayneWarrenHenryKeokukLouisa WashingtonCountyAverage Row Crop CSR IndexDavis Des MoinesLee JeffersonWapello Van BurenClarkeMonroeLucasAcres in Each CropExpected YieldUSDA Direct Payments%Total Gross Income for Crop, per acre Herbicides Insecticides Miscellaneous CSR x $ per point for rentlength of period (months) interest rate Total hoursInterest on Input CostsAverage Weighted RentAuthors: William Edwards andAverage Weighted ResidualCrop Share EquivalentOwner's share of incomeminus owner's costsAverage Weighted ReturnPProduction Costs (For Tenant's Residual or Crop Share Equivalent approach, only) OR payment per acreTotal annual payment Ann JohannsTSee Information File C2-20, "Computing a Cropland Cash Rental Rate" for information. B Expected Price FertilizerHumboldtMononaPolk Version 1.32Desired return to tenant for management and profitEstimated Cash Rental Rates/hourhrs. Cost per bu.DryingStorageTransportation Labor: Wage rate or enter hr/a Hours/acre%Total of all non-land costs, per acre#Enter farm CSR index for crop acres3This approach assumes the landowner receives 50% of8all income and pays 50% of seed, fertilizer, pesticides,8insurance, misc, drying, transportion and storage costs.4This approach shows how much revenue is projected to6be available after paying all production costs and the1tenant's desired profit and return to management.Current market value of land $/acre return'Choose a county from the drop down listorsThe latest Farmland Cash Rental Rate Survey from Iowa State University Extension is available for more information. !+ Click here to see a table that shows average cash rents for cropland as a percent of average cropland sale values in Iowa in recent years (USDA estimates). Click here to see a table that shows average cash rents for cropland as a percent of gross crop revenue in Iowa in recent years.% Issued in furtherance of Cooperative Extension work, Acts of May 8 and July 30, 1914, in cooperation with the U.S. Department of Agriculture. Cathann A. Kress, director, Cooperative Extension Service, Iowa State University of Science and Technology, Ames, Iowa. 6The U.S. Department of Agriculture (USDA) prohibits discrimination in all its programs and activities on the basis of race, color, national origin, gender, religion, age, disability, political beliefs, sexual orientation, and marital or family status. (Not all prohibited bases apply to all programs.) Many materials can be made available in alternative formats for ADA clients. To file a complaint of discrimination, write USDA, Office of Civil Rights, Room 326-W, Whitten Building, 14th and Independence Avenue, SW, Washington, DC 20250-9410 or call 202-720-5964. Michigan 2016 examplez 3{e{B|t@}r}}1~c~~Ql/T2O+], (Z ccJB g2ɀ Z3  dMbP?_*+%&?'?(?)?M HP LaserJet 2100 PCL6,C odXXLetterDINU",O SMTJHP LaserJet 2100 PCL6InputBinFORMSOURCERESDLLUniresDLLEconomodeOption1RETOption1ResolutionOption2OrientationPORTRAITPaperSizeLETTERDitherHIQUALITYTrueTypeFormatOUTLINE"<XX??&U} \} } }  } q} } U }  } q } q } q } } }  ZhU  ___     ,@@ U VW ]^ VW mm VW XY  XY     "VWCCCCCCCCCCCC "XYCCCCCCCCCCCC XY  CCCC " XYCCCCCDCC XY  MMMMM  S  XY  CCCC~ i@ ~ i@ XY  CCEC~ d@ ~ F@ GHC XY  CCEC~ t@ ~ #@ GC XY  CCC   CXYC  ~ $@k$@ UD D  7DD DD D  $" B k $@  UD D  7DD DD D  $" B C XY (P@  D D D ( |@ D D D  C XY  CXYCCCCC  IC XY MMMM  K___ XY CCCC~ Y@ ~  F@  XY CCCC~ b@ ~  N@  Z[ CCCC~ $@ ~  $@  Z[ CCCC~ 9@ ~  1@ _}_}~ Z[ CCCC~  ~   _}}~ Z[ CCCC~ 4@ ~  $@  ____ VW CCCC~ "@ ~  "@  ____ VW CCuuCC  VW ~  @u ~ @3Q)@  %DD  3 )\(@K % DD   XY  CCCC~  ~   LC Y XY  CCCC~ D@ ~  ?@  LC XY  CCCC ~ R@  ~  @P@  LC D l&60*&&H&ddfdV.*.HdddnnvvDnd !"#$@%&'()*+,@-.,e/01234,56789:;<=>@? XY  CCCC~ >@! H@7 D @D ~ ! " D @D  LC !XY !!CCCC~ !@!333333@J !!"  L @L~ ! @! ? ! ! LC "XY ""CCCC~ "$@"0@!!~ " $@" @! ! " LC #XY # #~ #.@ ##u ## # # # LC $XY $$ $ $~ $@p@T$C@$ >D$D$ D$D#D D D$D#B~ $ @T$ @@3>D$D$ D$D#D D D$ D#B $ CLC %XYCCCCCCC % LC &XY &&CCCC~ &I@& ~ & I@ & HC 'XYCCCC ' HC (XY ((OOOO#({G‚@ D %&( #( ףp=ju@ E %&  ( JC )CCCCCCCCCCCC *^ + +MMMMMMttttC ,CCCCCCCuuuu -E -C -CC-P@KD -C~ -?- v - w!- P`@D D-D- - v - -. . . .. |@L D .~ .A@. . !. c@/ D.D. . . /TOOOPOs / / x_/ a@F ID @D @ )D @D- D @D. D @D @  B / y/ 0ECCCGCM{wuC 11MMMMMMtttC &2CCCCCCCuuu 3C 3C 3CC3Cd@3 D  3C~ 3V@ 3 u 3 w!3 b@4 D3D3 3 v 3 3 4C 4C 4CC4CF@4 D  4C~ 4t@ 4 u 4 w!4 b@@ D4D4 4 v4 5TOOOPOO 5 5 x_5 Hb@( ID @D @ )D @D3 D @D4 D @D @  B 5 y5 &6CCCCCCCuuu 77MMMMMMttt $7 ?<D<#B@7&8ICCCCCCuuu 9E 9CC~ 9N@9CCuuu : :|~ :@ :  : NE: b@/D9 D9D:D<D:B : F : : ;_ ; ;C ; C; < <a<S<N@: =D9  $9&D7 ;c;cBB< NF&=ssssssssss >>MMMMMMMMM > >&?CCCCCCCCCCDSl .d.". ".**f*LL*L@ABCDE,FGHIJK,LMNeOePeQeR_STUVWX,@Yh@ @T @OOO~ @`@ @O~ @@ @ O @ R!@ c@Q D@D@ @ Q@ &ACCCCCCCuuu B$BMMMMMMttt&CCCCCCCCuuu DC DC DCCDGP@D D- DCDCD z{G‚@ JD( D w!D أp= S E DDDD  D v D D EC EC ECCEG |@E D. ECECE z ףp=ju@ (D( E w!E أp= Z@ . DEDE  E v E EFTOOOPOO F F x_F +@ ID @D @ )D @DD D @DE D @D @  B F y F F&Gsssss H$HCCCCCCuuu&ICCCCCCuuu J JJPp@J D J7J (\µh@ !%e% "e J !J (\O@- DJDJ  J J J K KK l@K D  K6K Gz\T@$ % %% "  K !K (\a@. DKDK  K K KLTTTTTT L L _L Y@- ID @D @ )D @DJ D @DK D @D @  B L L LMEEEEEEd_ NZ[ NaNbcddd^ OZY OO O PZY PP P QZ[ QgQ  @!5 AQ  QfffRVWhiiiiji SXY S TXY T UXY VXY VkVllllllll WXY WWn "XXYn YXY YYn 8Q *6**6*":BBW6<&!" (Q  ,0v(  0 0 B XPP?i#]4@ W9zIyq[ @<APlace the cursor over cells with red triangles to read comments.<n@$~~ 0 < XPP? i9 ]4@  {s!My  M<NEnter the number of acres for each crop to calculate an average rent below.<M;Hl~~ 0 <І XPP?9tk;]4@ a sYMV/  L<MThis cell must be empty to find the $/acre rent using the county CSR Index.<L'-~~ 0 < XPP? i]4@ =A,I1QE`)  9<:Input total direct payment per year or payment per acre.<Q9~~ 0 <( XPP?x i  Q]4@ 5]K[-.|c  &<'Based on actual yields in recent years<&;~~ 0 <P XPP? x i  Q]4@ xrt2;ԳI(!^  &<'Based on actual yields in recent years<&T$~~  0 < XPP?$ u&]4 @ >@ wW  H<IEstimated total hours of labor needed to plant and harvest both crops.<H12~~  0 < XPP? : =F]4 @ فr={CJ  a0<bThe Farm CSR Index input cell must be empty to find the $/acre rent using the County CSR Index.<0P.VCa'- 0 NЇ X?#: $$]4@ 3H:LjbFp   6<7This will override the "Total hours" input cell value.<$6 0 N X? #] $H]4@ 0}8O@ K x  6<7This will override the "Total hours" input cell value.<$6 ,0 A$@??$Univ_B_1_NoTh_RegPicture 2Univ_B_1_NoTh_RegS:Ut]&,` Economics Department Economics Department William Edwardst William Edwardst Economics Department$ William Edwardst$Edwards, William M t$ Edwards, William M t 9Economics Department < Economics Department>@<dnojo% %% >@ 35 WX -/ YY :< QQ  99<<7"yK /Estimating the Field Capacity of Farm MachinesyK http://www.extension.iastate.edu/agdm/crops/pdf/a3-24.pdfyX;H,]ą'cRyK AFor more information see "Computing a Cropland Cash Rental Rate"yK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-20.htmlyX;H,]ą'cP33 yK @http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlyK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlyX;H,]ą'cOOyK Authors: William Edwards andyK mailto:wedwards@iastate.edu?subject=AgDM%20Spreadsheet%20C2-20yX;H,]ą'cPPyK  Ann HolsteyK mailto:aholste@iastate.edu?subject=AgDM%20Spreadsheet%20C2-20yX;H,]ą'cP:: yK @http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlyK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlyX;H,]ą'c>@ yK Click here to see a table that shows average cash rents for cropland as a percent of average cropland sale values in Iowa in recent years (USDA estimates).yK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-09.htmlyX;H,]ą'c-/ yK Click here to see a table that shows average cash rents for cropland as a percent of gross crop revenue in Iowa in recent years.yK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-20.htmlyX;H,]ą'cInclude potential USDA loan deficiency payments and counter cyclical payments. Maximum CCP is about $.20 per bushel for corn ($.22/bu. for soybeans). Add CCP to county loan rate to get minimum price.rp +  p#l <<ggD g2ɀ Zp  dMbP?_*+%&?'?(?)?M HP LaserJet 2100 PCL6,C odXXLetterDINU",O SMTJHP LaserJet 2100 PCL6InputBinFORMSOURCERESDLLUniresDLLEconomodeOption1RETOption1ResolutionOption2OrientationPORTRAITPaperSizeLETTERDitherHIQUALITYTrueTypeFormatOUTLINE"<XX??&U} \} } }  } q} } U }  } q } q } q } } }  ZhU  ___     ,@@ U VW ]^ VW mm VW XY  XY     "VWCCCCCCCCCCCC "XYCCCCCCCCCCCC XY CCCC " XYCCCCCDCC XY  MMMMM  S  XY  CCCC XY  CCECGHC XY  CCEC GC XY  CCC   CXYC  kUD D  7DD DD D  $" B k  UD D  7DD DD D  $" B C XY (( D D D ( D D D  C XY  CXYCCCCC  IC XY MMMM  K___ XY CCCC  XY CCCC  Z[ CCCC  Z[ CCCC  _}_}~ Z[ CCCC  _}}~ Z[ CCCC  ____ VW CCCC  ____ VW CCuuCC  VW  u 3 %DD  3 % DD   XY  CCCC  LC Y XY  CCCC  LC XY  CCCC     LC D l&60*&&<&dD<DV"*.HDDDNNVVDND !"#$@%&'()*+,@-.,e/01234,56789:;<=>@? XY  CCCC!  D @D  !   D @D  LC !XY !!CCCC! !!"  L @L! ! !! ! LC "XY ""CCCC"! !" " "! " LC #XY # ## ##u ## # # # LC $XY $$ $ $$T$" >D$D$ D$D#D D D$D#B$ T$ $>D$D$ D$D#D D D$ D#B $ CLC %XYCCCCCCC % LC &XY &&CCCC & HC 'XYCCCC ' HC (XY ((OOOO#(D %&( #( E %&  ( JC )CCCCCCCCCCCC *^ + +MMMMMMttttC ,CCCCCCCuuuu -E -C -CC-JD -C -v - w!- E D-D- - v - -. . . ... D . . . !. - D.D. . . /TOOOPOs / / x_/ F ID @D @ )D @D- D @D. D @D @  B / y/ 0ECCCGCM{wuC 11MMMMMMtttC &2CCCCCCCuuu 3C 3C 3CC3C3 D  3C3 3 u 3 w!3 $ D3D3 3 v 3 3 4C 4C 4CC4C4 D  4C4 4 u 4 w!4 3 D4D4 4 v4 5TOOOPOO 5 5 x_5 (ID @D @ )D @D3 D @D4 D @D @  B 5 y5 &6CCCCCCCuuu 77MMMMMMttt $7 ?<D<#B@7&8ICCCCCCuuu 9E$9CCCCuuu : :|: :  : NE: 4/D9 D9D:D<D:B : F : : ;_ ; ;C ; C; < <a<S<Q@: =D9  $9&D7 ;c;cBB< NF&=ssssssssss >>MMMMMMMMM > >&?CCCCCCCCCCDl.D.". ".**f*6L*L@ABCDE,FGHIJK,LMNeOePeQeR_STUVWX,@Yt@ @T@OOO` @O@ @ O @ R!@ 7 D@D@ @ Q@ &ACCCCCCCuuu B$BMMMMMMttt&CCCCCCCCuuu DC DC DCCDGD D- DCDCD zL D( D w!D - DDDD  D v D D EC EC ECCEGE D. ECECE zK D( E w!E / DEDE  E v E EFTOOOPOO F F x_F  ID @D @ )D @DD D @DE D @D @  B F y F F&Gsssss H$HCCCCCCuuu&ICCCCCCuuu J JJ5 D J7J K!%e% "e J !J Q DJDJ  J J J K KK. D  K6K J % %% "  K !K J DKDK  K K KLTTTTTT L L _L DID @D @ )D @DJ D @DK D @D @  B L L LMEEEEEEd_ NZ[ NaNbcddd^ OZY OO O PZY PP P QZ[ QgQ  @@ AQ  QfffRVWhiiiiji SXY S TXY T UXY VXY VkVllllllll WXY WWn "XXYn YXY YYn 8Q *6**6*":BBW6<&" 5F   <v(  < < BЎ XPP?i#]4@ kuݢB.fE @<APlace the cursor over cells with red triangles to read comments.<n@$~~ < < XPP? i9 ]4@ ¨U%*Mr%}-  M<NEnter the number of acres for each crop to calculate an average rent below.<M;Hl~~ < <( XPP?x i  Q]4@ V8FL$S9  &<'Based on actual yields in recent years<&;~~ < <P XPP? x i  Q]4@ SO J7<n  &<'Based on actual yields in recent years<&T$~~ < < XPP? i]4@ u gG !  9<:Input total direct payment per year or payment per acre.<Q9~~ < < XPP?$ u&]4@ :C'CA_$f  H<IEstimated total hours of labor needed to plant and harvest both crops.<H12 < NЏ X?#: $$]4@ nͰ;NX  6<7This will override the "Total hours" input cell value.<$6 < N X? #] $H]4@ MH K~*  6<7This will override the "Total hours" input cell value.<$6~~  < <( XPP?9tk;]4 @ ѝ5 @CD$4  L<MThis cell must be empty to find the $/acre rent using the county CSR Index.<L'-~~  < <P XPP? : =F]4 @ E) 2%K'  a0<bThe Farm CSR Index input cell must be empty to find the $/acre rent using the County CSR Index.<0P.VCa'- < A$@??$Univ_B_1_NoTh_RegPicture 2Univ_B_1_NoTh_RegS:Ut]&` Economics Department Economics Department William Edwardst William Edwardst Economics Department$William Edwardst$Edwards, William M t$ Edwards, William M t 9 Economics Department < Economics Department>@<dnojo  >@ QQWX YY -/ 35 99:< <<"yK /Estimating the Field Capacity of Farm MachinesyK http://www.extension.iastate.edu/agdm/crops/pdf/a3-24.pdfyX;H,]ą'cRyK AFor more information see "Computing a Cropland Cash Rental Rate"yK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-20.htmlyX;H,]ą'cP33 yK @http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlyK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlyX;H,]ą'cOOyK Authors: William Edwards andyK mailto:wedwards@iastate.edu?subject=AgDM%20Spreadsheet%20C2-20yX;H,]ą'cPPyK  Ann HolsteyK mailto:aholste@iastate.edu?subject=AgDM%20Spreadsheet%20C2-20yX;H,]ą'cP:: yK @http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlyK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlyX;H,]ą'c>@ yK Click here to see a table that shows average cash rents for cropland as a percent of average cropland sale values in Iowa in recent years (USDA estimates).yK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-09.htmlyX;H,]ą'c-/ yK Click here to see a table that shows average cash rents for cropland as a percent of gross crop revenue in Iowa in recent years.yK http://www.extension.iastate.edu/agdm/wholefarm/html/c2-20.htmlyX;H,]ą'c+  #<<Include potential USDA loan deficiency payments and counter cyclical payments. Maximum CCP is about $.20 per bushel for corn ($.22/bu. for soybeans). Add CCP to county loan rate to get minimum price.rp ggD g2ɀ 05)119MAEIMQR  dMbP?_*+%&?'?(?)?M HP LaserJet 2100 PCL6,C odXXLetterDINU",O SMTJHP LaserJet 2100 PCL6InputBinOption1RESDLLUniresDLLEconomodeOption1RETOption1ResolutionOption2OrientationPORTRAITPaperSizeLETTERDitherHIQUALITYTrueTypeFormatOUTLINE"dXX??&cU}  _}  _      ow _x~ ? a~ rQ@~ @ b~ rQ@~ @ 6~ r@S@~ @ qk~ rQ@~ @ C~ r@Q@~ @ Q~ rT@~ @ R~ r@T@~  @ J~ rT@~ "@ 7~ rT@~ $@ S~ rS@~ &@ =~ rR@~ (@ .~ rS@~ *@ (~ rS@~ ,@ D~ rR@~ .@ c~ rQ@~ 0@ Y~ r@U@~ 1@ /~ rS@~ 2@ >~ rQ@~ 3@ 8~ rS@~ 4@ q~ rQ@~ 5@  ~ r@R@~ 6@ 9~ r@Q@~ 7@ Z~ rR@~ 8@ E~ rO@~ 9@ K~ r@U@~ :@ y~ rP@~ ;@ ql~ rP@~ <@ [~ rR@~ =@ qz~ rT@~ >@ !~ rQ@~ ?@ \~ rQ@Dl****************************** !"#$%&'()*+,-./0123456789:;<=>?~ @@ "~ r@Q@~ !@@ !:~ !rS@~ "A@ "0~ "rT@~ #A@ #1~ #rT@~ $B@ $d~ $rR@~ %B@ %F~ %rT@~ &C@ &L~ &r@U@~ 'C@ 'G~ 'rR@~ (D@ ()~ (rS@~ )D@ )2~ )rR@~ *E@ *M~ *rT@~ +E@ +H~ +r@P@~ ,F@ ,s~ ,rS@~ -F@ -;~ -rS@~ .G@ .~ .S@.r~ /G@ /?~ /rO@~ 0H@ 0T~ 0r@S@~ 1H@ 1]~ 1rP@~ 2I@ 2N~ 2rS@~ 3I@ 3|~ 3rS@~ 4J@ 4U~ 4r@U@~ 5J@ 5^~ 5rR@~ 6K@ 6t~ 6r@S@~ 7K@ 7*~ 7rR@~ 8L@ 8q{~ 8rQ@~ 9L@ 9V~ 9rT@~ :M@ :qu~ :rS@~ ;M@ ;q~ ;rR@~ <N@ <#~ <rP@~ =N@ =qm~ =rT@~ >O@ >qn~ >r@T@~ ?O@ ?qo~ ?rS@Dl**************4****************@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_~ @P@ @O~ @rT@~ A@P@ Ae~ Ar@R@~ BP@ B3~ Br@T@~ CP@ C~ CrM@Cr~ DQ@ Dq~ DrR@~ E@Q@ Ef~ ErQ@~ FQ@ F_~ FrT@~ GQ@ G$~ GrR@~ HR@ H%~ HrQ@~ I@R@ Ig~ IrQ@~ JR@ J&~ JrR@~ KR@ K@~ KrO@~ LS@ L+~ LrR@~ M@S@ M~ MrV@Mr~ NS@ Nh~ Nr@Q@~ OS@ OW~ OrS@~ PT@ Pi~ Pr@Q@~ Q@T@ QA~ QrR@~ RT@ R`~ RrU@~ ST@ SI~ SrQ@~ TU@ T'~ TrP@~ U@U@ UP~ UrT@~ VU@ VX~ VrT@~ WU@ Wj~ WrR@~ XV@ Xp~ XrS@~ Y@V@ Yq~~ Yr@Q@~ ZV@ Zq}~ ZrS@~ [V@ [r~ [r@T@~ \W@ \v~ \r@T@~ ]@W@ ]q~ ]rP@~ ^W@ ^,~ ^rS@~ _W@ _4~ _rQ@Dl***4*********4*****************`abcdefghijklmnopqrstuvwxyz{|}~~ `X@ `<~ `rR@~ a@X@ aB~ arL@~ bX@ b5~ brS@~ cX@ c-~ crR@dpepfpgphpipjpkplpmpnpopppqprpsptpupvpwpxpypzp{p|p}p~ppD@l**** ppppppppppppppppppppppppppppppppDl ppppppppppppppppppppppppppppppppDl ppppppppppppppppppppppppppppppppDl pppp x< >@_Z7ggD Oh+'0HPp Economics DepartmentbetzMicrosoft Excel@p@vur@+ ՜.+,D՜.+,@ PXx  Iowa State University ExampleBlankData countiesBlank!Print_AreaExample!Print_Area  Worksheets Named Rangesl  8@ _PID_HLINKSA$ `p+@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-20.htmlr"@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-09.htmls+@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmli >mailto:aholste@iastate.edu?subject=AgDM%20Spreadsheet%20C2-20.?mailto:wedwards@iastate.edu?subject=AgDM%20Spreadsheet%20C2-20s+@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlp+@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-20.htmlZ:http://www.extension.iastate.edu/agdm/crops/pdf/a3-24.pdfp+@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-20.htmlr"@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-09.htmls+@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmli >mailto:aholste@iastate.edu?subject=AgDM%20Spreadsheet%20C2-20.?mailto:wedwards@iastate.edu?subject=AgDM%20Spreadsheet%20C2-20s+@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-10.htmlp+@http://www.extension.iastate.edu/agdm/wholefarm/html/c2-20.htmlZ:http://www.extension.iastate.edu/agdm/crops/pdf/a3-24.pdf  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FWorkbook#SSummaryInformation(DocumentSummaryInformation8