YOU MUST USE EXCEL'S FUNCTIONALITY TO PERFORM ALL CALCULATIONS TO EARN CREDIT $($insert rows as needed$)$

DO NOT MERELY TYPE IN NUMBERS OR IMPORT TEXT FROM OTHER SOURCES:

$13.$ Howell Corporation has just issued a $$1,000$ face value, $7\%$ coupon bond with $10$ years to maturity. What should this bond sell for

today if similar bonds have a yield$-$to$-$maturity of $8\mathrm{.}35\%?($Assume coupon payable once per year$)$

$14.$ United Health Care paid annual dividends of $$19$ per share last year, and you anticipate that future dividends will increase by $10\%$

per annum. As a shareholder, if you require a $17\%$ return on your investment in UHC, how much are you willing pay to purchase

one share of the stock of UHC today?

$15.$ Analysts project Citigroup Inc. will pay annual dividends of $$4\mathrm{.}75$ next year with future dividends increasing by $7\%$ annually. If the

market rate of return on this stock is $15\%,$ what should the stock be currently selling for?

$16.$ East Bay Diner pays an annual dividend of $$3\mathrm{.}50$ per share to its shareholders. The economy is tough with supply chain problems, but

East Bay promises to somehow continue maintaining this level of dividend for the time being. How much are you willing to pay for one share

of East Bay stock if you need to earn an $19\mathrm{.}5\%$ annual return?

$17.$ Errico Enterprises just paid a $$8$ per share annual dividend with the stated intention of increasing its dividends by $5\mathrm{.}25\%$ annually. You would

like to purchase stock in this company but realize that you will not have the funds to do so for another $4$ years. If you require a $15\%$ annual rate

of return, how much will you be willing to pay per share for the stock when you can afford to make this investment?

$18.$ Apple Inc. recently paid a $$5\mathrm{.}60$ annual dividend on its common stock, which is expected to increase at an average rate of $7\%$ per year.

If the stock is currently trading for $$175$ per share, what is its market rate of return?

$19.$ The common stock of Plyler Enterprises currently sells for $$85$ a share and pays an annual dividend that increases by $7\%$ annually. If

the market rate of return on this stock is $15\mathrm{.}9\%,$ what was the amount of the last dividend paid per share?

$20.$ The next annual dividend payment by Bristol$-$Myers Squibb is expected to be $$7\mathrm{.}90$ per share. The dividends are anticipated to maintain

a $8\mathrm{.}5\%$ growth rate per year for the foreseeable future and the stock currently sells for $$64$ per share. What is the annual dividend yield?