Use Excel to calculate (Please type the complete function command with all parameter inputs; round up your answers to 2 decimal places):

1. a) the yield to maturity of a 20-year 8% coupon bond with a $1,000 face value that sells for $1,200. (Excel function: rate)
2. b) the yield to maturity of a 5-year discount bond with $1,000 face value that sells for $950. (Excel function: rate)
3. c) the installment payment of a 4-year fixed payment loan of $25,000 with 4% interest rate. (Excel function: pmt)
4. d) the present value of a lottery winning that pays $20,000 annually for 30 years with discounting rate of 5% (Note: the first payment is received today.) (Excel function: pv)
5. e) the unpaid balance of a 3% (per month) fixed-payment car loan of $15,000 with monthly payment of $800 paid for one year. (Excel function: fv)