\begin{tabular}{|l|c|c|} \hline Asset Category & Depreclation Method & Useful Life (in Yeara) \\ \hline Land & Not depreciated & Indefinite \\ \hline Buildings & Straight line & 39 \\ \hline Equipment & Straight line & 4 \\ \hline Furniture & Straight line & 6 \\ \hline Land Improvements & Straightline & 14 \\ \hline \end{tabular} Dataset Background: James, the owner of Future Electronics has contacted you to review his fixed asset records. Future Electronics was a Canadian conusmer and home electronics store chain. It was established in 2017 in Vancouver, British Columbla, The campany opened a few new stores in Ontario in 2019 and continued its expansion into Qubee in 2020 . Jomes has provided you with a spreadsheet containing the company's fixed asset dats (over 1,500 records) and has asked you to prepare a fixed asset schedule, which will be included in the notes to the company's financial statements for fiscal 2020 James included the following information from the company's fived asset policies: - The company has five fixed assets cotegories; fand, buildings, equipment, furniture, and land improvements fe.g. fencing and parking lots). - All fixed assets but land are depreciated using the straight-line method. Estimated residual values are included it the 5preadsheet. Estimated useful lives are given at the top of this page. - The company charges a full month's depreciation in the month when a fixed asset is put into service, fegarcloss of when in the month the asset is put into service. For example, if a fixed asset is put into service on March 21, a full-month depreciation will be charged for March, although the asset is to be used for only 10 days of March. 9. Create a PivotTable and complete the following fixed asset schedute. Future Electranics will include the schedufe in the notes to its financial statements for fiscal 2020 . (Express every number as a postive number.) 10. Create a PrivotTable and determine total cost, accumulated depreciation and carrying amount of facd assets af December 31,202? by each province. (Express every number as a postive number) \begin{tabular}{|l|c|c|} \hline Asset Category & Depreciation Method & Useful Life (in Years) \\ \hline Land & Not depreciated & Indefinite \\ \hline Buildings & Straigit line & 39 \\ \hline Equipment & Straight line & 4 \\ \hline Furniture & Straight line & 6 \\ \hline Land Improvements & Straight line & 14 \\ \hline \end{tabular} 9. Create a PlvotTable and complete the following fixed asset sciedule. Future Electronics will include the schedule in the notes to its firmatial statomante for fiteral 2020 . (Exaress everv number as a bostive number.) 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,) Column Labels \begin{tabular}{lrrrrrrr} Values & Bulldings & Equipment & Furniture & Land & Land Improvements & (blank) & Grand Total \\ \hline Sum of BegaccumDepr & 465,268.0 & 798,879.0 & 3,421,627.0 & & 1,049,947.0 & 5,735,721.0 \\ Count of CurrentYearDepr & 67.0 & 470.0 & 907.0 & 24.0 & 47.0 & 224.0 & UN//A \\ Count of EndAccumDept & 67.0 & 470.0 & 907.0 & 24.0 & 47.0 & 224.0 & tNN/A \end{tabular} Dataset Background: James, the owner of Future Electronics has contacted you to review his fixed asset records. Future Electronics was o Canadian conusmer and home electronics store chain. It was established in 2017 in Vancouver, British Columbia. The company opened a few new stores in Ontario in 2019 and continued its expansion into Qubec in. 2020. James has provided you with a spreadsheet containing the company's fixed asset data (over 1,500 records) and han asked you to prepare a fixed asset schedule, which will be included in the notes to the company's financial statements: for fiscal 2020 James included the following information from the company's fixed asset policies. - The company has five fixed assets categories, land, buildings, equipment, furniture, and land improvements (e.g. fencing and parking lots). - All fixed assets but land are depreciated using the straight-line method. Estimated residual values are included in the spreadsheet. Estimated useful lives are given at the top of this page. - The company charges a full month's depreciation in the month when a fixed asset is put into service, tegardless of when in the month the asset is put into service. For example, If a fixed asset is put into service on March 21, a fullmonth depreciation will be charged for March, although the asset is to be used for only 10 days of March \begin{tabular}{|l|c|c|} \hline Asset Category & Depreclation Method & Useful Life (in Yeara) \\ \hline Land & Not depreciated & Indefinite \\ \hline Buildings & Straight line & 39 \\ \hline Equipment & Straight line & 4 \\ \hline Furniture & Straight line & 6 \\ \hline Land Improvements & Straightline & 14 \\ \hline \end{tabular} Dataset Background: James, the owner of Future Electronics has contacted you to review his fixed asset records. Future Electronics was a Canadian conusmer and home electronics store chain. It was established in 2017 in Vancouver, British Columbla, The campany opened a few new stores in Ontario in 2019 and continued its expansion into Qubee in 2020 . Jomes has provided you with a spreadsheet containing the company's fixed asset dats (over 1,500 records) and has asked you to prepare a fixed asset schedule, which will be included in the notes to the company's financial statements for fiscal 2020 James included the following information from the company's fived asset policies: - The company has five fixed assets cotegories; fand, buildings, equipment, furniture, and land improvements fe.g. fencing and parking lots). - All fixed assets but land are depreciated using the straight-line method. Estimated residual values are included it the 5preadsheet. Estimated useful lives are given at the top of this page. - The company charges a full month's depreciation in the month when a fixed asset is put into service, fegarcloss of when in the month the asset is put into service. For example, if a fixed asset is put into service on March 21, a full-month depreciation will be charged for March, although the asset is to be used for only 10 days of March. 9. Create a PivotTable and complete the following fixed asset schedute. Future Electranics will include the schedufe in the notes to its financial statements for fiscal 2020 . (Express every number as a postive number.) 10. Create a PrivotTable and determine total cost, accumulated depreciation and carrying amount of facd assets af December 31,202? by each province. (Express every number as a postive number) \begin{tabular}{|l|c|c|} \hline Asset Category & Depreciation Method & Useful Life (in Years) \\ \hline Land & Not depreciated & Indefinite \\ \hline Buildings & Straigit line & 39 \\ \hline Equipment & Straight line & 4 \\ \hline Furniture & Straight line & 6 \\ \hline Land Improvements & Straight line & 14 \\ \hline \end{tabular} 9. Create a PlvotTable and complete the following fixed asset sciedule. Future Electronics will include the schedule in the notes to its firmatial statomante for fiteral 2020 . (Exaress everv number as a bostive number.) 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,) Column Labels \begin{tabular}{lrrrrrrr} Values & Bulldings & Equipment & Furniture & Land & Land Improvements & (blank) & Grand Total \\ \hline Sum of BegaccumDepr & 465,268.0 & 798,879.0 & 3,421,627.0 & & 1,049,947.0 & 5,735,721.0 \\ Count of CurrentYearDepr & 67.0 & 470.0 & 907.0 & 24.0 & 47.0 & 224.0 & UN//A \\ Count of EndAccumDept & 67.0 & 470.0 & 907.0 & 24.0 & 47.0 & 224.0 & tNN/A \end{tabular} Dataset Background: James, the owner of Future Electronics has contacted you to review his fixed asset records. Future Electronics was o Canadian conusmer and home electronics store chain. It was established in 2017 in Vancouver, British Columbia. The company opened a few new stores in Ontario in 2019 and continued its expansion into Qubec in. 2020. James has provided you with a spreadsheet containing the company's fixed asset data (over 1,500 records) and han asked you to prepare a fixed asset schedule, which will be included in the notes to the company's financial statements: for fiscal 2020 James included the following information from the company's fixed asset policies. - The company has five fixed assets categories, land, buildings, equipment, furniture, and land improvements (e.g. fencing and parking lots). - All fixed assets but land are depreciated using the straight-line method. Estimated residual values are included in the spreadsheet. Estimated useful lives are given at the top of this page. - The company charges a full month's depreciation in the month when a fixed asset is put into service, tegardless of when in the month the asset is put into service. For example, If a fixed asset is put into service on March 21, a fullmonth depreciation will be charged for March, although the asset is to be used for only 10 days of March