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, an increase of $2,110 from 12-month ago), including all extra features and fees. You just won a $5,300 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 $225 every month starting immediately. (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,69% (annualized rate, or APR) for 60 months available, after negotiation, the dealership is willing to offer a $1000 discount if you will finance the car for 60 months, how much you will pay each month for either type of loan?