{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Variables"]
["MG EV Excite",null,"Unit",null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15"]
["Drive away new car price",39000,"$"]
["GST component of new car",3900,"$","Licensing costs",815,815,815,815,815,815,815,815,815,815,815,815,815,815,815,815]
["Stamp duty component",1891,"$","Service costs",{"$f":"$B$7","v":165},{"$f":"$B$7","v":165},165,165,165,165,165,165,165,165,165,165,165,165,165,165]
["Annual licensing costs",805,"$","Electricity costs",{"$f":"$B$10*$B$9*$B$8/100","v":176.8},176.8,176.8,176.8,176.8,176.8,176.8,176.8,176.8,176.8,176.8,176.8,176.8,176.8,176.8,176.8]
["Annual service costs",165,"$","GST on Electricity",{"$f":"0.1*E6","v":17.680000000000003},{"$f":"0.1*F6","v":17.680000000000003},17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003,17.680000000000003]
["Annual km",13000,"km p.a.","RUC costs",{"$f":"$B$11*$B$8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Efficiency of EV",17,"kWh/100 km","Annual spend",{"$f":"SUM(E4:E8)","v":1174.48},1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48,1174.48]
["Retail price of electricity",0.08,"$/kWh","Cumulative spend EV",{"$f":"B3+E9","v":40174.480000000003},{"$f":"E10+F9","v":41348.960000000006},{"$f":"F10+G9","v":42523.44000000001},43697.920000000013,44872.400000000016,46046.880000000019,47221.360000000022,48395.840000000026,49570.320000000029,50744.800000000032,51919.280000000035,53093.760000000038,54268.240000000042,55442.720000000045,56617.200000000048,57791.680000000051]
["Road user charge (flat)",0,"$ /km","Annual gov. Take",{"$f":"E8+E4","v":815},815,815,815,815,815,815,815,815,815,815,815,815,815,815,815]
[null,null,null,"Cumulative gov. take EV",{"$f":"$B$4+$B$5","v":5791},{"$f":"E12+F11+F7","v":6623.68},{"$f":"F12+G11+G7","v":7456.3600000000006},8289.0400000000009,9121.7200000000012,9954.4000000000015,10787.080000000002,11619.760000000002,12452.440000000002,13285.120000000003,14117.800000000003,14950.480000000003,15783.160000000003,16615.840000000004,17448.520000000004,18281.200000000004]
[]
["Your ICE car",null,null,null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15"]
["Drive away new car price",32000,"$","Licensing costs",{"$f":"$B$18","v":805},{"$f":"$B$18","v":805},805,805,805,805,805,805,805,805,805,805,805,805,805,805]
["GST component of new car",3200,"$","Service costs",{"$f":"$B$19","v":300},{"$f":"$B$19","v":300},300,300,300,300,300,300,300,300,300,300,300,300,300,300]
["Stamp duty component",1000,"$","Fuel costs",{"$f":"$B$21*$B$20*$B$22/100","v":1645.8},1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8,1645.8]
["Annual licensing costs",805,"$","GST on fuel",{"$f":"0.1*E17","v":164.58},{"$f":"0.1*F17","v":164.58},164.58,164.58,164.58,164.58,164.58,164.58,164.58,164.58,164.58,164.58,164.58,164.58,164.58,164.58]
["Annual service costs",300,"$","RUC costs",{"$f":"$B$23*$B$20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Annual km",13000,"km p.a.","Annual spend",{"$f":"SUM(E15:E19)","v":2915.38},2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38,2915.38]
["Efficiency of ICE",6,"l/100 km","Cumulative spend ICE",{"$f":"B15+E20","v":34915.379999999997},{"$f":"E21+F20","v":37830.759999999995},{"$f":"F21+G20","v":40746.139999999992},43661.51999999999,46576.899999999987,49492.279999999984,52407.659999999982,55323.039999999979,58238.419999999976,61153.799999999974,64069.179999999971,66984.559999999969,69899.939999999973,72815.319999999978,75730.699999999983,78646.079999999987]
["Retail price of unleaded",2.11,"$ per litre","Fuel excise Take",{"$f":"$B$21*$B$20/100*0.423","v":329.94},329.94,329.94,329.94,329.94,329.94,329.94,329.94,329.94,329.94,329.94,329.94,329.94,329.94,329.94,329.94]
["Road user charge (flat)",0,"$ /km","Annual gov. Take",{"$f":"E15+E19+E22","v":1134.94},1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94,1134.94]
[null,null,null,"Cumulative gov. take ICE",{"$f":"$B$16+$B$17+E23","v":5334.9400000000005},{"$f":"E24+F23+F18","v":6634.4600000000009},{"$f":"F24+G23+G18","v":7933.9800000000014},9233.5000000000018,10533.020000000002,11832.540000000003,13132.060000000003,14431.580000000004,15731.100000000004,17030.620000000006,18330.140000000007,19629.660000000007,20929.180000000008,22228.700000000008,23528.220000000008,24827.740000000009]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}