A Construction company XYZ purchased a Crane for $600,000 and it will have a Salvage value...
A Construction company XYZ purchased a Crane for $600,000 and it will have a Salvage value of $60,000 at the end of its useful life. Company XYZ uses a 150% Declining-Balance Depreciation Method with a Switchover to Straight-Line Depreciation Method. Calculate the required Depreciation amounts for every year, identify the year that the Switchover will occur to Straight-Line Method, and fill all required amounts in the given TABLE below. List all your calculations below the table.
| Year, K | ||||
Please show all calculations, and please no Excel usage. Will rate. Thank you.
Homework Answers
| Year | Book Value | Depreciation 150% | SLM | Depreciation | BV EoY |
|---|---|---|---|---|---|
| 0 | $ 600,000 | - | - | - | $ 600,000 |
| 1 | 600,000 | 0.1875×600,000 =112,500 | 0.125*(600000-60000) = 67,500 | 112,500 | 487,500 |
| 2 | 487,500 | 0.1875*487,500 = 91406.25 | (487500-60000)/7= 61,071.43 | 91,406.25 | 396,093.75 |
| 3 | 396,093.75 | 74,267.58 | (396,093.75-60000)/6=56,015.625 | 74,267.58 | 321,826.17 |
| 4 | 321,826.17 | 60,342.41 | (321,826.17-60,000)/5= 52,365.23 | 60,342.41 | 261,483.46 |
| 5 | 261,483.46 | 49,028.21 | (261,483.46-60000)/4)= 50,370.94 | 50,370.94 | 211,112.82 |
| 6 | 211,112.82 | 39,583.65 | 50,370.94 | 50,379.94 | 160,741.88 |
| 7 | 160,741.88 | 30,139.10 | 50,370.94 | 50,370.94 | 10,370.94 |
| 8 | 110,370.94 | 20,694.55 | 50,370.94 | 50,370.94 | 60,000 |
Straight line method depreciation charges = (1/8) = 12.5% every year
150% DB depreciation = 1.5 × 12.5 = 18.75% every year
Here useful life is not given thus I have assumed it by counting number of rows provided. PleaSe contact if having any doubt.
Please refer the attached picture solved it using excel too got the same answer
Please contact if having any query will be obliged to you for your generous support. Please help me it mean a lot to me. Thank you.
Add Answer to:
A Construction company XYZ purchased a Crane for $600,000 and it
will have a Salvage value...
Problem 1) A Fantastic Transportation Company bought today a new Tractor unit for use over the...
Problem 1) A Fantastic Transportation Company bought today a new Tractor unit for use over the road for shipping products all over the USA for $98,000. And this Tractor unit requires an additional working capital of $3,000 to install a GPS tracking system. It is estimated that the Salvage Value of tractor unit is going to be equal to $8,000 at the end of its useful life. Fantastic Company uses an After-Tax MARR of 15%. Calculate: ONLY the depreciation amounts...
2. On January 1, Clayton Cranes purchased a crane for $190,000. Clayton expects the crane to...
2. On January 1, Clayton Cranes purchased a crane for $190,000. Clayton expects the crane to remain useful for ten years (1,200,000 lifts) and to have a residual value of $10,000. The company expects the crane to be used for 160,000 lifts the first year. Read the requirements. a. Compute the first-year depreciation expense on the crane using the straight-line method. Begin by selecting the formula to calculate the company's first-year depreciation on the crane using the straight-line method. Then...
2. On January 1, Clayton Cranes purchased a crane for $190,000. Clayton expects the crane to...
2. On January 1, Clayton Cranes purchased a crane for $190,000. Clayton expects the crane to remain useful for ten years (1,200,000 lifts) and to have a residual value of $10,000. The company expects the crane to be used for 160,000 lifts the first year. Read the requirements. a. Compute the first-year depreciation expense on the crane using the straight-line method Begin by selecting the formula to calculate the company's first-year depreciation on the crane using the straight-line method. Then...
You have a tax basis of $80,000 and a useful life of five years and no...
You have a tax basis of $80,000 and a useful life of five years and no salvage value. Provide a depreciation schedule (dk for k=1-5) for 200% declining balance with switchover to straight line. Specify the year to switchover. Determine the depreciation amounts using the 200% declining balance and straight-line methods and BV amounts for each year. (Round to the nearest dollar.) 200% DB Method, $ Depreciation SL Method, $ Amount Selected, Year BVk; $
please show all the excel functions (12-14) A construction equipment rental company can purchase a new crane for $1...
please show all the excel functions
(12-14) A construction equipment rental company can purchase a new crane for $1,125,000 which is expected to last for 25 years. The expected salvage value at that time is $147,000. The annual rental income from the crane is $195,000. Using straight-line depreciation and a MARR of 15%, a) What is the present worth of the after-tax cash flow for this equipment? b) Should the company invest in this crane?
On July 1, 2017, Crane Company purchased factory equipment for $293000. Salvage value was estimated to...
On July 1, 2017, Crane Company purchased factory equipment for
$293000. Salvage value was estimated to be $8500. The equipment
will be depreciated over five years using the double-declining
balance method. Counting the year of acquisition as one-half year,
Crane should record depreciation expense for 2018 on this equipment
of
$70320.
$93760.
$91200.
$117200.
You have a tax basis of $90,000 and a useful life of five years and no...
You have a tax basis of $90,000 and a useful life of five years and no salvage value. Provide a depreciation schedule (d, for k=1-5) for 150% declining balance with switchover to straight line. Specify the year to switchover. Determine the depreciation amounts using the 150% declining balance and straight-line methods and BV amounts for each year. (Round to the nearest dollar.) Year 150% DB Method, $ SL Method, $ Depreciation Amount Selected, $ BV: $ 1 0 0 0...
1. A piece of office equipment is purchased for $110,000 and has an estimated salvage value...
1. A piece of office equipment is purchased for $110,000 and has an estimated salvage value of $10,000 at the end of the recovery period. Using excel, prepare a depreciation schedule for the piece of equipment using ONLY the straight line method with a recovery period of _____ years. For tax purposes, the IRS has stated this specific piece of equipment has a standard recovery period of how many years? (Fill in the blank). 2. Using excel, prepare a depreciation...
Crane Company purchased a new machine on October 1, 2022, at a cost of $94,100. The...
Crane Company purchased a new machine on October 1, 2022, at a cost of $94,100. The company estimated that the machine has a salvage value of $2,940. The machine is expected to be used for 86,000 working hours during its 10-year life. Compute depreciation using the following methods in the year indicated. Your answer is incorrect. Declining-balance using double the straight-line rate for 2022 and 2023. 2022 2023 Depreciation using the Declining-balance method $ eTextbook and Media X Your answer...
2. On January 1, Clayton Cranes purchased a crane for $182,000. Clayton expects the crane to...
2. On January 1, Clayton Cranes purchased a crane for $182,000. Clayton expects the crane to remain useful for four years (600,000 lifts) and to have a residual value of $50,000. The company expects the crane to be used for 80,000 lifts the first year. Read the requirements. A Requirements a. Compute the first-year depreciation expense on the crane using the straight-line method. Begin by selecting the formula to calculate the company's first-year depreciation on the crane using the straight-line...
2. On January 1, Clayton Cranes purchased a crane for $190,000. Clayton expects the crane to remain useful for ten years (1,200,000 lifts) and to have a residual value of $10,000. The company expects the crane to be used for 160,000 lifts the first year. Read the requirements. a. Compute the first-year depreciation expense on the crane using the straight-line method. Begin by selecting the formula to calculate the company's first-year depreciation on the crane using the straight-line method. Then...
2. On January 1, Clayton Cranes purchased a crane for $190,000. Clayton expects the crane to remain useful for ten years (1,200,000 lifts) and to have a residual value of $10,000. The company expects the crane to be used for 160,000 lifts the first year. Read the requirements. a. Compute the first-year depreciation expense on the crane using the straight-line method Begin by selecting the formula to calculate the company's first-year depreciation on the crane using the straight-line method. Then...
You have a tax basis of $80,000 and a useful life of five years and no salvage value. Provide a depreciation schedule (dk for k=1-5) for 200% declining balance with switchover to straight line. Specify the year to switchover. Determine the depreciation amounts using the 200% declining balance and straight-line methods and BV amounts for each year. (Round to the nearest dollar.) 200% DB Method, $ Depreciation SL Method, $ Amount Selected, Year BVk; $
please show all the excel functions
(12-14) A construction equipment rental company can purchase a new crane for $1,125,000 which is expected to last for 25 years. The expected salvage value at that time is $147,000. The annual rental income from the crane is $195,000. Using straight-line depreciation and a MARR of 15%, a) What is the present worth of the after-tax cash flow for this equipment? b) Should the company invest in this crane?
On July 1, 2017, Crane Company purchased factory equipment for
$293000. Salvage value was estimated to be $8500. The equipment
will be depreciated over five years using the double-declining
balance method. Counting the year of acquisition as one-half year,
Crane should record depreciation expense for 2018 on this equipment
of
$70320.
$93760.
$91200.
$117200.
You have a tax basis of $90,000 and a useful life of five years and no salvage value. Provide a depreciation schedule (d, for k=1-5) for 150% declining balance with switchover to straight line. Specify the year to switchover. Determine the depreciation amounts using the 150% declining balance and straight-line methods and BV amounts for each year. (Round to the nearest dollar.) Year 150% DB Method, $ SL Method, $ Depreciation Amount Selected, $ BV: $ 1 0 0 0...
Crane Company purchased a new machine on October 1, 2022, at a cost of $94,100. The company estimated that the machine has a salvage value of $2,940. The machine is expected to be used for 86,000 working hours during its 10-year life. Compute depreciation using the following methods in the year indicated. Your answer is incorrect. Declining-balance using double the straight-line rate for 2022 and 2023. 2022 2023 Depreciation using the Declining-balance method $ eTextbook and Media X Your answer...
2. On January 1, Clayton Cranes purchased a crane for $182,000. Clayton expects the crane to remain useful for four years (600,000 lifts) and to have a residual value of $50,000. The company expects the crane to be used for 80,000 lifts the first year. Read the requirements. A Requirements a. Compute the first-year depreciation expense on the crane using the straight-line method. Begin by selecting the formula to calculate the company's first-year depreciation on the crane using the straight-line...
Most questions answered within 3 hours.
-
According to the network system security, please explain:
1- What is canary and how it does...
asked 43 minutes ago -
Study the provided BagInterface and the methods implemented in
the ResizableArrayBag
For the following methods that...
asked 41 minutes ago -
Enter your answer in the provided box. To what fraction of its
original volume, Vfinal/Vinitial, must...
asked 1 hour ago -
Can you figure out if any R functions used to subset a time
series 1 or...
asked 1 hour ago -
Which of the following is correct?
A. APC + MPS = 1
B. APS + MPS...
asked 1 hour ago -
Given a regression sum of squares equal to 2373.59 and a total
sum of squares equal...
asked 3 hours ago -
Compare and contrast the linear motion and angular motion
equations F ma and . That is,...
asked 2 hours ago -
Now that this course has taken you on a journey of introduction
to the world of...
asked 3 hours ago -
The sandwich maker of the EE-Cole-Eye Sandwich Truck was just
fired (for a reason described below)...
asked 5 hours ago -
Name the following coordination compounds using systematic
nomenclature.
1. [Co(H2O)6]Cl2:
2. [Cr(NH3)6](NO3)3:
3. K4[Fe(CN)6]:
4. Na[Au(CN)4]:...
asked 5 hours ago -
Propose an efficient synthesis of 2-Bromo-5-nitrotoluene from
benzene. Hint: 3 steps. Consider directing effects of substituents....
asked 7 hours ago -
This assignment will explore the impact of corporate decisions
on a local versus a global perspective....
asked 6 hours ago