The original price of a car is entered into spreadsheet cell A1 and the annual depreciation amount in cell B1.
a. Write the spreadsheet formula to determine the number of years it will take for the car to totally depreciate.
b. The spreadsheet user is instructed to enter a car value in cell D1.
Write the spreadsheet formula to compute how long it will take for the car to depreciate to that value.
c. The spreadsheet user is instructed to enter a percent into cell E1. Write the spreadsheet formula to compute the length of time it will take for the car to decrease by that percent.