3. Your have made a decision to purchase a new Pickup, and have negotiated a purchase price of $44,300. The dealer is giving you two finance options. They will finance the entire purchase price ($44,300) at a bargain rate of 0% annual interest for 36 equal monthly payments, or they will give you an additional $3,000 rebate on the purchase and finance the balance at 6.0% annual interest for 36 equal monthly payments. (A) Which of these two alternatives is a better financing deal? (Hint: in either case you are getting the equivalent of $44,300 (the truck) in period 0, so compare the payments on the full purchase price at 0% with the payments on the lower purchase price after the rebate at 6.0%). (B) What would the rebate need to be in order to make these two options equal? (C) As recently as 6 months ago dealers were offering similar deals with 60 month financing. Why have they shortened the length of loans they are willing to commit too? Please turn in enough of your spreadsheet that we can see how you approached the problems