{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["SYD","Manual"],"read":"whole","date_system":"1900"}

{"sheet":"SYD","index":0,"n_rows":17,"n_cols":3,"rows_kept":17}
["Initial Cost",500000]
["Salvage Value",40000]
["Life",12]
[]
["Year","Depreciation","Remaining Value"]
[1,{"$f":"SYD($B$1,$B$2,$B$3,A6)","v":{"v":70769.23076923077,"d":"$70,769.23"}},{"$f":"B1-B6","v":{"v":429230.76923076925,"d":"$429,230.77"}}]
[2,{"$f":"SYD($B$1,$B$2,$B$3,A7)","v":{"v":64871.794871794875,"d":"$64,871.79"}},{"$f":"C6-B7","v":{"v":364358.9743589744,"d":"$364,358.97"}}]
[3,{"v":58974.35897435898,"d":"$58,974.36"},{"$f":"C7-B8","v":{"v":305384.6153846154,"d":"$305,384.62"}}]
[4,{"v":53076.92307692308,"d":"$53,076.92"},{"v":252307.6923076923,"d":"$252,307.69"}]
[5,{"v":47179.48717948718,"d":"$47,179.49"},{"v":205128.20512820513,"d":"$205,128.21"}]
[6,{"v":41282.05128205128,"d":"$41,282.05"},{"v":163846.15384615384,"d":"$163,846.15"}]
[7,{"v":35384.61538461538,"d":"$35,384.62"},{"v":128461.53846153847,"d":"$128,461.54"}]
[8,{"v":29487.17948717949,"d":"$29,487.18"},{"v":98974.35897435898,"d":"$98,974.36"}]
[9,{"v":23589.74358974359,"d":"$23,589.74"},{"v":75384.61538461539,"d":"$75,384.62"}]
[10,{"v":17692.30769230769,"d":"$17,692.31"},{"v":57692.3076923077,"d":"$57,692.31"}]
[11,{"v":11794.871794871795,"d":"$11,794.87"},{"v":45897.435897435906,"d":"$45,897.44"}]
[12,{"v":5897.4358974358975,"d":"$5,897.44"},{"v":40000.00000000001,"d":"$40,000.00"}]

{"sheet":"Manual","index":1,"n_rows":19,"n_cols":4,"rows_kept":19}
["Initial Cost",500000]
["Salvage Value",40000]
["Life",12]
["Depreciation Base",{"$f":"B1-B2","v":460000}]
["Sum of Years",{"$f":"SUM(A8:A19)","v":78}]
[]
["Year","Depreciation Rate","Depreciation","Remaining Value"]
[1,{"$f":"(13-A8)/$B$5","v":{"v":0.15384615384615385,"d":"15%"}},{"$f":"$B$4*B8","v":{"v":70769.23076923078,"d":"$70,769.23"}},{"$f":"B1-C8","v":{"v":429230.76923076925,"d":"$429,230.77"}}]
[2,{"$f":"(13-A9)/$B$5","v":{"v":0.14102564102564102,"d":"14%"}},{"$f":"$B$4*B9","v":{"v":64871.794871794875,"d":"$64,871.79"}},{"$f":"D8-C9","v":{"v":364358.9743589744,"d":"$364,358.97"}}]
[3,{"v":0.1282051282051282,"d":"13%"},{"v":58974.35897435897,"d":"$58,974.36"},{"$f":"D9-C10","v":{"v":305384.6153846154,"d":"$305,384.62"}}]
[4,{"v":0.11538461538461539,"d":"12%"},{"v":53076.92307692308,"d":"$53,076.92"},{"v":252307.6923076923,"d":"$252,307.69"}]
[5,{"v":0.10256410256410256,"d":"10%"},{"v":47179.48717948718,"d":"$47,179.49"},{"v":205128.20512820513,"d":"$205,128.21"}]
[6,{"v":0.08974358974358974,"d":"9%"},{"v":41282.05128205128,"d":"$41,282.05"},{"v":163846.15384615384,"d":"$163,846.15"}]
[7,{"v":0.07692307692307693,"d":"8%"},{"v":35384.61538461539,"d":"$35,384.62"},{"v":128461.53846153845,"d":"$128,461.54"}]
[8,{"v":0.0641025641025641,"d":"6%"},{"v":29487.179487179485,"d":"$29,487.18"},{"v":98974.35897435897,"d":"$98,974.36"}]
[9,{"v":0.05128205128205128,"d":"5%"},{"v":23589.74358974359,"d":"$23,589.74"},{"v":75384.61538461538,"d":"$75,384.62"}]
[10,{"v":0.038461538461538464,"d":"4%"},{"v":17692.307692307695,"d":"$17,692.31"},{"v":57692.30769230768,"d":"$57,692.31"}]
[11,{"v":0.02564102564102564,"d":"3%"},{"v":11794.871794871795,"d":"$11,794.87"},{"v":45897.435897435884,"d":"$45,897.44"}]
[12,{"v":0.01282051282051282,"d":"1%"},{"v":5897.4358974358975,"d":"$5,897.44"},{"v":39999.999999999985,"d":"$40,000.00"}]