a. 3. 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% APR for 24 months, with no cash back. The original financing offer terms are listed in cells A3:39 on the Car Loan worksheet.Cell B10 contains a formula with a PMT 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. Create names for the following cells on the Car Loan worksheet to make the scenarios easier to follow: Name cell B3: Price Name cell B4: 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: Total Cost b. Create a scenario named Original Financing to save the original values in cells B3, B5, B8, and B9. c. Create a second scenario named Intermediate Car. Change the values as follows: Cell B3: 33999 Cell B5: 1500 Cell B8: 36 Cell B9: 2.4% I d. Show the Intermediate Car scenario to verify your data entry. Create a third scenario named Luxury Car. Change the values as follows: Cell B3: 62700 Cell B5: 2500 Cell B8: 60 Cell B9: 3.9% f. Show the Luxury Car scenario to verify your data entry. nmnare the results for cells B10 (the monthly payment) and B12 e. Draw Page Layout Form Data Herview View Tell me Codul BE $ C for Me All Models BE ! !!! LE 333 5: 888888::::: IEEEEEEEEEEEEEEEE 11 BERER FREE FEEEEEEEEEEEEEEEEEEEEE ES EL LLLLL LLLLLLEZA 10338 RE My Car Data Tin TOD Dawy a. 3. 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% APR for 24 months, with no cash back. The original financing offer terms are listed in cells A3:39 on the Car Loan worksheet.Cell B10 contains a formula with a PMT 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. Create names for the following cells on the Car Loan worksheet to make the scenarios easier to follow: Name cell B3: Price Name cell B4: 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: Total Cost b. Create a scenario named Original Financing to save the original values in cells B3, B5, B8, and B9. c. Create a second scenario named Intermediate Car. Change the values as follows: Cell B3: 33999 Cell B5: 1500 Cell B8: 36 Cell B9: 2.4% I d. Show the Intermediate Car scenario to verify your data entry. Create a third scenario named Luxury Car. Change the values as follows: Cell B3: 62700 Cell B5: 2500 Cell B8: 60 Cell B9: 3.9% f. Show the Luxury Car scenario to verify your data entry. nmnare the results for cells B10 (the monthly payment) and B12 e. Draw Page Layout Form Data Herview View Tell me Codul BE $ C for Me All Models BE ! !!! LE 333 5: 888888::::: IEEEEEEEEEEEEEEEE 11 BERER FREE FEEEEEEEEEEEEEEEEEEEEE ES EL LLLLL LLLLLLEZA 10338 RE My Car Data Tin TOD Dawy
