{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["Annual Depreciation Schedule","3-Year Asset","5-Year Asset ","7-Year Asset","10-Year Asset","15-Year Asset","30-Year Asset"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Annual Depreciation Schedule","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[7,11,10,12]],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"2005 Capital Asset Depreciation Schedule",{"$nulls":9},"List data:","No. of years depreciation"]
[null,"[Date]",{"$nulls":10},5]
[{"$nulls":12},7]
[{"$nulls":12},10]
[null,"Year to calculate",2005,{"$nulls":9},15]
[{"$nulls":12},30]
[null,"Capital asset classification","Description","Initial cost","Depreciable life (in years)","Date purchased","Accumulated depreciation beginning of year","Number of depreciable months in current year","Current year depreciation expense","Net asset value at beginning of year","Remaining value at end of year","Note: The area above contains data that populates the list in the Depreciable life (in years) column. You can alter this list as needed by using the Validation command. Do not delete rows 2 through 7, which contain data for the list. If you do, you'll affect the list. For further help with lists and Data Validation, please see Help."]
[null,"Land","4567 Main St., Buffalo, NY 98052",{"v":700000,"d":"$700,000"},null,"1991-04-20",{"v":0,"d":"$0"},0,{"v":0,"d":"$0"},{"v":700000,"d":"$700,000"},{"v":700000,"d":"$700,000"}]
[null,"Equipment","Grinding machine #1",{"v":350000,"d":"350,000 "},10,"2004-05-01",{"v":23333.333333333332,"d":"$23,333"},12,{"v":35000,"d":"$35,000"},{"v":326666.6666666667,"d":"$326,667"},{"v":291666.6666666667,"d":"291,667 "}]
[null,"IT equipment","Servers",{"v":50000,"d":"50,000 "},3,"2000-02-01",{"v":50000,"d":"$50,000"},12,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"0 "}]
[null,"Equipment","Welding machine",{"v":255000,"d":"255,000 "},5,"2003-06-17",{"v":76500,"d":"$76,500"},12,{"v":51000,"d":"$51,000"},{"v":178500,"d":"$178,500"},{"v":127500,"d":"127,500 "}]
[null,"Transportation","Corporate vehicle",{"v":50000,"d":"50,000 "},7,"2004-10-05",{"v":1785.7142857142858,"d":"$1,786"},12,{"v":7142.857142857142,"d":"$7,143"},{"v":48214.28571428572,"d":"$48,214"},{"v":41071.42857142857,"d":"41,071 "}]
[null,"Building","Warehouse - 4567 Main St., Buffalo, NY 98052",{"v":750000,"d":"750,000 "},15,"1991-04-20",{"v":683333.3333333334,"d":"$683,333"},12,{"v":50000,"d":"$50,000"},{"v":66666.66666666663,"d":"$66,667"},{"v":16666.666666666628,"d":"16,667 "}]
[null,"Building","Main office building",{"v":1250000,"d":"1,250,000 "},30,"1990-04-01",{"v":614583.3333333334,"d":"$614,583"},12,{"v":41666.666666666664,"d":"$41,667"},{"v":635416.6666666666,"d":"$635,417"},{"v":593750,"d":"593,750 "}]
[{"$nulls":6},{"v":0,"d":"$0"},0,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"0 "}]
[{"$nulls":6},{"v":0,"d":"$0"},0,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"0 "}]
[null,"TOTAL ANNUAL DEPRECIATION EXPENSE",{"$nulls":6},{"v":184809.52380952382,"d":"$184,810"},{"v":1955464.2857142854,"d":"$1,955,464"},{"v":1770654.7619047621,"d":"$1,770,655"}]

