Insurance Operation Analysis - Excel by mjs17436

VIEWS: 7 PAGES: 21

Insurance Operation Analysis document sample

More Info
									    Livestock Risk Protection Analysis for both            Feeder Cattle
                                                           & Fed Cattle
STOCKER CATTLE OPERATION                    DAYS ON FEED
PURCHASE PRICE    $110.50                        120
PURCHASE WEIGHT       450     Per Head                      Per Load
COST PER HEAD        497.25       $497.25                      $29,337.75
NO/HEAD                  59
CASH COSTS/PERHEAD
PROCUREMENT                         $2.00                        $118.00
VET/MEDICINE                       $12.00                        $708.00
FLY/LICE                            $2.00                        $118.00
SALT/MIN/ETC 30LBS                  $5.00                        $295.00
FENCE/FACILITY                      $0.00                          $0.00
EQUIPMENT                           $2.00                        $118.00
FUEL                                $2.00                        $118.00
REPAIRS                             $0.00                          $0.00
PAST/RENT
         AC/HEAD          1
         $/ACRE    $   7.50        $30.00                       $1,770.00
PASTURE MAINTENANCE
         $/ACRE                     $0.00                           $0.00
FEED COSTS
CORN SIL LBS/DAY          2
         TONS/HD       0.12
         $/TON     $ 25.00          $3.00                        $177.00
HAY      LBS/DAY          2
         TONS/HD       0.12
         $/TON     $ 25.00          $3.00                        $177.00
CORN     LBS/DAY $    1.00
         TONS/HD       0.06
         $/TON                      $0.00                           $0.00
PROTEIN LBS/DAY       1.00
         TONS/HD       0.06
         $/TON     $  1.00          $0.06                           $3.54
OTHER    LBS/DAY          1
         TONS/HD       0.06
         $/TON     $  1.00          $0.06                           $3.54
LABOR    DAILY            1
         HRS./HD       2.03
         $/HRS     $  5.00        $10.17                          $600.00
INSURANCE ($/cwt) $ 90.00        $447.53                       $26,403.98
MISC                               $8.00                          $472.00
OTHER                              $8.00                          $472.00
PROD/COSTS                  $1,032.06           $60,891.81
MKTG/HAUL                      $17.50            $1,032.50
INTEREST RATE         6%
         CASH               $1,049.56
         INT/HD                $20.70            $1,221.52
TOTAL COSTS                 $1,070.27           $63,145.83
PLANNED PROFIT/HD $   -         $0.00                $0.00
DEATH $       2% PER/HD        $21.41            $1,262.92
BREAK-EVEN
        GAIN          250                ##
        SALE WT       700                ##
$/LBS.     102.75
                              $719.25    ##    $42,435.75
PROF/HD                      ($372.42)   ##   ($21,972.99)
B/E $                           $1.56
BEEFBREAK

FILL IN THE SHADED
BOXES WITH YOUR OWN
INFORMATION.

COMPLETE THE FORM
ON SEVERAL PAGES
FOR COMPARISON
SCENARIOS THAT MAY
INCLUDE DIFFERENT
FEED OR PERFORMANCE
OPTIONS.

CONSIDER BREAKING
THE WINTERING APART
FROM THE GRASS FOR
BETTER COMPARISON.

YOUR COMPARISONS
CAN BE VIEWED ON
THE NINTH PAGE
NAMED "COMPARISON"




TOT/FEED
 $361.08
STOCKER CATTLE OPERATION                    DAYS ON FEED
PURCHASE PRICE    $110.50                        120
PURCHASE WEIGHT       450     Per Head                     Per Load
COST PER HEAD          497.25     $497.25                     $29,337.75
NO/HEAD                    59
CASH COSTS/PERHEAD
PROCUREMENT                         $2.00                       $118.00
VET/MEDICINE                       $12.00                       $708.00
FLY/LICE                            $2.00                       $118.00
SALT/MIN/ETC 30LBS                  $5.00                       $295.00
FENCE/FACILITY                      $0.00                         $0.00
EQUIPMENT                           $2.00                       $118.00
FUEL                                $2.00                       $118.00
REPAIRS                             $0.00                         $0.00
PAST/RENT
         AC/HEAD            1
         $/ACRE    $     7.50      $30.00                      $1,770.00
