Jill is leasing a $35,500 car for $659/month for three years. In three years, she expects to buy it outright for $18,000 at the same time she makes her last lease payment. If it costs her 5.55% to borrow, what is the implicit rate in the lease, which has a $1,000 down payment? Should she lease or borrow the money to get the car? (Hint: use the IRR function).

Start Mo. 1 Mo. 2 Mo. 3 Mo.4 Mo. 5 Mo. 6 Mo. 7 Mo. S Mo. 9 Mo. 10 Mo. 11 Mo. 12 Mo. 13 Mo. 14 Mo. 15 Mo. 16 Mo. 17 Mo. 18 Mo. 19 Mo. 20 Mo. 21 Mo. 22 Mo. 23 Mo. 24 Mo. 25 Mo. Cash flows Borrowing cost Implicit lease cost