Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps as Lab 1-2 to the Alt Lab 1-2 Data.xlsx dataset. Open the Excel file Alt Lab 1-2 Data.xlsx. Required: Calculate depreciation expense using straight-line depreciation, double-declining balance, and sum-of-the-year's digits depreciation for 2025 and 2026. Ask the Question: How does depreciation expense differ by the depreciation method chosen? Master the Data: Pathway Gardens is a landscaping company. It has various equipment that appears on its fixed asset schedule included in the spreadsheet Lab 1-2.xlsx. We will compute the depreciation using three different methods and compare and contrast them. Software needed • Excel • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Alt Lab 1-2 Data.xlsx Perform the Analysis: Refer to original Lab 1-2 in the text for instructions and steps for each of the lab parts. Answer the following questions based the details provided. Question 1. What is the total depreciation expense for the total company using sum-of-the-years' digits for 2025? 2. What is the total depreciation expense using double declining balance for 2025? 3. What is the SYD depreciation for the reach-in refrigerator for 2025? 4. What is the SLN depreciation for the hot holding cabinet 1 for 2025? 5. What is the DDB depreciation for the hot holding cabinet 1 for 2026? Answer A JX B C D E 2025 1 Current Year 2 3 Year Placed in Service Useful Life Description Original Cost Salvage Value 4 2022 10 Conveyer Oven 1 18,000 2,500 5 2024 7 Reach-in Refrigerator 4,500 800 6 2022 7 Freezer 3,500 700 7 2022 5 Work table 200 50 8 2023 5 Pizza Prep Table 300 50 9 2021 7 Dough Mixer 500 100 10 2019 7 Dough Prep Equipmen 400 20 11 2022 5 Hot Holding Cabinet 1 150 50 12 2023 5 Hot Holding Cabinet 2 200 50 13 2022 5 Delivery Bags 200 14 2020 10 Conveyer Oven 2 15,000 2,000 15 2022 5 Pizza Prep Table 350 150 16 2022 5 Assorted utensils 300 17 18 LL F G H |

Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps as Lab 1-2 to the Alt Lab 1-2 Data.xlsx dataset. Open the Excel file Alt Lab 1-2 Data.xlsx. Required: Calculate depreciation expense using straight-line depreciation, double-declining balance, and sum-of-the-year's digits depreciation for 2025 and 2026. Ask the Question: How does depreciation expense differ by the depreciation method chosen? Master the Data: Pathway Gardens is a landscaping company. It has various equipment that appears on its fixed asset schedule included in the spreadsheet Lab 1-2.xlsx. We will compute the depreciation using three different methods and compare and contrast them. Software needed • Excel • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Alt Lab 1-2 Data.xlsx Perform the Analysis: Refer to original Lab 1-2 in the text for instructions and steps for each of the lab parts. Answer the following questions based the details provided. Question 1. What is the total depreciation expense for the total company using sum-of-the-years' digits for 2025? 2. What is the total depreciation expense using double declining balance for 2025? 3. What is the SYD depreciation for the reach-in refrigerator for 2025? 4. What is the SLN depreciation for the hot holding cabinet 1 for 2025? 5. What is the DDB depreciation for the hot holding cabinet 1 for 2026? Answer A JX B C D E 2025 1 Current Year 2 3 Year Placed in Service Useful Life Description Original Cost Salvage Value 4 2022 10 Conveyer Oven 1 18,000 2,500 5 2024 7 Reach-in Refrigerator 4,500 800 6 2022 7 Freezer 3,500 700 7 2022 5 Work table 200 50 8 2023 5 Pizza Prep Table 300 50 9 2021 7 Dough Mixer 500 100 10 2019 7 Dough Prep Equipmen 400 20 11 2022 5 Hot Holding Cabinet 1 150 50 12 2023 5 Hot Holding Cabinet 2 200 50 13 2022 5 Delivery Bags 200 14 2020 10 Conveyer Oven 2 15,000 2,000 15 2022 5 Pizza Prep Table 350 150 16 2022 5 Assorted utensils 300 17 18 LL F G H |

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter6: Investing And Financing Activities

Section: Chapter Questions

Problem 1.3C

See similar textbooks