Wine Depot
Depreciation Summary
Asset
Date
Acquired
Cost
Deprec.
Method
2015
Deprec.
2015 Acc.
Deprec.
2016
Deprec.
2016 Acc.
Deprec.
2017
Deprec.
2017 Acc.
Deprec.
2018
Deprec.
2018 Acc.
Deprec.
Wine Depot Depreciation Schedule
Asset #
101
Asset
Equipment
Year
Depreciation
Expense
Accumulated
Depreciation
2015 $134,823.00 $134,823.00
2016 $134,823.00 $269,646.00
2017 $134,823.00 $404,469.00
2018 $134,823.00 $539,292.00
2019 $134,823.00 $674,115.00
Wine Depot Depreciation Schedule
Asset #
102
Asset
Truck
Year
Depreciation
Expense
Accumulated
Depreciation
2016 $14,200.00 $14,200.00
2017 $14,200.00 $28,400.00
2018 $14,200.00 $42,600.00
2019 $14,200.00 $56,800.00
2020 $14,200.00 $71,000.00
2021 $14,200.00 $85,200.00
2022 $14,200.00 $99,400.00
Wine Depot Depreciation Schedule
Asset #
103
Asset
Portable
Year
Depreciation
Expense
Accumulated
Depreciation
2017 $11,694.13 $11,694.13
2018 $11,694.13 $23,388.27
2019 $11,694.13 $35,082.40
2020 $11,694.13 $46,776.53
2021 $11,694.13 $58,470.67
2022 $11,694.13 $70,164.80
2023 $11,694.13 $81,858.93
2024 $11,694.13 $93,553.07
Student Name 3/6/2023 ch4-04_student_name.xlsx
Wine Depot
Depreciation Summary
Asset
Date
Acquired
Cost
Deprec.
Method
2015
Deprec.
2015 Acc.
Deprec.
2016
Deprec.
2016 Acc.
Deprec.
2017
Deprec.
2017 Acc.
Deprec.
2018
Deprec.
2018 Acc.
Deprec.
Equipment 1/1/2015 689,115$ DDB $275,646 $275,646 $165,388 $441,034 $99,233 $540,266 $66,924 $607,191
Student Name 3/6/2023 ch4-04_student_name.xlsx
Truck 1/1/2016 150,000$ DDB $30,000 $30,000 $24,000 $54,000 $19,200 $73,200
Portable 1/1/2017 198,412$ DDB $26,455 $26,455 $22,928 $49,383
Wine Depot Depreciation Schedule
Asset #
101
Asset
Equipment
Year
Depreciation
Expense
Accumulated
Depreciation
Straight-Line
Test
Switch
Depreciation
Expense
Accumulated
Depreciation
2015 $275,646.00 $275,646.00 $134,823.00 – $275,646.00 $275,646.00
2016 $165,387.60 $441,033.60 $99,617.25 – $165,387.60 $441,033.60
2017 $99,232.56 $540,266.16 $77,693.80 – $99,232.56 $540,266.16
2018 $59,539.54 $599,805.70 $66,924.42 X $66,924.42 $607,190.58
2019 $35,723.72 $635,529.42 $74,309.30 X $66,924.42 $674,115.00
Student Name 3/6/2023 ch4-04_student_name.xlsx
Wine Depot Depreciation Schedule
Asset #
102
Asset
Truck
Year
Depreciation
Expense
Accumulated
Depreciation
Straight-Line
Test
Switch
Depreciation
Expense
Accumulated
Depreciation
2016 $30,000.00 $30,000.00 $14,200.00 – $30,000.00 $30,000.00
2017 $24,000.00 $54,000.00 $12,444.44 – $24,000.00 $54,000.00
2018 $19,200.00 $73,200.00 $11,000.00 – $19,200.00 $73,200.00
2019 $15,360.00 $88,560.00 $9,828.57 – $15,360.00 $88,560.00
Wine Depot Depreciation Schedule
Asset #
103
Asset
Portable
Date acquired
1/1/2017
Year
Depreciation
Expense
Accumulated
Depreciation
Straight-Line
Test
Switch
Depreciation
Expense
Accumulated
Depreciation
2017 $26,454.93 $26,454.93 $11,694.13 – $26,454.93 $26,454.93
2018 $22,927.61 $49,382.54 $10,639.79 – $22,927.61 $49,382.54
2019 $19,870.59 $69,253.14 $9,694.57 – $19,870.59 $69,253.14
2020 $17,221.18 $86,474.32 $8,846.57 – $17,221.18 $86,474.32
2021 $14,925.02 $101,399.34 $8,085.24 – $14,925.02 $101,399.34
2022 $12,935.02 $114,334.36 $7,401.27 – $12,935.02 $114,334.36
2023 $11,210.35 $125,544.72 $6,786.40 – $11,210.35 $125,544.72
2024 $9,715.64 $135,260.35 $6,233.41 – $9,715.64 $135,260.35
2025 $8,420.22 $143,680.57 $5,735.95 – $8,420.22 $143,680.57
2026 $7,297.52 $150,978.10 $5,288.57 – $7,297.52 $150,978.10
2027 $6,324.52 $157,302.62 $4,886.78 – $6,324.52 $157,302.62
2028 $5,481.25 $162,783.87 $4,527.35 – $5,481.25 $162,783.87
2029 $4,750.42 $167,534.29 $4,209.38 – $4,750.42 $167,534.29
2030 $4,117.03 $171,651.31 $3,938.86 – $4,117.03 $171,651.31
2031 $3,568.09 $175,219.41 $3,760.69 X $3,760.69 $175,412.00
Student Name 3/6/2023 ch4-04_student_name.xlsx
Wine Depot
Depreciation Summary
Asset
Date
Acquired
Cost
Deprec.
Method
2015
Deprec.
2015 Acc.
Deprec.
2016
Deprec.
2016 Acc.
Deprec.
2017
Deprec.
2017 Acc.
Deprec.
2018
Deprec.
2018 Acc.
Deprec.
Student Name 3/6/2023 ch4-04_student_name.xlsx
Wine Depot Depreciation Schedule
Asset #
101
Year
Depreciation
Expense
Accumulated
Depreciation
2015 $224,705.00 $224,705.00
2016 $179,764.00 $404,469.00
2017 $134,823.00 $539,292.00
2018 $89,882.00 $629,174.00
2019 $44,941.00 $674,115.00
Student Name 3/6/2023 ch4-04_student_name.xlsx
Wine Depot Depreciation Schedule
Asset #
102
Asset
Truck
Year
Depreciation
Expense
Accumulated
Depreciation
2016 $25,818.18 $25,818.18
2017 $23,236.36 $49,054.55
2018 $20,654.55 $69,709.09
2019 $18,072.73 $87,781.82
Wine Depot Depreciation Schedule
Asset #
103
Asset
Portable
Date acquired
1/1/2017
Year
Depreciation
Expense
Accumulated
Depreciation
2017 $21,926.50 $21,926.50
2018 $20,464.73 $42,391.23
2019 $19,002.97 $61,394.20
2020 $17,541.20 $78,935.40
2021 $16,079.43 $95,014.83
Student Name 3/6/2023 ch4-04_student_name.xlsx
$20,000.00
$25,000.00
$30,000.00
Asset 103 Depreciation Comparison