{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Menu","Calculator","Tables","Factsheets"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["This is a farm business decision calculator that has 3 worksheets. There are fields that can be completed by the user. It is up to 24 columns wide and 373 rows."]
["Welcome to the Machinery Cost Calculator Menu Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The Machinery Cost Calculator contains a machinery cost calculator, cost charts, "]
["and a factsheet on machinery budgeting."]
[]
["Developed by John Molenhuis"]
["Business Analysis and Cost of Production Specialist"]
["OMAFA, Brighton"]
["email: john.molenhuis@ontario.ca"]
[]
["Revised June 2025"]
["End of worksheet"]

{"sheet":"Calculator","index":1,"n_rows":97,"n_cols":44,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Machinery Cost Calculator"]
[null,"Numbers/text in blue, yellow shaded areas can be edited/changed"]
[null,"GENERAL PARAMETERS"]
[null,"Annual interest rate ***",0.05,"Fuel cost per litre",1.35]
[null,"Insurance and housing rate (% of purchase price)",0.01,"Fuel consumption - litres/engine hp.hr",0.192,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2WD tractor","2WD tractors",null,null,"2WD tractors"]
[null,null,null,"Operator labour (self or hired) rate per hour",27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Front wheel assist tractor","FWA tractors",null,null,"FWA tractors"]
[null,null,null,"Return to management, administration costs",0.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4WD tractor","4WD tractors",null,null,"4WD tractors"]
[null,"POWER UNIT (TRACTOR OR SELF-PROPELLED (SP) MACHINE)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tracked tractor","Self Propelled combines",null,null,"Self Propelled combines"]
[null,"Rated engine horsepower",375,"SP Rotary combine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP Rotary combine","Self propelled high clearance sprayer",null,null,"Self propelled high clearance sprayer"]
[null,"Life (years)",{"$f":"IF(D10<>\"\",VLOOKUP(D10,DeprRep,3,FALSE),0)","v":12},"Purchase price",740000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP Swather","Self propelled forage harvesters",null,null,"Self propelled forage harvesters"]
[null,"Acres/year",{"$f":"C15*E12","v":2550},"Hours per year",{"$f":"IF(D10<>\"\",VLOOKUP(D10,DeprRep,2,FALSE),0)","v":250},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP Forage harvester","Depreciation"]
[null,null,null,"Fuel Used - litres/hour  (see Table 5)",{"$f":"C10*E6","v":72},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP Forage harvester header","Trade in value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP Mower/conditioner","Repairs",3.3000000000000003]
[null,"Work rate: Acres/hour (see table 5)",{"$f":"C16*C17*(C18*100)/825","v":10.199999999999999},"Annual depreciation rate (%) from Table 3",{"$f":"IF(D10<>\"\",VLOOKUP(D10,DeprRep,4,FALSE),0)","v":5.6000000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP small square bale mover"]
[null,"Average speed (miles per hour)",3.3,"Annual repair rate (%) from Table 3",{"$f":"IF(D10<>\"\",VLOOKUP(D10,DeprRep,5,FALSE),0)","v":2.63},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High clearance sprayers"]
[null,"Implement width (feet)",30]
[null,"Field efficiency (%)",0.85,"Trade in Value**",{"$f":"IF(E15=0,0,E11-(E11*E15/100*C11))","v":242719.99999999988}]
[]
[null,"Annual Fixed Cost",null,null,"Total annual $","$ per hour","$ per acre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4–18-in. furrow plow","Rigid headers"]
[null,"Capital recovery*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6–18-in. furrow plow","Pickup headers"]
[null,"purchase price – trade-in value",null,{"$f":"E11-E18","v":497280.00000000012},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8–18-in. furrow plow","Flex headers"]
[null,"capital recovery factor (from Table 4)","x",{"$f":"IFERROR((C5*(1+C5)^C11)/((1+C5)^C11-1),0)","v":0.11282541002081541},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24-ft field cultivator","Draper headers"]
[null,null,null,{"$f":"D22*D23","v":56105.8198951511},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31-ft field cultivator","Corn headers"]
[null,"trade-in value x annual interest rate**","+",{"$f":"E18*C5","v":12135.999999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"44-ft field cultivator","Grain carts"]
[null,"Total capital recovery",null,null,{"$f":"D24+D25","v":68241.8198951511},{"$f":"IFERROR(E26/$E$12,0)","v":272.96727958060438},{"$f":"IFERROR(F26/$C$15,0)","v":26.76149799809847},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16-ft chisel plow","Powered augers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21-ft chisel plow","PTO augers"]
[null,"Insurance & housing = ",null,{"$f":"\"purchase price x \"&$C$6*100&\" %\"","v":"purchase price x 1 %"},{"$f":"E11*C6","v":7400},{"$f":"IFERROR(E28/$E$12,0)","v":29.6},{"$f":"IFERROR(F28/$C$15,0)","v":2.9019607843137258},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24-ft tandem disk","Grain vac"]
[null,"Total Fixed Cost",null,null,{"$f":"SUM(E26:E28)","v":75641.8198951511},302.56727958060441,29.663458782412199,"(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30-ft tandem disk","PT Mower/conditioner (sickle)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-ft offset disk","PT Mower/conditioner (disc)"]
[null,"Annual Operating Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16-ft offset disk","Hay rake (wheel)"]
[null,"Fuel (Table 5)  =   ",null,"(litres/hour x hours/year x fuel cost/litre)",{"$f":"E13*E12*E5","v":24300},{"$f":"IFERROR(E32/$E$12,0)","v":97.2},{"$f":"IFERROR(F32/$C$15,0)","v":9.529411764705884},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21-ft vertical tillage","Round baler"]
[null,"Repairs and maintenance =",null,"annual repair rate x purchase price",{"$f":"E11*E16/100","v":19462},77.847999999999999,7.6321568627450986,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30-ft vertical tillage","Large square baler"]
[null,"Total Operating Costs",null,null,{"$f":"SUM(E32:E33)","v":43762},175.048,17.161568627450983,"(B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"43-ft vertical tillage","Small square baler"]
[null,"Total Power Unit Costs",null,null,{"$f":"SUM(E34,E29)","v":119403.8198951511},477.61527958060441,46.825027409863182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-row strip tillage","PT round bale mover"]
[null,"+ IMPLEMENT 1 (TILLAGE IMPLEMENT, PTO MACHINE, OTHER)",null,"Corn headers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6R – 30-in. row crop planter","PT large square bale mover"]
[null,null,null,"12R – 30-in. corn hd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12R – 30-in. row crop planter","Air drills (independent openers)"]
[null,"Life (years)",{"$f":"IF(D36<>\"\",VLOOKUP(D36,DeprRep,3,FALSE),0)","v":15},"Purchase Price",170000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16R – 30-in. row crop planter","Air hoe drills"]
[null,"Acres/year",{"$f":"E39*C15","v":1019.9999999999999},"Hours per year",{"$f":"IF(D36<>\"\",VLOOKUP(D36,DeprRep,2,FALSE),0)","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6R – 30-in. minimum-till planter","Air disk drills"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12R – 30-in. minimum-till planter","Air seeder"]
[null,"Trade in Value**",{"$f":"IF(E41=\"\",\"\",E38-(E38*E41/100*C38))","v":57799.999999999985},"Annual depreciation rate (%) from Table 3",{"$f":"IF(D36<>\"\",VLOOKUP(D36,DeprRep,4,FALSE),0)","v":4.4000000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16R – 30-in. minimum-till planter","Row crop planters"]
[null,null,null,"Annual repair rate (%) from Table 3",{"$f":"IF(D36<>\"\",VLOOKUP(D36,DeprRep,5,FALSE),0)","v":2.94},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25-ft grain drill","Plows"]
[null,"Annual Fixed Cost",null,null,"Total annual $","$ per hour","$ per acre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35-ft grain drill","Disks"]
[null,"Capital recovery*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-ft presswheel drill","Cultivators"]
[null,"purchase price – trade-in value",null,{"$f":"E38-C41","v":112200.00000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20-ft presswheel drill","Standard harrows"]
[null,"capital recovery factor (from Table 4)","x",{"$f":"IFERROR((C5*(1+C5)^C38)/((1+C5)^C38-1),0)","v":9.6342287609244348E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15-ft no-till drill","Heavy harrows"]
[null,null,null,{"$f":"D45*D46","v":10809.604669757216},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20-ft no-till drill","Harrow packers"]
[null,"trade-in value x annual interest rate**","+",{"$f":"(C41*C5)","v":2889.9999999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90-ft sprayer, pull type","Vertical tillage tools",null,null,null,null,null,null,null,null,null,"per hour","implement1","implement2",null,"power + return+operator"]
[null,"Total capital recovery",null,null,{"$f":"D47+D48","v":13699.604669757216},{"$f":"IFERROR(E49/$E$39,0)","v":136.99604669757215},{"$f":"IFERROR(F49/($C$15),0)","v":13.430984970350211},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90-ft sprayer, self propelled","Land roller",null,null,null,null,null,null,null,null,null,"trade in",{"$f":"E38-C41","v":112200.00000000001},{"$f":"E60-C63","v":0},{"$f":"SUM(AN49:AO49)","v":112200.00000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-ft mower conditioner","Land scraper",null,null,null,null,null,null,null,null,null,"cap recovery rate",{"$f":"D68","v":0}]
[null,"Insurance & housing = ",null,{"$f":"\"purchase price x \"&$C$6*100&\" %\"","v":"purchase price x 1 %"},{"$f":"E38*C6","v":1700},{"$f":"IFERROR(E51/$E$39,0)","v":17},{"$f":"IFERROR(F51/($C$15),0)","v":1.6666666666666667},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-ft rotary mower/conditioner","Post pounder",null,null,null,null,null,null,null,null,null,null,{"$f":"AN49*AN50","v":0},{"$f":"AO49*AN50","v":0},{"$f":"SUM(AN51:AO51)","v":0}]
[null,"Total Fixed Cost",null,null,{"$f":"SUM(E45:E51)","v":15399.604669757216},153.99604669757215,{"$f":"IFERROR(F52/($C$15),0)","v":15.097651637016879},"(C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square baler","Vertical feed mixer",null,null,null,null,null,null,null,null,null,"interest",{"$f":"C41*C39","v":58955999.999999978},{"$f":"C63*C61","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round baler 1,000 lb","Grinder mixers and feed mixers",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN51:AN52)","v":58955999.999999978},{"$f":"SUM(AO51:AO52)","v":0},{"$f":"SUM(AN53:AO53)","v":58955999.999999978}]
[null,"Annual Operating Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round baler 1,500 lb","Bale processors",null,null,null,null,null,null,null,null,null,"insurance",{"$f":"E38*0.01","v":1700},{"$f":"E60*0.01","v":0},{"$f":"SUM(AN54:AO54)","v":1700}]
[null,"Repairs and maintenance =",null,"annual repair rate x purchase price",{"$f":"(E38*E42/100)","v":4998},{"$f":"IFERROR(E55/$E$39,0)","v":49.98},{"$f":"IFERROR(F55/($C$15),0)","v":4.9000000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large size square baler","Manure spreader",null,null,null,null,null,null,null,null,null,"repairs",{"$f":"E38*E42/100","v":4998},{"$f":"E60*E64/100","v":0},{"$f":"SUM(AN55:AO55)","v":4998}]
[null,"Total Operating costs",null,null,{"$f":"SUM(E54:E55)","v":4998},49.98,{"$f":"IFERROR(F56/($C$15),0)","v":4.9000000000000004},"(D)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round baler 1,000 lb/wrapper",null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AN53,AN54,AN55)","v":58962697.999999978},{"$f":"SUM(AO53,AO54,AO55)","v":0},{"$f":"SUM(AN56:AO56)","v":58962697.999999978},{"$f":"E35+(E35*C81)+E85","v":145076.89287942377},{"$f":"SUM(AP56:AQ56,AN57:AO57)","v":67952179.5928794}]
[null,"Total Implement Costs",null,null,{"$f":"SUM(E56,E52)","v":20397.604669757216},{"$f":"SUM(F56,F52)","v":203.97604669757214},19.99765163701688,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-row forage harvester",null,null,null,null,null,null,null,null,null,null,"profit",{"$f":"AN56*C81","v":8844404.6999999955},{"$f":"AO56*C81","v":0}]
[null,"+ IMPLEMENT 2 (TILLAGE IMPLEMENT, PTO MACHINE, OTHER)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self-propelled forage harvester, 6 row, 15 ft",null,null,null,null,null,null,null,null,null,null,"per hour",{"$f":"IFERROR(AN56/E39,\"\")","v":589626.97999999975},{"$f":"IFERROR(AO56/E61,\"\")","v":""},null,{"$f":"IFERROR(AQ56/E12,\"\")","v":580.30757151769512},{"$f":"SUM(AN58:AQ58)","v":590207.2875715174}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large forage blower"]
[null,"Life (years)",{"$f":"IF(D58<>\"\",VLOOKUP(D58,DeprRep,3,FALSE),0)","v":0},"Purchase Price",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6R – 30-in. corn hd",null,null,null,null,null,null,null,null,null,null,"ST rental","implement1","implement2",null,"power"]
[null,"Acres/year",{"$f":"E61*C15","v":0},"Hours per year",{"$f":"IF(D58<>\"\",VLOOKUP(D58,DeprRep,2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12R – 30-in. corn hd",null,null,null,null,null,null,null,null,null,null,"machine costs",{"$f":"AN56","v":58962697.999999978},{"$f":"AO56","v":0},null,{"$f":"E35-E32","v":95103.8198951511},{"$f":"SUM(AN61:AQ61)","v":59057801.819895126}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grain head 25 ft",null,null,null,null,null,null,null,null,null,null,"profit"]
[null,"Trade in Value**",{"$f":"IF(E63=\"\",\"\",E60-(E60*E63/100*C60))","v":0},"Annual depreciation rate (%) from Table 3",{"$f":"IF(D58<>\"\",VLOOKUP(D58,DeprRep,4,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grain head 35 ft",null,null,null,null,null,null,null,null,null,null,"total"]
[null,null,null,"Annual repair rate (%) from Table 3",{"$f":"IF(D58<>\"\",VLOOKUP(D58,DeprRep,5,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per hour"]
[null,"Annual Fixed Cost",null,null,"Total annual $","$ per hour","$ per acre"]
[null,"Capital recovery*"]
[null,"purchase price – trade-in value",null,{"$f":"(E60-C63)","v":0}]
[null,"capital recovery factor (from Table 4)","x",{"$f":"IFERROR((C5*(1+C5)^C60)/((1+C5)^C60-1),0)","v":0}]
[null,null,null,{"$f":"IFERROR(D67*D68,0)","v":0}]
[null,"trade-in value x annual interest rate**","+",{"$f":"(C63*C5)","v":0}]
[null,"Total capital recovery",null,null,{"$f":"D69+D70","v":0},{"$f":"IFERROR(E71/$E$61,0)","v":0},{"$f":"IFERROR(E71/($E$61*$C$15),0)","v":0}]
[]
[null,"Insurance & housing = ",null,{"$f":"\"purchase price x \"&$C$6*100&\" %\"","v":"purchase price x 1 %"},{"$f":"E60*C6","v":0},{"$f":"IFERROR(E73/$E$61,0)","v":0},{"$f":"IFERROR(E73/($E$61*$C$15),0)","v":0}]
[null,"Total Fixed Cost",null,null,{"$f":"SUM(E67:E73)","v":0},0,{"$f":"IFERROR(E74/($E$61*$C$15),0)","v":0},"(C)"]
[]
[null,"Annual Operating Cost"]
[null,"Repairs and maintenance =",null,"Annual repair rate x purchase price",{"$f":"(E60*E64/100)","v":0},{"$f":"IFERROR(E77/$E$61,0)","v":0},{"$f":"IFERROR(E77/($E$61*$C$15),0)","v":0}]
[null,"Total Operating costs",null,null,{"$f":"SUM(E76:E77)","v":0},0,{"$f":"IFERROR(E78/($E$61*$C$15),0)","v":0},"(D)"]
[null,"Total Implement Costs",null,null,{"$f":"SUM(E78,E74)","v":0},0,{"$f":"IFERROR(E79/($E$61*$C$15),0)","v":0}]
[null," = Annual Machinery Costs  (A+B+C+D) ",null,null,{"$f":"SUM(E79,E35,E57)","v":139801.42456490832},{"$f":"F79+F57+F35","v":681.59132627817655},{"$f":"G79+G57+G35","v":66.822679046880069},"(E)"]
[null,"Return to management, administration costs",{"$f":"E8","v":0.15},"Operator labour (self or hired) per hour  ",{"$f":"E7","v":27}]
[null,null,null,"Labour allowance for machine travel, downtime",0.15]
[null,null,null,null,"Total annual $","$ per hour","$ per acre"]
[null," + Margin (return to management, administration costs)",null,null,{"$f":"E80*C81","v":20970.213684736245},{"$f":"E84/E12","v":83.880854738944976},{"$f":"IFERROR(E84/C12,0)","v":8.2236132097004884},"(F)"]
[null," + Operator labour (self or hired)",null,null,{"$f":"E12*E81*(1+E82)","v":7762.4999999999991},{"$f":"E85/E12","v":31.049999999999997},{"$f":"IFERROR(E85/C12,0)","v":3.0441176470588234},"(G)"]
[null,"=    Total Machinery Costs     (E+F+G)",null,null,{"$f":"E80+E84+E85","v":168534.13824964457},null,null,"(H)"]
[null," = Total machinery cost",null,"Per hour",null,{"$f":"F79+F57+F35+F84+F85","v":796.52218101712151}]
[null,null,null,"Per acre",null,null,{"$f":"IFERROR(G79+G57+G35+G84+G85,0)","v":78.090409903639383}]
[null,"* The capital recovery method estimates the annual depreciation and interest costs. It combines depreciation and"]
[null,"interest costs in one calculation. To calculate the capital recovery costs, the capital recovery factor is multiplied by total"]
[null,"depreciation and adds the result of the trade-in value multiplied by the interest rate. Table 4 provides the capital recovery"]
[null,"factors for selected combinations of years and interest rates."]
[null,"** Trade-in value = purchase price – (purchase price x annual depreciation rate (from Table 3) x number of years owned)."]
[null,"*** Interest: Interest calculation is the average annual interest cost of the investment (yours and/or the lender’s) that is tied up in the machine."]
[]
[]
[null,"End of worksheet"]

{"sheet":"Tables","index":2,"n_rows":73,"n_cols":28,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[null,"Tables 4 and 5 scroll right"]
[]
[null,"Table 3, Annual hours of use, optimal life, depreciation and repair rates",null,null,null,null,null,"Table 4. Capital recovery factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE 5. Performance, Horsepower and Fuel Requirements of Selected Farm Equipment"]
[null,"Machine","Annual Use (hours)","Optimal Life (years)","Annual Depreciation Rate (% of purchase price) ","Annual Repair Rate (% of purchase price)",null,null,"Interest rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rated Engine HP(1,2)","Acres/hour(2)","Litres/acre","Litres/hour(3)"]
[null,"2WD tractor",300,20,3.3000000000000003,2.31,null,"Year",0.02,0.03,0.04,0.05,0.06,7.0000000000000007E-2,0.08,0.09,0.1,0.11,0.12,0.13,0.14000000000000001,0.15,null,"4–18-in. furrow plow",85,2.8,5.8285714285714292,16.32]
[null,"Front wheel assist tractor",450,15,4.4000000000000004,2.73,null,1,1.02,1.03,1.04,1.05,1.06,1.07,1.08,1.0900000000000001,1.1000000000000001,1.1100000000000001,1.1200000000000001,1.1299999999999999,1.1399999999999999,1.1499999999999999,null,"6–18-in. furrow plow",160,3,10.24,30.72]
[null,"4WD tractor",450,15,4.4000000000000004,2.63,null,2,0.51500000000000001,0.52300000000000002,0.53,0.53800000000000003,0.54500000000000004,0.55300000000000005,0.56100000000000005,0.56799999999999995,0.57599999999999996,0.58399999999999996,0.59199999999999997,0.59899999999999998,0.60699999999999998,0.61499999999999999,null,"8–18-in. furrow plow",285,5.6,9.7714285714285722,54.72]
[null,"Tracked tractor",450,15,4.4000000000000004,3.36,null,3,0.34699999999999998,0.35399999999999998,0.36,0.36699999999999999,0.374,0.38100000000000001,0.38800000000000001,0.39500000000000002,0.40200000000000002,0.40899999999999997,0.41599999999999998,0.42399999999999999,0.43099999999999999,0.438,null,"24-ft field cultivator",160,9,3.4133333333333331,30.72]
[null,"SP Rotary combine",250,12,5.6000000000000005,2.63,null,4,0.26300000000000001,0.26900000000000002,0.27500000000000002,0.28199999999999997,0.28899999999999998,0.29499999999999998,0.30199999999999999,0.309,0.315,0.32200000000000001,0.32900000000000001,0.33600000000000002,0.34300000000000003,0.35,null,"31-ft field cultivator",255,20.6,2.3766990291262133,48.96]
[null,"Rigid headers",250,20,3.3000000000000003,2.1,null,5,0.21199999999999999,0.218,0.22500000000000001,0.23100000000000001,0.23699999999999999,0.24399999999999999,0.25,0.25700000000000001,0.26400000000000001,0.27100000000000002,0.27700000000000002,0.28399999999999997,0.29099999999999998,0.29799999999999999,null,"44-ft field cultivator",305,29.1,2.0123711340206185,58.56]
[null,"Pickup headers",250,20,3.3000000000000003,1.58,null,6,0.17899999999999999,0.185,0.191,0.19700000000000001,0.20300000000000001,0.21,0.216,0.223,0.23,0.23599999999999999,0.24299999999999999,0.25,0.25700000000000001,0.26400000000000001,null,"16-ft chisel plow",175,9,3.7333333333333334,33.6]
[null,"Flex headers",250,15,4.4000000000000004,2.63,null,7,0.155,0.161,0.16700000000000001,0.17299999999999999,0.17899999999999999,0.186,0.192,0.19900000000000001,0.20499999999999999,0.21199999999999999,0.219,0.22600000000000001,0.23300000000000001,0.24,null,"21-ft chisel plow",275,12.6,4.1904761904761907,52.800000000000004]
[null,"Draper headers",250,15,4.4000000000000004,2.94,null,8,0.13700000000000001,0.14199999999999999,0.14899999999999999,0.155,0.161,0.16700000000000001,0.17399999999999999,0.18099999999999999,0.187,0.19400000000000001,0.20100000000000001,0.20799999999999999,0.216,0.223,null,"24-ft tandem disk",170,15.1,2.16158940397351,32.64]
[null,"Corn headers",100,15,4.4000000000000004,2.94,null,9,0.123,0.128,0.13400000000000001,0.14099999999999999,0.14699999999999999,0.153,0.16,0.16700000000000001,0.17399999999999999,0.18099999999999999,0.188,0.19500000000000001,0.20200000000000001,0.21,null,"30-ft tandem disk",255,15.3,3.1999999999999997,48.96]
[null,"SP Swather",200,15,4.4000000000000004,2.1,null,10,0.111,0.11700000000000001,0.123,0.13,0.13600000000000001,0.14199999999999999,0.14899999999999999,0.156,0.16300000000000001,0.17,0.17699999999999999,0.184,0.192,0.19900000000000001,null,"10-ft offset disk",125,6,4,24]
[null,"Grain carts",250,20,3.3000000000000003,2.1,null,11,0.10199999999999999,0.108,0.114,0.12,0.127,0.13300000000000001,0.14000000000000001,0.14699999999999999,0.154,0.161,0.16800000000000001,0.17599999999999999,0.183,0.191,null,"16-ft offset disk",175,9.6,3.5000000000000004,33.6]
[null,"Powered augers",100,20,3.3000000000000003,1.58,null,12,9.5000000000000001E-2,0.1,0.107,0.113,0.11899999999999999,0.126,0.13300000000000001,0.14000000000000001,0.14699999999999999,0.154,0.161,0.16900000000000001,0.17699999999999999,0.184,null,"21-ft vertical tillage",215,19.600000000000001,2.1061224489795918,41.28]
[null,"PTO augers",100,20,3.3000000000000003,1.58,null,13,8.7999999999999995E-2,9.4E-2,0.1,0.106,0.113,0.12,0.127,0.13400000000000001,0.14099999999999999,0.14799999999999999,0.156,0.16300000000000001,0.17100000000000001,0.17899999999999999,null,"30-ft vertical tillage",305,27.2,2.1529411764705886,58.56]
[null,"Grain vac",50,15,4.4000000000000004,2.1,null,14,8.3000000000000004E-2,8.8999999999999996E-2,9.5000000000000001E-2,0.10100000000000001,0.108,0.114,0.121,0.128,0.13600000000000001,0.14299999999999999,0.151,0.159,0.16700000000000001,0.17499999999999999,null,"43-ft vertical tillage",420,39.200000000000003,2.0571428571428569,80.64]
[null,"SP Forage harvester",400,10,6.7,8.4,null,15,7.8E-2,8.4000000000000005E-2,0.09,9.6000000000000002E-2,0.10299999999999999,0.11,0.11700000000000001,0.124,0.13100000000000001,0.13900000000000001,0.14699999999999999,0.155,0.16300000000000001,0.17100000000000001,null,"12-row strip tillage",330,17.5,3.6205714285714286,63.36]
[null,"SP Forage harvester header",400,10,6.7,8.4,null,16,7.3999999999999996E-2,0.08,8.5999999999999993E-2,9.1999999999999998E-2,9.9000000000000005E-2,0.106,0.113,0.12,0.128,0.13600000000000001,0.14299999999999999,0.151,0.16,0.16800000000000001,null,"6R – 30-in. row crop planter",110,7.6,2.7789473684210528,21.12]
[null,"SP Mower/conditioner",150,15,4.4000000000000004,3.36,null,17,7.0000000000000007E-2,7.5999999999999998E-2,8.2000000000000003E-2,8.8999999999999996E-2,9.5000000000000001E-2,0.10199999999999999,0.11,0.11700000000000001,0.125,0.13200000000000001,0.14000000000000001,0.14899999999999999,0.157,0.16500000000000001,null,"12R – 30-in. row crop planter",160,15.3,2.0078431372549019,30.72]
[null,"PT Mower/conditioner (sickle)",150,15,4.4000000000000004,2.1,null,18,6.7000000000000004E-2,7.2999999999999995E-2,7.9000000000000001E-2,8.5999999999999993E-2,9.1999999999999998E-2,9.9000000000000005E-2,0.107,0.114,0.122,0.13,0.13800000000000001,0.14599999999999999,0.155,0.16300000000000001,null,"16R – 30-in. row crop planter",175,20.399999999999999,1.6470588235294119,33.6]
[null,"PT Mower/conditioner (disc)",150,15,4.4000000000000004,2.63,null,19,6.4000000000000001E-2,7.0000000000000007E-2,7.5999999999999998E-2,8.3000000000000004E-2,0.09,9.7000000000000003E-2,0.104,0.112,0.12,0.128,0.13600000000000001,0.14399999999999999,0.153,0.161,null,"6R – 30-in. minimum-till planter",85,6.4,2.5499999999999998,16.32]
[null,"Hay rake (wheel)",50,20,3.3000000000000003,2,null,20,6.0999999999999999E-2,6.7000000000000004E-2,7.3999999999999996E-2,0.08,8.6999999999999994E-2,9.4E-2,0.10199999999999999,0.11,0.11700000000000001,0.126,0.13400000000000001,0.14199999999999999,0.151,0.16,null,"12R – 30-in. minimum-till planter",175,15.3,2.1960784313725492,33.6]
[null,"Round baler",100,15,4.4000000000000004,1.58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16R – 30-in. minimum-till planter",255,20.399999999999999,2.4000000000000004,48.96]
[null,"Large square baler",150,15,4.4000000000000004,1.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25-ft grain drill",160,11.7,2.6256410256410256,30.72]
[null,"Small square baler",100,20,3.3000000000000003,1.05,null,"Tractor example using Table 3 and 4:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35-ft grain drill",255,16.3,3.003680981595092,48.96]
[null,"PT round bale mover",100,15,4.4000000000000004,2.63,null,null,"310 Horsepower (HP) Four Wheel Drive (4WD) Tractor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-ft presswheel drill",85,5.0999999999999996,3.2,16.32]
[null,"PT large square bale mover",200,20,3.3000000000000003,2.1,null,"Purchase price",470000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20-ft presswheel drill",160,8.5,3.6141176470588232,30.72]
[null,"SP small square bale mover",150,15,4.4000000000000004,2.63,null,"Projected use","450 hr per year for 5 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15-ft no-till drill",160,7,4.3885714285714288,30.72]
[null,"Air drills (independent openers)",200,15,4.4000000000000004,3.68,null,"Depreciaton","Estimated total depreciation over the 5 years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20-ft no-till drill",200,9.3000000000000007,4.129032258064516,38.4]
[null,"Air hoe drills",200,15,4.4000000000000004,3.15,null,null,"= 4.4% annual depreciation rate (from Table 3, 4WD tractors) x 5 years x $470,000 = $103,400 total depreciation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90-ft sprayer, pull type",110,49.6,0.42580645161290326,21.12]
[null,"Air disk drills",200,15,4.4000000000000004,3.15,null,"Trade-in value","= $470,000 (purchase price) – $103,400 (total depreciation) = $366,600",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90-ft sprayer, self propelled",85,72.5,0.2,16.3]
[null,"Air seeder",200,15,4.4000000000000004,3.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-ft mower conditioner",45,4.4000000000000004,1.9636363636363636,8.64]
[null,"Row crop planters",100,10,6.7,4.2,null,"Capital recovery:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-ft rotary mower/conditioner",85,9.6999999999999993,1.682474226804124,16.32]
[null,"Plows",100,20,3.3000000000000003,3.68,null,null,"= (total depreciation x capital recovery factor)+ (trade-in value x interest rate)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square baler",45,4.4000000000000004,1.9636363636363636,8.64]
[null,"Disks",100,20,3.3000000000000003,3.68,null,null,"= ($103,400 x 0.218 (from Table 5, 3% interest and 5 years)) + ($366,600 x 3%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round baler 1,000 lb",70,3,4.4799999999999995,13.44]
[null,"Cultivators",200,20,3.3000000000000003,1.58,null,null,"= $22,541 + $10,998",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round baler 1,500 lb",70,4,3.36,13.44]
[null,"Standard harrows",75,25,2.7,1.26,null,null,"= $33,539 per year capital recovery (depreciation and interest costs).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large size square baler",160,16.3,1.8846625766871163,30.72]
[null,"Heavy harrows",100,20,3.3000000000000003,1.58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round baler 1,000 lb/wrapper",70,3,4.4799999999999995,13.44]
[null,"Harrow packers",200,25,2.7,0.53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-row forage harvester",160,1.4,21.942857142857143,30.72]
[null,"Vertical tillage tools",100,20,3.3000000000000003,3.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self-propelled forage harvester, 6 row, 15 ft",625,5.0999999999999996,20.6,105]
[null,"Land roller",75,20,3.3000000000000003,1.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large forage blower",70,"—","—",13.44]
[null,"Land scraper",80,10,6.7,2.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combine 6R – 30-in. corn hd",275,5.0999999999999996,10.4,52.8]
[null,"High clearance sprayers",175,8,8.3000000000000007,3.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combine 12R – 30-in. corn hd",375,10.199999999999999,7.1,72]
[null,"Post pounder",40,20,3.3000000000000003,2.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combine grain head 25 ft",375,7.4,9.6999999999999993,72]
[null,"Vertical feed mixer",200,15,4.4000000000000004,2.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combine grain head 35 ft",375,10.4,6.9,72]
[null,"Grinder mixers and feed mixers",200,15,4.4000000000000004,3.15,null,"End of worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Multiply Engine Horsepower by 0.88 to arrive at PTO horsepower"]
[null,"Bale processors",200,15,4.4000000000000004,3.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Source: Illinois Machinery Cost Estimates for 2023, University of Illinois, Department of Agricultural and Consumer Economics, 2023."]
[null,"Manure spreader",100,10,6.7,4.62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Source: Nebraska Tractor Test Laboratory, 2018–2024. Tractor fuel consumption results."]
[null,"Source: Farm Machinery Custom and Rental Rate Guide, Saskatchewan Ministry of Agriculture, 2024-25"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End of worksheet"]
[]
[]
[null,"EXAMPLE ","Accumulated Repair Cost Calculation "]
[null,"New 425 HP combine with corn header","$820,000 = $740,000 (combine) + $ 170,000 (corn header)"]
[null,"Estimated annual repair rates","2.63% combine"]
[null,null,"2.94% corn head"]
[null,"from Table 3"]
[null,"Estimated annual repair costs","Combine: $740,000 x 2.63% for an average of $19,462/year"]
[null,null,"Corn header: $170,000 x 2.94% for an average of $4,998/year"]
[]
[null,null,"Total annual repair costs = $19,462 + $4,998 = $24,460 per year"]
[null,"Used Machinery","When calculating the depreciation on used machinery, use the actual price paid "]
[null,null,"for the machine minus its expected trade-in or salvage value, divided by the "]
[null,null,"expected life of the machine on your farm. Increase repair rates to levels "]
[null,null,"appropriate for the age or number of hours on the machine. Expect to have "]
[null,null,"higher than normal repair expenses in the first year of ownership of a"]
[null,null," used machine as you bring it back into top operating shape"]
[]
[null,"End of worksheet"]

{"sheet":"Factsheets","index":3,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Budgeting Farm Machinery Costs"]
[]
["by John Molenhuis"]
["Business Analysis and Cost of Production Specialist"]
["Ontario Ministry of Agriculture, Food and Agribusiness"]
[]
["https://www.ontario.ca/page/budgeting-farm-machinery-costs"]
[]
[]
[]
[]
[]
["End of worksheet"]