Question

BHULYAN QUICK-PRINT, INC. Printing Press Depreciation Schedule • Double-Declining-Balance Method Cost of Asset: $340,000 Salvage Value:...

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.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
BHULYAN QUICK-PRINT, INC. Printing Press Depreciation Schedule • Double-Declining-Balance Method Cost of Asset: $340,000 Salvage Value:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT