(Sub-total = 12 Marks) 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 (BV) from straight-line method vs "End of Year Period" (k), (1) 2.2. Book Value (BV) from 200%declining balance method and vs "End of Year Period" (k), (1) 2.3. Book Value (BVK) from 150% declining balance method "End of Year Period" (k). (1) A 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. (1) The plots must be coloured differently- (1) Legends must be used differentiate the plots. (1) The chart title and the axes must be clearly labelled. (1) (Sub-total = 8 Marks) + 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 = E IKOS COROCZ II - CIKKSC 000000 EEEEECO FLEX O Ow ZSE8085 9 IKA-19 WLING 5 --- 216344 IKEREX. CEMEX . II-II-7: INCLL- 4 7. 46112 EBZEIGE ET Straight Line Depreciation 200% Depreciation 150% Depreciation Book Value Bock value at Year at beginning Depreciation Book Value at Accumulated Depreciation In Book Value at Book Value at Accumulated Depreciation Book Value at of year end of year beginning of year Depreciation the year and of the year beginning of year Depreciation in the year end of the year 1 230000 22 11 500000 2000000 75000 375000 2125000 2 2000 230000 500000 boy 712 379200 3502 3 7040000 230000 6910000 906567 435500 6097773 0768750 731250 33843 6430111 4 0810000 230000 G-80000 G097778 1402222 ACG519 5591259 0430313 1009583 321512 G108797 5 3 5520000 230000 G350000 5691259 180671 37917 5311842 6108797 1391203 305140 6 h1D 511) 2181 354123 767015 51252 1513 5513189 7 6120000 23001 5990000 a9012 2542281 330513 0827203 3513189 1900511 222058 5237530 & 8 5890000 230000 5360000 4627203 2872793 308430 4310724 3237320 2202470 201876 4973053 SG00000 230000 5430000 4318724 3131276 287313 4330809 4973653 2524347 24878 4726571 10 5420000 290000 5200000 4090909 3469191 258721 3762089 4726871 2773129 4490522 11 1/6700 312121 112 111 12 4970000 230000 4740000 3998717 239005 327719 4200001 3233999 213303 405270 4740000 230000 451000 3277197 4222503 218480 3058717 4052701 3447299 202035 3830066 14 4510000 230000 4280000 3068717 4441383 203914 2554803 383000G 3649934 192503 3GS 75G2 15 4280000 230000 4060000 2546 4645197 190120 25644 3657552 18282 3474584 16 AILSINIZ.KEND AR 1951/ 1XINIZ Mlih MM Mhs Ah 1/16 3 17 2820000 230000 3990000 248095) 5023149 165710 221001 2300930 4199050 165045 18 2500000 230000 3360000 5178939 134737 2160323 3135903 4394097 1079 2979207 19 3360000 230000 3130000 2166321 5323577 14442 2021902 2979107 4520893 148955 2810152 20 31000 39000 2200000 2001902 54780AR 13479 13710 20152 4661 141508 268544 21 JU 220 ) 2570 125417 linn 2a 401155 1:11:12 2594212 22 2670000 230000 2440000 1701301 5738599 117420 1543881 2354212 4945785 127711 2426502 23 2440000 230000 2210000 164388 3830119 109592 1534239 2426602 5073493 2906177 24 2210000 230000 1980000 1534289 5965711 10238 143200 2305177 519423 145259 2189910 25 1912001 1750000 1412003 605777 45457 13355.6 2111 5810442 10405 2011122 26 125000 25000 1520000 1936 016 Mot 12100 2087422 1001 27 1520000 23000 1290000 1244434 6252565 1164271 1976401 3523599 98823 1877581 28 1210000 230000 1000000 1144272 G395729 1080653 1877581 5623419 93873 1783702 29 1050000 230000 1086553 6413247 72444 1014210 1783700 5746293 89185 1694517 . BIKO 30 RONDO 200 14010 A 4111 1691512 Sesame 51051113 10'1512 60 SCHE 419210 CREARE 14. W. 04 EDESETE TOOTZEZ . SILLE STETZT CODEC VEWD?L S878 LIIVAL ZOTES STOLL 000065 er Dvo CUS DEX (Sub-total = 12 Marks) 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 (BV) from straight-line method vs "End of Year Period" (k), (1) 2.2. Book Value (BV) from 200%declining balance method and vs "End of Year Period" (k), (1) 2.3. Book Value (BVK) from 150% declining balance method "End of Year Period" (k). (1) A 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. (1) The plots must be coloured differently- (1) Legends must be used differentiate the plots. (1) The chart title and the axes must be clearly labelled. (1) (Sub-total = 8 Marks) + 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 = E IKOS COROCZ II - CIKKSC 000000 EEEEECO FLEX O Ow ZSE8085 9 IKA-19 WLING 5 --- 216344 IKEREX. CEMEX . II-II-7: INCLL- 4 7. 46112 EBZEIGE ET Straight Line Depreciation 200% Depreciation 150% Depreciation Book Value Bock value at Year at beginning Depreciation Book Value at Accumulated Depreciation In Book Value at Book Value at Accumulated Depreciation Book Value at of year end of year beginning of year Depreciation the year and of the year beginning of year Depreciation in the year end of the year 1 230000 22 11 500000 2000000 75000 375000 2125000 2 2000 230000 500000 boy 712 379200 3502 3 7040000 230000 6910000 906567 435500 6097773 0768750 731250 33843 6430111 4 0810000 230000 G-80000 G097778 1402222 ACG519 5591259 0430313 1009583 321512 G108797 5 3 5520000 230000 G350000 5691259 180671 37917 5311842 6108797 1391203 305140 6 h1D 511) 2181 354123 767015 51252 1513 5513189 7 6120000 23001 5990000 a9012 2542281 330513 0827203 3513189 1900511 222058 5237530 & 8 5890000 230000 5360000 4627203 2872793 308430 4310724 3237320 2202470 201876 4973053 SG00000 230000 5430000 4318724 3131276 287313 4330809 4973653 2524347 24878 4726571 10 5420000 290000 5200000 4090909 3469191 258721 3762089 4726871 2773129 4490522 11 1/6700 312121 112 111 12 4970000 230000 4740000 3998717 239005 327719 4200001 3233999 213303 405270 4740000 230000 451000 3277197 4222503 218480 3058717 4052701 3447299 202035 3830066 14 4510000 230000 4280000 3068717 4441383 203914 2554803 383000G 3649934 192503 3GS 75G2 15 4280000 230000 4060000 2546 4645197 190120 25644 3657552 18282 3474584 16 AILSINIZ.KEND AR 1951/ 1XINIZ Mlih MM Mhs Ah 1/16 3 17 2820000 230000 3990000 248095) 5023149 165710 221001 2300930 4199050 165045 18 2500000 230000 3360000 5178939 134737 2160323 3135903 4394097 1079 2979207 19 3360000 230000 3130000 2166321 5323577 14442 2021902 2979107 4520893 148955 2810152 20 31000 39000 2200000 2001902 54780AR 13479 13710 20152 4661 141508 268544 21 JU 220 ) 2570 125417 linn 2a 401155 1:11:12 2594212 22 2670000 230000 2440000 1701301 5738599 117420 1543881 2354212 4945785 127711 2426502 23 2440000 230000 2210000 164388 3830119 109592 1534239 2426602 5073493 2906177 24 2210000 230000 1980000 1534289 5965711 10238 143200 2305177 519423 145259 2189910 25 1912001 1750000 1412003 605777 45457 13355.6 2111 5810442 10405 2011122 26 125000 25000 1520000 1936 016 Mot 12100 2087422 1001 27 1520000 23000 1290000 1244434 6252565 1164271 1976401 3523599 98823 1877581 28 1210000 230000 1000000 1144272 G395729 1080653 1877581 5623419 93873 1783702 29 1050000 230000 1086553 6413247 72444 1014210 1783700 5746293 89185 1694517 . BIKO 30 RONDO 200 14010 A 4111 1691512 Sesame 51051113 10'1512 60 SCHE 419210 CREARE 14. W. 04 EDESETE TOOTZEZ . SILLE STETZT CODEC VEWD?L S878 LIIVAL ZOTES STOLL 000065 er Dvo CUS DEX