What SUP Partial Year Straight-Line Depreciation for Asset 1004 Create a new worksheet to calculate depreciation for a table purchased on August 1, 2017, for $95,000. It has an estimated salvage value of $2,000 and is to be depreciated over 10 years using the straight-line method. Follow the same process used in the chapter to calculate depreciation for partial periods. Save the workbook as ch4-07 SLN_PY_student_name (replacing student_name with your name). Print the newly created worksheet.