{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Straight line depreciation","VBA","Depreciated Cost"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Overview","index":0,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,7],[4,4,4,5],[4,6,4,7]]}
["Excel SLN Function"]
[null,"returns the straight-line depreciation of an asset for one period. "]
[null,"=SLN(cost,salvage,life)"]
[]
[null,"Asset","Initial Cost","Salvage","Life ",null,"Depreciation"]
[null,"A",100000,20000,5,"Years",{"$f":"SLN(C6,D6,E6)","v":16000},"per year"]
[null,"B",80000,10000,7,"Years",{"$f":"SLN(C7,D7,E7)","v":10000},"per year"]
[null,"C",20000,2000,10,"Months",1800,"per month"]
[]
[]
[null,"Output","Formula"]
[null,{"$f":"G6","v":16000},{"$f":"_xlfn.FORMULATEXT(G6)","v":"=SLN(C6,D6,E6)"}," //straight line depreciation of asset A is $16000 per year"]
[null,{"$f":"G7","v":10000},{"$f":"_xlfn.FORMULATEXT(G7)","v":"=SLN(C7,D7,E7)"}," //straight line depreciation of asset B is $10000 per year"]
[null,{"$f":"G8","v":1800},{"$f":"_xlfn.FORMULATEXT(G8)","v":"=SLN(C8,D8,E8)"}," //straight line depreciation of asset C is  $1800 per month"]

{"sheet":"Straight line depreciation","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel SLN Function"]
[]
[]
[null,"Initial Cost",150000]
[null,"Salvage",10000]
[null,"Life (years)",5]
[null,"Depreciation (per year)",{"$f":"SLN(C4,C5,C6)","v":28000}]

{"sheet":"VBA","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel SLN Function"]
[]
[]
[null,"Initial Cost",150000]
[null,"Salvage",10000]
[null,"Life (years)",5]
[null,"Depreciation (per year)",28000]

{"sheet":"Depreciated Cost","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel SLN Function"]
[]
[]
[null,"Initial Cost",150000]
[null,"Salvage",10000]
[null,"Life (years)",5]
[]
[null,"Year","Depreciation","Accumulated Deprecition","Depreciated Value"]
[null,0,null,null,{"$f":"C4","v":150000}]
[null,1,{"$f":"SLN($C$4,$C$5,$C$6)","v":28000},{"$f":"D9+C10","v":28000},{"$f":"$C$4-D10","v":122000}]
[null,2,{"$f":"SLN($C$4,$C$5,$C$6)","v":28000},{"$f":"D10+C11","v":56000},{"$f":"$C$4-D11","v":94000}]
[null,3,28000,84000,66000]
[null,4,28000,112000,38000]
[null,5,28000,140000,10000]