Question

Company A purchased equipment. The cost for the equipment is 500,000. Estimated salvage value after 5...

Company A purchased equipment. The cost for the equipment is 500,000. Estimated salvage value after 5 years is 50,000.

1.Determine the depreciation for n= 3 using MACRS, DDB, 150% DB and SL methods.

2.Plot the book value of DDB and SL depreciation.

EVERYTHING ABOVE HERE IS THE QUESTION. EVERYTHING BELOW HERE IS SOMEWHAT HOW IT NEEDS TO BE COMPLETED. THIS IS JUST THE START BUT PLEASE IN MICROSOFT EXCEL IN RELATION TO HOW IT IS BELOW

SLN DB DDB Macr
n Dt BVt Dt BVt Dt BVt d Dt BVt
0
1
2
3
0 0
Add a comment Improve this question Transcribed image text
Answer #1

2 SLN DB 1.50 DDB BVT Byt Dt Byte * 5,00,000.00 35,00,000.00 * 5,00,000.00 1 R 90,000.00 4,10,000.00 1,84,500.00 * 3,15,500.0

Add a comment
Know the answer?
Add Answer to:
Company A purchased equipment. The cost for the equipment is 500,000. Estimated salvage value after 5...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Company A purchased equipment. The cost for the equipment is 500,000. Estimated salvage value after 5...

    Company A purchased equipment. The cost for the equipment is 500,000. Estimated salvage value after 5 years is 50,000. 1. Determine the depreciation for year 3 using DDB, 150% DB and SL methods. 2. For DDB and 150% DB methods, determine the implied salvage after 5 years. 3. Calculate the depreciation rate d for each year for the DDB method. 4. Plot the book value of DDB and SL depreciation.

  • Halcrow Yolles purchased equipment for new highway construction in Manitoba, Canada, costing $550.000 Canadian The estimated...

    Halcrow Yolles purchased equipment for new highway construction in Manitoba, Canada, costing $550.000 Canadian The estimated salvage at the end of the expected life of 5 years is $50,000. Various acceptable depreciation methods are being studied currently. Determine the depreciation for year 2 using the DDB(Double Declining Balance). 150% DB(Declining Balance), and SL(Straight Line Depreciation) methods. Problem 16.018.a: Calculate the depreciation value in a certain year using DDB, 150% DB and Straight Line methods Determine the depreciation by hand. The...

  • Company B purchased equipment that cost 750,000 with salvage value of 150,000 after 10 year for...

    Company B purchased equipment that cost 750,000 with salvage value of 150,000 after 10 year for both plant in the United States and Hong Kong. MACRS depreciation with n=5 year is applied in the United States and standard SL depreciation with n=10 years is used in Hong Kong. 1. Develop and graph the book value for both plants. 2. If the equipment is sold after year 10 for 100,000, find the over or under depreciated amounts for each plant.

  • Problem 2 – 10 points Company B purchased equipment that cost 750,000 with salvage value of...

    Problem 2 – 10 points Company B purchased equipment that cost 750,000 with salvage value of 150,000 after 10 year for both plant in the United States and Hong Kong. MACRS depreciation with n=5 year is applied in the United States and standard SL depreciation with n=10 years is used in Hong Kong. Develop and graph the book value for both plants. If the equipment is sold after year 10 for 100,000, find the over or under depreciated amounts for...

  • Straight-Line cost of equipment: $450,000 Estimated Salvage Value: $30,000 Estimated Life (yrs): 17.50 test after this...

    Straight-Line cost of equipment: $450,000 Estimated Salvage Value: $30,000 Estimated Life (yrs): 17.50 test after this many years: 4 net future cash flow (@ time of testing): $300,000 fair value (@ time of testing): $275,000 --------------- A. Depreciable Cost Annual Depreciation Expense (SL)    B. At time of testing SL Method Accumulated Depreciaton balance Book Value IMPAIRED? (Y/N) Impairment Loss B/S at 12/31 in year of testing SL Method Equipment Accumulated Depreciation $$$,$$$,$$$ $$$,$$$,$$$

  • Q1 A machine cost $500,000 on January 1, 2006. Its estimated salvage value is $50,000 and...

    Q1 A machine cost $500,000 on January 1, 2006. Its estimated salvage value is $50,000 and its expected life is eight years. Instructions Calculate the depreciation expense (to the nearest dollar) by each of the following methods, showing the figures used. (a) Double-declining balance for 2007 (b) Sum-of-the-years'-digits for 2007

  • Equipment cost 78,000 Salvage Value 2500 Life 6 years Units over life 678,000 Depreciate using Excel...

    Equipment cost 78,000 Salvage Value 2500 Life 6 years Units over life 678,000 Depreciate using Excel SL DDB SYD Units of Activity Year 1 Year 2 Year 3 Year 4 Year 5 Year 6

  • Max Metal Inc. uses the same type of production line in the US and Malaysia plants. The first cost was $1,500,000 w...

    Max Metal Inc. uses the same type of production line in the US and Malaysia plants. The first cost was $1,500,000 with a salvage value of $500,000 at the end of year 10. MACRS depreciation with n=5 years is applied in the US and standard SL depreciation with n=10 years is used by the Malaysian facility. a. If the equipment is sold after 6 years for $500,000, calculate the over or under depreciation amounts for each method. b. Use a...

  • Question 1 A business equipment used for the manufacture of commercial goods $40,000. This asset is expected to be sold...

    Question 1 A business equipment used for the manufacture of commercial goods $40,000. This asset is expected to be sold after 4 years for $7,000. Compute the depreciation amounts every year (depreciation schedule) during the useful life of this asset. Please refer to a current tax regulations1 for CCA rates. Please attempt using the following methods: can be purchased for First, book depreciation: [a] Straight-line (SL) method (Book Depreciation) b] Double balance (DB) method with rate 20% (Book Depreciation) [c]...

  • 1. Determine the probable average cost per hour over the life of the equipment for owning...

    1. Determine the probable average cost per hour over the life of the equipment for owning & operating a wheel loader under the conditions listed below. Use the straight-line method of depreciation. Operator cost: $20/hr. • Operating conditions: Average • Delivered price: $70,000 • Cost of a set of tires: $4,000 • Expected life: 5 years • Hours operated: 2,000 hrs./year • salvage value: 32,000 • Fuel cost $3.00/gal • horsepower: 120 hp • Rate for interest, tax, insurance, &...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT