Question

In: Finance

The Apple Company purchased a new office computer and other depreciable computer hardware for $12,000. During...

The Apple Company purchased a new office computer and other depreciable computer hardware for $12,000. During the third year, the computer is declared obsolete and is donated to the local community college. Assume that no salvage was initially declared and that the machine was expected to last 5 years.

Compute the PW of the depreciation charges for each method using an interest rate of 10%. Summarize all the information in a table and interpret the results.


Help me. Thanks!

The Apple Company purchased a new office computer and other depreciable computer hardware for $12,000. During the third year, the computer is declared obsolete and is donated to the local community college. Assume that no salvage was initially declared and that the machine was expected to last 5 years.
Required:
1. Prepare a table with the depreciation schedules and book values for each method: a. Straight-line depreciation
b. Double declining balance depreciation
c. 100% bonus depreciation
d. MACRS depreciation.

2- Compute the PW of the depreciation charges for each method using an interest rate of 10%. Summarize all the information in a table and interpret the results

Important: You must use Excel only to do this homework (tables, graphs, PW, etc.) and demonstrate the use of financial functions to compute the depreciation schedules a, b, d.


Please use Exel only, its required. Help me please!!! Thanks a lot!!!

Solutions

Expert Solution

Appreciate your Feedback


Related Solutions

The XYZ block company purchased a new office computer and other depreciable computer hardware for $12,000....
The XYZ block company purchased a new office computer and other depreciable computer hardware for $12,000. During the third year, the computer is declared obsolete and is donated to the local community college. Using an interest rate of 10%, calculate the PW of the depreciation deductions. Assume that no salvage value was initially declared and that the machine was expected to last 5 years. Double declining balance depreciation 100% bonus depreciation Which method id preferred for determining the firm’s taxes?...
The XYZ Block company purchased a new office computer and other depreciable computer hardware for $12,000....
The XYZ Block company purchased a new office computer and other depreciable computer hardware for $12,000. During the third year, the computer is declared obsolete and is donated to the local community college. Assume that no salvage was initially declared and that the machine was expected to last 5 years. Required: 1. Prepare a table with the depreciation schedules and book values for each method: a. Straight-line depreciation b. Double declining balance depreciation c. 100% bonus depreciation d. MACRS depreciation....
20.       Lussier Company purchased a new computer for $175,000. It is estimated that the computer will...
20.       Lussier Company purchased a new computer for $175,000. It is estimated that the computer will have a $15,000 residual value at the end of its 5-year useful service life. The double diminishing-balance method of depreciation will be used. Instructions Prepare a depreciation schedule which shows the annual depreciation expense on the computer for its 5-year life.
Becker Office Service purchased a new computer system on January 1, 2018, for $31,900. It is...
Becker Office Service purchased a new computer system on January 1, 2018, for $31,900. It is expected to have a five-year useful life and a $3,700 salvage value. Becker Office Service expects to use the computer system more extensively in the early years of its life. Calculate the depreciation expense for each of the five years, assuming the use of double-declining-balance depreciation. (Enter all amounts as positive values. Do not round intermediate calculations. Round "SL rate" answers to 2 decimal...
Paul purchased a new office computer system on February 15, 2016, at a cost of 8300....
Paul purchased a new office computer system on February 15, 2016, at a cost of 8300. He would like to use the General Depreciation System (GDS) straight-line method to depreciate the system and does not want to claim bonus depreciation. Using the half-year convention, compute his 2016 and 2017 depreciation. a. His 2016 Depreciation is $1,660, and his 2017 is $2,656 b. His 2016 is $1453 and 2017 is $1660. c. 2016 is $830 and 2017 is $1660 d. 2016...
Brandon Office Service purchased a new computer system on January 1, Year XXX1. Relevant data for...
Brandon Office Service purchased a new computer system on January 1, Year XXX1. Relevant data for the computer system is given below: Purchase price $36,200 Useful service life in years 5 Salvage value at the end of useful life $3,400 Required: a) Calculate the depreciation expense for each of the 5 years, assuming the use of straight line depreciation. Also, calculate the net book value of the asset and the accumulated depreciation expense for this asset at the end of...
The Office Supplies account started the year with a $3,875 balance. During 2015, the company purchased...
The Office Supplies account started the year with a $3,875 balance. During 2015, the company purchased supplies for $16,004, which was added to the Office Supplies account. The inventory of supplies available at December 31, 2015, totaled $3,410. Record the adjusting entry related to the company's insurance. The company has 15 employees, who earn a total of $2,650 in salaries each working day. They are paid each Monday for their work in the five-day workweek ending on the previous Friday....
Please thoroughly explain each answer. A manufacturer of computer chips has a computer hardware company as...
Please thoroughly explain each answer. A manufacturer of computer chips has a computer hardware company as its largest customer. The computer hardware company requires all of its chips to meet specifications of 1.2 cm. The vice-president of manufacturing, concerned about a possible loss of sales, assigns his production manager the task of ensuring that chips are produced to meet the specification of 1.2 cm. Based on the production run from last month, a 95% confidence interval was computed for the...
Apple Company purchased 42% of Orange Company's common stock for $418,000 on January 1, 2021. During...
Apple Company purchased 42% of Orange Company's common stock for $418,000 on January 1, 2021. During 2021, Orange Company reported a net income of $79,000 and paid dividends totaling $13,000. For 2022, Orange Company paid dividends totaling $21,000. On December 31, 2022, Apple Company sold three-fourths of its investment in Orange Company for $319,625 cash. Apple Company reported a loss on the sale equal to $12,460. What is the amount of net income earned by Orange Company in 2022?
The CEO of a computer hardware company notices that its sales are concentrated at the beginning...
The CEO of a computer hardware company notices that its sales are concentrated at the beginning of each quarter and at the end of each quarter, with few sales in the middle. Sales at the beginning of the quarter and at the end of the quarter have much lower prices, about 10% lower than earlier sales. Why?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT