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

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)

b) the yield to maturity of a 5-year discount bond with $1,000 face value that sells for $950. (Excel function: rate)

c) the installment payment of a 4-year fixed payment loan of $25,000 with 4% interest rate. (Excel function: pmt)

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)

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)

If you need help with Excel functions, please check this:

https://exceljet.net/excel-functions/excel-rate-function