Question: Microsoft Excel please help with functions Al fx Chloe's Coffee Shop A B D E F 1 Chloe's Coffee Shop 2 3 Cost of Asset



Microsoft Excel please help with functions
Al fx Chloe's Coffee Shop A B D E F 1 Chloe's Coffee Shop 2 3 Cost of Asset 4 Salvage Value 5 Useful Life $24,000.00 $9,000.00 5 6 7 Straight Line Depreciation Depreciation Accumulated expense for depreciation at year end of year 1 Book value at end of year End of Year 8 9 10 11 12 3 4 5 13 14 15 16 Declining-Balance Depreciation Depreciation Accumulated expense for depreciation at End of Year year end of year 1 Book value at end of year 2 3 4 5 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 14 On the Depreciation worksheet, in cell B9, use the SLN function to calculate the straight line depreciation amount for year 1. AutoFill the function down to B13. 15 In cell C9, calculate the accumulated depreciation at the end of year 1. In cell C10, calculate the accumulated depreciation at the end of year 2. AutoFill the calculation down to C13. 16 In cell D9, calculate the book value at the end of year 1. AutoFill the calculation down to D13. 17 In cell B18, use the DB function to calculate the declining-balance depreciation amount for year 1. AutoFill the function down to B22. 18 In cell C18, calculate the accumulated depreciation at the end of year 1. In cell C19, calculate the accumulated depreciation at the end of year 2. AutoFill the calculation down to C22. 19 In cell D18, calculate the book value at the end of year 1. AutoFill the calculation down to D22. Chloe's Coffee Shop Cost of Asset Salvage Value Useful Life $24,000.00 $9,000.00 5 Straight Line Depreciation Depreciation Accumulated expense for depreciation at year end of year 1 2 3 Book value at end of year End of Year 4 5 Declining-Balance Depreciation Depreciation Accumulated expense for depreciation at End of Year year end of year Book value at end of year 1 2 3 4 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
