$5($Chapter $6)$ Optional. $2$ points Extra Credit for perfect answer, showing work. $($Hint:Do this on an Excel spreadsheet.$)$ Operating costs of an automobile in Best Semiconductor Inc.$\text{'}$s $($BSI$)$ automotive pool $($for its employees$)$ are as follows for a car in year t of its age $($e$.$g$.,$ year $1,$year $2,$etc.$)$:

t

$1$

$1000$

$2$

$3$

$4$

$5$

$2000$

$1500$

$1500$

Cost of auto replacement is $$30,000.$ BSI's discount rate is $10\%.$ Salvage value if a car is sold at age t is:

t $1$

$2$

$22,000$

$16,000$

$3$

$4$

$12,000$

$5$

$8,500$

$6$

$500$