FINA $4102$ Excel Assignment

Please solve the following problems on Excel. An Excel template for questions $1-3$ can be found in the "Excel Assignment" module in D$2$L$.$ Then use what you have learned from the $1$ st $3$ questions to build a model in Excel to answer question $4.$ After you finish, upload your Excel file on D$2$L assignment page. It's due on October $20$th at $11$:$59$ pm$.$

You have just purchased a $15-$year, $$1,000$ par value bond. The coupon rate on the bond is $8$ percent annually, with interest being paid every six months. The market rate on bonds of similar risk is currently $6$ percent. What price did you have to pay to purchase the bond? $(10$ points$)$

Your company just paid a dividend of $$2\mathrm{.}00.$ The growth rate in dividends is expected to be $10$ percent per year for the next three $(3)$ years and then the dividend growth rate is expected to decline to a constant $5$ percent thereafter. The required rate of return on equity is $8$ percent. Compute the expected value of the company's common stock today. By comparing the stock's expected value based on your calculation with its current market price, is this stock underpriced or overpriced if its current market price is $$90?$ Why? $(20$ points$)$

Project A have the following estimated cash flows:

$\backslash$table$[[$Year$,$Project A$],[0,-120,000$