Answer Happy

Question 2 Use the tabulated information and Excel workbook from Question 1 to plot the following scatter plots on the same set of axes: 2.1. Book Value (BVK) from straight-line method vs "End of Year Period" (k), (1) 2.2. Book Value (BVK) from 200%declining balance method and vs "End of Year Period" (k), (1) 2.3. Book Value (BV) from 150% declining balance method "End of Year Period" (k). (1) Follow the following instructions carefully when constructing the scatter plots: The three plots must be constructed in the sheet tilled "Plots". (1) The three plots must be on the same set of axes. The plots must be coloured differently. ? (1) (1) Legends must be used differentiate the plots. (1) The chart title and the axes must be clearly labelled. (1)
Expert Q&A Show full question Answers M Mechanical Engineering expert For straight line depreciation, Annual depreciation = (Initial book value- salvage value)/useful life For 200% depreciation, Annual depreciation = 2(asset cost- accumulated depreciation)/useful life For 150% depreciation, Annual depreciation = 1.5(asset cost- accumulated depreciation)/useful life = Year IKUMS II 11 COMEN FREE CHIOSCE ACE וונה יה 000? 00012 HOVO CACOOR EEEEECO E 1 2 3 4 4 5 6 T 8 TRAXIS19 REXC CIRK.LY .נירור.1 6 TETOG 0000025 GLETZ 6 GOSUEDE 10 11 12 IKE4 COMO GREED : INGLL41 19. EBZTIGE ORDEZ 66EEEZE COEEIZ ET Straight Line Depreciation 200% Depreciation 150% Depreciation Book Value at beginning Depreciation Book value at Book Value at Accumulated Depreciation in Book Value at Book Value at Accumulated Depreciation Book Value at end of year beginning of year Depreciation the year of year end of the year beginning of year Depreciation in the year end of the year 2:2000 2220000 2500000 520000 7500030 21250 50000 obo 125000 / 7040000 230000 651000 906567 435:55 6097778 5768730 731250 338435 6430313 0810000 230000 G380000 G097778 1402222 AGIO 5091239 0430313 1069583 321515 G108797 5500000 290000 6350000 S691259 1908741 37917 5311843 5108797 139120 305143 SB0315 : 55111 21BIS 15412 540122 1 2011 1513182 61 2000 230000 5590000 499729 2542281 330515 4827205 1900521 275009 5217530 3890000 230000 4627203 2872795 308480 4115724 3237530 2202470 4973053 SGB0000 230000 5430000 4818724 3181276 287915 4330809 4975GS3 2514:47 248783 4726371 5430000 30000 5200000 3469191 268721 3762089 4726871 2773129 20634 4490527 1/2012 12.12.11 2511-16 0723 21:25 12:01 4970000230000 09 3998/17 3277197 4200001 4052/01 4740000 230000 4510000 3277197 4222001 218480 3003717 4052701 3447299 202035 3830060 4510000 230000 4280000 305BI7 4441283 203914 2554801 38500G 3649934 192503 3GS7562 420000 290000 4060000 2540 4645192 150320 26544 3657550 384M3 182828 3474584 4115IXEN KERE 2 ARI1/ 1 SINIZ MINES MM 1 MID 11h 2820000 Sewa 233000 3990000 2430551 3023149 165790 222106) 3300950 4199.00 105045 230000 3360000 3178939 134737 21663 2: 3135903 4304997 156793 2979107 3360000 230000 3130000 2166323 5333677 144422 2021902 2979107 4520593 148955 2830152 113000 2.22.000 200000 5471 2001902 134743 ANA 1987 4664848 141506 268546 2 KONEX 2 25 T/ 2001 TI2 116412 2530212 2670000233000 244000 1701201 5739999 117420 1643881 2554212 494578 127711 2420902 2440000 230000 2210000 1643881 583GHIS 109592 1534289 2420002 5073495 2300177 2210000 230000 1980000 1534289 5965711 102286 1432003 2205177 5194623 115259 2189913 23.00 14120011 606202 45457 12365.36 21R1911 10495 12 1520000 1 016 2100 124MM 2000922 500125 10000 1901 1520000 230000 1290000 1247434 6232560 89162 1264271 1970401 3523599 98820 1877981 1290000 230000 1164271 SCH 77618 6335729 1877311 5622419 93873 1783702 1050000 30000 830000 1086553 6413347 72414 1014210 1783702 5746298 89185 1694517 KO SIKO 1012018 414,10 SIKUD 161512 SR683 101512 ok CRNA MIL 14 EDECETE 0000IGE TOOTEZ CYTOR KRISY. וייחו קוויריו חוו:וחו 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 USFIND T STETZT IKNOL GUISEE COULES сите 0000 רדיו החדר TATET 000000T ES99 80T XXCC