1) 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.

2) 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.

3) In cell D9, calculate the book value at the end of year 1. AutoFill the calculation down to D13.

4) In cell B18, use the DB function to calculate the declining-balance depreciation amount for year 1. AutoFill the function down to B22.

5) 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.

6) In cell D18, calculate the book value at the end of year 1. AutoFill the calculation down to D22.

NEED HELP WITH THE FORMULAS!!!!!!

B C D E F G 1 Chloe's Coffee Shop 2 3 Cost of Asset 4 Salvage Value 5 Useful Life NMON $24,000.00 $9,000.00 5 Straight Line Depreciation Depreciation Accumulated expense for depreciation at year end of year Book value at end of year 8 End of Year 1 2 3 9 10 11 12 13 14 15 4 5 16 Declining-Balance Depreciation Depreciation Accumulated expense for depreciation at End of Year year Book value at end of year end of year 1 2 17 18 19 20 21 22 23 3 4 5