{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instruction","Operating Lease ","Finance Lease","Outright Purchase"],"read":"whole","date_system":"1900"}

{"sheet":"Instruction","index":0,"n_rows":7,"n_cols":1,"rows_kept":7}
[]
["For Operating Lease"]
[]
[]
[]
[]
["Finance lease"]

{"sheet":"Operating Lease ","index":1,"n_rows":21,"n_cols":8,"rows_kept":21,"merged":[[7,1,7,3]]}
[{"$nulls":5},{"v":3000000,"d":"3,000,000.00"}]
["Period","Rental Fee Per Month","Rental Fee Per Year","Maitenance and Support - Per Year","Total","Average Usage @ 3m printouts","Total Price"]
["Year 1",{"v":10000,"d":"R10,000.00"},{"$f":"B3*12","v":{"v":120000,"d":"R120,000.00"}},{"$f":"C3*0.2","v":{"v":24000,"d":"R24,000.00"}},{"$f":"SUM(C3+D3)","v":{"v":144000,"d":"R144,000.00"}},{"$f":"$F$1*B21","v":{"v":1849830.6274414063,"d":"1,849,830.63"}},{"$f":"SUM(E3:F3)","v":{"v":1993830.6274414063,"d":"R1,993,830.63"}}]
["Year 2",{"v":11000,"d":"11,000.00"},{"$f":"B4*12","v":{"v":132000,"d":"R132,000.00"}},{"$f":"C4*0.2","v":{"v":26400,"d":"R26,400.00"}},{"$f":"SUM(C4+D4)","v":{"v":158400,"d":"R158,400.00"}},{"$f":"$F$1*C21","v":{"v":1942322.1588134768,"d":"1,942,322.16"}},{"$f":"SUM(E4:F4)","v":{"v":2100722.1588134766,"d":"R2,100,722.16"}}]
["Year 3",{"v":12000,"d":"12,000.00"},{"v":144000,"d":"R144,000.00"},{"v":28800,"d":"R28,800.00"},{"v":172800,"d":"R172,800.00"},{"$f":"$F$1*D21","v":{"v":2039438.2667541506,"d":"2,039,438.27"}},{"v":2212238.2667541504,"d":"R2,212,238.27"}]
["Total",{"$f":"SUM(B3:B5)","v":{"v":33000,"d":"R33,000.00"}},{"$f":"SUM(C3:C5)","v":{"v":396000,"d":"R396,000.00"}},{"v":79200,"d":"R79,200.00"},{"v":475200,"d":"R475,200.00"},{"v":5831591.053009033,"d":"R5,831,591.05"},{"v":6306791.053009033,"d":"R6,306,791.05"}]
[]
["Usage Fee","Color printer"]
[null,"Year 1","Year 2","Year 3"]
["Usage Bracket","Rate Per Page","Rate Per Page","Rate Per Page"]
[{"$nulls":6},{"v":13000000,"d":"13,000,000.00"}]
["0 - 50 000",{"v":1.5,"d":"1.50"},{"$f":"B12*1.05","v":{"v":1.5750000000000002,"d":"1.58"}},{"$f":"C12*1.05","v":{"v":1.6537500000000003,"d":"1.65"}},{"v":50000,"d":"50,000.00"},{"$f":"E12*12","v":{"v":600000,"d":"600,000.00"}},{"$f":"F12/$G$11","v":{"v":0.046153846153846156,"d":"5%"}}]
["50 001 - 75 000",{"$f":"B12*0.75","v":{"v":1.125,"d":"1.13"}},{"$f":"B13*1.05","v":{"v":1.1812500000000001,"d":"1.18"}},{"v":1.2403125000000002,"d":"1.24"},{"$f":"E12+25000","v":{"v":75000,"d":"75,000.00"}},{"$f":"E13*12","v":{"v":900000,"d":"900,000.00"}},{"$f":"F13/$G$11","v":{"v":0.06923076923076923,"d":"7%"}},{"$f":"SUM(E13-E12)/E12","v":{"v":0.5,"d":"50%"}}]
["75 001 - 100 000",{"$f":"B13*0.75","v":{"v":0.84375,"d":"0.84"}},{"$f":"B14*1.05","v":{"v":0.8859375,"d":"0.89"}},{"v":0.9302343750000001,"d":"0.93"},{"$f":"E13+25000","v":{"v":100000,"d":"100,000.00"}},{"v":1200000,"d":"1,200,000.00"},{"v":0.09230769230769231,"d":"9%"}]
["100 001 - 125 000",{"v":0.6328125,"d":"0.63"},{"$f":"B15*1.05","v":{"v":0.664453125,"d":"0.66"}},{"v":0.69767578125,"d":"0.70"},{"v":125000,"d":"125,000.00"},{"v":1500000,"d":"1,500,000.00"},{"v":0.11538461538461539,"d":"12%"}]
["125 001 - 150 000",{"v":0.474609375,"d":"0.47"},{"$f":"B16*1.05","v":{"v":0.49833984375,"d":"0.50"}},{"v":0.5232568359375,"d":"0.52"},{"v":150000,"d":"150,000.00"},{"v":1800000,"d":"1,800,000.00"},{"v":0.13846153846153847,"d":"14%"}]
["175 001 - 200 000",{"v":0.35595703125,"d":"0.36"},{"$f":"B17*1.05","v":{"v":0.3737548828125,"d":"0.37"}},{"v":0.39244262695312504,"d":"0.39"},{"v":175000,"d":"175,000.00"},{"v":2100000,"d":"2,100,000.00"},{"v":0.16153846153846155,"d":"16%"}]
["200 001 - 225 000",{"v":0.2669677734375,"d":"0.27"},{"$f":"B18*1.05","v":{"v":0.280316162109375,"d":"0.28"}},{"v":0.29433197021484375,"d":"0.29"},{"v":200000,"d":"200,000.00"},{"v":2400000,"d":"2,400,000.00"},{"v":0.18461538461538463,"d":"18%"}]
["225 001 - 250 000",{"v":0.200225830078125,"d":"0.20"},{"$f":"B19*1.05","v":{"v":0.21023712158203126,"d":"0.21"}},{"v":0.22074897766113283,"d":"0.22"},{"v":225000,"d":"225,000.00"},{"v":2700000,"d":"2,700,000.00"},{"v":0.2076923076923077,"d":"21%"}]
["225 001 >",{"v":0.15016937255859375,"d":"0.15"},{"$f":"B20*1.05","v":{"v":0.15767784118652345,"d":"0.16"}},{"v":0.16556173324584963,"d":"0.17"},{"v":250000,"d":"250,000.00"},{"v":3000000,"d":"3,000,000.00"},{"v":0.23076923076923078,"d":"23%"}]
["Average Usage fee",{"$f":"AVERAGE(B12:B20)","v":{"v":0.6166102091471354,"d":"0.62"}},{"$f":"AVERAGE(C12:C20)","v":{"v":0.6474407196044922,"d":"0.65"}},{"v":0.6798127555847169,"d":"0.68"}]

{"sheet":"Finance Lease","index":2,"n_rows":51,"n_cols":6,"rows_kept":51}
["Capital",0,"Client Input"]
["Interest rate",{"v":0,"d":"0.00%"},"Client Input"]
["Term",3]
["Payment",{"$f":"-ROUND(PMT(B2/12,B3*12,B1),2)","v":{"v":0,"d":"R0.00"}}]
[]
["Summary of Amortisation Table",{"$nulls":3},"Client Input"]
["Period","Capital","Interest","Payment","Maitenance and Support Per Year","Total"]
["Year 1",{"$f":"SUM(B16:B27)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(C16:C27)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},null,{"$f":"SUM(B8:C8)+E8","v":{"v":0,"d":"R0.00"}}]
["Year 2",{"$f":"SUM(B28:B39)","v":0},{"$f":"SUM(C28:C39)","v":0},0,null,{"$f":"SUM(B9:C9)+E9","v":{"v":0,"d":"R0.00"}}]
["Year 3",{"$f":"SUM(B40:B51)","v":0},{"$f":"SUM(C40:C51)","v":0},0,null,{"v":0,"d":"R0.00"}]
["Total",{"$f":"SUM(B8:B10)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(C8:C10)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"$f":"SUM(E8:E10)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F8:F10)","v":{"v":0,"d":"R0.00"}}]
[]
["Detail Amortisation Table"]
["Period","Principal","Interest","Payment","Balance"]
[0,{"$nulls":3},{"$f":"B1","v":0}]
[1,{"$f":"D16-C16","v":{"v":0,"d":"R0.00"}},{"$f":"ROUND(E15*$B$2/12,2)","v":0},{"$f":"$B$4","v":{"v":0,"d":"R0.00"}},{"$f":"E15-B16","v":0}]
[2,{"$f":"D17-C17","v":0},{"$f":"ROUND(E16*$B$2/12,2)","v":0},{"$f":"$B$4","v":{"v":0,"d":"R0.00"}},{"$f":"E16-B17","v":0}]
[3,0,0,{"v":0,"d":"R0.00"},0]
[4,0,0,{"v":0,"d":"R0.00"},0]
[5,0,0,{"v":0,"d":"R0.00"},0]
[6,0,0,{"v":0,"d":"R0.00"},0]
[7,0,0,{"v":0,"d":"R0.00"},0]
[8,0,0,{"v":0,"d":"R0.00"},0]
[9,0,0,{"v":0,"d":"R0.00"},0]
[10,0,0,{"v":0,"d":"R0.00"},0]
[11,0,0,{"v":0,"d":"R0.00"},0]
[12,0,0,{"v":0,"d":"R0.00"},0]
[13,0,0,{"v":0,"d":"R0.00"},0]
[14,0,0,{"v":0,"d":"R0.00"},0]
[15,0,0,{"v":0,"d":"R0.00"},0]
[16,0,0,{"v":0,"d":"R0.00"},0]
[17,0,0,{"v":0,"d":"R0.00"},0]
[18,0,0,{"v":0,"d":"R0.00"},0]
[19,0,0,{"v":0,"d":"R0.00"},0]
[20,0,0,{"v":0,"d":"R0.00"},0]
[21,0,0,{"v":0,"d":"R0.00"},0]
[22,0,0,{"v":0,"d":"R0.00"},0]
[23,0,0,{"v":0,"d":"R0.00"},0]
[24,0,0,{"v":0,"d":"R0.00"},0]
[25,0,0,{"v":0,"d":"R0.00"},0]
[26,0,0,{"v":0,"d":"R0.00"},0]
[27,0,0,{"v":0,"d":"R0.00"},0]
[28,0,0,{"v":0,"d":"R0.00"},0]
[29,0,0,{"v":0,"d":"R0.00"},0]
[30,0,0,{"v":0,"d":"R0.00"},0]
[31,0,0,{"v":0,"d":"R0.00"},0]
[32,0,0,{"v":0,"d":"R0.00"},0]
[33,0,0,{"v":0,"d":"R0.00"},0]
[34,0,0,{"v":0,"d":"R0.00"},0]
[35,0,0,{"v":0,"d":"R0.00"},0]
[36,0,0,{"v":0,"d":"R0.00"},0]

{"sheet":"Outright Purchase","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}