{"sheet":"3-Year Asset","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Depreciation schedule - servers"]
[null,"[Date]"]
[]
[]
[null,"User input"]
[null,"Fixed asset",null,"servers"]
[null,"Initial cost",null,{"v":50000,"d":"$50,000"}]
[null,"Date placed in service",null,"2002-02-01"]
[null,"Number of months owned in first year",null,11]
[]
[null,"End of year","Annual depreciation","Remaining value"]
[null,2002,{"v":15277.77777777778,"d":"$15,278"},{"v":34722.22222222222,"d":"$34,722"}]
[null,2003,{"v":16666.666666666668,"d":"16,667 "},{"v":18055.55555555555,"d":"18,056"}]
[null,2004,{"v":16666.666666666668,"d":"16,667 "},{"v":1388.8888888888832,"d":"1,389"}]
[null,2005,{"v":1388.8888888888905,"d":"1,389 "},{"v":-7.275957614183426e-12,"d":"-0"}]
[null,"TOTAL",{"v":50000,"d":"$50,000"}]

{"sheet":"5-Year Asset ","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Depreciation schedule - welding machine"]
[null,"[Date]"]
[]
[]
[null,"User input"]
[null,"Fixed asset",null,"welding machine"]
[null,"Initial cost",null,{"v":255000,"d":"$255,000"}]
[null,"Date placed in service",null,"2003-06-17"]
[null,"Number of months owned in first year",null,6]
[]
[null,"End of year","Annual depreciation","Remaining value"]
[null,2003,{"v":25500,"d":"$25,500"},{"v":229500,"d":"$229,500"}]
[null,2004,{"v":51000,"d":"51,000 "},{"v":178500,"d":"178,500 "}]
[null,2005,{"v":51000,"d":"51,000 "},{"v":127500,"d":"127,500 "}]
[null,2006,{"v":51000,"d":"51,000 "},{"v":76500,"d":"76,500 "}]
[null,2007,{"v":51000,"d":"51,000 "},{"v":25500,"d":"25,500 "}]
[null,2008,{"v":25500,"d":"25,500 "},{"v":0,"d":"0 "}]
[null,"TOTAL",{"v":255000,"d":"$255,000"}]