PASTURE MAINTENANCE
         $/ACRE                     $0.00                          $0.00
FEED COSTS
CORN SIL LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
HAY      LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
CORN     LBS/DAY $      1.00
         TONS/HD         0.06
         $/TON                      $0.00                          $0.00
PROTEIN LBS/DAY         1.00
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
OTHER    LBS/DAY            1
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
LABOR    DAILY              1
         HRS./HD         2.03
         $/HRS     $    5.00       $10.17                        $600.00
INSURANCE ($/cwt) $    90.00      $447.53                     $26,403.98
MISC                                $8.00                        $472.00
OTHER                               $8.00                        $472.00
PROD/COSTS                      $1,032.06                     $60,891.81
MKTG/HAUL                          $17.50                      $1,032.50
INTEREST RATE             6%
        CASH                $1,049.56
        INT/HD                 $20.70            $1,221.52
TOTAL COSTS                 $1,070.27           $63,145.83
PLANNED PROFIT/HD $   -         $0.00                $0.00
DEATH $       2% PER/HD        $21.41            $1,262.92
BREAK-EVEN
        GAIN          250                ##
        SALE WT       700                ##
$/LBS.     102.75
                              $719.25    ##    $42,435.75
PROF/HD                      ($372.42)   ##   ($21,972.99)
B/E $                           $1.56
BEEFBREAK

FILL IN THE SHADED
BOXES WITH YOUR OWN
INFORMATION.

COMPLETE THE FORM
ON SEVERAL PAGES
FOR COMPARISON
SCENARIOS THAT MAY
INCLUDE DIFFERENT
FEED OR PERFORMANCE
OPTIONS.

CONSIDER BREAKING
THE WINTERING APART
FROM THE GRASS FOR
BETTER COMPARISON.

YOUR COMPARISONS
CAN BE VIEWED ON
THE NINTH PAGE
NAMED "COMPARISON"




TOT/FEED
 $361.08
STOCKER CATTLE OPERATION                    DAYS ON FEED
PURCHASE PRICE    $110.50                        120
PURCHASE WEIGHT       450     Per Head                     Per Load
COST PER HEAD          497.25     $497.25                     $29,337.75
NO/HEAD                    59
CASH COSTS/PERHEAD
PROCUREMENT                         $2.00                       $118.00
VET/MEDICINE                       $12.00                       $708.00
FLY/LICE                            $2.00                       $118.00
SALT/MIN/ETC 30LBS                  $5.00                       $295.00
FENCE/FACILITY                      $0.00                         $0.00
EQUIPMENT                           $2.00                       $118.00
FUEL                                $2.00                       $118.00
REPAIRS                             $0.00                         $0.00
PAST/RENT
         AC/HEAD            1
         $/ACRE    $     7.50      $30.00                      $1,770.00
PASTURE MAINTENANCE
         $/ACRE                     $0.00                          $0.00
FEED COSTS
CORN SIL LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
HAY      LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
CORN     LBS/DAY $      1.00
         TONS/HD         0.06
         $/TON                      $0.00                          $0.00
PROTEIN LBS/DAY         1.00
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
OTHER    LBS/DAY            1
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
LABOR    DAILY              1
         HRS./HD         2.03
         $/HRS     $    5.00       $10.17                        $600.00
INSURANCE ($/cwt) $    90.00      $447.53                     $26,403.98
MISC                                $8.00                        $472.00
OTHER                               $8.00                        $472.00
PROD/COSTS                      $1,032.06                     $60,891.81
MKTG/HAUL                          $17.50                      $1,032.50
INTEREST RATE             6%
        CASH                $1,049.56
        INT/HD                 $20.70            $1,221.52
TOTAL COSTS                 $1,070.27           $63,145.83
PLANNED PROFIT/HD $   -         $0.00                $0.00
DEATH $       2% PER/HD        $21.41            $1,262.92
BREAK-EVEN
        GAIN          250                ##
        SALE WT       700                ##
