Modify What SUPs Straight-Line Depreciation Schedule You are to add another depreciation schedule for What SUP. Use
Question:
Modify What SUP’s Straight-Line Depreciation Schedule
You are to add another depreciation schedule for What SUP. Use the ch4-01_SLN_student_name.xls 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 a forge purchased on January 1, 2018, for $85,000. It has an estimated salvage value of $4,000 and is to be depreciated over 3 years using the straight-line method. Update the summary worksheet to include information on this new asset. (Be careful to note the date this asset was acquired.) Save the file as ch4-02_SLN_student_name (replacing student_name with your name).
Print the newly completed worksheet for Asset 1003 and the modified Summary worksheet 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