BHULYAN QUICK-PRINT, INC. Printing Press Depreciation Schedule • Double-Declining-Balance Method |
|||||
Cost of Asset: | $340,000 | ||||
Salvage Value: | $35,000 | ||||
Length of Service (yrs): | 8 | ||||
Annual Double-Declining-Balance Rate: | |||||
Double-Declining | Years | ||||
(DB) | 1 | 2 | 3 | 4 | 5 |
Annual Depreciation | |||||
Cumulative Depreciation | |||||
End-of-Year Book Value | |||||
Directions: | |||||
a. In Cell C7 Calculate the Annual Double-Declining Balance Rate. | |||||
b. Enter a Double-Declining Balance formula in cell B10 to calculate the Annual Depreciation. | |||||
c. Copy this formula across to Column F. | |||||
d. In Cell B11, enter the formula to display the depreciation for the first year. | |||||
e. In Cell C11, enter the formula to add this yearly depreciation to the previous year's depreciation. | |||||
f. Copy this formula across to column F. | |||||
g. In Cell B12, enter the formula to calculate the dpreciated asset's value after the first year. | |||||
h. In Cell C12, enter the formula to calculate the End -of-Year Book Value. | |||||
i. Copy this formula across to column F. | |||||
j. Save the file as ch13ex04a.xlsx. | |||||
The table has been created in excel
BHULYAN QUICK-PRINT, INC. | |||||
Printing Press | |||||
Depreciation Schedule • Double-Declining-Balance Method | |||||
Cost of Asset: | $340,000 | ||||
Salvage Value: | $35,000 | ||||
Length of Service (yrs): | 8 | ||||
Annual Double-Declining-Balance Rate: | |||||
Double-Declining | Years | ||||
(DB) | 1 | 2 | 3 | 4 | 5 |
Annual Depreciation | $76,250 | $76,250 | $76,250 | $76,250 | |
Cumulative Depreciation | $76,250 | $152,500 | $228,750 | $305,000 | |
End-of-Year Book Value | $263,750 | $187,500 | $111,250 | $35,000 | |
Please Discuss in case of Doubt
Best
of Luck. God Bless
Please Rate Well
BHULYAN QUICK-PRINT, INC. Printing Press Depreciation Schedule • Double-Declining-Balance Method Cost of Asset: $340,000 Salvage Value:...
GOOD FELLAS’ CATERING Truck Depreciation Schedule • Straight-Line Method Cost of Asset: $56,500 Salvage Value: $5,500 Length of Service (yrs): 5 Depreciable Base: Annual Depreciation: Straight-Line Years (SLN) 1 2 3 4 5 Annual Depreciation Cumulative Depreciation End-of-Year Book Value 1. Enter a formula in Cell C7 to calculate the Depreciable Base. 2. Enter a straight line depreciation formula in Cell C8 to calculate the Annual Depreciation. 3. Copy the formula in C8 to B11. 4. Copy the formula in...
The following table demonstrates the double-declining balance method for the same asset. The depreciation rate is equal to double the depreciation rate for the straight-line method. The annual depreciation in the straight-line method is $2,000. Therefore the depreciation rate is $2,000 divided by $10,000, which is 20%. In the double-declining balance method this rate is doubled to 40%. Fill up the blanks. Year Book value (start of year) Depreciation Rate Depreciation expense Accumulated Depreciation Book value (year end) 1 10000 40%...
fill in question mark. double declining balance deprc. 221,800 DOUBLE-DECLINING-BALANCE DEPRECIATION Computation Book Value Beginning of Year x Depreciation Rate - Annual Depreciation Expense 252,000) 126,000 End of Year Accumulated Depreciation Years 2022 Book Value 125,000 2023 T 126,000 63,000 63.000 T 63,000 31,500 2024 2025 I 31,500 77722727 1,300 30,200 Depreciation expense for 2020 under Double declining-balance is adjusted so that ending book value is equal to salvage value.
The double-declining - balance method of depreciation causes: O A. the same amount of depreciation in early years of an asset's use as compared to other depreciation methods O B. more depreciation in early years of an asset's use as compared to other depreciation methods O c. less depreciation in early years of an asset's use as compared to other depreciation methods OD. is not an acceptable depreciation method according to GAAP A loss is recorded on the sale of...
How do I use the double-declining-balance method, a time-based method, to calculate the depreciation expense for Asset A in year 2017? Depreciation Methods Vorst Corporation's schedule of depreciable assets at December 31, 2016, was as follows: Asset Cost Accumulated Acquisition Residual Depreciation Date Value $ 64,000 2015 $20,000 36,000 2014 10,000 A $100,000 B 55,000 с 70,000 33,600 2014 14,000 $225,000 $133,600 $44,000 Vorst takes a full year's depreciation expense in the year of an asset's acquisition and no depreciation...
Double-declining-balance depreciation In early January 2016, NewTech purchases computer equipment for $154,000 to use in operating activities for the next four years. It estimates the equipment's salvage value at $25,000. Prepare a table showing depreciation and book value for each of the four years assuming double- declining-balance depreciation. Double-declining-balance depreciation Depreciation for the Period End of Period Accumulated Depreciation Depreciation Book Value Beginning-Year Depreciation Annual Year-End Year Book Value Rate 2016 2017 2018 2019 Total 50% 50% 50% 50%
Machinery purchased from Telecom, Inc., by Blazedales cost $53,300. Depreciation was determined by the double-declining-balance method for an estimated life of 16 years. Do not round annual rate. Round other interim calculations and final answer to two decimal places. a. Compute the book value after 4 years. $ b. Compute the total depreciation after 6 years. $
Double Declining Balance Depreciation A small delivery truck was purchased on January 1 at a cost of $25,000. It has an estimated useful life of four years and an estimated salvage value of $5,000. Prepare a depreciation schedule showing the depreciation expense, accumulated depreciation, and book value for each year under the Double Declining balance method Accum. depr. end of Yr. 2:$18,750
Use the following information to complete the deprecation schedule below using the Double Declining Balance method of depreciation: An asset was purchased on Jan. 1 2017 at a cost of $60,000. The asset has a salvage value of $4,000 and an estimated life of 8 years. Year Book Value Rate Depreciation Book Value
3. Record the Depreciation Expense for the period under the double-declining-balance method. 4.Record the Depreciation Expense for the period under the activity-based method. Required: 1. Use your spreadsheet to recalculate Depreciation Expense, Accumulated Depreciation, and the Book Value for Year 6 under each method. Note your revised values below. Double-Declining- Balance Activity-Based Straight-Line Depreciation Expense Accumulated Depreciation 16,711 S 14,100 $ 18,612 18,612 wwww 14,100 16,711 Book Value 112,800 112,800 .. 112,800 2. Prepare the journal entry to record depreciation...