$/LBS.     102.75
                              $719.25    ##    $42,435.75
PROF/HD                      ($372.42)   ##   ($21,972.99)
B/E $                           $1.56
BEEFBREAK

FILL IN THE SHADED
BOXES WITH YOUR OWN
INFORMATION.

COMPLETE THE FORM
ON SEVERAL PAGES
FOR COMPARISON
SCENARIOS THAT MAY
INCLUDE DIFFERENT
FEED OR PERFORMANCE
OPTIONS.

CONSIDER BREAKING
THE WINTERING APART
FROM THE GRASS FOR
BETTER COMPARISON.

YOUR COMPARISONS
CAN BE VIEWED ON
THE NINTH PAGE
NAMED "COMPARISON"




TOT/FEED
 $361.08
STOCKER CATTLE OPERATION                    DAYS ON FEED
PURCHASE PRICE    $110.50                        120
PURCHASE WEIGHT       450     Per Head                     Per Load
COST PER HEAD          497.25     $497.25                     $29,337.75
NO/HEAD                    59
CASH COSTS/PERHEAD
PROCUREMENT                         $2.00                       $118.00
VET/MEDICINE                       $12.00                       $708.00
FLY/LICE                            $2.00                       $118.00
SALT/MIN/ETC 30LBS                  $5.00                       $295.00
FENCE/FACILITY                      $0.00                         $0.00
EQUIPMENT                           $2.00                       $118.00
FUEL                                $2.00                       $118.00
REPAIRS                             $0.00                         $0.00
PAST/RENT
         AC/HEAD            1
         $/ACRE    $     7.50      $30.00                      $1,770.00
PASTURE MAINTENANCE
         $/ACRE                     $0.00                          $0.00
FEED COSTS
CORN SIL LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
HAY      LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
CORN     LBS/DAY $      1.00
         TONS/HD         0.06
         $/TON                      $0.00                          $0.00
PROTEIN LBS/DAY         1.00
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
OTHER    LBS/DAY            1
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
LABOR    DAILY              1
         HRS./HD         2.03
         $/HRS     $    5.00       $10.17                        $600.00
INSURANCE ($/cwt) $    90.00      $447.53                     $26,403.98
MISC                                $8.00                        $472.00
OTHER                               $8.00                        $472.00
PROD/COSTS                      $1,032.06                     $60,891.81
MKTG/HAUL                          $17.50                      $1,032.50
INTEREST RATE             6%
        CASH                $1,049.56
        INT/HD                 $20.70            $1,221.52
TOTAL COSTS                 $1,070.27           $63,145.83
PLANNED PROFIT/HD $   -         $0.00                $0.00
DEATH $       2% PER/HD        $21.41            $1,262.92
BREAK-EVEN
        GAIN          250                ##
        SALE WT       700                ##
$/LBS.     102.75
                              $719.25    ##    $42,435.75
PROF/HD                      ($372.42)   ##   ($21,972.99)
B/E $                           $1.56
BEEFBREAK

FILL IN THE SHADED
BOXES WITH YOUR OWN
INFORMATION.

COMPLETE THE FORM
ON SEVERAL PAGES
FOR COMPARISON
SCENARIOS THAT MAY
INCLUDE DIFFERENT
FEED OR PERFORMANCE
OPTIONS.

CONSIDER BREAKING
THE WINTERING APART
FROM THE GRASS FOR
BETTER COMPARISON.

YOUR COMPARISONS
CAN BE VIEWED ON
THE NINTH PAGE
NAMED "COMPARISON"




TOT/FEED
 $361.08
