You want to purchase a new car . Your current car is worth $3 , 500 as a trade-in . The base sticker price on the car You want is $24, 595 . The first financing offer from the dealer is 1. 9%/ A PR for 24 months , with 110 cash back . The original financing offer terms are listed in cells *3 : 39 on the Car Loan worksheet . Cell BIO contains a formula with a PN'T function to calculate the monthly payment . Use what - if analysis tools to compare financing options . Create scenarios to compare financing options for the car loan . a . Create names for the following cells on the Car Loan worksheet to make the scenarios easier to follow : Name cell B 3 : Price Name cell $ 4 : Trade In Name cell B5 : CashBack Name cell B6 : Loan Name cell B8 : Months Name cell B9 : APR Name cell B10 : Payment Name cell B12 : TotalCost