SOLVE BOTH USING EXCEL. A company aims to estimate its stock price using the price$-$to$-$earnings $(\frac{P}{E})$ ratio method. The company's earnings per share $($EPS$)$ is $$5.$ The $\frac{P}{E}$ ratios of five peer firms in the same industry are $15,18,20,22,$ and $17.$ Calculate the estimated stock price of the company using the average $\frac{P}{E}$ ratio of these peer firms.

A company issues a bond with a face value of $$1,000,$ an annual coupon payment of $$80,$ a current market price of $$950,$ and a maturity of $10$ years. Calculate the bond's yield to maturity $($YTM$).$