STOCKER CATTLE OPERATION                    DAYS ON FEED
PURCHASE PRICE    $110.50                        120
PURCHASE WEIGHT       450     Per Head                     Per Load
COST PER HEAD          497.25     $497.25                     $29,337.75
NO/HEAD                    59
CASH COSTS/PERHEAD
PROCUREMENT                         $2.00                       $118.00
VET/MEDICINE                       $12.00                       $708.00
FLY/LICE                            $2.00                       $118.00
SALT/MIN/ETC 30LBS                  $5.00                       $295.00
FENCE/FACILITY                      $0.00                         $0.00
EQUIPMENT                           $2.00                       $118.00
FUEL                                $2.00                       $118.00
REPAIRS                             $0.00                         $0.00
PAST/RENT
         AC/HEAD            1
         $/ACRE    $     7.50      $30.00                      $1,770.00
PASTURE MAINTENANCE
         $/ACRE                     $0.00                          $0.00
FEED COSTS
CORN SIL LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
HAY      LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
CORN     LBS/DAY $      1.00
         TONS/HD         0.06
         $/TON                      $0.00                          $0.00
PROTEIN LBS/DAY         1.00
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
OTHER    LBS/DAY            1
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
LABOR    DAILY              1
         HRS./HD         2.03
         $/HRS     $    5.00       $10.17                        $600.00
INSURANCE ($/cwt) $    90.00      $447.53                     $26,403.98
MISC                                $8.00                        $472.00
OTHER                               $8.00                        $472.00
PROD/COSTS                      $1,032.06                     $60,891.81
MKTG/HAUL                          $17.50                      $1,032.50
INTEREST RATE             6%
        CASH                $1,049.56
        INT/HD                 $20.70            $1,221.52
TOTAL COSTS                 $1,070.27           $63,145.83
PLANNED PROFIT/HD $   -         $0.00                $0.00
DEATH $       2% PER/HD        $21.41            $1,262.92
BREAK-EVEN
        GAIN          250                ##
        SALE WT       700                ##
$/LBS.     102.75
                              $719.25    ##    $42,435.75
PROF/HD                      ($372.42)   ##   ($21,972.99)
B/E $                           $1.56
BEEFBREAK

FILL IN THE SHADED
BOXES WITH YOUR OWN
INFORMATION.

COMPLETE THE FORM
ON SEVERAL PAGES
FOR COMPARISON
SCENARIOS THAT MAY
INCLUDE DIFFERENT
FEED OR PERFORMANCE
OPTIONS.

CONSIDER BREAKING
THE WINTERING APART
FROM THE GRASS FOR
BETTER COMPARISON.

YOUR COMPARISONS
CAN BE VIEWED ON
THE NINTH PAGE
NAMED "COMPARISON"




TOT/FEED
 $361.08
STOCKER CATTLE OPERATION                    DAYS ON FEED
PURCHASE PRICE    $110.50                        120
PURCHASE WEIGHT       450     Per Head                     Per Load
COST PER HEAD          497.25     $497.25                     $29,337.75
NO/HEAD                    59
CASH COSTS/PERHEAD
PROCUREMENT                         $2.00                       $118.00
VET/MEDICINE                       $12.00                       $708.00
FLY/LICE                            $2.00                       $118.00
SALT/MIN/ETC 30LBS                  $5.00                       $295.00
FENCE/FACILITY                      $0.00                         $0.00
EQUIPMENT                           $2.00                       $118.00
FUEL                                $2.00                       $118.00
REPAIRS                             $0.00                         $0.00
PAST/RENT
         AC/HEAD            1
         $/ACRE    $     7.50      $30.00                      $1,770.00
PASTURE MAINTENANCE
         $/ACRE                     $0.00                          $0.00
FEED COSTS
CORN SIL LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
HAY      LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
CORN     LBS/DAY $      1.00
         TONS/HD         0.06
         $/TON                      $0.00                          $0.00
PROTEIN LBS/DAY         1.00
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
OTHER    LBS/DAY            1
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
LABOR    DAILY              1
         HRS./HD         2.03
         $/HRS     $    5.00       $10.17                        $600.00
INSURANCE ($/cwt) $    90.00      $447.53                     $26,403.98
MISC                                $8.00                        $472.00
OTHER                               $8.00                        $472.00
PROD/COSTS                      $1,032.06                     $60,891.81
MKTG/HAUL                          $17.50                      $1,032.50
INTEREST RATE             6%
        CASH                $1,049.56
        INT/HD                 $20.70            $1,221.52
