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
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
