Please answer in a spreadsheet with formulas

You have made a decision to purchase a new Jeep Wrangler. The purchase price is $45,095. The dealer is offering you two alternative financing options for the purchase. They will finance the entire purchase price on a 48-month monthly payment plan at a stated annual rate of 0.9%, or they will give you a cash rebate off of the purchase price of $2,500.00 and finance the remainder on a 48-month monthly payment at a 5.5% stated annual rate. (A) Which of these two alternatives is a better financing deal? (B) What would the cash allowance need to be in order to make these two options equal? (C), A few years ago dealers were offering similar options except they were willing to finance either for up to 72 months, instead of 48. Why have they shortened the length of loans they are willing to commit too?