Can you please solve these on Excel and show me how you solved it. Thank you so much.

1) Find the present value of receiving $1000 per year for ten years beginning in year 12 until year 21, assuming an interest rate of 9%. 2) If the expected dividend today is $2, and it is expected to grow 6% per annum thereafter, what is the price of the stock if the appropriate discount rate is 15%? 3) Assuming a semi-annual interest payment, determine both the bond-equivalent and annual effective annual yield (to two significant digits) of a bond whose current price is $972, a coupon rate of 7%, a face value of $1000 and with a maturity of 15 years. 4) You borrowed from the bank $300,000 with an annual interest rate of 6% and a maturity of 30 years. Determine the monthly mortgage payment. 5) Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years. There is a balloon payment of $1,000,000 at the end of year 8. Determine annual interest and principal payment for each year. Please make sure your answer includes a separate statement as to the exact principal payment in year 8