Just recently having accepted a full time position at your dream job, you go in search of a new car. You found one you like a lot and you consider a three-year lease. It will cost you $280 per month, plus an additional $15,000 at the end of the lease if you want to purchase it. If (1) your opportunity cost of money is about an APR of 6.0%, and (2) you intend to purchase the car after the lease, what will be the total investment you will have made in the car when the lease is up and you purchase it?

The answer is 25,080

(please use excel)