In the same workbook, create Wine Depot’s fixed asset depreciation sum- mary and individual depreciation worksheets using the double declining balance method and based on the same tabulated information. Again, pay close attention to the date of purchase for each asset so that your summary sheet is correct. Label your worksheets: Summary DDB. Asset 101 DDB, Asset 102 DDB, and Asset 103 DDB. In the same workbook, next create Wine Depot’s fixed asset depreciation summary and individual depreciation worksheets using the sum-of-the-year’s digits method and based on the tabulated information. Be sure to pay close attention to the date of purchase for each asset so that your summary sheet is correct. Label your worksheets: Summary SYD. Asset 101 SYD, Asset 102 SYD, and Asset 103 SYD. In the same workbook, you should now create a chart of Asset 103’s depreci- ation (over its 15-year estimated useful life) that compares the straight-line, dou- ble declining balance, and sum-of-the-year’s digits methods of calculating depreciation. Label this worksheet: Chart. Choose any 2D line chart and chart layout that you like.
Home » Accounting Class Homework Help » In the same workbook, create Wine Depot’s fixed asset depreciation sum- mary
In the same workbook, create Wine Depot’s fixed asset depreciation sum- mary
- by Jared Walker