{"sheet":"7-Year Asset","index":3,"n_rows":21,"n_cols":4,"rows_kept":21,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Depreciation schedule - corporate auto"]
[null,"[Date]"]
[]
[]
[null,"User input"]
[null,"Fixed asset",null,"corporate auto"]
[null,"Initial cost",null,{"v":50000,"d":"$50,000"}]
[null,"Date placed in service",null,"2004-10-05"]
[null,"Number of months owned in first year",null,3]
[]
[null,"End of year","Annual depreciation","Remaining value"]
[null,2004,{"v":1785.7142857142856,"d":"$1,786"},{"v":48214.28571428572,"d":"$48,214"}]
[null,2005,{"v":7142.857142857143,"d":"7,143 "},{"v":41071.42857142857,"d":"41,071 "}]
[null,2006,{"v":7142.857142857143,"d":"7,143 "},{"v":33928.57142857143,"d":"33,929 "}]
[null,2007,{"v":7142.857142857143,"d":"7,143 "},{"v":26785.714285714283,"d":"26,786 "}]
[null,2008,{"v":7142.857142857143,"d":"7,143 "},{"v":19642.857142857138,"d":"19,643 "}]
[null,2009,{"v":7142.857142857143,"d":"7,143 "},{"v":12499.999999999995,"d":"12,500 "}]
[null,2010,{"v":7142.857142857143,"d":"7,143 "},{"v":5357.142857142851,"d":"5,357 "}]
[null,2011,{"v":5357.142857142848,"d":"5,357 "},{"v":0,"d":"0 "}]
[null,"TOTAL",{"v":50000,"d":"$50,000"}]

{"sheet":"10-Year Asset","index":4,"n_rows":24,"n_cols":4,"rows_kept":24,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Depreciation schedule - grinding machine #1"]
[null,"[Date]"]
[]
[]
[null,"User input"]
[null,"Fixed asset",null,"grinding machine #1"]
[null,"Initial cost",null,{"v":350000,"d":"$350,000"}]
[null,"Date placed in service",null,"2004-05-01"]
[null,"Number of months owned in first year",null,8]
[]
[null,"End of year","Annual depreciation","Remaining value"]
[null,2004,{"v":23333.333333333332,"d":"$23,333"},{"v":326666.6666666667,"d":"$326,667"}]
[null,2005,{"v":35000,"d":"35,000 "},{"v":291666.6666666667,"d":"291,667 "}]
[null,2006,{"v":35000,"d":"35,000 "},{"v":256666.6666666667,"d":"256,667 "}]
[null,2007,{"v":35000,"d":"35,000 "},{"v":221666.6666666667,"d":"221,667 "}]
[null,2008,{"v":35000,"d":"35,000 "},{"v":186666.6666666667,"d":"186,667 "}]
[null,2009,{"v":35000,"d":"35,000 "},{"v":151666.6666666667,"d":"151,667 "}]
[null,2010,{"v":35000,"d":"35,000 "},{"v":116666.66666666669,"d":"116,667 "}]
[null,2011,{"v":35000,"d":"35,000 "},{"v":81666.66666666669,"d":"81,667 "}]
[null,2012,{"v":35000,"d":"35,000 "},{"v":46666.666666666686,"d":"46,667 "}]
[null,2013,{"v":35000,"d":"35,000 "},{"v":11666.666666666686,"d":"11,667 "}]
[null,2014,{"v":11666.666666666686,"d":"11,667 "},{"v":0,"d":"0 "}]
[null,"TOTAL",{"v":350000,"d":"$350,000"}]

{"sheet":"15-Year Asset","index":5,"n_rows":29,"n_cols":4,"rows_kept":29,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Depreciation schedule - warehouse"]
[null,"[Date]"]
[]
[]
[null,"User input"]
[null,"Fixed asset",null,"warehouse"]
[null,"Initial cost",null,{"v":750000,"d":"$750,000"}]
[null,"Date placed in service",null,"1991-04-20"]
[null,"Number of months owned in first year",null,8]
[]
[null,"End of year","Annual depreciation","Remaining value"]
[null,1991,{"v":33333.333333333336,"d":"$33,333"},{"v":716666.6666666666,"d":"$716,667"}]
[null,1992,{"v":50000,"d":"50,000 "},{"v":666666.6666666666,"d":"666,667 "}]
[null,1993,{"v":50000,"d":"50,000 "},{"v":616666.6666666666,"d":"616,667 "}]
[null,1994,{"v":50000,"d":"50,000 "},{"v":566666.6666666666,"d":"566,667 "}]
[null,1995,{"v":50000,"d":"50,000 "},{"v":516666.6666666666,"d":"516,667 "}]
[null,1996,{"v":50000,"d":"50,000 "},{"v":466666.6666666666,"d":"466,667 "}]
[null,1997,{"v":50000,"d":"50,000 "},{"v":416666.6666666666,"d":"416,667 "}]
[null,1998,{"v":50000,"d":"50,000 "},{"v":366666.6666666666,"d":"366,667 "}]
[null,1999,{"v":50000,"d":"50,000 "},{"v":316666.6666666666,"d":"316,667 "}]
[null,2000,{"v":50000,"d":"50,000 "},{"v":266666.6666666666,"d":"266,667 "}]
[null,2001,{"v":50000,"d":"50,000 "},{"v":216666.66666666663,"d":"216,667 "}]
[null,2002,{"v":50000,"d":"50,000 "},{"v":166666.66666666663,"d":"166,667 "}]
[null,2003,{"v":50000,"d":"50,000 "},{"v":116666.66666666663,"d":"116,667 "}]
[null,2004,{"v":50000,"d":"50,000 "},{"v":66666.66666666663,"d":"66,667 "}]
[null,2005,{"v":50000,"d":"50,000 "},{"v":16666.666666666628,"d":"16,667 "}]
[null,2006,{"v":16666.666666666628,"d":"16,667 "},{"v":0,"d":"0 "}]
[null,"TOTAL",{"v":750000,"d":"$750,000"}]

{"sheet":"30-Year Asset","index":6,"n_rows":44,"n_cols":4,"rows_kept":44,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Depreciation schedule - main office building"]
[null,"[Date]"]
[]
[]
[null,"User input"]
[null,"Fixed asset",null,"main office building"]
[null,"Initial cost",null,{"v":1250000,"d":"$1,250,000"}]
[null,"Date placed in service",null,"1990-04-01"]
[null,"Number of months owned in first year",null,9]
[]
[null,"End of year","Annual depreciation","Remaining value"]
[null,1990,{"v":31250,"d":"$31,250"},{"v":1218750,"d":"$1,218,750"}]
[null,1992,{"v":41666.666666666664,"d":"41,667 "},{"v":1177083.3333333333,"d":"1,177,083 "}]
[null,1993,{"v":41666.666666666664,"d":"41,667 "},{"v":1135416.6666666665,"d":"1,135,417 "}]
[null,1994,{"v":41666.666666666664,"d":"41,667 "},{"v":1093749.9999999998,"d":"1,093,750 "}]
[null,1995,{"v":41666.666666666664,"d":"41,667 "},{"v":1052083.333333333,"d":"1,052,083 "}]
[null,1996,{"v":41666.666666666664,"d":"41,667 "},{"v":1010416.6666666664,"d":"1,010,417 "}]
[null,1997,{"v":41666.666666666664,"d":"41,667 "},{"v":968749.9999999998,"d":"968,750 "}]
[null,1998,{"v":41666.666666666664,"d":"41,667 "},{"v":927083.3333333331,"d":"927,083 "}]
[null,1999,{"v":41666.666666666664,"d":"41,667 "},{"v":885416.6666666665,"d":"885,417 "}]
[null,2000,{"v":41666.666666666664,"d":"41,667 "},{"v":843749.9999999999,"d":"843,750 "}]
[null,2001,{"v":41666.666666666664,"d":"41,667 "},{"v":802083.3333333333,"d":"802,083 "}]
[null,2002,{"v":41666.666666666664,"d":"41,667 "},{"v":760416.6666666666,"d":"760,417 "}]
[null,2003,{"v":41666.666666666664,"d":"41,667 "},{"v":718750,"d":"718,750 "}]
[null,2004,{"v":41666.666666666664,"d":"41,667 "},{"v":677083.3333333334,"d":"677,083 "}]
[null,2005,{"v":41666.666666666664,"d":"41,667 "},{"v":635416.6666666667,"d":"635,417 "}]
[null,2006,{"v":41666.666666666664,"d":"41,667 "},{"v":593750.0000000001,"d":"593,750 "}]
[null,2007,{"v":41666.666666666664,"d":"41,667 "},{"v":552083.3333333335,"d":"552,083 "}]
[null,2008,{"v":41666.666666666664,"d":"41,667 "},{"v":510416.6666666668,"d":"510,417 "}]
[null,2009,{"v":41666.666666666664,"d":"41,667 "},{"v":468750.0000000001,"d":"468,750 "}]
[null,2010,{"v":41666.666666666664,"d":"41,667 "},{"v":427083.33333333343,"d":"427,083 "}]
[null,2011,{"v":41666.666666666664,"d":"41,667 "},{"v":385416.66666666674,"d":"385,417 "}]
[null,2012,{"v":41666.666666666664,"d":"41,667 "},{"v":343750.00000000006,"d":"343,750 "}]
[null,2013,{"v":41666.666666666664,"d":"41,667 "},{"v":302083.3333333334,"d":"302,083 "}]
[null,2014,{"v":41666.666666666664,"d":"41,667 "},{"v":260416.66666666672,"d":"260,417 "}]
[null,2015,{"v":41666.666666666664,"d":"41,667 "},{"v":218750.00000000006,"d":"218,750 "}]
[null,2016,{"v":41666.666666666664,"d":"41,667 "},{"v":177083.3333333334,"d":"177,083 "}]
[null,2017,{"v":41666.666666666664,"d":"41,667 "},{"v":135416.66666666674,"d":"135,417 "}]
[null,2018,{"v":41666.666666666664,"d":"41,667 "},{"v":93750.00000000009,"d":"93,750 "}]
[null,2019,{"v":41666.666666666664,"d":"41,667 "},{"v":52083.33333333342,"d":"52,083 "}]
[null,2020,{"v":41666.666666666664,"d":"41,667 "},{"v":10416.666666666759,"d":"10,417 "}]
[null,2021,{"v":10416.666666666744,"d":"10,417 "},{"v":1.4551915228366852e-11,"d":"0 "}]
[null,"TOTAL",{"v":1250000,"d":"$1,250,000"}]