Lunger Company is considering the purchase of a laser engraving machine that will allow it to offer personalization of its products. The laser engraving machine would be

purchased for $$32,200$ and placed into service on the first day of Lunger's fiscal year. Lunger must pay freight of $$4,200$ to ship the machine to its factory. Lunger will also

pay $$2,700$ of installation costs. The estimated useful life of the laser engraving machine is eight years and its estimated salvalue is $$5,500.$

Read the requirements.

$($Note: An Excel file is not provided for this question. You will create your own Excel file, using the information provided, to answer the questions.$)$

Requirement $1.$ Calculate the straight$-$line depreciation expense per year for the machine using the SLN function in Excel. List the depreciation expense for each year of

the machine's estimated useful life.

Straight$-$line

depreciation

Year $1$

Year $2$

Year $3$

Year $4$

Year $5$

Year $6$

Year $7$

Year $8$

Requirements

Calculate the straight$-$line depreciation expense per year for the machine using

the SLN function in Excel. List the depreciation expense for each year of

the machine's estimated useful life.

Calculate the double$-$declining balance depreciation expense per year for the

machine using the DDB function in Excel. List the depreciation expense for

each year of the machine's estimated useful life.