Model $1$ Car Loan

Objective: Data Visualization $$ the importance of formatting, spreadsheet layout, and presentation of data. Review of concepts learned in CSE $2111.$

Problem Statement: Congratulations! You have graduated and you$$ve landed a new job in Central Ohio.

You have driven your current car, handed down from your parents and older siblings, thru high school and college and wish to capitalize on the new job and salary by treating yourself to a new car. You need to consider several variables such as what car to buy, how much to pay, what the down payment will be$,$ and how long you want to make the monthly payment.

Since you$$ve had considerable costs associated with repairs to your current, well$-$used, vehicle, you decide you want a new car. You decide on a new $2023$ Chevy Bolt $2$Lt$.$ You choose the Radiant Red with jet black interior. With the accessories and packages, you have selected, the total cost is $$32,380.$ The dealership has generously offered you $$4,200$ for the trade in of your current vehicle.