HELP!

You are shopping for a car and will be financing the purchase with monthly payments over 5 years. A car dealer makes you an offer for a car that you want to buy. You can get special financing from the dealer at the annual interest rate of 0.5% for 5 years (60 monthly payments at the end of each month) or you can get $2,500 off the sticker price, get financing from your bank and pay cash today. Which is a better deal the special financing from the dealer or paying the cash price and why? Submit an excel spreadsheet using the appropriate excel time value of money formula and calculations of inputs into the formulas.

Key Facts Sticker Price $38,000 Market annual interest rate on car loans 1.0% Sales Tax rate 10% - sales tax is applied to the price to be paid Sticker Price $38,000 Price Discount - $2,500 - if pay cash and finance from a bank at market rate Special Annual Financing Rate - 0.5% - no discount and finance through dealer