Suppose that a local used car dealer offers a special deal to law students who survive the first year in good standing. You can buy a special edition Car for $5000 with no payment until three years from the date of sale (after you pass the bar). At that point you must pay $1000 per year for five years (with the first payment due on the third anniversary of the sale). Assuming an interest rate of 5% (about the going rate for a new car loan), what is the effective price of the car to you?

I know the answer is $3927, but could you show me how to solve this in excel.