{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Menu","Factsheets","Calculator","Cost Charts","Comparison","Loan","Lease Comparison"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":3,"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":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["This is a farm business decision calculator that has 7 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, a factsheet on machinery"]
["budgeting and a comparison worksheet that compares machinery replacement options including purchase,"]
["repair, lease and custom hire. It also has a simple cash basis lease worksheet."]
[]
["Developed by John Molenhuis"]
["Business Analysis and Cost of Production Specialist"]
["OMAFRA, Brighton"]
["email: john.molenhuis@ontario.ca"]
[]
["Revised April 2020"]
["End of worksheet"]

{"sheet":"Factsheets","index":1,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Budgeting Farm Machinery Costs"]
["by John Molenhuis"]
["Economic Development Division,"]
["Ontario Ministry of Agriculture, Food and Rural Affairs"]
[]
["https://www.publications.gov.on.ca/300228"]
[]
[]
[]
[]
[]
[]
["Lease Agreements, Farm Equipment"]
["by Erich Weber, "]
["Finance and Business Structures Specialist"]
["Economic Development Division,"]
["Ontario Ministry of Agriculture, Food and Rural Affairs"]
[]
[]
["http://www.omafra.gov.on.ca/english/busdev/facts/13-059.htm "]
[]
[]
["End of worksheet"]

{"sheet":"Calculator","index":2,"n_rows":86,"n_cols":30,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Machinery Cost Calculator"]
[null,"POWER UNIT (TRACTOR OR SELF-PROPELLED MACHINE)"]
[null,"PTO Horsepower",375,"Self propelled forage harvesters"]
[null,"Life (years)",5,"Purchase Price",478000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D4","v":"Self propelled forage harvesters"},"2WD tractors",null,null,"2WD tractors"]
[null,"Interest rate",0.05,"Hours per year",250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FWA tractors",null,null,"FWA tractors"]
[null,"Acres/year",2575,"Fuel Cost per litre ",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4WD tractors",null,null,"4WD tractors"]
[null,"Acres/hour (see table 5)",10.3,"Fuel Used -litres/hr  (see Table 5)",{"$f":"C4*0.244","v":91.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self Propelled combines",null,null,"Self Propelled combines"]
[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,"Self propelled high clearance sprayer",null,null,"Self propelled high clearance sprayer"]
[null,"Annual depreciation rate (%) from Table 3",{"$f":"IF(D4<>\"\",VLOOKUP(D4,DeprRep,4,FALSE),0)","v":6.7},"Annual repair rate (%) from Table 3",{"$f":"IF(D4<>\"\",VLOOKUP(D4,DeprRep,5,FALSE),0)","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self propelled forage harvesters",null,null,"Self propelled forage harvesters"]
[null,"Trade in Value**",{"$f":"IF(C10=0,0,E5-(E5*C10/100*C5))","v":317870},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depreciation"]
[null,"Annual Fixed 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,"Trade in value"]
[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,"Repairs",{"$f":"VLOOKUP(D4,DeprRep,4)","v":6.7}]
[null,"purchase price – trade-in value",null,{"$f":"E5-C11","v":160130}]
[null,"capital recovery factor","x",{"$f":"(C6*(1+C6)^C5)/((1+C6)^C5-1)","v":0.23097479812826807}]
[null,null,null,{"$f":"D14*D15","v":36985.994424279568}]
[null,"trade-in value x annual interest rate**","+",{"$f":"C11*C6","v":15893.5}]
[null,"Total Capital recovery",null,null,{"$f":"D16+D17","v":52879.494424279568}]
[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,"Headers, grain"]
[null,"Insurance & housing = ",null,"purchase price x 1.0 %",{"$f":"E5*0.01","v":4780},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Headers, corn"]
[null,"Total Fixed Cost",null,null,{"$f":"SUM(E18:E20)","v":57659.494424279568},"(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grain carts"]
[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,"Plows, discs"]
[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,"Vertical tillage"]
[null,"Fuel & lubricants( Table 5)  =   ",null,"(litres/hour x hr/yr x fuel cost/L x 1.15)",{"$f":"E8*E6*E7*1.15","v":26306.249999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cultivators, hoes"]
[null,"Repairs =",null,"Annual repair rate x purchase price",{"$f":"E5*E10/100","v":38240},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrows"]
[null,"Total Operating Costs",null,null,{"$f":"SUM(E24:E25)","v":64546.25},"(B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drills"]
[null,"Total Power Unit Costs",null,null,{"$f":"SUM(E26,E21)","v":122205.74442427958},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row crop planters"]
[null,"+ IMPLEMENT 1 (TILLAGE IMPLEMENT, PTO MACHINE, OTHER)",null,"Balers, round","Group",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mower/conditioner"]
[null,null,null,"Round baler 1,000 lb","Implement"]
[null,"Life (years)",10,"Purchase Price",100000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Balers, round"]
[null,"Interest rate",0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Balers, large square"]
[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,"Balers, small square"]
[null,"Annual depreciation rate (%) from Table 3",{"$f":"IF(D28<>\"\",VLOOKUP(D28,DeprRep,4,FALSE),0)","v":4.4000000000000004},"Annual repair rate (%) from Table 3",{"$f":"IF(D28<>\"\",VLOOKUP(D28,DeprRep,5,FALSE),0)","v":1.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manure spreaders"]
[null,"Trade in Value**",{"$f":"IF(C33=\"\",\"\",E30-(E30*C33/100*C30))","v":55999.999999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mower/conditioner"]
[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,"Balers, round"]
[null,null,null,null,"Implement"]
[null,"Life (years)",{"$f":"C30","v":10},"Purchase Price",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Balers, large square"]
[null,"Interest rate",{"$f":"C31","v":0.05},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Balers, small square"]
[null,"Acres/hour (see table 5)"]
[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,"Manure spreaders"]
[null,"Annual depreciation rate (%) from Table 3",{"$f":"IF(D35<>\"\",VLOOKUP(D35,DeprRep,4,FALSE),0)","v":0},"Annual repair rate (%) from Table 3",{"$f":"IF(D35<>\"\",VLOOKUP(D35,DeprRep,5,FALSE),0)","v":0}]
[null,"Trade in Value**",{"$f":"IF(C41=\"\",\"\",E37-(E37*C41/100*C37))","v":0}]
[null,"Annual Fixed 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,"4–18-in. furrow plow"]
[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,"6–18-in. furrow plow"]
[null,"purchase price – trade-in value",null,{"$f":"(E30-C34)+(E37-C42)","v":44000.000000000007},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"]
[null,"capital recovery factor","x",{"$f":"(C31*(1+C31)^C30)/((1+C31)^C30-1)","v":0.1295045749654567},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"]
[null,null,null,{"$f":"D45*D46","v":5698.2012984800958},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"]
[null,"trade-in value x annual interest rate**","+",{"$f":"(C34*C31)+(C42*C38)","v":2800},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"]
[null,"Capital recovery",null,null,{"$f":"D47+D48","v":8498.2012984800967},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16-ft chisel plow"]
[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"]
[null,"Insurance & housing = ",null,"purchase price x 1%",{"$f":"(E37+E30)*0.01","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24-ft tandem disk"]
[null,"Total Fixed Cost",null,null,{"$f":"SUM(E45:E51)","v":9498.2012984800967},"(C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30-ft tandem disk"]
[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"]
[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,"16-ft offset disk"]
[null,"Repairs =",null,"Annual repair rate x purchase price",{"$f":"(E30*E33/100)+(E37*E41/100)","v":1500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21-ft vertical tillage"]
[null,"Total Operating costs",null,null,{"$f":"SUM(E54:E55)","v":1500},"(D)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30-ft vertical tillage"]
[null,"Total Implement Costs",null,null,{"$f":"SUM(E56,E52)","v":10998.201298480097},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"43-ft vertical tillage"]
[null," = Annual Machinery Costs  (A+B+C+D) ",null,null,{"$f":"SUM(E57,E27)","v":133203.94572275967},"(E)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-row strip tillage"]
[null,"Return to Management",0.15,"Operator Labour (self or hired) per Hour  ",22,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"]
[null,null,null,"Labour Allowance for Machine travel, downtime",0.15,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"]
[null," + Profit Margin (return to management, admin. costs) (suggest 15% of machinery costs ( E x 0.15 )",null,null,{"$f":"E58*C59","v":19980.591858413951},"(F)",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"]
[null," + Operator Labour (self or hired) --- (suggest 15% over machine hr for travel, downtime)  # of machinery hr x 1.15 x wage/h",null,null,{"$f":"E6*E59*(1+E60)","v":6324.9999999999991},"(G)",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"]
[null,"=    Total Costs     (E+F+G)",null,null,{"$f":"E58+E61+E62","v":159509.53758117362},"(H)",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"]
[null," = Total cost including return to management and labour",null,"Per Acre",{"$f":"E63/C7","v":61.945451487834411},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"]
[null,null,null,"Per Hour",{"$f":"E63/E6","v":638.03815032469447},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"]
[null,"* The capital recovery method estimates the annual depreciation and interest costs. It combines depreciation and",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35-ft grain drill"]
[null,"interest costs in one calculation. To calculate the capital recovery costs, the capital recovery factor is multiplied by total",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"]
[null,"depreciation and adds the result of the trade-in value multiplied by the interest rate. Table 4 provides the 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,"20-ft presswheel drill"]
[null,"factors for selected combinations of years and interest rates.",null,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"]
[null,"** Trade-in value = purchase price – (purchase price x annual depreciation rate (from Table 3) x number of years owned).",null,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"]
[null,"*** Interest: Interest calculation is the average annual interest cost of the investment (yours and/or the lender’s) that is tied",null,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"]
[null,"up in the 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,"90-ft sprayer, self propelled"]
[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"]
[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,"13-ft rotary mower/conditioner"]
[null,"Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square baler"]
[null,"Fixed cost per acre",null,{"$f":"(E52+E21)/C7","v":26.080658533110551},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"]
[null,"Operating cost per acre",null,{"$f":"(E56+E26)/C7","v":25.649029126213591},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"]
[null,"Return to management and labour per acre",null,{"$f":"(E61+E62)/C7","v":10.215763828510273},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large size square baler"]
[null,"Total cost per acre",null,{"$f":"SUM(D76:D78)","v":61.945451487834418},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/wrapper"]
[null,"Fixed cost per hour",null,{"$f":"(E52+E21)/E6","v":268.63078289103868},null,null,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,"Operating cost per hour",null,{"$f":"(E56+E26)/E6","v":264.185},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,"Return to management and labour per hour",null,{"$f":"(E61+E62)/E6","v":105.2223674336558},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,"Total cost per hour",null,{"$f":"SUM(D80:D82)","v":638.03815032469447},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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grain head 25 ft"]
[null,"End of worksheet",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 35 ft"]

{"sheet":"Cost Charts","index":3,"n_rows":54,"n_cols":28,"rows_kept":54,"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,"PTO HP(1,2)","Acres/hour(2)","Litres/acre","Litres/hour(3)"]
[null,"2WD tractors",300,20,3.3,2.2000000000000002,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",75,2.8,6.5,18.3]
[null,"FWA tractors",450,15,4.4000000000000004,2.6,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",140,3,11.4,34.200000000000003]
[null,"4WD tractors",450,15,4.4000000000000004,2.5,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",250,5.6,10.9,61.1]
[null,"Self Propelled combines",250,12,5.6,2.5,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",140,9,3.8,34.200000000000003]
[null,"Headers, grain",250,15,4.4000000000000004,2.5,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",225,20.6,2.7,55]
[null,"Headers, corn",100,15,4.4000000000000004,2.8,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",270,29.1,2.2999999999999998,66]
[null,"Grain carts",250,20,3.3,2,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",155,9,4.2,37.9]
[null,"Plows, discs",100,20,3.3,1.5,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",240,12.6,4.7,58.6]
[null,"Vertical tillage",100,20,3.3,3.5,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",150,15.1,2.4,36.700000000000003]
[null,"Cultivators, hoes",200,20,3.3,1.5,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",225,15.3,3.6,55]
[null,"Harrows",200,25,2.7,0.5,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",110,6,4.5,26.9]
[null,"Drills",200,15,4.4000000000000004,3,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",155,9.6,3.9,37.9]
[null,"Row crop planters",100,10,6.7,4,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",190,19.600000000000001,2.4,46.4]
[null,"Self propelled high clearance sprayer",200,8,8.3000000000000007,3.5,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",270,27.2,2.4,66]
[null,"Mower/conditioner",150,15,4.4000000000000004,2.2999999999999998,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",370,39.200000000000003,2.2999999999999998,90.4]
[null,"Balers, round",100,15,4.4000000000000004,1.5,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",290,17.5,4,70.900000000000006]
[null,"Balers, large square",150,15,4.4000000000000004,1.7,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",95,7.6,3.1,23.2]
[null,"Balers, small square",100,20,3.3,1,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",140,15.3,2.2000000000000002,34.200000000000003]
[null,"Self propelled forage harvesters",400,10,6.7,8,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",155,20.399999999999999,1.9,37.9]
[null,"Manure spreaders",100,10,6.7,4.4000000000000004,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",75,6.4,2.9,18.3]
[null,"Source: Farm Machinery Custom and Rental Rate Guide, Saskatchewan Ministry of Agriculture, 2018–19.",null,null,null,null,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",155,15.3,2.5,37.9]
[null,null,null,null,null,null,null,"Source: Estimating Farm Machinery Costs, Edwards, William, Iowa State University, 2015.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16R – 30-in. minimum-till planter",225,20.399999999999999,2.7,55]
[null,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",140,11.7,2.9,34.200000000000003]
[null,null,null,null,null,null,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",225,16.3,3.4,55]
[null,null,null,null,null,null,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",75,5.0999999999999996,3.6,18.3]
[null,"EXAMPLE ","Accumulated Repair Cost Calculation ",null,null,null,null,"Purchase price",470000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20-ft presswheel drill",140,8.5,4,34.200000000000003]
[null,"New 375 HP Combine Cost","$660,000 = $478,000 (combine) + $ 122,000 (corn head) + $60,000 (grain head)",null,null,null,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",140,7,4.9000000000000004,34.200000000000003]
[null,"Estimated annual repair rates","2.5% combine",null,null,null,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",175,9.3000000000000007,4.5999999999999996,42.8]
[null,null,"2.8% corn head",null,null,null,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",95,49.6,0.5,23.2]
[null,"from Table 3","2.5% grain head",null,null,null,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.3,20.8]
[null,"Estimated annual repair costs","Combine: $478,000 x 2.5% for an average of $11,950/year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-ft mower conditioner",40,4.4000000000000004,2.2000000000000002,9.8000000000000007]
[null,null,"Corn head: $122,000 x 2.8% for an average of $3,416/year",null,null,null,null,"Capital recovery:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-ft rotary mower/conditioner",75,9.6999999999999993,1.9,18.3]
[null,null,"Grain head: $60,000 x 2.5% for an average of 1,500/year",null,null,null,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",40,4.4000000000000004,2.2000000000000002,9.8000000000000007]
[null,null,"Total annual repair costs = $11,950 + $3,416 + $1,500 = $16,866 per year",null,null,null,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",60,3,4.9000000000000004,14.7]
[null,"Used Machinery","When calculating the depreciation on used machinery, use the actual price paid ",null,null,null,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",60,4,3.7,14.7]
[null,null,"for the machine minus its expected trade-in or salvage value, divided by the ",null,null,null,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",140,16.3,2.1,34.200000000000003]
[null,null,"expected life of the machine on your farm. Increase repair rates to levels ",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/wrapper",60,3,4.9000000000000004,14.7]
[null,null,"appropriate for the age or number of hours on the machine. Expect to have ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-row forage harvester",140,1.4,24.4,34.200000000000003]
[null,null,"higher than normal repair expenses in the first year of ownership of a",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",625,5.0999999999999996,11.2,56.8]
[null,null," used machine as you bring it back into top operating shape",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large forage blower",60,"—","—",14.7]
[null,null,null,null,null,null,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,13.2,67.2]
[null,null,null,null,null,null,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,9,91.6]
[null,null,null,null,null,null,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,12.4,91.6]
[null,null,null,null,null,null,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,8.8000000000000007,91.6]
[null,"End of worksheet",null,null,null,null,null,"End of worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Power take off horsepower"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Source: Illinois Machinery Cost Estimates for 2019, University of Illinois, Department of Agricultural and Consumer Economics, 2019."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Source: Nebraska Tractor Test Laboratory, 2008–2017. Tractor fuel consumption results."]
[]
[]
[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"]

{"sheet":"Comparison","index":4,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,"Machinery Cost Comparison Calculator"]
[null,"Type of Machine"]
[null,null,"New","Used","Repair","Lease","Custom"]
[null,"New Price (or Value of your current)",175000,100000,35000,175000,0]
[null,"Value of the machine on future sale (end of lease)",{"$f":"C4*0.32","v":56000},25000,15000,65000]
[null,"Trade in Value of your current machine (or sale in cust. work)",35000,35000,0,35000,35000]
[null,"Life of the machine (years)",15,6,3,5,0]
[null,"Hours on machine when purchased",0,2000,2000,0]
[null,"Acres per Year",1200,1200,1200,1200,1200]
[null,"Hours per year / and Total Hours",{"$f":"C9/C12","v":285.71428571428572},{"$f":"D9/D12","v":285.71428571428572},{"$f":"E9/E12","v":285.71428571428572},{"$f":"F9/F12","v":285.71428571428572}]
[null,"Accumulated Total Hours over Life",{"$f":"C10*C7","v":4285.7142857142862},{"$f":"(D10*D7)+D8","v":3714.2857142857142},{"$f":"(E10*E7)+E8","v":2857.1428571428569},{"$f":"(F10*F7)+F8","v":1428.5714285714287}]
[null,"Rate of Work (acres per hour) Optional entry",4.2,4.2,4.2,4.2]
[null,null,"New","Used","Repair","Lease","Custom"]
[null,"Fuel Cost per litre",0.5,0.5,0.5,0.5,"Rate"]
[null,"Fuel Use per Hour (litres)",40,40,40,40,"per acre"]
[null,"Annual Repair Costs",{"$f":"C17/C7","v":1085.0000000000002},{"$f":"D17/D7","v":5250},{"$f":"E17/E7","v":7500},{"$f":"F17/F7","v":3255.0000000000005},34]
[null,"Total Repairs over machines life",{"$f":"C4*C18/100","v":16275.000000000002},31500,{"$f":"22500","v":22500},{"$f":"F4*F18/100","v":16275.000000000002}]
[null,"Repairs as a %  the purchase  price",9.3000000000000007,21,15,{"$f":"9.3","v":9.3000000000000007}]
[null,"Down Payment",5000,5000,0,5000]
[null,"Loan Amount Required",{"$f":"(C4-C6-C19)","v":135000},{"$f":"(D4-D6-D19)","v":60000}]
[null,"Interest Expense (total)",28618,12719]
[null,"Annual Loan Payments (or Lease)",40904,18179,0,29325]
[null,"Discount rate (if you put your money elsewhere)",0.06,0.06,0.06,0.06,0.06]
[null,"Annual Fixed Costs","New","Used","Repair","Lease","Custom"]
[null,"Average Depreciation per year",{"$f":"(C4-C5)/C7","v":7933.333333333333},{"$f":"(D4-D5)/D7","v":12500},{"$f":"(E4-E5)/E7","v":6666.666666666667},{"$f":"(F4-F5)/F7","v":22000}]
[null,"Interest on Your Investment (income for custom)",{"$f":"(C4+C6)/2*C23","v":6300},{"$f":"(D4+D6)/2*D23","v":4050},{"$f":"(E4+E6)/2*E23","v":1050},{"$f":"(F4+F6)/2*F23","v":6300},{"$f":"G23*G6","v":2100}]
[null,"Insurance and Housing",{"$f":"C4*0.015","v":2625},{"$f":"D4*0.015","v":1500},{"$f":"E4*0.015","v":525},{"$f":"F4*0.015","v":2625}]
[null,"Total Fixed Costs",{"$f":"SUM(C25:C27)","v":16858.333333333332},{"$f":"SUM(D25:D27)","v":18050},{"$f":"SUM(E25:E27)","v":8241.6666666666679},{"$f":"SUM(F25:F27)","v":30925}]
[null,"Annual Operating Costs"]
[null,"Fuel and Lubricants",{"$f":"C15*C10*C14*1.15","v":6571.4285714285716},{"$f":"D15*D10*D14*1.15","v":6571.4285714285716},{"$f":"E15*E10*E14*1.15","v":6571.4285714285716},{"$f":"F15*F10*F14*1.15","v":6571.4285714285716}]
[null,"Repairs",{"$f":"C16","v":1085.0000000000002},{"$f":"D16","v":5250},{"$f":"E16","v":7500},{"$f":"F16","v":3255.0000000000005}]
[null,"Labour",0,0,0,0]
[null,"Total Operating Costs",{"$f":"SUM(C30:C32)","v":7656.4285714285716},{"$f":"SUM(D30:D32)","v":11821.428571428572},{"$f":"SUM(E30:E32)","v":14071.428571428572},{"$f":"SUM(F30:F32)","v":9826.4285714285725}]
[null,"Total Annual Costs ",{"$f":"C33+C28","v":24514.761904761905},{"$f":"D33+D28","v":29871.428571428572},{"$f":"E33+E28","v":22313.09523809524},{"$f":"F33+F28","v":40751.428571428572},{"$f":"(G16*1200)-G26","v":38700}]
[null,"Total Annual Costs Per Acre",{"$f":"C34/C9","v":20.428968253968254},{"$f":"D34/D9","v":24.892857142857142},{"$f":"E34/E9","v":18.594246031746035},{"$f":"F34/F9","v":33.959523809523809},{"$f":"G34/G9","v":32.25}]
[]
[null,"Annual Cash Costs","New","Used","Repair","Lease","Custom"]
[null,"Annual Payments on Loan",{"$f":"C22","v":40904},{"$f":"D22","v":18179},{"$f":"E22","v":0},{"$f":"F22","v":29325}]
[null,"Down Payment X Interest Rate",{"$f":"C19*C23","v":300},{"$f":"D19*D23","v":300},{"$f":"E19*E23","v":0},{"$f":"F19*F23","v":300}]
[null,"Total Operating Costs",{"$f":"C33","v":7656.4285714285716},{"$f":"D33","v":11821.428571428572},{"$f":"E33","v":14071.428571428572},{"$f":"F33","v":9826.4285714285725}]
[null,"Total Pre Tax Cash Costs",{"$f":"SUM(C38:C40)","v":48860.428571428572},{"$f":"SUM(D38:D40)","v":30300.428571428572},{"$f":"SUM(E38:E40)","v":14071.428571428572},{"$f":"SUM(F38:F40)","v":39451.428571428572},{"$f":"G16*G9","v":40800}]
[null,"Cash Costs Per Acre",{"$f":"C41/C9","v":40.717023809523809},{"$f":"D41/D9","v":25.250357142857144},{"$f":"E41/E9","v":11.726190476190476},{"$f":"F41/F9","v":32.87619047619048},{"$f":"G16","v":34}]
[null,"After Tax Calculations","New","Used","Repair","Lease","Custom"]
[null,"Tax Rate ",0.41,0.41,0.41,0.41,0.41]
[null,"Capital Cost Allowance Rate",0.3,0.3,0.3]
[null,"Tax Deductable Expenses"]
[null,"Average Capital Cost Allowance per year",{"$f":"VLOOKUP(C7,$B$66:$H$81,3,FALSE)/C7","v":11599.409545275808},{"$f":"VLOOKUP(D7,$B$66:$H$81,5,FALSE)/D7","v":14285.675000000001},{"$f":"VLOOKUP(E7,$B$66:$H$81,7,FALSE)/E7","v":6807.5}]
[null,"Interest Expense per Year (average)",{"$f":"C21/C7","v":1907.8666666666666},{"$f":"D21/D7","v":2119.8333333333335},{"$f":"E21/E7","v":0},{"$f":"F21/F7","v":0}]
[null,"Fuel, lubricants and repair expenses",{"$f":"C30+C31","v":7656.4285714285716},{"$f":"D30+D31","v":11821.428571428572},{"$f":"E30+E31","v":14071.428571428572},{"$f":"F30+F31","v":9826.4285714285725},{"$f":"G30+G31","v":0}]
[null,"Lease Payments",null,null,null,{"$f":"F38","v":29325}]
[null,"Custom Work Expense",null,null,null,null,{"$f":"G16*G9","v":40800}]
[null,"Total Tax deductable expenses",{"$f":"SUM(C47:C51)","v":21163.704783371046},{"$f":"SUM(D47:D51)","v":28226.936904761907},{"$f":"SUM(E47:E51)","v":20878.928571428572},{"$f":"SUM(F47:F51)","v":39151.428571428572},{"$f":"SUM(G47:G51)","v":40800}]
[null,"Tax Reduction",{"$f":"C52*C44","v":8677.1189611821283},{"$f":"D52*D44","v":11573.044130952381},{"$f":"E52*E44","v":8560.3607142857145},{"$f":"F52*F44","v":16052.085714285713},{"$f":"G52*G44","v":16728}]
[null,"Per acre tax reduction",{"$f":"C53/C9","v":7.2309324676517734},{"$f":"D53/D9","v":9.6442034424603182},{"$f":"E53/E9","v":7.1336339285714283},{"$f":"F53/F9","v":13.376738095238094},{"$f":"G53/G9","v":13.94}]
[null,"After Tax Cost Per Acre",{"$f":"C42-C54","v":33.486091341872033},{"$f":"D42-D54","v":15.606153700396826},{"$f":"E42-E54","v":4.592556547619048},{"$f":"F42-F54","v":19.499452380952384},{"$f":"G42-G54","v":20.060000000000002}]
[]
[null,"CCA Calculations are below"]
[]
[]
[]
[]
[]
[]
[]
[null,"CCA Calculations"]
[null,"Start",{"$f":"+C4","v":175000},null,{"$f":"+D4","v":100000},null,{"$f":"+E4","v":35000}]
[null,1,{"$f":"C66-C83","v":148750},{"$f":"$C$66-C67","v":26250},{"$f":"E66-D83","v":85000},{"$f":"$E$66-E67","v":15000},{"$f":"G66-E83","v":29750},{"$f":"$G$66-G67","v":5250}]
[null,2,104125,{"$f":"$C$66-C68","v":70875},59500,{"$f":"$E$66-E68","v":40500},20825,{"$f":"$G$66-G68","v":14175}]
[null,3,72887.5,102112.5,41650,58350,14577.5,20422.5]
[null,4,51021.25,123978.75,29155,70845,10204.25,24795.75]
[null,5,35714.875,139285.125,20408.5,79591.5,7142.9750000000004,27857.025000000001]
[null,6,25000.412499999999,149999.58749999999,14285.95,85714.05,5000.0825000000004,29999.9175]
[null,7,17500.28875,157499.71124999999,10000.165000000001,89999.834999999992,3500.0577500000004,31499.94225]
[null,8,12250.202125,162749.79787499999,7000.1155000000008,92999.8845,2450.0404250000001,32549.959575000001]
[null,9,8575.1414875000009,166424.85851250001,4900.0808500000003,95099.919150000002,1715.0282975,33284.971702499999]
[null,10,6002.5990412500014,168997.40095874999,3430.056595,96569.943404999998,1200.5198082500001,33799.480191750001]
[null,11,{"$f":"C76-C93","v":4201.8193288750008},170798.18067112501,{"$f":"E76-D93","v":2401.0396165000002},97598.960383500002,{"$f":"G76-E93","v":840.36386577500002},34159.636134225002]
[null,12,2941.2735302125006,172058.72646978751,1680.72773155,98319.272268450004,588.25470604250006,34411.745293957501]
[null,13,2058.8914711487505,172941.10852885124,1176.5094120850001,98823.490587915003,411.77829422975003,34588.221705770251]
[null,14,1441.2240298041254,173558.77597019589,823.55658845950006,99176.443411540502,288.24480596082503,34711.755194039171]
[null,15,1008.8568208628878,173991.14317913711,576.48961192165007,99423.510388078343,201.77136417257753,34798.228635827421]
[null,"Deductions"]
[null,"Year 1",{"$f":"0.5*C45*C66","v":26250},{"$f":"0.5*D45*E66","v":15000},{"$f":"0.5*E45*G66","v":5250}]
[null,"Year 2",{"$f":"C45*C67","v":44625},{"$f":"D45*E67","v":25500},{"$f":"E45*G67","v":8925}]
[null,"Year 3",{"$f":"C45*C68","v":31237.5},{"$f":"D45*E68","v":17850},{"$f":"E45*G68","v":6247.5}]
[null,"Year 4",{"$f":"C45*C69","v":21866.25},{"$f":"D45*E69","v":12495},{"$f":"E45*G69","v":4373.25}]
[null,"Year 5",{"$f":"$C$45*C70","v":15306.375},{"$f":"D45*E70","v":8746.5},{"$f":"E45*G70","v":3061.2750000000001}]
[null,"Year 6",10714.4625,{"$f":"$C$45*E71","v":6122.55},{"$f":"$C$45*G71","v":2142.8924999999999}]
[null,"Year 7",7500.1237499999988,{"$f":"$C$45*E72","v":4285.7849999999999},{"$f":"$C$45*G72","v":1500.02475}]
[null,"Year 8",5250.0866249999999,{"$f":"$C$45*E73","v":3000.0495000000001},{"$f":"$C$45*G73","v":1050.017325}]
[null,"Year 9",3675.0606374999998,{"$f":"$C$45*E74","v":2100.0346500000001},{"$f":"$C$45*G74","v":735.01212750000002}]
[null,"Year 10",2572.54244625,{"$f":"$C$45*E75","v":1470.024255},{"$f":"$C$45*G75","v":514.50848925000003}]
[null,"Year 11",1800.7797123750004,{"$f":"$C$45*E76","v":1029.0169785000001},{"$f":"$C$45*G76","v":360.15594247500002}]
[null,"Year 12",1260.5457986625001,720.31188495000004,252.10915973249999]
[null,"Year 13",882.38205906375015,504.21831946499998,176.47641181275]
[null,"Year 14",617.6674413446251,352.9528236255,123.533488268925]
[null,"Year 15",432.36720894123761,247.06697653785,86.473441788247513]
[]
[null,"Total for 5 Years",{"$f":"SUM(C83:C87)","v":139285.125},{"$f":"SUM(D83:D87)","v":79591.5},{"$f":"SUM(E83:E87)","v":27857.025000000001}]
[null,"Average Deduction",{"$f":"C99/5","v":27857.025000000001},{"$f":"D99/5","v":15918.3},{"$f":"E99/5","v":5571.4050000000007}]

{"sheet":"Loan","index":5,"n_rows":373,"n_cols":14,"rows_kept":373,"cut":false,"hidden":false,"merged":[]}
[null,null,"Payment Schedule",null,null,null,null,"Interim Totals for Principal, Interest and Total Payments"]
[null,null,null,null,null,"    PAYMENT"]
["  LOAN AMOUNT      ($)",null,null,60000,null,{"$f":"IF(AND(AND(AND(AND(D5>=1,D6>=1),D7>=1),D3>=0),D4>=0),IF(D4=0,D3/D5/D6,((1+(D4/(D7*100)))^(D7/D6)-1)/(1-((1/(1+((1+(D4/(D7*100)))^(D7/D6)-1))^(D6*D5))))*D3),#VALUE!)","v":13882.439726022558},null,"Starting with payment number:",null,null,1]
["  ANNUAL INTEREST RATE %",null,null,5,null," Scheduled Interest",null,"and ending with payment number:",null,null,12]
["  LENGTH OF LOAN (YEARS)",null,null,5,null,{"$f":"F3*D5*D6-D3","v":9412.1986301127909},null,null,"August 6, 1997 Release 1"]
["  NO. OF PAYMENTS PER YEAR",null,null,1,null,"Actual Interest",null,null,"The total payments are:   $",null,18113.52]
["  COMPOUNDING PERIODS/YEAR",null,null,2,null,"with optional payments",null,null,"The total interest is:          $",null,10291.14]
[{"$f":"IF(D6<1,\"     WARNING: PAYMENTS PER YEAR SHOULD BE AT LEAST 1 \",IF(D4<0,\"        Warning: Interest rate must be at least 0\",\"\"))","v":""},null,null,null,null,{"$f":"IF(D5*D6>400,\"Can not calculate\",SUM(D14:D413))","v":9412.1899999999987},null,null,"The total principal is:        $",null,7822.38]
[{"$f":"IF(D5<1,\"  WARNING: LENGTH IS LESS THAN ONE YEAR: DOUBLE CHECK INPUT\",IF(D3<=0,\"       Warning: Loan Amount must be greater than 0\",\"\"))","v":""},null,null,null,null,{"$f":"IF(D5*D6>400,\"more than 400 payments\",\"\")","v":""},null,{"$f":"IF(K6<=0,\"Please correct your choice of payment numbers \",\"\")","v":""}]
[{"$f":"IF(D7<1,\"  WARNING: NUMBER OF COMPOUNDING PERIODS SHOULD BE AT LEAST ONE PER YEAR\",\"\")","v":""}]
[null,"Beginning","Scheduled","Interest"," Principal","Optional","Closing",null,"Payments","Interest ","Principal"]
["Pmt"," Balance","Payment","Portion","Portion"," Payments","Balance","Pmt"," to date","to date","to Date"]
[null,120000,null,null,null,null,120000,0,0,0,0]
[1,{"$f":"D3","v":60000},{"$f":"ROUND(IF(B14+D14<$F$3,B14+D14,$F$3),2)","v":13882.44},{"$f":"ROUND(((1+(D4/($D$7*100)))^($D$7/$D$6)-1)*B14,2)","v":3037.5},{"$f":"C14-D14+F14","v":10844.94},0,{"$f":"ROUND(B14-E14,2)","v":49155.06},{"$f":"A14","v":1},{"$f":"C14+F14","v":13882.44},{"$f":"D14","v":3037.5},{"$f":"I14-J14","v":10844.94}]
[{"$f":"IF(G14=0,\"\",1+A14)","v":2},{"$f":"IF(G14=0,\"\",ROUND(G14,2))","v":49155.06},{"$f":"IF(G14=0,\"\",ROUND(IF(B15+D15<$F$3,B15+D15,$F$3),2))","v":13882.44},{"$f":"IF(G14=0,\"\",ROUND(((1+($D$4/($D$7*100)))^($D$7/$D$6)-1)*B15,2))","v":2488.4699999999998},{"$f":"IF(G14=0,\"\",C15-D15+F15)","v":11393.970000000001},0,{"$f":"IF(G14=0,\"\",ROUND(B15-E15,2))","v":37761.089999999997},2,{"$f":"IF(G14=0,\"\",C15+F15+I14)","v":27764.880000000001},{"$f":"IF(G14=0,\"\",J14+D15)","v":5525.9699999999993},{"$f":"IF(G14=0,\"\",I15-J15)","v":22238.910000000003}]
[{"$f":"IF(G15=0,\"\",1+A15)","v":3},{"$f":"IF(G15=0,\"\",ROUND(G15,2))","v":37761.089999999997},13882.44,1911.66,{"$f":"IF(G15=0,\"\",C16-D16+F16)","v":11970.78},0,{"$f":"IF(G15=0,\"\",ROUND(B16-E16,2))","v":25790.31},3,41647.32,7437.6299999999992,34209.69]
[4,25790.31,13882.44,1305.6300000000001,12576.810000000001,0,13213.5,4,55529.760000000002,8743.2599999999984,46786.5]
[5,13213.5,13882.43,668.93,13213.5,0,0,5,69412.19,9412.1899999999987,60000]
["","","","","",0,"","","","",""]
[{"$f":"IF(G19=0,\"\",1+A19)","v":""},"","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["",{"$f":"IF(G34=0,\"\",ROUND(G34,2))","v":""},"","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
[{"$f":"IF(G42=0,\"\",1+A42)","v":""},"","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","",{"$f":"IF(G46=0,\"\",C47+F47+I46)","v":""},{"$f":"IF(G46=0,\"\",J46+D47)","v":""},{"$f":"IF(G46=0,\"\",I47-J47)","v":""}]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,"","","","",""]
["","","","","",0,{"$f":"IF(G72=0,\"\",ROUND(B73-E73,2))","v":""},"","","",""]
["","","","","",0,"",null,null,null,{"$f":"A74","v":""},{"$f":"IF(G73=0,\"\",C74+F74+L73)","v":""},{"$f":"IF(G73=0,\"\",M73+D74)","v":""},{"$f":"IF(G73=0,\"\",L74-M74)","v":""}]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","",{"$f":"IF(G78=0,\"\",ROUND(IF(B79+D79<$F$3,B79+D79,$F$3),2))","v":""},{"$f":"IF(G78=0,\"\",ROUND(((1+($D$4/($D$7*100)))^($D$7/$D$6)-1)*B79,2))","v":""},"",0,"",null,null,null,"","","",""]
[{"$f":"IF(G79=0,\"\",1+A79)","v":""},{"$f":"IF(G79=0,\"\",ROUND(G79,2))","v":""},"","",{"$f":"IF(G79=0,\"\",C80-D80+F80)","v":""},0,{"$f":"IF(G79=0,\"\",ROUND(B80-E80,2))","v":""},null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,{"$f":"A138","v":""},{"$f":"IF(G137=0,\"\",C138+F138+L137)","v":""},{"$f":"IF(G137=0,\"\",M137+D138)","v":""},{"$f":"IF(G137=0,\"\",L138-M138)","v":""}]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","",{"$f":"IF(G142=0,\"\",ROUND(IF(B143+D143<$F$3,B143+D143,$F$3),2))","v":""},{"$f":"IF(G142=0,\"\",ROUND(((1+($D$4/($D$7*100)))^($D$7/$D$6)-1)*B143,2))","v":""},"",0,"",null,null,null,"","","",""]
[{"$f":"IF(G143=0,\"\",1+A143)","v":""},{"$f":"IF(G143=0,\"\",ROUND(G143,2))","v":""},"","",{"$f":"IF(G143=0,\"\",C144-D144+F144)","v":""},0,{"$f":"IF(G143=0,\"\",ROUND(B144-E144,2))","v":""},null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,{"$f":"A202","v":""},{"$f":"IF(G201=0,\"\",C202+F202+L201)","v":""},{"$f":"IF(G201=0,\"\",M201+D202)","v":""},{"$f":"IF(G201=0,\"\",L202-M202)","v":""}]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","",{"$f":"IF(G206=0,\"\",ROUND(IF(B207+D207<$F$3,B207+D207,$F$3),2))","v":""},{"$f":"IF(G206=0,\"\",ROUND(((1+($D$4/($D$7*100)))^($D$7/$D$6)-1)*B207,2))","v":""},"",0,"",null,null,null,"","","",""]
[{"$f":"IF(G207=0,\"\",1+A207)","v":""},{"$f":"IF(G207=0,\"\",ROUND(G207,2))","v":""},"","",{"$f":"IF(G207=0,\"\",C208-D208+F208)","v":""},0,{"$f":"IF(G207=0,\"\",ROUND(B208-E208,2))","v":""},null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,{"$f":"A266","v":""},{"$f":"IF(G265=0,\"\",C266+F266+L265)","v":""},{"$f":"IF(G265=0,\"\",M265+D266)","v":""},{"$f":"IF(G265=0,\"\",L266-M266)","v":""}]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","",{"$f":"IF(G270=0,\"\",ROUND(IF(B271+D271<$F$3,B271+D271,$F$3),2))","v":""},{"$f":"IF(G270=0,\"\",ROUND(((1+($D$4/($D$7*100)))^($D$7/$D$6)-1)*B271,2))","v":""},"",0,"",null,null,null,"","","",""]
[{"$f":"IF(G271=0,\"\",1+A271)","v":""},{"$f":"IF(G271=0,\"\",ROUND(G271,2))","v":""},"","",{"$f":"IF(G271=0,\"\",C272-D272+F272)","v":""},0,{"$f":"IF(G271=0,\"\",ROUND(B272-E272,2))","v":""},null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,{"$f":"A330","v":""},{"$f":"IF(G329=0,\"\",C330+F330+L329)","v":""},{"$f":"IF(G329=0,\"\",M329+D330)","v":""},{"$f":"IF(G329=0,\"\",L330-M330)","v":""}]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","",{"$f":"IF(G334=0,\"\",ROUND(IF(B335+D335<$F$3,B335+D335,$F$3),2))","v":""},{"$f":"IF(G334=0,\"\",ROUND(((1+($D$4/($D$7*100)))^($D$7/$D$6)-1)*B335,2))","v":""},"",0,"",null,null,null,"","","",""]
[{"$f":"IF(G335=0,\"\",1+A335)","v":""},{"$f":"IF(G335=0,\"\",ROUND(G335,2))","v":""},"","",{"$f":"IF(G335=0,\"\",C336-D336+F336)","v":""},0,{"$f":"IF(G335=0,\"\",ROUND(B336-E336,2))","v":""},null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]
["","","","","",0,"",null,null,null,"","","",""]

{"sheet":"Lease Comparison","index":6,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Leasing vs Buying"]
[null,"Lease Option"]
[null,"Cost of Equipment",120000]
[null,"Total Lease Payments per Year",18507]
[null,"Length of Lease",5]
[null,"Total Payments on Lease",{"$f":"C5*C6","v":92535},"(A)"]
[null,"Down Payment or Trade",25000]
[null,"Total Cash Invested in Lease",{"$f":"C7+C8","v":117535},null,"    To read the Leasing Factsheet "]
[null,"Amount Tax Reduced @ 41% tax rate (.41 x line  A)",{"$f":"0.41*C7","v":37939.35},null,"    click on the link below"]
[null,"Total After Tax Cost of Lease",{"$f":"C9-C10","v":79595.649999999994},null,"http://www.omafra.gov.on.ca/english/busdev/facts/13-059.htm "]
[null,"Purchase Option"]
[null,"Cost of Equipment",120000,"(B)"]
[null,"Down Payment of Trade ",25000,"(C)"]
[null,"Loan Amount",{"$f":"C13-C14","v":95000}]
[null,"Total Loan Payments - 5 years @ 6%",113280,"(D)"]
[null,"Total Loan Payments per year",22656]
[null,"Depreciated Value of equipment at the end of 5 years (42%)",50000,"(E)"]
[null,"FMV of asset at the end of 4 years",50000]
[null,"Amount left to be paid on loan at year 4"]
[null,"Total Cash Investment in Purchase ( C+D-E )",{"$f":"C14+C16-C19","v":88280}]
[null,"Amount of tax reduced @.41 tax rate"]
[null,"              Interest ( $16,956  x .41 )",{"$f":"(C16-C15)*0.41","v":7494.7999999999993}]
[null,"              Depreciation  ( B - E  x .41 )",{"$f":"(C13-C18)*0.41","v":28700}]
[null,"Recapture on equipment if sold at the end of 4th year",{"$f":"C19-C18","v":0}]
[null,"             Tax on recapture @ 41% tax rate",{"$f":"0.41*C25","v":0}]
[null,"Total After Tax Cost of Purchase",{"$f":"C21-C23-C24+C26","v":52085.2}]
[]
[null,"Average Increased Cash Flow per year by Leasing ",{"$f":"C17-C5","v":4149}]
[null,"Average Cost Saving per year on Purchasing ",{"$f":"(C11-C27)/C6","v":5502.0899999999992}]