Yоu аre buying а new cаr. Yоu can pay cash fоr the entire amount by writing a check from your money market deposit account at the bank that currently pays 1.2% (annual, compounded monthly). Download this Excel answer file with the project information in it. Use it to answer the following three questions showing your work and then upload your file to answer this question. Part a: The finance manager says he can get you a special deal if you take out a loan: “All you have to do to qualify for a rebate is to finance a minimum of $7,500 at 3.99% (annual, compounded monthly). You also cannot pay off the loan for at least 6 months.” How much would your loan payments be if you borrowed the minimum $7,500 and paid it off in equal installments over the next 6 months? Part b: The finance manager says, “Taking out the loan entitles you to an immediate $500 cash rebate on the car.” Make a timeline for the loan and the rebate. Part c: How much better or worse off are you today if you take out the loan, receive the rebate, and make loan payments from your money market deposit account? Does the loan/rebate deal make financial sense?