Engineering Economy 7th Edition by Leland Blank ,Anthony Tarquin

Exercise 22

An asset has an unadjusted basis of $200,000, a salvage value of $10,000, and a recovery period of 7 years. Write a single-cell spreadsheet function to display the book value after 5 years of straight line depreciation. Use your function to determine the book value.