I need help in finance and have to show work in excel or problem worked out.
1. Stock. What is the required rate of return on a stock with a $2.50 expected dividend and a $19 price with 6% growth?
2. Stock. What is the growth rate of the stock with a $3.00 expected dividend and a $20.60 price with 15% required return?
3. Bonds. What is the value of a $1,000 par value bond with annual payments of an 10% coupon with a maturity of 10 years and a 15% required return?
4. Bond. What is the yield to maturity of a $1000 par value bond with an 10% annual coupon and 10 years to maturity and a $1000 price?