Problem 1 (USE Problem 1 Excel Sheet, its blank)

A Ford Mustang GT costs $75000. Assuming the price of a Ford Mustang didn't change since 1985, calculate the current(2019) price of resale for Mustangs purchased over the years, subject to variable depreciation based on Year of Purchase.

YEAR OF PURCHASE	ANNUAL DEPRECIATION
1985 - 1995	$2000
1996 - 2005	$1800
2006 - 2015	$1600
2016 - Present	$1400

Choose the formula that will calculate the resale value of a Mustang in 2020

		= 75000 - [Year of Purchase] * Annual Depreciation)
		= [Year of Purchase] ) * Annual Depreciation)
		= 75000 - ((2020 - [Year of Purchase] ) * Annual Depreciation)
		= (2020 - [Year of Purchase] ) * Annual Depreciation)