Rosey’s Roses Depreciation Schedule
Asset
Building #1
Date acquired
1/1/2018
Year
Depreciation
Expense
Accumulated
Depreciation
2018 $4,666.67 $4,666.67
2019 $4,666.67 $9,333.33
2020 $4,666.67 $14,000.00
2021 $4,666.67 $18,666.67
2022 $4,666.67 $23,333.33
2023 $4,666.67 $28,000.00
2024 $4,666.67 $32,666.67
2025 $4,666.67 $37,333.33
2026 $4,666.67 $42,000.00
2027 $4,666.67 $46,666.67
2028 $4,666.67 $51,333.33
2029 $4,666.67 $56,000.00
2030 $4,666.67 $60,666.67
2031 $4,666.67 $65,333.33
2032 $4,666.67 $70,000.00
Rosey’s Roses Depreciation Schedule
Asset
Building #2
Date acquired
1/1/2019
Year
Depreciation
Expense
Accumulated
Depreciation
2019 $4,600.00 $4,600.00
2020 $4,600.00 $9,200.00
Rosey’s Roses Depreciation Schedule
Asset
Equipment
Date acquired
1/1/2018
Year
Depreciation
Expense
Accumulated
Depreciation
2018 $2,250.00 $2,250.00
2019 $2,250.00 $4,500.00
2020 $2,250.00 $6,750.00
2021 $2,250.00 $9,000.00
Student Name 3/6/2023 ch4-06_student_name.xlsx
Rosey’s Roses Depreciation Schedule
Asset
Building #1
Date acquired
1/1/2018
Year
Depreciation
Expense
Accumulated
Depreciation
Straight-Line
Test
Switch
Depreciation
Expense
Accumulated
Depreciation
2018 $9,866.67 $9,866.67 $4,666.67 – $9,866.67 $9,866.67
2019 $8,551.11 $18,417.78 $4,295.24 – $8,551.11 $18,417.78
2020 $7,410.96 $25,828.74 $3,967.86 – $7,410.96 $25,828.74
2021 $6,422.83 $32,251.58 $3,680.94 – $6,422.83 $32,251.58
2022 $5,566.46 $37,818.03 $3,431.67 – $5,566.46 $37,818.03
2023 $4,824.26 $42,642.29 $3,218.20 – $4,824.26 $42,642.29
2024 $4,181.03 $46,823.32 $3,039.75 – $4,181.03 $46,823.32
2025 $3,623.56 $50,446.88 $2,897.08 – $3,623.56 $50,446.88
2026 $3,140.42 $53,587.30 $2,793.30 – $3,140.42 $53,587.30
2027 $2,721.69 $56,308.99 $2,735.45 X $2,735.45 $56,322.75
2028 $2,358.80 $58,667.79 $2,738.20 X $2,735.45 $59,058.20
2029 $2,044.29 $60,712.09 $2,833.05 X $2,735.45 $61,793.65
2031 $1,535.49 $64,019.30 $3,758.10 X $2,735.45 $67,264.55
2032 $1,330.76 $65,350.06 $5,980.70 X $2,735.45 $70,000.00
Rosey’s Roses Depreciation Schedule
Asset
Building #2
Date acquired
1/1/2019
Year
Depreciation
Expense
Accumulated
Depreciation
Straight-Line
Test
Switch
Depreciation
Expense
Accumulated
Depreciation
2019 $9,600.00 $9,600.00 $4,600.00 – $9,600.00 $9,600.00
Rosey’s Roses Depreciation Schedule
Asset
Equipment
Year
Depreciation
Expense
Accumulated
Depreciation
Straight-Line
Test
Switch
Depreciation
Expense
Accumulated
Depreciation
2018 $4,750.00 $4,750.00 $2,250.00 – $4,750.00 $4,750.00
2019 $2,375.00 $7,125.00 $1,416.67 – $2,375.00 $7,125.00
2020 $1,187.50 $8,312.50 $937.50 – $1,187.50 $8,312.50
Student Name 3/6/2023 ch4-06_student_name.xlsx
Rosey’s Roses Depreciation Schedule
Asset
Building #1
Year
Depreciation
Expense
Accumulated
Depreciation
2018 $8,750.00 $8,750.00
2019 $8,166.67 $16,916.67
2020 $7,583.33 $24,500.00
2021 $7,000.00 $31,500.00
2022 $6,416.67 $37,916.67
2023 $5,833.33 $43,750.00
2024 $5,250.00 $49,000.00
2025 $4,666.67 $53,666.67
2026 $4,083.33 $57,750.00
2027 $3,500.00 $61,250.00
2028 $2,916.67 $64,166.67
2029 $2,333.33 $66,500.00
2030 $1,750.00 $68,250.00
2031 $1,166.67 $69,416.67
2032 $583.33 $70,000.00
Rosey’s Roses Depreciation Schedule
Asset
Building #2
Date acquired
1/1/2019
Year
Depreciation
Expense
Accumulated
Depreciation
2019 $7,666.67 $7,666.67
Rosey’s Roses Depreciation Schedule
Asset
Equipment
Date acquired
1/1/2018
Year
Depreciation
Expense
Accumulated
Depreciation
2018 $3,600.00 $3,600.00
2019 $2,700.00 $6,300.00
2020 $1,800.00 $8,100.00
2021 $900.00 $9,000.00
Student Name 3/6/2023 ch4-06_student_name.xlsx
$10,000.00
$12,000.00
Building #1 Depreciation Comparison
$8,000.00
$10,000.00
$12,000.00
Building #2 Depreciation Comparison
$4,000.00
$4,500.00
$5,000.00
Equipment Depreciation Comparison