Question

You are required to calculate depreciation on assets for the year 2008 to 2018 and fill in the above depreciation schedule for the management reporting ( show all the working notes in detail)

Following is the detail of Fixed Assets owned by Kingfisher Limited: Price Asset Name Year Salvage Life Method 2008 2009 2010 2011 Depreciation for the year (E) 2012 2013 2014 Buildings 25.000 2008 2.500: 25 SL Plant & Machinery 18.000: 2008 1.800 10 DDB Vehicles 22.000! 2009 2.200: 10 DDB Electronic Equipments 12.000: 2009 1.200 5 DDB Computers 8.000; 2010 800 DDB Printers 6,500 2012 DDB Furniture & Fixtures 4.800! 2013 480 $ DDB You are rywired to calcwlule depreciation on Assets for the year 2018 Ledenadmedule for the Management Reporting (Show all the working in the Note

Answer 1

												Depreciation	for the year £
Asset Name	Price £	Year	Salvage £	Life	Method	Depreciation rate	Depreciable Amount £	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018
Buildings	25,000	2008	2,500	25	SL	4%	22,500	900	900	900	900	900	900	900	900	900	900	900
Plant & machinery	18,000	2008	1,800	10	DDB	20%	16,200	3,600	2,880	2,304	1,843	1,475	1,180	944	755	604	483	133
Vehicles	22,000	2009	2,200	10	DDB	20%	19,800		4,400	3,520	2,816	2,253	1,802	1,442	1,153	923	738	753
Electronic Equipments	12,000	2009	1,200	5	DDB	40%	10,800		4,800	2,880	1,728	1,037	355
Computers	8,000	2010	800	5	DDB	40%	7,200			3,200	1,920	1,152	928	-
Printers	6,500	2012	650	5	DDB	40%	5,850					2,600	1,560	936	562	192
Furniture & Fixtures	4,800	2013	480	5	DDB	40%	4,320						1,920	1,152	691	415	142

Formulas:

А B C D E F G H. K M N 1 2 Depreciation for the year £ 3 4 5 6 7 8 9 10 11 12 13 Asset Name Price £ Year Salvage £ Life Method Depreciation rate Depreciable Amount £ 2008 2009 2010 2011 2012 2013 Buildings 25000 2008 2500 25 SL =((C4-E4)/25)/C4 =C4-E4 =(C4-E4)/25 =24 =K4 =L4 =M4 =N4 Plant & machinery 18000 2008 1800 10 DDB =1/F5*2 =C5-E5 =C5* 20% =(C5-45)* 20% =(C5-35-K5)*20% =(C5-35-K5-L5)*20% =(C5-35-K5-L5-M5)* 20% =(C5-35-K5-L5-M5-N5)*20% Vehicles 22000 2009 2200 10 DDB =1/F6*2 =C6-E6 =(C6-J6)* 20% =(C6-J6-K6)* 20% =(C6-16-K6-L6)* 20% =(C6-J6-K6-L6-M6)*20% =(C6-46-K6-L6-M6-N6)* 20% Electronic Equipments 12000 2000 1200 5 DDB =1/F7*2 =C7-E7 =(C7-17)*40% =(C7-17-K7)*40% =(C7-17-K7-L7)* 40% =(C7-17-K7-L7-M7)*40% =17-SUM(K7:N7) Computers 8000 2010 800 5 DDB =1/F8*2 =C8-E8 =(C8-18-K8)*40% =(C8-18-K8-L8)*40% =(C8-18-K8-L8-M8)*40% =18-SUM(K8:N8) Printers 6500 2012 650 5 DDB =1/F9*2 =C9-E9 =(C9-19-59-L9-M9)*40% =(C9-19-K9-L9-M9-N9)*40% Furniture & Fixtures 4800 2013 480 5 DDB =1/F10*2 =C10-E10 =(C10-J10-10-L10-M10-N10)*40% Р R S T 1 2 3 2014 2015 2016 2017 2018 4 =04 =P4 =Q4 =R4 =S4 5 =(C5-45-65-L5-M5-N5-05)* 20% =(C5-35-K5-L5-M5-N5-05-P5)* 20% =(C5-45-K5-L5-M5-N5-05-P5-05)* 20% =(C5-15-K5-L5-M5-N5-05-P5-05-R5)* 20% =(15-SUM(5:55)) 6 =(C6-36-K6-L6-M6-N6-06)* 20% =(C6-J6-K6-L6-M6-N6-06-P6)* 20% =(C6-J-K6-L6-M6-N6-06-P6-26)* 20% =(C6-46-K6-L6-M6-N6-06-P6-26-R6)* 20% =(16-SUM(16:56)) 7 8 0 9 =(C9-19-K9-L9-M9-N9-09)* 40% =(C9-19-K9-L9-M9-N9-09-29)*40% =19-SUM(N9:09) 10 =(C10-J10-K10-L10-M10-N10-010)*40% =(C10-J10-K10-L10-M10-N10-010-P10)* 40% =(C10-J10-10-L10-M10-N10-010-P10-Q10)*40% =110-SUM(010:R10) 11