A couple of things to the person who answers this

1) This needs to be done in MSFS excel

2)This is all one question there are just 3 parts to the question so per chegg guidlines all three questions must be answererd because they are underarching a question.

3) Please show some work for the answersn and just dont put the answers there need to be some equations to show the answer you got

This is to be done in M.S. Excel. Email the Excel file with your solutions to the problems by no later than You may use any books or notes to help you in answering these questions, 2. (a) You are thinking of buying shares of stock in Company A. Last year's dividend was $2.75, and you estimate the annual growth rate, based on recent past dividends, to be 3.12%. The required rate of return is 6.19% per year. What do you think the price per share should be? (b) You look at the Internet and see that the current market price is $89.78 per share. Should you buy or sell this stock? Why? (c) A bond is a form of debt. Basically, a fixed rate bond pays a level coupon at the end of every six months (an annuity) and a lump sum payment of $1,000 per bond at the termination date (maturity or future value). The APR or rate is commonly referred to as the "Yield to Maturity (YTM)." The number of periods is the number of semi-annual periods during the life of the debt instrument. Say you have a bond with a YTM of 6.84% and a coupon rate (quoted as an annual rate) of 5.64% payable over the next 6 years exactly. What is the current price of that bond