Spreadsheet: 675960d1588586092-populating-a-straight-line-depreciation-annual-table-expense-schedule-excelguru10581simple-sl-depreciation-schedulepq
Sheet: Sheet1

Simple Straight Line Depreciation Schedule
Account: | Home Improvement's |  |  |  |  | Year | AC Unit | Solar System | Home Remodel | Fence Replacement | Total
Purchase Date | Item Desc. | Cost | Yr.'s Service | Salvage Value |  | 2018 | 549.5747 |  |  |  | 549.5747 |  |  |  |  |  |  |  | Copy of expected values from OP
2018-03-24 00:00:00 | AC Unit | 10640 | 15 | 0 |  | 2019 | 708.8155 | 704.5133 | 345.3823 |  | 1758.7111 |  |  |  |  |  |  |  | Year | AC Unit | Solar System | Home Remodel | Fence Replacement | Total
2019-07-10 00:00:00 | Solar System | 29408.4 | 20 | 0 |  | 2020 | 710.7574 | 1473.4393 | 790.062 | 174.341 | 3148.5997 |  |  |  |  |  |  |  | 2018 | 547.63 |  |  |  | 547.63
2019-07-25 00:00:00 | Home Remodel | 7885.51 | 10 | 0 |  | 2021 | 708.8155 | 1469.4136 | 787.9034 | 250.5294 | 3216.6619 |  |  |  |  |  |  |  | 2019 | 709.509 | 400.49 | 343.22 | 173.65 | 1626.869
2020-04-22 00:00:00 | Fence Replacement | 3760 | 15 | 0 |  | 2022 | 708.8155 | 1469.4136 | 787.9034 | 250.5294 | 3216.6619 |  |  |  |  |  |  |  | 2020 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
2020-03-03 00:00:00 | New Kitchen | 8000 | 20 | 500 |  | 2023 | 708.8155 | 1469.4136 | 787.9034 | 250.5294 | 3216.6619 |  |  |  |  |  |  |  | 2021 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
2022-05-05 00:00:00 | Re-lay Drive | 4000 | 40 | 0 |  | 2024 | 710.7574 | 1473.4393 | 790.062 | 251.2158 | 3225.4745 |  |  |  |  |  |  |  | 2022 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
2015-09-09 00:00:00 | Greenhouse | 6000 | 25 | 0 |  | 2025 | 708.8155 | 1469.4136 | 787.9034 | 250.5294 | 3216.6619 |  |  |  |  |  |  |  | 2023 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
2019-10-10 00:00:00 | Computer Network | 1999 | 7 | 0 |  | 2026 | 708.8155 | 1469.4136 | 787.9034 | 250.5294 | 3216.6619 |  |  |  |  |  |  |  | 2024 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
 |  |  |  |  |  | 2027 | 708.8155 | 1469.4136 | 787.9034 | 250.5294 | 3216.6619 |  |  |  |  |  |  |  | 2025 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
 |  |  |  |  |  | 2028 | 710.7574 | 1473.4393 | 790.062 | 251.2158 | 3225.4745 |  |  |  |  |  |  |  | 2026 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
 |  |  |  |  |  | 2029 | 708.8155 | 1469.4136 | 442.5211 | 250.5294 | 2871.2796 |  |  |  |  |  |  |  | 2027 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
 |  |  |  |  |  | 2030 | 708.8155 | 1469.4136 |  | 250.5294 | 2428.7585 |  |  |  |  |  |  |  | 2028 | 709.509 | 1486.474 | 788.863 | 234.01 | 3218.856000000001
 |  |  |  |  |  | 2031 | 708.8155 | 1469.4136 |  | 250.5294 | 2428.7585 |  |  |  |  |  |  |  | 2029 | 709.509 | 1486.474 | 442.52 | 234.01 | 2872.513
 |  |  |  |  |  | 2032 | 710.7574 | 1473.4393 |  | 251.2158 | 2435.4125 |  |  |  |  |  |  |  | 2030 | 709.509 | 1486.474 |  | 234.01 | 2429.993
 |  |  |  |  |  | 2033 | 159.2407 | 1469.4136 |  | 250.5294 | 1879.1837 |  |  |  |  |  |  |  | 2031 | 709.509 | 1486.474 |  | 234.01 | 2429.993
 |  |  |  |  |  | 2034 |  | 1469.4136 |  | 250.5294 | 1719.943 |  |  |  |  |  |  |  | 2032 | 709.509 | 1486.474 |  | 234.01 | 2429.993
 |  |  |  |  |  | 2035 |  | 1469.4136 |  | 76.1884 | 1545.602 |  |  |  |  |  |  |  | 2033 | 159.24 | 1486.474 |  | 234.01 | 1879.724
 |  |  |  |  |  | 2036 |  | 1473.4393 |  |  | 1473.4393 |  |  |  |  |  |  |  | 2034 |  | 1486.474 |  | 234.01 | 1720.484
 |  |  |  |  |  | 2037 |  | 1469.4136 |  |  | 1469.4136 |  |  |  |  |  |  |  | 2035 |  | 1486.474 |  | 76.19 | 1562.664
 |  |  |  |  |  | 2038 |  | 1469.4136 |  |  | 1469.4136 |  |  |  |  |  |  |  | 2036 |  | 1486.474 |  |  | 1486.474
 |  |  |  |  |  | 2039 |  | 764.9002 |  |  | 764.9002 |  |  |  |  |  |  |  | 2037 |  | 1486.474 |  |  | 1486.474
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2038 |  | 1486.474 |  |  | 1486.474
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2039 |  | 764.9 |  |  | 764.9