What is the value of cell B$4?$

$\backslash$table$[[,$A$,$B$],[1,$Redemption Value,$100],[2,$Purchase Price,$97\mathrm{.}50],[3,$Days to Maturity,$181],[4,$Bond Equivalent Yield,?$]]$

a$.4\mathrm{.}235\%$

b$.4\mathrm{.}972\%$

c$.5\mathrm{.}171\%$

d$.5\mathrm{.}264\%$

e$.5\mathrm{.}634\%$ What should be the correct formula for cell B$8?$

a$.=-B7**($$$A3-$$$A2)$

b$.=B7**($$$A3-$$$A2)$

c$.=-B7**($$$A3+$$$A2)$

d$.=-B7**($$$B3-$$$B2)$

e$.=-B7**$$$A3-$$$A2$ What should be the correct formula for cell B$4?$

a$.=B\frac{2}{1+B3}+B3**B\frac{1}{B3+1}$

b$.=B\frac{1}{B}3+B\frac{2}{B}3$

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

d$.=B\frac{1}{1-B3}+B3**B\frac{2}{B3-1}$

e$.=B1**(1+B3)+B\frac{3}{B}\frac{2}{B3+1}$ What should be the right formula for cell B$8?$

Remember that the basic syntax of the NPV function is: NPV$($rate$,$ value $1,$ value $2,$dots $)$

a$.=NPV($$$B$$$6,B2$:$B5)$

b$.=NPV($$$B$$$6,B3$:$B5)-B2$

c$.=NPV($$$B$$$6,B3$:$B5)+B2$

d$.=NPV($$$B$$$6,B2$:$B5)+B2$

e$.=NPV($$$B$$$6,B2$:$B5)-B2$A proposed investment project will generate sales of $3K$ units at a price of $$20$ per unit. The

fixed costs are $$8,000$ and the variable costs per unit are $$15.$ The project requires $$20,000$ of

fixed assets that will be depreciated on a straight$-$line basis to a zero book value over the

project's $4-$year life. If the tax rate is $34\%,$ what should be the formula on cell B$8$ to calculate the

operating after$-$tax cash flows for year $5?$

a$.=\frac{B\frac{1}{B2+B4}+B3}{1-B7}-(B5**B\frac{6}{B}7)$

b$.=B1**B2-B4-B3**(1+B7)+B\frac{5}{B}6**B7$

c$.=(B1**B2-B3)**(1+B7)+B\frac{5}{B}6**B7$

d$.=(B1**(B2-B4)-B3{)}^{**}(1-B7)+B\frac{5}{B}6**B7$

e$.=(B1**(B2-B4)-B3)**B7+B\frac{5}{B}6**B7$