Needs to be done in excel, so please show or tell the excel formulas used. thank you

1. A young baseball player has been signed to a three-year $15 million contract. The details provice for an immediate cash bonus in year zero) of $2 million. The player is to receive $3 million in salary at the end of the first year, $4 million the next year, and $6 million at the end of the last year (see below). Assuming an 8% discount rate, what is the present value of this contract? (Show the answer in dollars and cents; do not show extra decimals.) Here are the payments (payable at the end of each year): Year 0:$2,000,000 Year 1:$3,000,000 Year 2:$4,000,000 Year 3:$6,000,000 2. One of your customers is delinquent on his accounts payable balance. You have mutually agreed to a repayment schedule of $400 per month. You will charge 1.3% per month interest on the overdue balance. If the current balance is $12,815, how long will it take for the account to be paid off? (Show the answer in months with two decimals.) 3. Suppose a small business borrows $20,000 for four years at 7.5%. The loan agreement calls for the company to pay the interest on the loan balance each year and to pay back the principal in four equal payments. Prepare an amortization schedule for the loan. How much interest will the company pay over the life of the loan? (Show the dollar amounts in dollars and cents.) 4. Elmo wants to buy a car that costs $30,000. He plans to pay $5,000 as a down payment and finance the rest. The dealer's bank quotes an interest rate of 3.9% APR for a 72-month loan with equal monthly payments. What will Elmo's monthly payment be? (Show the answer in dollars and cents.) What is the effective annual rate on the loan? (Show the answer as a percentage with two decimals.)