Question Hi could someone help me solve this? Thank you!! 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 Cost At January 1, 2020 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 56,433,899 26,262,970 Additions 0 0 0 0 0 0 21,205,110 6,059,295 33,336,494 12,233,400 9,862,570 82,696,869 0 0 0 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 15,316,200 4,457,785 18,967,224 7,820,640 9,872,050 12,233,400 56,433,899 12,233,400 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.) Province Cost Accumulated Depreciation Carrying Amount British Columbia 0 Ontario 0 Quebec 0 Total 0 0 0 Please enter each category's useful life as given on Question Page 2. 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 38 4 7 15
SXAJKH The Asker · Accounting
Hi could someone help me solve this? Thank you!!
Transcribed Image Text: 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 Cost At January 1, 2020 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 56,433,899 26,262,970 Additions 0 0 0 0 0 0 21,205,110 6,059,295 33,336,494 12,233,400 9,862,570 82,696,869 0 0 0 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 15,316,200 4,457,785 18,967,224 7,820,640 9,872,050 12,233,400 56,433,899 12,233,400
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.) Province Cost Accumulated Depreciation Carrying Amount British Columbia 0 Ontario 0 Quebec 0 Total 0 0 0
Please enter each category's useful life as given on Question Page 2. 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 38 4 7 15
More Transcribed Image Text: 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 Cost At January 1, 2020 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 56,433,899 26,262,970 Additions 0 0 0 0 0 0 21,205,110 6,059,295 33,336,494 12,233,400 9,862,570 82,696,869 0 0 0 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 15,316,200 4,457,785 18,967,224 7,820,640 9,872,050 12,233,400 56,433,899 12,233,400
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.) Province Cost Accumulated Depreciation Carrying Amount British Columbia 0 Ontario 0 Quebec 0 Total 0 0 0
Please enter each category's useful life as given on Question Page 2. 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 38 4 7 15
Community Answer
ME1FZ8
10ln^(0)0:9Building:- Total cast on 31 Dec 2020 rarr2,12,05,110useful life - 38 yrsSralgen biva rarr Dep. =>2,12,05,110 xx1y,=>558029 (Approne)Carrying dml. as on 31-Dec. 2020 rarr2,12,05,110-558029=>206,47,081Equipment:- Total cat on 31 Dec. 2020 rarr60,59,295 useful life rarr4 yrsCarrying Amt. as at 31-Dee 2020=>6059295-1514828=>45,44,467furniture :- Total cout on 31Dec.202033,33,36,494useful life =>7 gredraight lingepep =>(3,33,36,494)/(7" yrs ")=>47(62,356 Approx)Catrying dml. as on 31 Dec. 2020 rarr3,33,36494-4762352=>28574138land Improvemente :- Total cat on 31 Dee. 2020 & ... See the full answer