IRSIK AND DOLL COMPANY
Replace the existing data in the yellow cells with your own
Please note: while it is not necessary to use $ when entering dollar values  the date does need to be enter with /
DATE IN: MM/DD/YY INTEREST RATE CATTLE  (%)
PURCHASE WEIGHT INTEREST RATE FEED (%)
GROW LOT OR PASTURE FEED YARD
DAYS ON FEED   DAYS ON FEED
ADG    ADG    Please enter sale price for this animal and re-calculate
 COST VET & MED /HD $ COST VET & MED /HD $   WEIGHING
COST PROCESSING /HD $ COST PROCESSING /HD $ ON THIS DATE
DEATH LOSS % DEATH LOSS %  EXPECTED SALE PRICE
COST OF GAIN / CWT COST OF GAIN / CWT
Projected Date Out: Projected Date Out: ANIMAL WEIGHING
 Projected Weight OUT  Projected Weight OUT BREAKEVEN PURCHASE PRICE CWT
While much effort and research was put into the building of this calculator, actual costs may vary  as a result of, but not limited to, death loss, feeding conditions, or general health and condition of your livestock
Copyright 2002 John R. Martin / Phoenix Engineering LLC
HOME
Constant Test Below - Review and erase from form for final

 Ans01.value=(1)-((ABS(Que09.Value))*(.7275)/(100))        deathloss factor phase I
Ans02.value=(1)-((ABS(Que16.Value))*(.7275)/(100))        deathloss factor phase II
Ans03.Value=(ABS(Que05.value))*(ABS(Que06.Value))      total lbs gained phaseI
Ans04.Value=(((ABS(Ans03.Value))*(ABS(Que10.Value)))/100)+(ABS(Que07.Value))+(ABS(Que08.Value))  feed cost med procc  phase I
Ans05.Value=(ABS(Que12.value))*(ABS(Que13.Value))         total lbs gained phaseII
Ans06.Value=(((ABS(Ans05.Value))*(ABS(Que17.Value)))/100)+(ABS(Que14.Value))+(ABS(Que15.Value))  feed cost med procc phase II
Ans07.Value=((ABS(Ans04.Value))*(ABS(Que02.Value))/(365)*(ABS(Que05.Value)))/100/2  int for feed phase I
Ans08.Value=((ABS(Ans06.Value))*(ABS(Que02.Value))/(365)*(ABS(Que12.Value)))/100/2  int for feed phaseII
Ans11.Value=((ABS(Ans33.Value))*(ABS(Ans02.Value)))*(ABS(Ans01.Value))  factored out weight by deathloss
Ans12.Value=(ABS(Ans04.Value))+(ABS(Ans06.Value))+(ABS(Ans08.Value))+(ABS(Ans07.value)) grand total feeding cost includeing int
Ans13.Value=(ABS(Ans11.value))*(ABS(Que18.Value))/100   sale price
Ans14.Value=(ABS(Ans13.Value))-(ABS(Ans12.Value))   value less feed cost
Ans15.value=(ABS(Ans14.Value))/(ABS(Que03.Value))  first cost breakeven before int
Ans16.Value=(ABS(Que01.Value))*(ABS(Ans14.Value))/(365)/100  cattle int per hd per day
Ans17.Value=((ABS(Que05.Value))+(ABS(Que12.Value)))*(ABS(Ans16.Value))  total int for animal
Ans18.Value=((ABS(Ans14.Value))-(ABS(Ans17.Value)))/(ABS(Que03.Value))*100