Answer the following questions below about car loans. Remember to number your answers. After submitting your answer, look and respond to at least two classmates post- either validate your answer or revise your answer and explain your mistakes. 1. Andrea's car has broken down for the third time this month, and she has decided to buy a different car. Her dream car, a 2016 Chevrolet Camaro, costs $38,000. She has a $4,000 down payment saved, and the bank is offering 3.00% APR on 60 month loans for new cars. a. How much will Andrea need to borrow to buy the Camaro? b. What would Andrea need to type in Excel to figure her monthly payment, and what will her monthly payment be? c. What will the total of all of Andrea's payments be over the lifetime of the car loan? d. How much will Andrea pay in interest over the lifetime of the car loan? 2) Because of Andrea's low credit score, the bank manager told her she will need a co-signer on the loan. Andrea's parents are not willing to co-sign, but have offered to sell her their 2013 Ford Fusion for $15,000. The bank is offering a 3.25% APR 60 month used car loan. a. Since Andrea still plans to use the $4,000 down payment, how much will she need to borrow? b. What would Andrea type into Excel to figure her monthly payment for the Fusion, and what will her monthly payment be? c. How much will Andrea save over the 60 months of the car loan if she buys the Fusion?