Scribd Logo
Upload

Welcome to Scribd!

  • 85 views

    Depreciation Excel File

    Uploaded by

    api-454991083
    The document contains depreciation schedules for 3 assets: 1) A building acquired on 1/1/2013 for $55,000 with a 15 year useful life. 2) A building acquired on 1/1/2014 for $20,000 with a 5 year useful life. 3) Equipment acquired on 1/1/2013 for $7,500 with a 4 year useful life. The schedules calculate annual depreciation expense and accumulated depreciation using straight line and declining balance depreciation methods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Depreciation Excel File

    Uploaded by

    api-454991083
    85 views18 pages
    The document contains depreciation schedules for 3 assets: 1) A building acquired on 1/1/2013 for $55,000 with a 15 year useful life. 2) A building acquired on 1/1/2014 for $20,000 with a 5 year useful life. 3) Equipment acquired on 1/1/2013 for $7,500 with a 4 year useful life. The schedules calculate annual depreciation expense and accumulated depreciation using straight line and declining balance depreciation methods.

    Original Title

    depreciation excel file

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains depreciation schedules for 3 assets: 1) A building acquired on 1/1/2013 for $55,000 with a 15 year useful life. 2) A building acquired on 1/1/2014 for $20,000 with a 5 year useful life. 3) Equipment acquired on 1/1/2013 for $7,500 with a 4 year useful life. The schedules calculate annual depreciation expense and accumulated depreciation using straight line and declining balance depreciation methods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    85 views18 pages

    Depreciation Excel File

    Uploaded by

    api-454991083
    The document contains depreciation schedules for 3 assets: 1) A building acquired on 1/1/2013 for $55,000 with a 15 year useful life. 2) A building acquired on 1/1/2014 for $20,000 with a 5 year useful life. 3) Equipment acquired on 1/1/2013 for $7,500 with a 4 year useful life. The schedules calculate annual depreciation expense and accumulated depreciation using straight line and declining balance depreciation methods.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 18

    Depreciation Schedule

    Asset # 1
    Asset Building
    Date aquired 1/1/2013
    Cost $ 55,000
    Depreciation Method S/L
    Salvage Vaule $ 4,000.00
    Estimated Usefeul Life 15

    Year Depreciation Epense Accumulated depreciation


    2013 $3,400.00 $3,400.00
    2014 $3,400.00 $6,800.00
    2015 $3,400.00 $10,200.00
    2016 $3,400.00 $13,600.00
    2017 $3,400.00 $17,000.00
    2018 $3,400.00 $20,400.00
    2019 $3,400.00 $23,800.00
    2020 $3,400.00 $27,200.00
    2021 $3,400.00 $30,600.00
    2022 $3,400.00 $34,000.00
    2023 $3,400.00 $37,400.00
    2024 $3,400.00 $40,800.00
    2025 $3,400.00 $44,200.00
    2026 $3,400.00 $47,600.00
    2027 $3,400.00 $51,000.00
    Depreciation Schedule

    Asset # 2
    Asset Building
    Date aquired 1/1/2014
    Cost $ 20,000.00
    Depreciation Method S/L
    Salvage Vaule $ 1,000.00
    Estimated Usefeul Life 5

    Year Depreciation Epense Accumulated depreciation


    2014 3800 3800
    2015 3800 7600
    2016 3800 11400
    2017 3800 15200
    2018 3800 19000
    Depreciation Schedule

    Asset # 3
    Asset Equipment
    Date aquired 1/1/2013
    Cost $ 7,500
    Depreciation Method S/L
    Salvage Vaule $ 500.00
    Estimated Usefeul Life 4

    Year Depreciation Epense Accumulated depreciation


    2013 $1,750.00 $1,750.00
    2014 $1,750.00 $3,500.00
    2015 $1,750.00 $5,250.00
    2016 $1,750.00 $7,000.00
    Depreciation Schedule

    Asset # 1
    Asset Building
    Date aquired 1/1/2013
    Cost $ 55,000
    Depreciation Method DDB
    Salvage Vaule $ 4,000.00
    Estimated Usefeul Life 15

    Year Depreciation Epense Accumulated depreciation


    2013 $7,333.33 $7,333.33
    2014 $6,355.56 $13,688.89
    2015 $5,508.15 $19,197.04
    2016 $4,773.73 $23,970.77
    2017 $4,137.23 $28,108.00
    2018 $3,585.60 $31,693.60
    2019 $3,107.52 $34,801.12
    2020 $2,693.18 $37,494.30
    2021 $2,334.09 $39,828.39
    2022 $2,022.88 $41,851.28
    2023 $1,753.16 $43,604.44
    2024 $1,519.41 $45,123.85
    2025 $1,316.82 $46,440.67
    2026 $1,141.24 $47,581.91
    2027 $989.08 $48,570.99
    Straight-Line Test Switch Depreciation Expense Accum. Depreciation
    $3,400.00 - $7,333.33 $7,333.33
    $3,119.05 - $6,355.56 $13,688.89
    $2,870.09 - $5,508.15 $19,197.04
    $2,650.25 - $4,773.73 $23,970.77
    $2,457.20 - $4,137.23 $28,108.00
    $2,289.20 - $3,585.60 $31,693.60
    $2,145.16 - $3,107.52 $34,801.12
    $2,024.86 - $2,693.18 $37,494.30
    $1,929.39 - $2,334.09 $39,828.39
    $1,861.93 - $2,022.88 $41,851.28
    $1,829.74 X $1,829.74 $43,681.02
    $1,848.89 X $1,829.74 $45,510.77
    $1,958.72 X $1,829.74 $47,340.51
    $2,279.67 X $1,829.74 $49,170.26
    $3,418.09 X $1,829.74 $51,000.00
    Depreciation Schedule

    Asset # 2
    Asset Building
    Date aquired 1/1/2014
    Cost $ 20,000
    Depreciation Method DDB
    Salvage Vaule $ 1,000.00
    Estimated Usefeul Life 5

    Year Depreciation Epense Accumulated depreciation


    2014 $8,000.00 $8,000.00
    2015 $4,800.00 $12,800.00
    2016 $2,880.00 $15,680.00
    2017 $1,728.00 $17,408.00
    2018 $1,036.80 $18,444.80
    Straight-Line Test Switch Depreciation Expense Accum. Depreciation
    $3,800.00 - $8,000.00 $8,000.00
    $2,750.00 - $4,800.00 $12,800.00
    $2,066.67 - $2,880.00 $15,680.00
    $1,660.00 - $1,728.00 $17,408.00
    $1,592.00 X $1,592.00 $19,000.00
    Depreciation Schedule

    Asset # 3
    Asset Equipment
    Date aquired 1/1/2013
    Cost $ 7,500
    Depreciation Method DDB
    Salvage Vaule $ 500.00
    Estimated Usefeul Life 4

    Year Depreciation Epense Accumulated depreciation


    2013 $3,750.00 $3,750.00
    2014 $1,875.00 $5,625.00
    2015 $937.50 $6,562.50
    2016 $437.50 $7,000.00
    Straight-Line Test Switch Depreciation Expense Accum. Depreciation
    $1,750.00 - $3,750.00 $3,750.00
    $1,083.33 - $1,875.00 $5,625.00
    $687.50 - $937.50 $6,562.50
    $437.50 - $437.50 $7,000.00
    Depreciation Schedule

    Asset # 1
    Asset Building
    Date aquired 1/1/2013
    Cost $ 55,000
    Depreciation Method SYD
    Salvage Vaule $ 4,000.00
    Estimated Usefeul Life 15

    Year Depreciation Epense Accumulated depreciation


    2013 $6,375.00 $6,375.00
    2014 $5,950.00 $12,325.00
    2015 $5,525.00 $17,850.00
    2016 $5,100.00 $22,950.00
    2017 $4,675.00 $27,625.00
    2018 $4,250.00 $31,875.00
    2019 $3,825.00 $35,700.00
    2020 $3,400.00 $39,100.00
    2021 $2,975.00 $42,075.00
    2022 $2,550.00 $44,625.00
    2023 $2,125.00 $46,750.00
    2024 $1,700.00 $48,450.00
    2025 $1,275.00 $49,725.00
    2026 $850.00 $50,575.00
    2027 $425.00 $51,000.00
    Depreciation Schedule

    Asset # 2
    Asset Building
    Date aquired 1/1/2014
    Cost $ 20,000
    Depreciation Method SYD
    Salvage Vaule $ 1,000.00
    Estimated Usefeul Life 5

    Year Depreciation Epense Accumulated depreciation


    2014 $6,333.33 $6,333.33
    2015 $5,066.67 $11,400.00
    2016 $3,800.00 $15,200.00
    2017 $2,533.33 $17,733.33
    2018 $1,266.67 $19,000.00
    Depreciation Schedule

    Asset # 3
    Asset Equuipment
    Date aquired 1/1/2013
    Cost $ 7,500
    Depreciation Method SYD
    Salvage Vaule $ 500.00
    Estimated Usefeul Life 4

    Year Depreciation Epense Accumulated depreciation


    2014 $2,800.00 $2,800.00
    2015 $2,100.00 $4,900.00
    2016 $1,400.00 $6,300.00
    2017 $700.00 $7,000.00
    Depreciation Schedule
    Building 1 Depreciation Comparison
    Asset # 1
    Asset Building
    Date aquired 1/1/2013
    Cost $ 55,000
    Depreciation Method S/L
    60000
    Salvage Vaule $ 4,000.00
    Estimated Usefeul Life 15
    50000

    40000

    Year 30000 Depreciation Epense Accumulated depreciation


    2013 $3,400.00 $3,400.00
    20000 2014 $3,400.00 $6,800.00
    2015 $3,400.00 $10,200.00
    10000 2016 $3,400.00 $13,600.00
    2017 $3,400.00 $17,000.00
    0 2018 $3,400.00 $20,400.00
    2013 2014
    2015 2016
    2019 $3,400.00
    2017 2018 $23,800.00
    2019 2020
    2020 $3,400.00 2021 $27,200.00
    2022 2023
    2021 $3,400.00 $30,600.00 2024 2025 2026
    2027
    2022 $3,400.00 $34,000.00
    Depreci ation Schedul e As s et #$3,400.00
    2023 As s et Date a qui red Cost Depreciation Method Sa l vage Va ul e Estimated Us efeul Li fe
    $37,400.00 Yea r
    1 Bui l di ng 1/1/2013 $55,000 S/L $4,000.00 15 Depreci ation Epens e
    2024
    Accumul ated depreci ation
    $3,400.00 $40,800.00
    SL 2025 $3,400.00 $44,200.00
    DDB 2026 $3,400.00 $47,600.00
    SYD
    2027 $3,400.00 $51,000.00
    27

    ated Us efeul Li fe Yea r


    Depreciation Schedule

    Asset # 2
    Asset Building
    Date aquired 20000 1/1/2014
    Cost 15000 $ 20,000.00
    Depreciation Method 10000 S/L
    Salvage Vaule $ 1,000.00
    5000
    Estimated Usefeul Life 5
    0
    2014
    2015
    2016
    2017
    2018
    Year Depreciation Epense Accumulated depreciation
    Depreci ation Schedul e As s et # As s et Date a quired Cost Depreci ation Method Sa l vage Va ule Estimated Us efeul Li fe Yea r
    2014 3800
    2 Bui l di ng 1/1/2014 $20,000.00 S/L $1,000.00 5 Depreci ation Epens e
    3800
    2015
    Accumul ated depreci ation 3800 7600
    SL 2016 3800 11400
    DDB
    2017 3800 15200
    SYD
    2018 3800 19000
    ated Us efeul Li fe Yea r
    Depreciation Schedule
    Equipment Depreciation Comparison
    Asset # 3
    Asset Equipment
    Date aquired 1/1/2013
    Cost $ 7,500
    8000
    Depreciation Method 6000
    S/L
    Salvage Vaule $4000 500.00
    Estimated Usefeul Life 2000 4
    0
    2013
    2014
    2015
    2016
    Year Depreciation Epense Accumulated depreciation
    Depreci ation Schedul e As s et # As s et Date a qui red Cost Depreciation Method Sa l vage Va ul e Estimated Us efeul Li fe Yea r
    2013
    3 Equi pment 1/1/2013 $7,500 S/L$1,750.00
    $500.00 4 Depreci ation Epens $1,750.00
    e
    2014 depreci ation$1,750.00
    Accumulated $3,500.00
    SL 2015 $1,750.00 $5,250.00
    DDB
    2016 $1,750.00 $7,000.00
    SYD
    ted Us efeul Li fe Yea r

    You might also like