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.)

Asset Category Land Buildings Equipment Furniture Land Improvements Depreciation Method Not depreciated Straight line Straight line Straight line Straight line Useful Life (in years) Indefinite 40 4 8 16 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.) Buildings Equipment Furniture Land Land Improvements Total 15,316,200 5,888,910 4,457,785 1,601,510 18,967,224 14,369,270 9,872,050 2,361,350 7,820,640 2,041,930 0 56,433,899 26,262,970 0 0 0 0 0 21,205,110 6,059,295 33,336,494 12,233,400 9,862,570 82,696,869 Cost At January 1, 2020 Additions Disposal At December 31, 2020 Accumulated Depreciation At January 1, 2020 Depreciation expense Disposal At December 31, 2020 Carrying Amount At January 1, 2020 At December 31, 2020 0 0 0 0 0 0 0 0 0 0 0 0 0 0 15,316,200 4,457,785 18,967,224 9,872,050 7,820,640 56,433,899 0