The Fraser River Corporation has purchased a new piece of factory equipment on January 1, 2018, and
Fantastic news! We've Found the answer you've been seeking!
Question:
The Fraser River Corporation has purchased a new piece of factory equipment on January 1, 2018, and wishes to compare three depreciation methods: straight-line, double-declining-balance, and units-of-production.
Transcribed Image Text:
The equipment costs $400,000 and has an estimated useful life of four years, or 8,000 machine hours. At the end of four years, the equipment is estimated to have a residual value of $20,000. Requirements 1. Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods. 2. Prepare a second depreciation schedule for double declining-balance method, using the Excel function DDB. The DDB function cannot be used in the last year of the asset's useful life. 3. At December 31, 2018, Fraser River is trying to determine if it should sell the factory equipment. Fraser River will only sell the factory equipment if the company earns a gain of at least $6,000. For each of the depreciation methods, what is the minimum amount that Fraser River will sell the factory equipment for in order to have a gain of $6,000? Excel Skills 1. Create formulas with absolute and relative cell references. 2. Format the cells as accounting number format. 3. Use the Excel function DDB to calculate double-declining-balance depreciation. The equipment costs $400,000 and has an estimated useful life of four years, or 8,000 machine hours. At the end of four years, the equipment is estimated to have a residual value of $20,000. Requirements 1. Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods. 2. Prepare a second depreciation schedule for double declining-balance method, using the Excel function DDB. The DDB function cannot be used in the last year of the asset's useful life. 3. At December 31, 2018, Fraser River is trying to determine if it should sell the factory equipment. Fraser River will only sell the factory equipment if the company earns a gain of at least $6,000. For each of the depreciation methods, what is the minimum amount that Fraser River will sell the factory equipment for in order to have a gain of $6,000? Excel Skills 1. Create formulas with absolute and relative cell references. 2. Format the cells as accounting number format. 3. Use the Excel function DDB to calculate double-declining-balance depreciation.
Expert Answer:
Answer rating: 100% (QA)
1 Straight line depreciation Cost of asset salvage value Life of the asset Depreciation expense 4000... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Olympus Equipment Company purchased a new piece of factory equipment on May 1, 2013, for $29,200. For income tax purposes, the equipment is classified as a 7-year asset. Because this is similar to...
-
Olympus Equipment Company purchased a new piece of factory equipment on May 1, 2011, for $29,200. For income tax purposes, the equipment is classified as a 7-year asset. Because this is similar to...
-
On January 1, 2011, Picard Inc. purchased a new piece of equipment from LaForge Engineering to expand its production facilities. The equipment was purchased at a cost of $800,000. Picard financed the...
-
Growth Strategy A. Organic Growth This section describes how JB Hi-Fi Australia can take advantage of various organic growth strategies, including new product development, market development and...
-
From phillies.mlb.com, the official Web site of the 2008World Series champion Philadelphia Phillies major league baseball team, we obtained the data shown on the next page on the heights, in inches,...
-
Edwards has decided to use probability-proportional-to-size (PPS) sampling, sometimes called dollar-unit sampling, in the audit of a clients accounts receivable balance. Few, if any, misstatements of...
-
What are units for \(C_{1}\) in Eq. (15.10)? Confirm that the units agree on both sides. F = 4 (15.10)
-
Does competition help or hurt the valuation of a business? Explain.
-
A particle's position is given by x = 2 - 11t + 2t2 (where t is in seconds and x is in meters). (a) What is its velocity at t = 1 s? (Indicate the direction with the sign of your answer.) -7 m/s (b)...
-
On January 1. Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year 500,000 15 7% Required: 1) Calculate the bond selling price given the...
-
William Wild Oats was a strapping young man aged 18 who enjoyed smoking, drinking, swearing and gambling, all legal pursuits for 18-year-olds where he lived. His uncle Ned No Nonsense, believing that...
-
Explain why communication is the heart of a groups throughput process.
-
Explain and give examples of a member being an effective participant-observer.
-
Two African American members of your group refer to each other as nigga when they greet each other at the beginning of group meetings. 4 You and one other member find the use of the term highly...
-
Based on the annual GDP and TPES data reported for two countries A and B, as noted in Table P-14.1. a. Calculate the two countries EPs and plot the trends on the same graph. b. Assess which country...
-
Your five-member class project group has been assigned to serve as consultants to another group. You are charged with observing this group, gathering data about it, evaluating the groups...
-
Based on the list below, critically evaluate the transformations of Vivo smartphones in Malaysia based on their marketing practices and thinking that are occurring in response to changes in the...
-
Classify each of the following as direct costs or indirect costs of operating the Pediatrics ward for children at the Cleveland Clinic: a. Wi-Fi covering the entire hospital campus b. Net cost of...
-
If you look at the light spectrum reflected from the surface of a DVD compared to the spectrum reflected from the surface of a CD, youll see that the rainbows from the DVD are more spread out, with...
-
Increasing the density of a material tends to increase the index of refraction. Does light travel faster in seawater or in fresh water?
-
Antireflection coatings for glass usually have an index of refraction that is less than that of glass. Explain how this permits a thinner coating.
Study smarter with the SolutionInn App