A 3D printer exclusively for producing dental molar crowns, complete with all the contouring and evaluation apparatus for matching the removed molar, is purchased for $41,000. It will be depreciated over 8 years and have a salvage value of $6,500.

Part a

Using a table and the formulas, determine the depreciation and book value at the end of each year using straight-line depreciation.

Year	Depreciation		Book Value
1
2
3
4
5
6
7
8

B.) Using a table and the Excel SLN function, determine the depreciation and book value at the end of each year using straight-line depreciation. Carry all interim calculations to 5 decimal places and then round your final answers to 2 decimal places. The tolerance is 0.50.

C.) Using a table and the formulas, determine the depreciation and book value at the end of each year using declining balance depreciation with a percentage that will ensure the book value equals the salvage value at the end of the final year. Carry all interim calculations to 5 decimal places and then round your final answers to 2 decimal places. The tolerance is 1.50.

D.) Using a table and the formulas, determine the depreciation and book value at the end of each year using declining balance depreciation with a depreciation rate of 200% of the straight-line rate. Carry all interim calculations to 5 decimal places and then round your final answers to 2 decimal places. The tolerance is 1.50.

E.) Is the printer tangible or intangible?

F.) Is the printer personal property or real property?

G.) Is it better to say we are depreciating or amortizing the printer over time?

PLEASE SHOW WORK IN EXCEL