2022 excel farmland rent calculator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1														Part A			Part B	Part (A+B)
2											Fair Rent ?			Farmland			Farmland	Combined
3											at			Revenue			Revenue	Farmland & Bins
4											25.0000%			50%			50%	Revenue
5	rent	rent			2021						of Farmland			A			B	2022
6	to	from			Cultivated	Roll					Revenue	wheat	bushels grown	60	canola	bushels grown	50	50/50
7			No.	Land Name	Acres	Number					(A+B) x 25%	price per bushel	per acre	10.00	price per bushel	per acre	20.00	Value
8	randy	johnny	1	Pete's	89.35	120800	NW	14	37	26	17,870.00	10.00	60.00	26,805.00	20.00	50.00	44,675.00	71,480.00
9	randy	johnny	2	Albert's	124.47	121100	NE	15	37	26	24,894.00	10.00	60.00	37,341.00	20.00	50.00	62,235.00	99,576.00
10	randy	johnny	3	Eisner's	104.91	124600	NE	23	37	26	20,982.00	10.00	60.00	31,473.00	20.00	50.00	52,455.00	83,928.00
11	randy	johnny	4	Slavic's	142.20	124700	NW	23	37	26	28,440.00	10.00	60.00	42,660.00	20.00	50.00	71,100.00	113,760.00
12	randy	johnny	5	East Hill's	137.13	164200	SW	1	38	26	27,426.00	10.00	60.00	41,139.00	20.00	50.00	68,565.00	109,704.00
13	randy	johnny	6	North Hill's	81.33	164500	NE	2	38	26	16,266.00	10.00	60.00	24,399.00	20.00	50.00	40,665.00	65,064.00
14	randy	johnny	7	South Hill's	128.00	164700	SE	2	38	26	25,600.00	10.00	60.00	38,400.00	20.00	50.00	64,000.00	102,400.00
15	randy	johnny	8	Mark's	151.62	164900	SW	2	38	26	30,324.00	10.00	60.00	45,486.00	20.00	50.00	75,810.00	121,296.00
16					959.01						191,802.00			287,703.00			479,505.00	767,208.00
17
18
19	randy	randy hart	5	Pete's on Randys	28.7	120800	NW	14	37	26	5,740.00	10.00	60.00	8,610.00	20.00	50.00	14,350.00	22,960.00
20	randy	randy hart	5	Pete's on Georges	3.43	120800	NW	14	37	26	686.00	10.00	60.00	1,029.00	20.00	50.00	1,715.00	2,744.00
21	randy	randy hart	8	Eisner's on Randys	10.41	124600	NE	23	37	26	2,082.00	10.00	60.00	3,123.00	20.00	50.00	5,205.00	8,328.00
22					42.540
23
24	dev	randy hart	1	Watson	153.46	82600	NW	24	36	27	30,692.00	10.00	60.00	46,038.00	20.00	50.00	76,730.00	122,768.00
25	dev	randy hart	2	Rambow	128.15	82800	SW	24	36	27	25,630.00	10.00	60.00	38,445.00	20.00	50.00	64,075.00	102,520.00
26					281.610
27
28	hold	randy hart	14	Gault's	160	115500	NW	2	37	26	32,000.00	10.00	60.00	48,000.00	20.00	50.00	80,000.00	128,000.00
29	hold	randy hart	16	Hollands North	160	119500	NW	11	37	26	32,000.00	10.00	60.00	48,000.00	20.00	50.00	80,000.00	128,000.00
30	hold	randy hart	17	Hollands South	160	119700	SW	11	37	26	32,000.00	10.00	60.00	48,000.00	20.00	50.00	80,000.00	128,000.00
31					480.000
32
33	hold	brad fothergill	22	Arts	152.85	123000	NW	19	37	26	30,570.00	10.00	60.00	45,855.00	20.00	50.00	76,425.00	122,280.00
34
35	hold	colin hart	15	The 35 acres	28.774	119300	SW	10	37	26	5,754.87	10.00	60.00	8,632.31	20.00	50.00	14,387.18	23,019.48
36	hold	colin hart	18	George's	140.820	121000	SW	14	37	26	28,164.00	10.00	60.00	42,246.00	20.00	50.00	70,410.00	112,656.00
37	hold	colin hart	5	Pete's on Georges	3.43	120800	NW	14	37	26	686.00	10.00	60.00	1,029.00	20.00	50.00	1,715.00	2,744.00
38	hold	colin hart	20	McAuley's	6.830	121300	SE	15	37	26	1,366.00	10.00	60.00	2,049.00	20.00	50.00	3,415.00	5,464.00
39					179.854
40
41	hold	johnny	19	McAuley's	84.94	121300	SE	15	37	26	16,988.00	10.00	60.00	25,482.00	20.00	50.00	42,470.00	67,952.00
42	hold	johnny	21	Charles	150.55	121400	SW	15	37	26	30,110.00	10.00	60.00	45,165.00	20.00	50.00	75,275.00	120,440.00
43					235.490
44
45	hold	lyle marchuk	23	North Farm	148	175500	NW	26	38	26	29,600.00	10.00	60.00	44,400.00	20.00	50.00	74,000.00	118,400.00
46
47	jim	colin hart	24	Home Quarter	123.25	118900	NE	10	37	26	24,650.00	10.00	60.00	36,975.00	20.00	50.00	61,625.00	98,600.00
48
49					2602.604						520,520.87		Part A	780,781.31		Part B	1,301,302.18	2,082,083.48
50																Part (A+B)	2,082,083.48	TOTAL
51														200			520,520.87	0.25
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
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