Todd Service Company, on January $1,20$xx$,$ purchased a machine that makes a particular part for dining room tables. The following information applies to the machine purchased:

Purchase price $-$ $$80,000$

Delivery cost $-$ $ $2,500$

Installation Cost $ $850$

Estimated life $-5$ years

Estimated parts produced $160,000$

Salvage value $ $3,350$

The copies produced as follows:

Year $135,000$ parts

Year $236,000$ parts

Year $340,000$ parts

Year $430,000$ parts

Year $519,000$ parts

Using Excel, determine the amount of depreciation expense and the net book value for each of the five years $(8$ years for MACRS$)$ using each of the following methods:

Straight$-$line

Double$-$declining balance

Units of production

MACRS, assuming the machine is classified as five$-$year property

Use the following Excel template: Unit $8$ TemplateDownload Unit $8$ Template

After you completed the worksheet then copy it and assume the machine cost was $$90,000$ instead of $$80,000($all other information remains the same$)$ and calculate depreciation expense and the net book value for each of the five years $(8$ years for MACRS$)$ using each of the following methods:

Straight$-$line

Double$-$declining balance $($Be sure to double check the calculation for this type of depreciation.$)$

Units of production

MACRS, assuming the machine is classified as five$-$year property

If you link the cells then this change of the cost of the machine will be easy to calculate.

Answer rating: 100% (QA)

lets go through the calculations stepbystep using the provided information Given information Purchas... View the full answer