Part $2$: Stock Valuation

Solve using Information provided in questions and plug into excel formulas and explain work please! Thank you!

Solve the following problems and answer the last question. Create appropriate formulas using the supplied values in the corresponding cells so Excel can calculate the answer. Example problems can be found on the "Stock Valuation Example" tab below. Show your work.

On March $5,2013,$ the Dow Jones Industrial Average set a new high. The index closed at $14,253\mathrm{.}77,$ which was up $125\mathrm{.}95$ that day. What was the return $($in percent$)$ of the

$[$Answer here$]$

stock market that day?

Your discount brokerage firm charges $$9\mathrm{.}50$ per stock trade. How much money do you need to buy $300$ shares of

$[$Answer here$]$ Time Warner, Inc. $($TWX$),$ which trades at $22\mathrm{.}62?$

Financial analysts forecast XYZ company's growth for the future to be a constant $8\%.$ XYZ$\text{'}$s recent dividend was $$0\mathrm{.}88.$ What is the value of XYZ stock when the required return is

$[$Answer here$]$

$12\%?$

A preferred stock from ABC pays $$3\mathrm{.}55$ in annual dividends. If the required return on the preferred stock is

$[$Answer here$]$

$6\mathrm{.}7\%,$ what is the value of the stock?

QRST has earnings per share of $$1\mathrm{.}56$ and a $\frac{P}{E}$ ratio of $32\mathrm{.}48.$ What's the stock price?

$[$Answer here$]$

$[$Answer here$]$

Explain why the S&P $500$ Index might be a better measure of stock market performance than the Dow Jones Industrial Average.