ACC – Chapter 4 Case Problem 1 – KELLY’S BOUTIQUE
Chapter four Case Drawback 1:KELLY'S BOUTIQUEKelly's Boutique owned the next fastened property as of December 31, 2010:DescriptionAsset #101102103AssetBuildingComputer SystemPhone SystemDate acquired1/1/071/1/09 1/1/09Price$500,000$65,000$46,500Salvage worth$50,000$1,000$1,000Estimated helpful life20years5years5years You might be to create a set asset depreciation abstract and particular person depreciation worksheets for Kelly's Boutique utilizing the straight-line depreciation technique based mostly on the data tabulated above. Remember to pay shut consideration to the date of buy for every asset in order that your abstract sheet is appropriate. The abstract sheet want solely embrace depreciation from 2007 via 2010. Particular person property should present depreciation over their complete helpful life. Comply with the textual content examples for formatting. Label your worksheets as follows: Abstract SL, Asset 101 SL, Asset 102 SL, and Asset 103 SL. In the identical workbook, create Kelly's Boutique's fastened asset depreciation abstract and particular person depreciation worksheets utilizing the double declining stability technique and based mostly on the tabulated info. Once more, pay shut consideration to the date of buy for every asset in order that your abstract sheet is appropriate. Label your worksheets: Abstract DDB, Asset 101 DDB, Asset 102 DDB, and Asset 103 DDB.In the identical workbook, subsequent create Kelly's Boutique's fastened asset depreciation abstract and particular person depreciation worksheets utilizing the sum-of-the-year's digits technique and based mostly on the tabulated info. Pay shut consideration to the date of buy for every asset in order that your abstract sheet is appropriate. Label your worksheets: Abstract SYD, Asset 101 SYD, Asset 102 SYD, and Asset 103 SYD. In the identical workbook, it's best to now create a chart of Asset 101's depreciation (over its 20-year estimated helpful life) that compares the straight-line, double103104declining stability, and sum-of-the-year's digits strategies of calculating depreciation. Label this worksheet: Chart. Select any 2D line chart and chart structure that you simply like. Save the workbook as ch4-03_student_name (changing student_name along with your title). Print all worksheets in Worth view, along with your title and date printed within the decrease left footer and the file title within the decrease proper footer.