USE excel functions of (PV,FV,RATE,PMT,ETC) for these questions and also show the formula used.

Q1. You just bought a home for $250,000 and are scheduled to make monthly payments of $1,834.41 for 30 years at 8% APR. Suppose you add $400 each month to the $1,834.41 house payment, making your monthly payment $2,234.41. This extra amount is applied to the principal. How long will it take you to pay off your loan of $250,000? (4 points)

Q2. Harrison Inc. has outstanding $1,000 face (par) value bonds that make semiannual payments and have 14 years remaining to maturity. If the current price for these bonds is $1,100 and the yield to maturity (YTM) is 8% and what is the coupon interest rate (Ci)? (3 points)Q3.

Q3. Jerry Resort Inc. has outstanding $1,000 face value, 8% coupon bonds that make quarterly payments, and have 14 years remaining to maturity. If the current price for these bonds is $1,118.74, what is the annualized yield to maturity? (3 points)