Modify What SUPs Double Declining Balance Depreciation Schedule You are to add another depreciation schedule for What
Question:
Modify What SUP’s Double Declining Balance Depreciation Schedule
You are to add another depreciation schedule for What SUP. Use the ch4-01_DDB_student_name worksheet you created in this chapter. Add a new depreciation worksheet, labeled Asset 1003, using the Move or Copy Shortcut menu. The asset to be depreciated is the forge purchased on January 1, 2018, for $85,000 (again, its estimated salvage value is $4,000). The forge is to be depreciated (over 3 years) using the double declining balance method. Update the summary worksheet to include information on this asset. (Be careful to note the date this asset was acquired.) Save the file as ch4-02_DDB_student_name (replacing student_name with your name).
Print the newly completed worksheet for Asset 1003 and the modified Summary worksheet (showing only 2017–2019) in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer.
Salvage value is the estimated book value of an asset after depreciation is complete, based on what a company expects to receive in exchange for the asset at the end of its useful life. As such, an asset’s estimated salvage value is an important...
Step by Step Answer:
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen