AgPro Feedlot Profit Calculator.xls

	A	B	C	D	E
1	Please Enter the Data in Yellow cells
2
3	Mob Size	500	500	500
4	Intitial Weight (kg)	40	40	40
5	Entry value pre feedlot ($/kg)	$ 3.50	$ 3.50	$ 3.50
6	Entry Value pre feedlot ($/hd)	$ 140.00	$ 140.00	$ 140.00	Enter data or value above
7	End Weight (kg)	50	50	50
8	Feed Intake (%of BWT)	3.5%	3.5%	3.5%	Estimated Average
9	Energy of feed	11.0	11.0	11.0	Estimated Average
10	Dressing %	45%	45%	45%
11	Price Expected or Paid	7.5	7.8	8
12	Feed Cost	300	300	300
13	Wool Weight	2	2	2	Enter if shearing
14	Wool Value	5	5	5	Enter if shearing
15	Shearing Cost	7.5	7.5	7.5	Enter if shearing
16	Extra feed costs / week	0.3	0.3	0.3
17	Drench	0.5	0.5	0.5
18	Vaccine	0.3	0.3	0.3
19	Interest Rate %	4%	4%	4%
20	Death %	2%	2%	2%
21	Labour$ Per Hour	35	35	35
22	Days	40	40	40	calculated on growth rates
23	Commission	5%	5%	5%
24	Freight	0.00	0.00	0.00
25
26	Stats
27
28	Feed Eaten (kg)	1.6	1.6	1.6
29	Maintenance (mj)	6.0	6.0	6.0
30	Energy Intake	17.3	17.3	17.3
31	Energy for BWT	11.3	11.3	11.3
32	BWT Added per day	0.252	0.252	0.252
33	Days on feed	40	40	40
34	Food Eaten	63	63	63
35	Total Feed	31	31	31
36
37		A	B	C
38	Intitial Weight	40	40	40
39	Initial Carcass Weight	18.00	18.00	18.00
40	Value pre feedlot	$140.00	$140.00	$140.00
41	End Weight	50	50	50
42	Weight Added	10	10	10
43	Weight gain per Day	0.252	0.252	0.252
44	Feed Eaten	63	63	63
45	Feed Conversion	6	6	6
46	Dressing %age	45%	45%	45%
47	Price Paid	$7.50	$7.80	$8.00
48	Feed Cost $/T	$300	$300	$300
49	Drenched	$0.50	$0.50	$0.50
50	Vaccination	$0.30	$0.30	$0.30
51
52		A	B	C
53	On Farm Carcass Value	$161.75	$168.50	$173.00
54
55	Direct Costs
56	Cost of store	$133.00	$133.00	$133.00
57	Cost of Feed	$18.77	$18.77	$18.77
58	Hay / Straw / Additives	$1.70	$1.70	$1.70
59	Drench and Vaccine	$0.80	$0.80	$0.80
60	Profit after Direct Costs	$7.47	$14.22	$18.72
61
62	Hidden
63	Extra Commission	$1.15	$1.42	$1.60
64	Labour	$2.78	$2.78	$2.78
65	Interest From Delayed Sale	$0.30	$0.30	$0.30
66	Interest on Feed Costs	$0.03	$0.03	$0.03
67	Cost of Deaths	$0.61	$0.61	$0.61
68
69	Profit / Loss From Feedlot	$2.63	$9.11	$13.43
70	On Farm Price to Break Even	$135.59	$142.07	$146.39
71	Cost/kg dressed weight added	$5.81	$5.87	$5.91
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100