locate the Depreciation Policy worksheet in the downloaded Excel file and enter the useful life of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Straight line Straight line Straight line Useful Life (in Years) Indefinite 40 6 6 14 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.) 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 Buildings 15,316,200 5,888,910. 0 21,205,110 0 0 15,316,200 Equipment 4,457,785 1,601,510 0 6,059,295 0 0 4,457,785 Furniture 18,967,224 14,369,270 0 33,336,494 0 0 18,967,224 Land 9,872,050 2,361,350 0 12,233,400 0 0 9,872,050 Land Improvements 7,820,640 2,041,930 0 9,862,570 0 0 0 0 7,820,640 Total 56,433,899 26,262,970 0 82,696,869 0 0 0 56,433,899 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 British Columbia Ontario Quebec Total Cost 0 Accumulated Depreciation 0 Carrying Amount oooo 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 Straight line Straight line Straight line Useful Life (in Years) Indefinite 40 6 6 14 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.) 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 Buildings 15,316,200 5,888,910. 0 21,205,110 0 0 15,316,200 Equipment 4,457,785 1,601,510 0 6,059,295 0 0 4,457,785 Furniture 18,967,224 14,369,270 0 33,336,494 0 0 18,967,224 Land 9,872,050 2,361,350 0 12,233,400 0 0 9,872,050 Land Improvements 7,820,640 2,041,930 0 9,862,570 0 0 0 0 7,820,640 Total 56,433,899 26,262,970 0 82,696,869 0 0 0 56,433,899 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 British Columbia Ontario Quebec Total Cost 0 Accumulated Depreciation 0 Carrying Amount oooo
Expert Answer:
Answer rating: 100% (QA)
Answer Particulars Buildings Equipment Furniture Land Land Improveme... View the full answer
Related Book For
Business Statistics in Practice
ISBN: 978-0077404741
6th edition
Authors: Bruce Bowerman, Richard O'Connell
Posted Date:
Students also viewed these accounting questions
-
Data Computer Company manufactures hard drives for servers for all the major computer companies. Below you will find the information for their 2025 budget. Use the following information to create the...
-
In this chapter, we have suggested that building quality into a process and its people is difficult. Inspections are also difficult. To indicate just how difficult inspections an, count the number of...
-
In this section we have presented a commonly accepted way to compute the first, second, and third quartiles. Some statisticians, however, advocate an alternative method for computing Q1 and Q2 This...
-
(a) An n n matrix K is the encryption matrix for the Hill cipher. Give the encryption formula. (b) The plaintext is (2, 5, 1,0). Encrypt it (show your work and the ciphertext) using the Hill cipher...
-
The following table gives pairs of dependent and independent variables. In each case state whether you would expect the relationship between the two variables to be positive, negative, or uncertain....
-
Are economists typically more concerned about the limits to growth imposed by environmental degradation or those imposed by resource scarcity? Explain, noting the role of negative externalities in...
-
White Company can invest in one of two projects, TD1 or TD2. Each project requires an initial investment of $101,250 and produces the year-end cash inflows shown in the following table. Required 1....
-
Common Chemical Companys management is evaluating its product mix in an attempt to maximize profits. For the past two years, Common has produced four products, and all have large markets in which to...
-
This table lists the gross property tax distribution applicable to a local homeowner. Property Tax Distribution. Taxing Authority 2017 2018 Airport $45.88 $46.71 Citilink - PTC $63.69 $66.18 City...
-
Macinski Leasing Company leases a new machine to Sharrer Corporation. The machine has a cost of $70,000 and fair value of $95,000. Under the 3-year, non-cancelable contract, Sharrer will receive...
-
In 2019, Swiss tennis legend Roger Federer invested in a local shoe company, On Swiss Performance Running Shoes, and received common stock. On September 15th 2021, the stock ONON went through its...
-
Explain why, for the same inventory level, a revenue-sharing contract results in a lower sales effort from the retailer than if the retailer has paid for the product and is responsible for all...
-
What factors led Walmart to own its trucks although many retailers outsource all their transportation?
-
In 1984, NZ All Natural Ice Cream (NAN) began as a small shop in Christchurch, the largest city in the South Island of New Zealand. As NANs sales volume has increased significantly over the years, it...
-
What are some ways in which a firm such as Walmart benefits from good sourcing decisions?
-
Discuss the challenge to sustainability posed by the tragedy of the commons.
-
Express the direction 7 3 deg counterclockwise from the positive x - axis in the following different ways. For this problem north is positive y and east is positive x . a ) north of east b ) above...
-
The column shown in the figure is fixed at the base and free at the upper end. A compressive load P acts at the top of the column with an eccentricity e from the axis of the column. Beginning with...
-
The U.S. News & World Report website provides rankings of the best colleges and universities in the United States. The free version of Best Colleges gives information such as number of students...
-
Consider the situation of Exercise 10.59. Use the sample information to test H0: 21 = 22 versus Ha: 21 22 with a = .05. Based on this test, does it make sense to use the equal variances procedure?...
-
Use the Kruskal-Wallis H test to compare golf ball brands Alpha. Best. Century, and Divot using the data in Table 18.11. Use = .01 and the Excel add-in (MegaStat) output on the right side of Table...
-
On Wednesday, Paul bought more wrapping paper for 46 cash. However, it was raining hard for much of the day and sales were slow. After Paul had sold half of his total inventories for 32, he decided...
-
Try drawing up a statement of financial position for Jerry and Company as at 4 March.
-
Assume a business owns a 50 percent stake in a gold mine. As this ownership stake will not give control over the whole of the gold mine, can this resource be regarded as an asset of the business?
Study smarter with the SolutionInn App