Please use a financial calculator or Excel. If you use the financial calculator, please provide your inputs for the calculator. If you use Excel, please email me the excel file with formulas. If you provide a simple answer, you WILL NOT receive any credit You intend to purchase a new car upon graduation in two years. It will have a cost of $40,857 (this is the average new car transaction price as of Jan 2021, it was $2,110 higher than 1-year ago), including all extra features and fees. You just won a $5,500 from a lottery ticket that you intend to deposit in a money market account that pays 5.5% interest, compounded monthly. You also plan to invest $250 every month at the end of the first month. (Part a) If you use the amount in the money market account for a down payment and take out an auto loan for the remainder, how much will you need to borrow? (Part b) The car dealership advertises that there are two types of loans for freshly graduated college students. There is a 4.49% (annualized rate, or APR) for 48 months deal, after negotiation, the dealership is willing to offer a $1500 discount if you will finance the car for 48 months. How much you will pay each month for either type of loan? (Part c) The car dealership advertises that there are two types of loans for freshly graduated college students. There is a 6.49% (annualized rate, or APR) for 60 months deal, after negotiation, the dealership is willing to offer a $1800 discount if you will finance the car for 60 months, How much you will pay each month for either type of loans