TOTAL COSTS                 $1,070.27           $63,145.83
PLANNED PROFIT/HD $   -         $0.00                $0.00
DEATH $       2% PER/HD        $21.41            $1,262.92
BREAK-EVEN
        GAIN          250                ##
        SALE WT       700                ##
$/LBS.     102.75
                              $719.25    ##    $42,435.75
PROF/HD                      ($372.42)   ##   ($21,972.99)
B/E $                           $1.56
BEEFBREAK

FILL IN THE SHADED
BOXES WITH YOUR OWN
INFORMATION.

COMPLETE THE FORM
ON SEVERAL PAGES
FOR COMPARISON
SCENARIOS THAT MAY
INCLUDE DIFFERENT
FEED OR PERFORMANCE
OPTIONS.

CONSIDER BREAKING
THE WINTERING APART
FROM THE GRASS FOR
BETTER COMPARISON.

YOUR COMPARISONS
CAN BE VIEWED ON
THE NINTH PAGE
NAMED "COMPARISON"




TOT/FEED
 $361.08
STOCKER CATTLE OPERATION                    DAYS ON FEED
PURCHASE PRICE    $110.50                        120
PURCHASE WEIGHT       450     Per Head                     Per Load
COST PER HEAD          497.25     $497.25                     $29,337.75
NO/HEAD                    59
CASH COSTS/PERHEAD
PROCUREMENT                         $2.00                       $118.00
VET/MEDICINE                       $12.00                       $708.00
FLY/LICE                            $2.00                       $118.00
SALT/MIN/ETC 30LBS                  $5.00                       $295.00
FENCE/FACILITY                      $0.00                         $0.00
EQUIPMENT                           $2.00                       $118.00
FUEL                                $2.00                       $118.00
REPAIRS                             $0.00                         $0.00
PAST/RENT
         AC/HEAD            1
         $/ACRE    $     7.50      $30.00                      $1,770.00
PASTURE MAINTENANCE
         $/ACRE                     $0.00                          $0.00
FEED COSTS
CORN SIL LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
HAY      LBS/DAY            2
         TONS/HD         0.12
         $/TON     $   25.00        $3.00                       $177.00
CORN     LBS/DAY $      1.00
         TONS/HD         0.06
         $/TON                      $0.00                          $0.00
PROTEIN LBS/DAY         1.00
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
OTHER    LBS/DAY            1
         TONS/HD         0.06
         $/TON     $    1.00        $0.06                          $3.54
LABOR    DAILY              1
         HRS./HD         2.03
         $/HRS     $    5.00       $10.17                        $600.00
INSURANCE ($/cwt) $    90.00      $447.53                     $26,403.98
MISC                                $8.00                        $472.00
OTHER                               $8.00                        $472.00
PROD/COSTS                      $1,032.06                     $60,891.81
MKTG/HAUL                          $17.50                      $1,032.50
INTEREST RATE             6%
        CASH                $1,049.56
        INT/HD                 $20.70            $1,221.52
TOTAL COSTS                 $1,070.27           $63,145.83
PLANNED PROFIT/HD $   -         $0.00                $0.00
DEATH $       2% PER/HD        $21.41            $1,262.92
BREAK-EVEN
        GAIN          250                ##
        SALE WT       700                ##
$/LBS.     102.75
                              $719.25    ##    $42,435.75
PROF/HD                      ($372.42)   ##   ($21,972.99)
B/E $                           $1.56
BEEFBREAK

FILL IN THE SHADED
BOXES WITH YOUR OWN
INFORMATION.

COMPLETE THE FORM
ON SEVERAL PAGES
FOR COMPARISON
SCENARIOS THAT MAY
INCLUDE DIFFERENT
FEED OR PERFORMANCE
OPTIONS.

CONSIDER BREAKING
THE WINTERING APART
FROM THE GRASS FOR
BETTER COMPARISON.

YOUR COMPARISONS
CAN BE VIEWED ON
THE NINTH PAGE
NAMED "COMPARISON"




TOT/FEED
 $361.08

								
To top