Please answer question $2$ in excel, with cell reference please!

If a firm has a payout ratio of $65\%$ and a ROE on projects of $11\%,$ what is the growth rate for the firm?

Assume a firm has a cost of capital of $13\%,$ and their future projects have an ROE of $10\%.$ As their plowback ratio increases, how will their $\frac{P}{E}$ ratio change. Why?

If Apple is expected to pay a dividend of $$3$ next year, and it is expected to grow at a rate of $2\%.$ If Apple's cost of capital is $15\%,$ what is a fair price for Apple?

If instead, we assume that Apple will grow at $15\%$ in the next $2$ years, then drop down to $10\%$ in the $3^{rd}$ year, and finally reach a steady growth rate of $3\%.$ If the cost of capital is $15\%$ and this years dividend is $$4,$ what is a fair price of Apple?

Using the following information, find the price of the bond with semi$-$annual coupon payments and $$1,000$ par value. Round to two digits.

a$.$ What is the duration of this bond?

$\backslash$table$[[$Settlement Date,$\frac{2}{15}\frac{?}{2015}$