Suppose you are planning to buy a car. Complete the following tasks. (1 point) a. Search online (dealer's website, Craigslist, etc) for a car you would like to buy. Write down the following information about that car. Brand Model Year Color Condition Mileage (ignore if new) Price b. Suppose you are buying with full financing. Search online (bank's website, dealer's website, etc) for the most recent auto loan interest rate. Write down that information. c. Suppose you plan to repay $500 each month for the auto loan you get from Part b. How long will it take for you to repay the loan. How do i do part c in excel!!??

Subject is Finacial modeling and Analytics