{"id":16140,"date":"2021-11-16T03:19:06","date_gmt":"2021-11-16T03:19:06","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/complete-a-depreciation-schedule-for-furniture-resellers\/"},"modified":"2021-11-16T03:19:06","modified_gmt":"2021-11-16T03:19:06","slug":"complete-a-depreciation-schedule-for-furniture-resellers","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/complete-a-depreciation-schedule-for-furniture-resellers\/","title":{"rendered":"Complete a depreciation schedule for furniture resellers"},"content":{"rendered":"
\n

In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12\/31\/2016 using an Excel table. You will then sort, filter, and analyze the data in the table. These fixed assets, with associated data as of 12\/31\/2015, were acquired prior to the current year.<\/p>\n

Fixed Asset<\/p>\n

Machinery Garage<\/p>\n

Equipment Computers<\/p>\n

Date of<\/p>\n

Acquisition 1\/1\/2007 1\/1\/2009<\/p>\n

1\/1\/2013 Cost $8,200 $11,000 $4,000<\/p>\n

Salvage Value<\/p>\n

$700 $200<\/p>\n

$0<\/p>\n

Useful Life (years) 10<\/p>\n

9 5<\/p>\n

Accumulated Depreciation<\/p>\n

$6,750 $8,400<\/p>\n

$2,400<\/p>\n

Furniture Resellers also acquired lobby furniture on 1\/1\/2016. The lobby furniture had a cost of $2,000, an estimated salvage value of $400, and an estimated useful life of eight years.<\/p>\n

1. Open a Blank Workbook and save the file in your Chapter 06 folder as: EA6-A2-Depreciation-[YourName]<\/p>\n

2. Enter appropriate bank reconciliation headers in the range A1:A2; apply italic formatting.<\/p>\n

3. Enter the fixed-asset data in the range A4:F7; for the accumulated depreciation, enter the title but not the dollar amounts.<\/p>\n

4. Format the range A4:F7 as a table using Blue, Table Style Dark 6 and add Depreciation _ Schedule as the table name.<\/p>\n

5. Add a total row to the table that shows sums in columns C:D and an average in column E.<\/p>\n

6. Turn on the First Column and Last Column table style options.<\/p>\n

Adjust Table Rows and Columns 7. From within cell F7, extend the table to add one additional row and enter all fixed-asset information for the newly acquired asset.<\/p>\n

8. Add two columns to the far right of the table with the headers Depreciation Expense and Year-End Book Value, in that order.<\/p>\n

9. Wrap the text in the headers.<\/p>\n

10. Apply appropriate column widths and, if necessary, autofit the header row height. 11. Change the orientation of the worksheet to Landscape.<\/p>\n

Use Depreciation Functions<\/p>\n

12. Use an Excel function to calculate depreciation expense for each fixed asset under the sum of the years\u2019 digits method. Hint: Turn off calculated columns when entering the formulas for each fixed asset.<\/p>\n

13. Replace the formula with one that uses an Excel function to calculate depreciation expense for each fixed asset under the straight-line depreciation method. Use calculated columns so you can enter the formula in a single row and have it automatically extend to all other fixed assets.<\/p>\n

14. Use structured references to calculate the accumulated depreciation for each fixed asset.<\/p>\n

15. Use structured references with calculated columns to calculate the year-end book value for each fixed asset.<\/p>\n

16. Use the Sum function on columns F:H.<\/p>\n

Sort and Filter a Table 17. Sort the data based on accumulated depreciation from smallest to largest. 18. Filter the table to not display fixed assets with a salvage value of $200.<\/p>\n

19. Clear all filters; apply a new filter that displays only fixed assets with a useful life greater than six years.<\/p>\n

Create a Chart Using Quick Analysis<\/p>\n

20. Use Quick Analysis to create a bar chart displaying the year-end book value for each fixed asset presently displayed in the table. Position the chart below the table.<\/p>\n

21. Apply the Accounting number format with zero decimal places to all dollar amounts.\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12\/31\/2016 using an Excel table. You will then sort, filter, and analyze the data in the table. These fixed assets, with associated data as of 12\/31\/2015, were acquired prior to the current year. Fixed Asset Machinery Garage Equipment Computers Date of […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-16140","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/16140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=16140"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/16140\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=16140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=16140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=16140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}