4 problems

profileMary James

Hi there,

 

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?

    • 10 years ago
    • 15
    Answer(2)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      excel_finance_answers.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      excel.xlsx
    Bids(1)