jagomart
digital resources
picture1_Spreadsheet Calculator 46487 | Calculator Cow Lease


 192x       Filetype XLSX       File size 0.05 MB       Source: www.gov.mb.ca


File: Spreadsheet Calculator 46487 | Calculator Cow Lease
cowshare lease calculator printed 8172022 enter changes to values in blue only cow market value 1 575 hd bull market value 3 500 hd average cow weight 1 350 lbs ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
                        . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 
                        CowShare Lease Calculator                                                                                                                              Printed:    8/17/2022
                        *** Enter changes to values in BLUE only
                        Cow Market Value                                        $1,575/ hd               Bull Market Value                             $3,500/ hd
                        Average Cow Weight                                       1,350 lbs               Cows per Bull                                       25 
                        Cow Death Loss                                             1.25 %                Bull Replacement Rate                               25 %
                        Cull Cow Market Price                                   $83.00/cwt               Cull Bull Market Value                        $2,100/ hd
                        Cull Cow Market Value                               $1,120.50                    Calf Crop                                           95 %
                        Cow Replacement Rate                                          12 %               Steer Calf Weight                                 600 lbs
                        Replacement Heifer Value                                $1,800/ hd               Steer Calf Market Price                     $225.00/cwt
                        Operating Interest Rate                                    5.00 %                Heifer Calf Weight                                550 lbs
                        Investment Rate                                            2.75 %                Heifer Calf Market Price                    $210.00/cwt
                        For more information on leases,  Manitoba Agriculutre and Resource Development Contracts and Leases
                        A.  Operating Costs                                                                        Owner               Leasee                         Total Cost
                            1.  Feed Costs
                                1.01   Grain and Concentrates                                                        $0.00            $102.23                             $102.23
                                1.02   Forages                                                                       $0.00            $317.42                             $317.42
                                1.03   Salt & Minerals                                                               $0.00              $32.45                              $32.45
                                1.04   Extended Grazing Forages                                                      $0.00              $41.52                              $41.52
                            Total Feed Cost                                                                          $0.00            $493.62                             $493.62
                            2.  Other Operating Costs
                                2.01   Straw                                                                         $0.00              $60.00                              $60.00
                                2.02   Veterinary Medicine & Supplies                                                $0.00              $21.79                              $21.79
                                2.03   Bull Operating Costs                                                          $0.00              $42.13                              $42.13
                                2.04   Fuel, Maintenance & Repairs                                                   $0.00              $32.92                              $32.92
                                2.05   Utilities                                                                     $0.00                $9.20                               $9.20
                                2.06   Marketing & Transportation                                                    $0.00              $35.88                              $35.88
                                2.07   Death Loss                                                                  $19.69                                                   $19.69
                                2.08   Manure Removal                                                                $0.00                $7.23                               $7.23
                                2.09   Insurance                                                                     $7.09                $4.33                             $11.42
                                2.10   Herd Replacement - Cows                                                     $81.54                                                   $81.54
                                2.11   Herd Replacement - Bulls                             Owner                  $17.08                 $0.00                             $17.08
                                2.12   Pasture Rental                                                                $0.00              $56.09                              $56.09
                                2.13   Pasture Operating                                                             $0.00              $33.10                              $33.10
                                2.13   Miscellaneous                                                                 $0.00                $3.33                               $3.33
                            Subtotal Operating Costs                                                             $125.40              $799.62                             $925.02
                                2.14   Operating Interest                                                            $3.13              $19.99                              $23.13
                            Total Operating Costs                                                                $128.53              $819.61                             $948.14
                        B.  Fixed Costs
                            3.  Depreciation
                                3.01   Livestock                                                                   $40.46                                                   $40.46
                                3.02   Buildings                                                                                        $21.49                              $21.49
                                3.03   Machinery & Equipment                                                                            $81.92                              $81.92
                                3.04   Pasture Land & Fencing                                                                           $34.74                              $34.74
                            Total Fixed Costs                                                                      $40.46             $138.15                             $178.61
                            Total Operating and Fixed Costs                                                      $168.99              $957.76                          $1,126.75
                        C.  Labour                                                                                   $0.00            $200.00                             $200.00
                        Total Contributions                                                                      $168.99           $1,157.76                           $1,326.75
                        Total Contributions                                                                         12.7%                87.3%
                                                                                                                                                          Manitoba Agriculture, Farm Management
                                                 Estimated Farmgate Revenue
                 Estimated Farmgate                                                                                 Per Cow
                   Price (weighted average $ per cwt)                                                                $217.83
                   Calf weight - average (lbs)                                                                           575 
                   Gross Revenue  / cow                                                                            $1,189.90
                                                 Lease Calculation #1 - Share Split Method
                                                                               Owner         Leasee
                 Share Split                                                    12.7%         87.3%
                 Share of Revenue                                             $151.12     $1,038.78
                 Net Return Per Cow                                          ($17.88)      ($118.98)
                 Cash Rental Per Cow                                         $168.99 
                 Return to Assets (ROA)                                          1.3%
                                                 Lease Calculation #2 - Flexible Share Calculation Method
                                                                               Owner         Leasee                     Total
                 Contribution Share                                           $168.99     $1,157.76                $1,326.75
                 Remaining Revenue                                                                                  -$136.86
                 Distribution of Surplus Revenue                                  50%           50%
                 Share of Surplus Revenue                                     -$68.43        -$68.43
                 Total Revenue Earned                                         $100.56     $1,089.33                $1,189.90
                 Percent Share of Revenue (Total)                                8.5%         91.5%
                 Net Return Per Cow                                          ($68.43)       ($68.43)
                 Cash Rental Per Cow                                         $168.99 
                 Return to Assets (ROA)                                         -1.6%
                   Note: This budget is only a guide and is not intended to be an in-depth study of the cost of production of this industry. 
                   Interpretation and utilization of this information is the responsibility of the user. No liability for decisions based on this 
                   publication is assumed. 
                 Created and maintained by    Manitoba Agriculture and Resource Development  Farm Management          September, 2021
                 For more information, contact your local  Manitoba Agriculture and Resource Developoment Office or:
                 Benjamin Hamm                                 Greg Fedak                            Roy Arnott
                 Farm Management Specialist                    Farm Management Specialist            Farm Management Specialist         
                                                                                                          Manitoba Agriculture, Farm Management
The words contained in this file might help you see if this file matches what you are looking for:

...Cowshare lease calculator printed enter changes to values in blue only cow market value hd bull average weight lbs cows per death loss replacement rate cull price cwt calf crop steer heifer operating interest investment for more information on leases manitoba agriculutre and resource development contracts a costs owner leasee total cost feed grain concentrates forages salt minerals extended grazing other straw veterinary medicine supplies fuel maintenance repairs utilities marketing transportation manure removal insurance herd bulls pasture rental miscellaneous subtotal b fixed depreciation livestock buildings machinery equipment land fencing c labour contributions agriculture farm management estimated farmgate revenue weighted gross calculation share split method of net return cash assets roa flexible contribution remaining distribution surplus...

no reviews yet
Please Login to review.