Fixed Asset	Acquisition Date	Cost	Salvage Value	Useful Life (years)	Accumulated Depreciation
Furniture	11/1/2024	$3,400	$400	6	$1,000
Office Equipment	11/1/2022	$7,000	$700	9	$2,800
Machinery	11/1/2025	$6,500	$100	4	$1,600

Use Depreciation Functions (STRAIGHT LINE METHOD)

In the appropriate column for each:

• Use a function and structured references to calculate depreciation expense for each fixed asset under the straight-line depreciation method.
• Use structured references to calculate the accumulated depreciation for each fixed asset.
• Use structured references with calculated columns to calculate the year-end book value for each fixed asset.
• PLEASE SHOW THE FORMULA USED IN EXCEL.