Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

begin{tabular}{|l|c|c|} hline Asset Category & Depreclation Method & Useful Life (in Yeara) hline Land & Not depreciated & Indefinite hline Buildings & Straight

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Process Auditing And Techniques Guide

Authors: J.P. Russell

2nd Edition

087389782X, 978-0873897822

More Books

Students also viewed these Accounting questions

Question

=+ (b) Define a set function v, on , by (11.6) "o (f, g] = A(g-f).

Answered: 1 week ago