ࡱ> ji T8\p Corp, Sean Ba==G$8X@"1%Calibri1%Calibri1%Calibri1%Calibri1%Calibri1%Calibri1 %Calibri1%Calibri14%Calibri1 %Calibri1%Calibri1%Calibri1,8%Calibri18%Calibri18%Calibri1>%Calibri14%Calibri1<%Calibri1?%Calibri1h8%Cambria1%Calibri1 %Calibri1%Calibri1%Calibri1%Calibri1%Calibri1%Calibri"$"#,##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\);_(* "-"??_);_(@_) 0.0%                                                                       ff + ) , *     P  P        `            a>    # # #4 "  0 8  ! " "  #  #< #< % $        $  $ #  !  !< !| ! ! # # #<a@ @  #<@ @  #<@ @  #<@ @  #<@ @  # #<@ @  #<   % ,@ @   ,@ @  #<@ @   #<@ @  #<@ @  # #< #|@ @  #|@ @  #|@ @  "|@ @  % l@ @  #|@ @  #\ #<@ @  t@ @     #|@ @  "|@ @  " "4@ @  #<@ @  #<@ @   "4@ @  "4@ @  # #<@ @  #< #4@ @  " " "4@ @    "< "4 ||}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-} 00\);_(*}-} 00\);_(*}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\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}+ 00\);_(*}-}, 00\);_(*}-}- 00\);_(*}-}. 00\);_(*}-}/ 00\);_(*}A}0 a00\);_(*;_(@_) }A}1 00\);_(*;_(@_) }A}2 00\);_(*?;_(@_) }A}3 00\);_(*23;_(@_) }-}4 00\);_(*}}5 ??v00\);_(*̙;_(@_)    }A}6 }00\);_(*;_(@_) }A}7 e00\);_(*;_(@_) }}8 00\);_(*;_(@_)    }}9 ???00\);_(*;_(@_) ??? ??? ??? ???}-}: 00\);_(*}-}; 00\);_(*}U}< 00\);_(*;_(@_)  }-}= 00\);_(*}-}> 00\);_(*}-}? 00\);_(*}-}@ 00\);_(*}-}A 00\);_(*}-}B 00\);_(*}-}C 00\);_(*}-}D 00\);_(*}-}E 00\);_(*}-}F 00\);_(*}-}G 00\);_(*}-}H 00\);_(*}-}I 00\);_(*}-}J 00\);_(*}-}K 00\);_(*}-}L 00\);_(*}-}M 00\);_(*}-}N 00\);_(*}(}O 00\);_(*}(}P 00\);_(*}-}Q 00\);_(*}-}R 00\);_(*}-}S 00\);_(*}-}T 00\);_(*}-}U 00\);_(*}-}V 00\);_(*}-}W 00\);_(*}-}X 00\);_(*}-}Y 00\);_(*}-}Z 00\);_(*}-}[ 00\);_(*}-}\ 00\);_(*}-}] 00\);_(*}-}^ 00\);_(*}-}_ 00\);_(*}-}` 00\);_(*}-}a 00\);_(*}-}b 00\);_(*}-}c 00\);_(*}-}d 00\);_(*}-}e 00\);_(*}-}f 00\);_(*}-}g 00\);_(*}-}h 00\);_(*}-}i 00\);_(*}-}j 00\);_(*}A}k 00\);_(*;_(@_) }A}l 00\);_(*;_(@_) }A}m 00\);_(*;_(@_) }A}n 00\);_(*;_(@_) }A}o 00\);_(*;_(@_) }A}p 00\);_(*;_(@_) }A}q 00\);_(*;_(@_) }-}r 00\);_(*}A}s 00\);_(*;_(@_) }-}t 00\);_(*}-}u 00\);_(*}-}v 00\);_(*}-}w 00\);_(*}-}x 00\);_(*}-}y 00\);_(*}-}z 00\);_(*}-}{ 00\);_(*}-}| 00\);_(*}-}} 00\);_(*}-}~ 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 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]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%3Normal % 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`OIncome Statement,RatiosSheet2Sheet3a|E `!Gross Income (Schedule F Line 11) Crops & FeedLivestock Held For SaleAccounts Receivable Other InventoryHedging AccountsAccount Total Expense (sched F, line 35) ! Prepaid Expenses & Supplies+ Cost of Feeder Livestock Sold (Line 2)& Crop Insurance Reported (Line 8b)& Crop Insurance Received (Line 8a) Cull Livestock Income Gross Cash Income Growing Crops Accounts Payable* Total Operating Expense (Accrual)# Breeding Livestock Replacments! Total Expense (accural)Net Farm Income (accural)aUse this worksheet to convert Schedule F tax information to an accrual adjusted income statement.Income Statement Worksheet9 Crop Insurance Deferred from Previous Year (Line 8d)End Invent - Beg InventBeg Invent - End InventEnd Invent - Beg Invent Depreciation4 Purchases of livestock & other items for resale Depreciation (line 16)++ - Key Ratios Worksheet VulnerableStrong,Liquidity: Working Capital to Gross RevenueTotal current assetsTotal current liabilities-Working capital=$Working capital to gross revenue (%)#----- 10% --------------- 25% -----Solvency: Debt to Asset RatioTotal liabilities Total assetsDebt to asset ratio (%)#----- 60% --------------- 30% -----(Profitability: Rate of Return on AssetsFarm interest expenseValue of labor and managementReturn on farm assetsTotal farm assets!Rate of return on farm assets (%)$------ 4% ----------------- 8% ------Repayment Capacity: Term Debt Coverage RatioInterest on term debtCapital debt repayment capacityScheduled payments on term debtTerm debt coverage ratio%----- 1.20 --------------- 1.50 ----- Efficiency: Asset Turnover RateAsset turnover rate (%)#----- 30% --------------- 45% -----Personal incomeFamily living expensebUse this worksheet with the income statement and ending balance sheet to calculate the key ratios.? Center for Farm Financial Management, University of Minnesota(Profitability: Rate of Return on EquityTotal farm net worth!Rate of return on farm equity (%)%------ 3% ----------------- 10% -----Return on farm equity" Gross Farm Income (Accrual)(A)(B)(C)(D) Total Depreciation(E)(F)Net farm income (F)Depreciation expense (D)Gross farm income (B)C + DB - E Accured Interest Income taxes Machinery Vehicles Buildings Begin value + Purchases- Sales= Value * % Depr bD FESFGDdH IIBJBKN%MMG >N ccB T8 +oz  dMbP?_*+%, &R&9May 2012&ffffff?'ffffff?(?)?MHP Officejet 6500 E709n SeriesC odXXLetterDINU"$׬SMTJHP Officejet 6500 E709n SeriesInputBinFORMSOURCERESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITResolution600dpiColorModeColor24HPSimplifiedUITrueIUPH3/KCj}(!XXKKV2C:\Windows\splwow64.exeZRxoU@m)M$.BS yUj A JP *P ,XذbKX$$PΜ'c;"g;333w*"m9 r@@G mD4Jif0Oa^&.rAL4!"c֭1>ǐG<׼>I#-)=I t3xх _},o׊/lH)kO`|D G{7*pJn9 ;F#fZ Y5Nl8fL;wh!msBR==ռι7x~*YVzO71< b_"&;f=fvbT;2:{ovo'XUǴ'yiwį~Dc]s ܹQtD4 z`y~dմm\fS<^}8cY*wXiik{eto.G} Zt-N5$7G'eŬ"{ ,Y^!o第Kxew#\x`\+9%I^b2-N9#SLlbdQ%w(֌XXy!QcZư`/>lFNؿD \[+8lŧLye| -bE 1:a1ƢD8K@*:aE :aN(I:aNp@':viN t^`;aE`9aE'P'Cs惚[u>={:Ajm^/9ɺ$DgSMqV!gBʩ7$߆%Tk~ɲ]_X@RjayB6Xe2%wAtT=<~9)oWdž`|qx}PKw[:w/t B, *:~!ѥ~[B|:~!Ѧ~9 _Gf[~ K%_6ʺdwn~!9 I?⥯I5̮. ᮺN_H~9 B=5 / r~Sx[G>>>(>)xxxxxxx *xD*xxxxxx2`jj$ x # ' %>@<d#d"j   ))**%%''ggD T8 0I1  dMbP?_*+%,&R&9March 2010&ffffff?'ffffff?(?)?MHP Officejet 6500 E709n SeriesC odXXLetterDINU"$׬SMTJHP Officejet 6500 E709n SeriesInputBinFORMSOURCERESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITResolution600dpiColorModeColor24HPSimplifiedUITrueIUPH3/KCj}(!XXKKV2C:\Windows\splwow64.exeZRxoU@m)M$.BS yUj A JP *P ,XذbKX$$PΜ'c;"g;333w*"m9 r@@G mD4Jif0Oa^&.rAL4!"c֭1>ǐG<׼>I#-)=I t3xх _},o׊/lH)kO`|D G{7*pJn9 ;F#fZ Y5Nl8fL;wh!msBR==ռι7x~*YVzO71< b_"&;f=fvbT;2:{ovo'XUǴ'yiwį~Dc]s ܹQtD4 z`y~dմm\fS<^}8cY*wXiik{eto.G} Zt-N5$7G'eŬ"{ ,Y^!o第Kxew#\x`\+9%I^b2-N9#SLlbdQ%w(֌XXy!QcZư`/>lFNؿD \[+8lŧLye| -bE 1:a1ƢD8K@*:aE :aN(I:aNp@':viN t^`;aE`9aE'P'Cs惚[u>={:Ajm^/9ɺ$DgSMqV!gBʩ7$߆%Tk~ɲ]_X@RjayB6Xe2%wAtT=<~9)oWdž`|qx}PKw[:w/t B, *:~!ѥ~[B|:~!Ѧ~9 _Gf[~ K%_6ʺdwn~!9 I?⥯I5̮. ᮺN_H~9 B=5 / r~Sx[G#c ! ?" $ oM % N& oM ' N("d  DDM T O)dZ@M * P("e DDQ N+ c >, c - pM . O) pM / N(" g D D  Q N0Z >1Z RdZ'@M 2 N pM 3 N& pM 4 N((aDDDM 5 O) aM 6 N("g DDQ N7NbQN >EZ RdZ'@M 3 N&a DM I N("a DDM F O) pM G N("g DDQ NHZ >8Z Rd%Z'@MD`l$$4*LHZ *Z :**R*Z:FL*Z  h@!h@"h@#h@$h@%h@&h@'h@(h@)h@*h@+h@,h@-h@.,/, S N d*Z#@ M !9 !N !pM "A "N "pM #B #N& #pM $X $N& $pM %: %N(:%a'$DD D!D"D#D$%M &; &O) &pM '< 'N("'h D%D&'R 'N=(Z )>>)Z *T*d,Z@*M +5 +O) +pM ,? ,N(",g D*D+,Q ,N@-FL.xxxx /xD/xxx$F,H****d*Z :*Z$! x%   +>@d *--..//ggD T8   dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3U>@ggD T8 1  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3U>@ggD Oh+'0HPdx  cffmuser Corp, SeanMicrosoft Excel@j9XSF@M@Y ՜.+,0HP X`hp x  Income StatementRatiosSheet2Sheet3  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXZ[\]^_`bcdefghRoot Entry FWorkbookSummaryInformation(YDocumentSummaryInformation8a