9. Create a PivotTable and complete the following fixed asset schedule. Future Electronics will include the schedule in the notes to its financial statements for fiscal 2020 (Express every number as a postive number.) Answer is not complete. Diskding's Familian Lave Lavt Mectives 1004 Cost At January 1, 2020 15,310.200 4,457,785 18.067.224 9.872.050 7.820,040 56,433,899 Additions 5,888,010 1,001,510 14,309,270 2.301.350 2,041,000 26,262,970 Disposal 0 0 O 0 0 At December 31, 2020 21,205,110 6.050.205 33,330,404 12.233,400 9,002,570 82,696,869 Accumulated Depreciation At January 1, 2020 405,208 706,870 Depreciation expense 1,320,217 3,421,027 O 2,000,620 00 1,040,047 00 402,778 5,735,721 4,779,621 Disposal O 0 0 At December 31, 2020 405.268 2.125.000 0.382.253 1,542,725 10,515,342 Carrying Amount At January 1, 2020 14,850,932 At December 31, 2020 3,658,000 3,034,100 15,545,507 26,054,241 0.872.050 6,770,603 50,690,178 12,233,400 8.319.845 51,441,685 10. Create a PrivotTable and determine total cost, accumulated depreciation and carrying amount of fixed assets at December 31, 2020 by each province. (Express every number as a postive number.) Answer is not complete. Province Cost British Columbia 43,244,025 Ontario 20,155,104 Quebec 10.297.740 Total 82,696,869 Accumulated Depreciation Carrying Amount 43.244.025 20.155.104 10.297,740 0 82,696,869 Before you proceed, please locate the "Depreciation Policy" worksheet in the downloaded Excel file and enter the useful life of each asset category as given below: Asset Category Land Buildings Equipment Furniture Land Improvements Depreciation Method Not depreciated Straight line Useful Life (in Years) Indefinite 38 4 8 Straight line 16 Straight line Straight line