Question #1: Dan and Marlo need your help. Dan and Marlo are in the market for a new vehicle. Marlo is looking for a reliable car that's relatively inexpensive. Dan is interested in upgrading the family's image. He and Marlo have always driven old used cars, and he thinks it's time that they buy a car that is stylish and something that sends a message to his friends and neighbors that they "have made it." They have narrowed their list down to five cars. While Dan has his preferences, he has agreed to abide by your estimates when selecting their next vehicle Instructions: Help Dan and Marlo calculate the total monthly cost of the cars they are looking at by completing the table and then answering the following questions. a. Which vehicle should they purchase if they are interested only in the lowest monthly loan payment? What should they choose if they are interested in buying something that has the lowest total monthly cost? c. If they are interested in a vehicle with the lowest overall cost of ownership, which one should they choose? Car 1 Car 2 Car 3 Car 4 Car 5 2-Door 4-Door 4-Door Luxury Type Luxury Luxury SUV Sedan SUV Coupe Sedan Cost $29,000 $43,000 $45.000 $34.000 $42,000 Loan interest rate 1.90% 3.40% 0.00% 1.90% 3.50% Length of loan (years) 3 6 5 Monthly insurance $125 $170 $175 $145 $155 Monthly gas $95 $150 $165 $190 $210 Monthly payment Total monthly expense Total of all payments Overall cost of ownership