answer in excel

1) Find the present value of receiving S100 per year for ten years beginning in year 12 until year 21, assuming an interest rate of 6%. 2) If the expected dividend one year from now is $2, and it is expected to grow 6% per annum 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 S1000 and with a maturity of 15 years. 4) You borrowed from the bank $500,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. Determine annual interest and principal payment for each year. 6) You would like to have $5 million dollars when you retire at age 70. You expect to start saving money at age 26. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 70 birthday? 7) What is the future value in year 7 of a seven year-annuity of $2,000, assuming the interest rate is 9% and the first payment is made at the end of the first year? 8) You can afford to pay $375 monthly car payments. Assume an annual interest rate of 6%, and assume 60 monthly payments. You can afford to put down $3,000. Can you afford to buy a car that costs $30,000