Modify What SUPs Sum-of-the-Years Digits Depreciation Schedule You are to add another depreciation schedule for What SUP.
Question:
Modify What SUP’s Sum-of-the-Year’s Digits Depreciation Schedule
You are to add another depreciation schedule for What SUP. Use the ch4-01_SYD_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 4 years) using the sum-of-the-year’s digits 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_SYD_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