I have a problem trying to set up a worksheet using SLN function to show a
straight-line depreciation and a formula to determine the annual rate of
depreciation. Cost=$96,345; Salvage=$25,000; Life= 6 yrs; Annual Rate of
Depreciation = SLN/Cost.

Create a data table showing straight-line depression and annual rate of
depreciation (forklift) for salvage from $20,000 to $29,000 in $500
increments.
Help. Much Thanks