What should be the formula on cell C$4$ if you want to determine the expected rate of return

of security $x$ using the CAPM model?

a$.=B4+C3**D4-B4$

b$.=B4+C3**(D4-B4)$

c$.=B4-C3**(D4+B4)$

d$.=B4+B3**(D4-B4)$

e$.=B4+D3**(C4-B4)$ What is the correct formula to determine the stock price using the earnings model on cell

B$6?$

a$.=B1**B\frac{2}{B}3+\frac{B1**B2**(B\frac{4}{B}3-1)}{B3-B5}$

b$.=B\frac{1}{B}3-\frac{B1**(1+B2)**(B\frac{4}{B}3+1)}{B3+B5}$

c$.=B\frac{1}{B}3+B1**\frac{1-B2**B\frac{4}{B}3-1}{B3-B5}$

d$.=B\frac{1}{B}3+\frac{B1**(1-B2)**(B\frac{4}{B}3-1)}{B3-B5}$

e$.=B\frac{1}{B}3+\frac{B1**(1-B3)**(B\frac{2}{B}3-1)}{B3-B4}$ Moonlighting Inc. stock is selling for $$10$ and the last dividend annual payment was $$0\mathrm{.}75.$

What is the correct formula for cell B$4$ to calculate the required rate of return if dividends are

expected to grow at $3\%$ per year?

a$.=B2**\frac{1-B3}{B}1-B3$

b$.=B1**\frac{B2-B3}{1+B3}$

c$.=B2**\frac{1+B3}{B}1+B3$

d$.=$ B$1/($B$2-$B$3)*(1+B3)$

e$.=$ B$2**\frac{1+B3}{B1+B3}$What should be the correct formula for cell B$9?$

Remember that the basic syntax of the Price function is:

Price$($settlemnt$,$maturity,rate,yld$,$redemption,frequency,basis$)$

a$.=\frac{B4**B6}{\text{P}\text{R}\text{I}\text{C}\text{E}(B2,(B)3,(B)4,(B)5,(B)\frac{6}{B}6**100,(B)7,(B)8{)}^{**}(B)6}$

b$.=$ B$4*$B$6/$PRICE$($B$2,$B$3,$B$4,$B$5,$B$6/$B$6/100,$B$7,$B$8)$

c$.=$ B$4100,$B$7,$B$8)/100*$B$6$

d$.$ B$4100,$B$7,$B$8)/100*$B$6)$

e$.=$ B$4/$PRICE$($B$2,$B$3,$B$4,$B$5,$B$6/$B$6,$B$7,$B$8)$You borrowed $75$ percent of a new car priced at $$20,000$ with an interest rate of $7$ percent

interest for $6$ years. What is the amount of your monthly payment? What should be the formula

on cell B$4$ to find the amount of your monthly payment?

a$.=PMT(B2**12,B\frac{3}{12},-0\mathrm{.}75**B1,0)$

b$.=PMT(B2,B3,-B1,0)$

c$.=PMT(B\frac{2}{12},B3**12,-0\mathrm{.}75**B1,0)$

d$.=PMT(B\frac{2}{12},B3**12,-B1,0)$

e$.=PMT(B\frac{2}{12},B\frac{3}{12},-0\mathrm{.}75**B1,0)$