Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred o...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred o the appropriate blank in the Solutions (orange tab) worksheet in this workbook. Make sure you are utilizing Excel functions, formatting, and calculation abilities where applicable. Your worksheets should be easy to read and labelled properly Problem: (Depreciation-SL, DDB, SYD, Act) On January 1st, 2017, Marco Company, a medium-sized manufacturer, acquired the following assets Cost Salvage Value Useful Life Asset #1 $1,375,000 $75,000 5 Asset #2 $830,000 $ 55,000 7 Asset #3 $ 969,000 $ 10 Units of Production 2017 2018 2019 2017 2018 2019 2017 2018 2019 38,000 5 40,000 35,000 22,000 16,000 18,000 Class Life 75,000 85,000 72,000 10 Total units of output 160,000 Total units of output 100,000 "Total units of output=600,000 The following depreciation methods will be used: (1) straight-line, (2) double-declining-balance; (3) sum-of-the-years-digits; and (4) units-of-output 2 3 4 Instructions: 5 6 37 58 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 (a) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods described above. Provide the depreciation expense for years 2017, 2018, and 2019. To complete this, utilize Excel worksheets and tools to create a table that is easy to read, use formulas and cell references where appropriate, and label the annual depreciation for each year. Make sure all compenents are included such as depreciable cost, etc. NOTE: Round final solutions to two digits. (b) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods, assuming they were all purchased August 1st, 2017 Provide the depreciation expense for years 2017, 2018, 2019. Provide all solutions in the Solutions tab. Be sure to use cell references. (c)(1) Which depreciation method would maximize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? (c)(2) Which depreciation method would minimize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? CHECK FIGURES Asset #1 Asset #11 Asset#2 Asset #2 Asset #3 Asset #3 DDB SYD DDB SYD DDB SYD Part A Yr 2 Part B, Yr3 Part A, Yr 2 Part B, Yr3 Part A Yr 2 Part B. Yr3 $ 330,000.00 $ 310,555.56 $ 169,387,76 154,538.69 S $ 155,040.00 $ 151,222.73 Solutions to Application Assignment 84 Student Name: (a) Asset #1 Straight Line Double-declining balance Sum-of-the-Years Digts Units of Output (b) Asset #1 60) Straight Line Double-decining balance Sum of the Years: Digts Units of Output (1) Method to maximize net income (2) Method to minimize net income 2017 2017 2018 2018 2019 Asset #2 SL DOB 2010 SYD U-Output Asset #2 SA 008 SYD U-Output 2017 2017 2018 2018 2019 2019 Asset 3 SL DOB SYD U-Output Asset 3 St DOB SYD U-Output 2017 2017 2018 2018 2019 2019 Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred o the appropriate blank in the Solutions (orange tab) worksheet in this workbook. Make sure you are utilizing Excel functions, formatting, and calculation abilities where applicable. Your worksheets should be easy to read and labelled properly Problem: (Depreciation-SL, DDB, SYD, Act) On January 1st, 2017, Marco Company, a medium-sized manufacturer, acquired the following assets Cost Salvage Value Useful Life Asset #1 $1,375,000 $75,000 5 Asset #2 $830,000 $ 55,000 7 Asset #3 $ 969,000 $ 10 Units of Production 2017 2018 2019 2017 2018 2019 2017 2018 2019 38,000 5 40,000 35,000 22,000 16,000 18,000 Class Life 75,000 85,000 72,000 10 Total units of output 160,000 Total units of output 100,000 "Total units of output=600,000 The following depreciation methods will be used: (1) straight-line, (2) double-declining-balance; (3) sum-of-the-years-digits; and (4) units-of-output 2 3 4 Instructions: 5 6 37 58 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 (a) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods described above. Provide the depreciation expense for years 2017, 2018, and 2019. To complete this, utilize Excel worksheets and tools to create a table that is easy to read, use formulas and cell references where appropriate, and label the annual depreciation for each year. Make sure all compenents are included such as depreciable cost, etc. NOTE: Round final solutions to two digits. (b) Calculate the annual depreciation for each of the three assets for each of the four depreciation methods, assuming they were all purchased August 1st, 2017 Provide the depreciation expense for years 2017, 2018, 2019. Provide all solutions in the Solutions tab. Be sure to use cell references. (c)(1) Which depreciation method would maximize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? (c)(2) Which depreciation method would minimize net income for financial statement reporting for the 3-year period ending December 31, 2019 for the (a) situation? CHECK FIGURES Asset #1 Asset #11 Asset#2 Asset #2 Asset #3 Asset #3 DDB SYD DDB SYD DDB SYD Part A Yr 2 Part B, Yr3 Part A, Yr 2 Part B, Yr3 Part A Yr 2 Part B. Yr3 $ 330,000.00 $ 310,555.56 $ 169,387,76 154,538.69 S $ 155,040.00 $ 151,222.73 Solutions to Application Assignment 84 Student Name: (a) Asset #1 Straight Line Double-declining balance Sum-of-the-Years Digts Units of Output (b) Asset #1 60) Straight Line Double-decining balance Sum of the Years: Digts Units of Output (1) Method to maximize net income (2) Method to minimize net income 2017 2017 2018 2018 2019 Asset #2 SL DOB 2010 SYD U-Output Asset #2 SA 008 SYD U-Output 2017 2017 2018 2018 2019 2019 Asset 3 SL DOB SYD U-Output Asset 3 St DOB SYD U-Output 2017 2017 2018 2018 2019 2019
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
To complete the requirements of this exercise, access the most recent Form 10-K for both Exxon Mobil and Chevron. Required: a. Determine whether each company's foreign operations have a predominant...
-
AKA Bhd (AB) is a medium sized manufacturer of automobiles body kits with an average annual turnover of RM730, 000. Located in Seberang Perai Industrial Park, Penang, its fiber range of products...
-
LWF Corp. was a medium sized manufacturer of fixtures for home and industrial use. Established in 1994, the firm designed, manufactured, and distributed its products throughout Canada. Until 2006,...
-
Evaluate and simplify the following derivatives. d dx -(x Inx)
-
Prepare a comparative common-size income statement for Sensible Music Co., using the 2010 and 2009 data of Exercise and rounding to four decimalplaces. Sensible Music Co. Comparative Income...
-
Why must the staff at the alternate site continue to observe backup strategies that are in place at the primary site?
-
The accounts of Valentine Moving Company follow with their normal balances at Requirement 1. Prepare Valentines trial balance at April 30, 2010. Common stock Insurance expense $ 59,500 Trucks $...
-
A large St. Louis feed mill, Robert Orwig Processing, prepares its 6- month aggregate plan by forecasting demand for 50- pound bags of cattle feed as follows: January, 1,000 bags; February, 1,200;...
-
Question 1 Fashy Online (referred to as "Fashy"), an online store, has been in operation for the last 15 years and sells a wide range of apparel. All customers will need to register with Fashy before...
-
Using the techniques you learned, redesign your Critical Thinking Assignments from Module 2 to make them more complex. Be sure to create a new flowchart for both. Discuss the changes you made to the...
-
If a student throws two dice, she wins $16 if the sum of the numbers is even. For the game to be fair, how much should she pay to play the game? (4 Marks) $ 8 $2 $0.3 $5.8
-
Moral Panics, Sex Offender Registration, and Youth In her article, "There Are Too Many Kids on the Sex Offender Registry," Lenore Skensazy discusses the unpopular view that perhaps sex offender...
-
On May 4, 2XX2, an investor company owns 30% of the outstanding common stock of an investee and can exercise significant influence over the investee. On May 4, 2XX2, immediately preceding the sale of...
-
1. Given the following graph, showing a field of budget constraints and indifference curves for Olivia, answer the following questions: Income (per day) $72 $48 $24 O L 24 W W W 2 4 6 L 1 1 22 20 18...
-
Given the following information, what would the ending inventory value per unit be on April 30 under the weighted-average method in a perpetual inventory system? Units of Inventory Dates Opening...
-
list and discuss briefly, your position that you will be using in the BSC Case and the four perspectives you have identified. Complete discussion by naming and discussing a fifth sustainability...
-
You are in charge of scheduling for computer science classes that meet Mondays, Wednesdays and Fridays. There are 5 classes that meet on these days and 3 professors who will be teaching these...
-
Assume today is the 21st of February. Using the information below, FT Extract, answer the following questions (parts i and ii). You work for a US company that is due to receive 250 million in June...
-
Patty Bayan is a single taxpayer living at 543 Space Drive, Houston, TX 77099. Her Social Security number is 466-33-1234. For 2012, Patty has no dependents, and her W-2 from her job at a local...
-
Jason and Mary Wells, friends of yours, were married on December 30, 2012. They know you are studying taxes and have come to you with a question concerning their filing status. Jason and Mary would...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-7. Ivan sold the following securities during the year and received a Form 1099-B that...
-
What is the relation between accounting and recordkeeping?
-
Who are the internal and external users of accounting information?
-
What are internal controls and why are they important?
Study smarter with the SolutionInn App